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 […]
Author: Mike Sullivan
Google Analytics 4 Annotations
You can now include GA4 annotations in your Analytics Edge reports! The latest releases of the Analytics Edge Exporter GA4 (v2.0) and Add-in for Excel (v11.42) now have Annotation Title, Description and Color dimensions that an be added to your queries.
The Easy Way to Monitor Search Engine Rankings
The rules for search engine optimization continue to change. It’s no longer about individual keywords and average position. But if position and individual terms aren’t the focus, how do you know if changes you made have any impact? This free Excel report demonstrates a new way to gain insight. It is a more holistic view […]
New Product Series: AE Exporter
For the past 11 years, the Analytics Edge portfolio has been rooted in making it easy to get your data from various API services like Google Analytics and Google WebmasterTools (Search Console). It is designed to run on your computer, making direct API calls and processing the results without requiring any programming or API knowledge. […]
Minimize Sampling in GA4 Reports
Analytics Edge has added a new option for GA4 Reporting — Minimize Sampling! If your reports suffer from sampling, it is now possible to split the report by month, week or day, with separate queries for each. Available now in version 11.16.0 of the Add-in for Excel. Download
Chrome UX, PageSpeed Insights, URL Inspection Report Automation
The Analytics Edge connector for Google Search has added the ability to get data from THREE new sources: the Chrome UX Reports API, the PageSpeed Insights API, and the new Google Search Console URL Inspection API! Each of the new query wizards can use an Analytics Edge range name (reference to a column of URLs) […]
LinkedIn Ads Reporting in Microsoft Excel
Save your self time and money by automating your advertising reports on your own computer with Microsoft Excel and Analytics Edge! Combine the flexibility of Excel with the simple automation capabilities of the Analytics Edge Core Add-in. Now you can pull your LinkedIn Ads data right into your spreadsheet!
Export more than 5000 rows in Google Analytics
The free Analytics Edge Exporter GA4 can download as many rows as you want, effortlessly. The simple wizard-based interface makes it easy to recreate standard reports, and just as easily customize them to suit your needs. No need to learn API field names or syntax rules! Best of all, there are no account limits, […]
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 […]
Adventures in Google Search Data Analysis
Being the start of a new year, I had a look back at the Google Search performance of my websites for the past 12 months. Looking at the Google Search Console reports was frustrating — the numbers were meaningless for a variety of reasons. Thus started my journey into Google Search data analysis, and my […]