A lot of us have enabled the new Google Analytics 4 tracking in parallel to our GA (Universal Analytics) implementation, and are in the ‘playing around mode’. With the latest update of the Analytics Edge connector for Google Analytics (Pro), you can now access the new Data API (v1alpha) — available as “GA 4 Reporting”. […]
Articles
Google Analytics Bot Traffic – 2021 Edition
It’s Back! Sigh…. Google Analytics was hit (hard) with a spike of bot traffic on January 30th, 2021, after 3 years of virtually eliminating it on their platform. To a lot of people, this is new stuff, but since I wrote the original Definitive Guide to Removing Google Analytics Spam article, I thought I should […]
Extract, Transform, and Load (ETL) With Analytics Edge
Way back in the 1970’s, the concept of ‘extract, transform and load’ (ETL) became popular in data warehousing environments. ETL tools could grab data from multiple sources, combine and transform it through various operations, then load it into database tables. In 2013, Analytics Edge brought that same capability to Microsoft Excel in the form of […]
Analytics Edge for Mac
A number of people have been searching for an Apple Mac version of the Analytics Edge add-ins, but that does not exist yet. It is possible to run the add-ins on a Mac using products like Parallels, but you will also need a copy of Microsoft Windows and a Windows version of Excel. A native […]
Explaining the Changes to Google Search Console Data
On July 13, 2017, Google changed the way it collects data for their Search Analytics reports to provide “better accounting for results in lower positions. This change might cause increase in impressions, but also a decrease in average position.” But how did it affect your metrics, and are their other changes hiding behind the confusion?
Foxweber.com Spam Review
Just when it looked like the spam referrals in your web site traffic reports was fading away, a new source appears — this time from China: Foxweber (a.k.a. KingDatas, a Beijing Company). Google Analytics has long been a target for referral spam – someone leaving fake referral visits in website traffic reports to entice them […]
Become Google Analytics Certified in 30 Days!
Yes, it really is possible – I did it! OK, so maybe I have a bit of experience with Google Analytics, but since I never actually tried to get my Google Analytics Individual Qualification (GAIQ) certification, when Jeff Sauer asked if I’d recommend his new Google Analytics course, I thought this would be a good exercise. […]
Excel Report Automation Options
Updating Excel reports is a tedious, mind-numbing activity that many people would love to do without. Looking for a solution to the problem, you will discover that there are a quite a few options available to you. They are all listed below, but something you should consider first… The Analytics Edge Add-in for Microsoft Excel […]