Way back in 2014, I built a connector for the Analytics Edge Add-in for Excel that accessed data from the Google Analytics APIs. In today’s lingo, that was for Universal Analytics data. That connector evolved over the years, adding features and capabilities to make reporting easier. When the switch to Google Analytics 4 happened, I […]
Articles
Google Analytics Export Data
If you are trying to export the data from your Google Analytics reports, you may be struggling to find the link. It is hiding behind the Share icon. Where to find the Download link in Google Analytics
Removing Referral Spam in Google Analytics [2025 update]
Bothered by spikes in direct and referral traffic (something about url umbrellas?) in your Google Analytics reports? Here’s how to prevent that junk from messing up your reports in the future.
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 […]
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 […]