Want a simple GEO hack? Find out which of your website pages are feeding ChatGPT conversations, and use those pages to showcase your brand and feed the very top of the funnel. This information is not available in Google Analytics or Google Search Console — it only appears in your web server logs. Analytics Edge […]
Author: Mike Sullivan
New Search Term View in Google Ads
In case you missed it, the Google Ads API was just updated and now includes a ‘Search Term View’ resource that allows you to report the Keyword text and the actual Search Term used. It can be split by campaign, date, device and match type as well. Available in Analytics Edge v11.50+.
Download Over 25,000 Rows From Google Search Console API
Contrary to a lot of information online, especially from AI search responses, you CAN download more than 25,000 rows of data from the Google Search Console (GSC) API…a lot more.
Split URLs Into Component Parts
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).
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.
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. […]
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.
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