Export GSC data to CSV – the Analytics Edge Exporter GSC allows you to automate the download of data from the Google Search Console API into simple comma or tab-separated files that can be read by virtually any application. There is no programming or knowledge of the APIs required; the query wizards use report-friendly field […]
Blog Articles
Building a Better Google Analytics MCP Server
Get your data faster with half the tokens (experimental, free, no limits). Simple installation: no Python, no Google Cloud projects. The experimental Analytics Edge MCP Server for Google Analytics is now available, and the initial benchmark is impressive. Here is the back story and the results.
Track ChatGPT-User In Your Website Logs
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 […]
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), 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) 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. […]