In the latest release of the Analytics Edge Add-in for Excel (11.45.0) and Desktop App (1.45.0), the Split function now lets you split a column of URLs into its component parts. This simplifies URL path analysis, separates the domain from the page path, and isolates the query string and anchor tag (fragment).
Blog
Eleven years working with the Google Analytics APIs
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 […]
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), Desktop App (v1.42) and Add-in for Excel (v11.42) now have Annotation Title, Description and Color dimensions that an be added to your queries.
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
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. […]
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.
Google Analytics API dropping (not set) in March 2025
Google is making a change to their API that powers the Analytics Edge connector for Google Analytics: Today, for fields where Google Analytics doesn’t receive any data, the value (not set) is returned in a report. The Google Analytics Data API will return blank values instead of (not set), beginning in March 2025. Action Required: […]
Bing Webmaster Tools – Nov 2024 Update
The Bing WebmasterTools connector now provides the ability to pivot weekly reports by the date as well as select which metrics to include. This makes it easier to generate time-based charts for position, clicks or impressions.
Bing Webmaster Tools Connector – Oct 2024 Update
The Add-in for Excel v11.32.0 and Desktop App v1.32.0 now feature updated Bing Webmaster Tools connectors with a full 16 months of historical data available. This latest release features some bug fixes as well as enhanced reporting. Simplified spreadsheet reporting from Analytics Edge. Download now
Optional Tracking and Debug Mode
Usage Tracking Product usage tracking can now be turned off in the latest releases of the Analytics Edge Add-in for Excel and the Desktop App (2024-06-30). The option appears in the License wizard as part of the License Agreement section: Note that usage tracking does not include any account or query details — it is […]