Mike Sullivan
LightNews LightNews
analyticsedge.com
Mike Sullivan
@analyticsedge.com
300 followers 220 following 120 posts
From electronics manufacturing engineer to CIO to entrepreneurship over 40+ years. Now simplifying spreadsheet report automation. SEO, PPC and more.
Posts Replies Media Videos
analyticsedge.com
Simple GEO hack: track ChatGPT-User in your website logs, then prominently position your brand in the popular content.
www.analyticsedge.com/blog/track-c...
October 16, 2025 at 11:57 AM
analyticsedge.com
Google Search: 15 #SEO Reports automated by Analytics Edge in #Excel help.analyticsedge.com/report/googl...
Google Search: 15 SEO Analysis Reports | Analytics Edge Help
This free workbook includes 15 different SEO reports, each with an Analytics Edge macro to automate the data download and analysis. Inspired by the work of Antoine Eripret’s gsc_wrapper, this…
help.analyticsedge.com
September 18, 2025 at 1:45 PM
analyticsedge.com
Is your search traffic dependant on a few or many search queries? Query count per page report from Analytics Edge. #SEO in #Excel
help.analyticsedge.com/article/goog...
September 18, 2025 at 11:57 AM
analyticsedge.com
How many pages appear in search each day? 1 of 15 new #SEO #Excel reports from Analytics Edge
help.analyticsedge.com/article/goog...
September 17, 2025 at 1:45 PM
analyticsedge.com
How many web pages appear in search that are NOT in your sitemap? 1 of 15 new #SEO #Excel reports from Analytics Edge
help.analyticsedge.com/article/goog...
September 17, 2025 at 11:57 AM
analyticsedge.com
How many of your web pages show up in search daily? Weekly? 1 of 15 free #SEO reports from Analytics Edge for #Excel
help.analyticsedge.com/article/goog...
September 16, 2025 at 1:45 PM
analyticsedge.com
When did your new/old content start appearing in search? 1 of 15 free #SEO reports from Analytics Edge in #Excel
help.analyticsedge.com/article/goog...
September 16, 2025 at 11:57 AM
analyticsedge.com
Content decay report - pages that quickly dropped from search. 1 of 15 new #SEO #Excel reports from Analytics Edge.
help.analyticsedge.com/article/goog...
September 15, 2025 at 1:45 PM
analyticsedge.com
Summarize your Google search performance by folder/sub-directory with this free #SEO #Excel report. 1 of 15 new ones Analytics Edge. help.analyticsedge.com/article/goog...
September 15, 2025 at 11:57 AM
analyticsedge.com
Monitor search engine CTR vs Position as well as Keyword Count vs Position. 1 of 15 free #SEO reports for #Excel from Analytics Edge help.analyticsedge.com/article/goog...
September 12, 2025 at 1:45 PM
analyticsedge.com
Compare the performance of groups of pages in search with Analytics Edge; 1 of 15 new free #SEO reports in #Excel
help.analyticsedge.com/article/goog...
September 12, 2025 at 11:57 AM
analyticsedge.com
Comparing search performance before and after an event -- surprisingly easy to do with Analytics Edge #SEO #Excel
help.analyticsedge.com/article/goog...
September 11, 2025 at 1:47 PM
analyticsedge.com
Are multiple pages competing for the same clicks? This #Excel report from Analytics Edge does the analysis for you! 1 of 15 new free #SEO reports. help.analyticsedge.com/article/goog...
September 11, 2025 at 11:57 AM
analyticsedge.com
Now with AI integration - summarize your reports automatically! Choose from Anthropic/Google/Open AI/Perplexity. Analytics Edge Add-in for Excel www.analyticsedge.com/analytics-ed...
September 10, 2025 at 2:14 PM
analyticsedge.com
Comparing branded vs non-branded search results is a 100-level #SEO task. Analytics Edge Add-in for #Excel makes it easy. 1 of 15 new SEO reports. help.analyticsedge.com/article/goog...
September 10, 2025 at 1:45 PM
analyticsedge.com
Combine sitemap and GSC data to profile your site performance in search; Analytics Edge automates the analysis (1 of 15 free #SEO #Excel reports) help.analyticsedge.com/article/goog...
September 10, 2025 at 11:57 AM
analyticsedge.com
Looking to categorize items? A simple technique is to use 'cumulative percentage contribution'. Analytics Edge can automate the analysis (1 of 15 new free reports) help.analyticsedge.com/article/goog... #SEO #Excel
September 9, 2025 at 11:57 AM
analyticsedge.com
Google Search: Cannibalization Report -- 1 of 15 new reports from Analytics Edge help.analyticsedge.com/article/goog... #GoogleSearchConsole #SEO
August 27, 2025 at 1:49 PM
analyticsedge.com
New Search Term View in Google Ads – Analytics Edge www.analyticsedge.com/blog/new-sea...
New Search Term View in Google Ads – Analytics Edge
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…
www.analyticsedge.com
August 13, 2025 at 1:18 PM
analyticsedge.com
Spent the last few days creating a 15-in-1, Analytics Edge-powered, Excel workbook inspired by the great work of Antoine Eripret's gsc_wrapper for Python. Giving credit up front. #SEO #GSC
github.com/antoineeripr...
July 27, 2025 at 11:57 AM
analyticsedge.com
Calculating an Average of Averages between 2 data sets the easy way in #Excel help.analyticsedge.com/article/calc...
Calculating a Weighted Average (Average of Averages) | Analytics Edge Help
A common reporting challenge in Excel is merging sets of data, such as combining monthly numbers for a quarterly or annual total. Adding up simple metrics is obvious, but what do you do with things…
help.analyticsedge.com
July 25, 2025 at 11:57 AM
analyticsedge.com
Get more than 25,000 rows from the #GoogleSeachConsole API. Vibe coding? Things to know...
www.analyticsedge.com/blog/downloa...
Download Over 25,000 Rows From Google Search Console API – Analytics Edge
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.
www.analyticsedge.com
July 21, 2025 at 1:25 PM
analyticsedge.com
It's happening again? Not that anyone's been watching...but it was nice of you to give us that new metadata in the API. @johnmu.com @rustybrick.com
Hourly data stalled, looks like daily data also delayed.
July 19, 2025 at 1:04 AM
analyticsedge.com
Easily compare hourly #GSC data to the same days last week in #Excel -- Analytics Edge makes it easy. Now with 'incomplete data' flag!
www.analyticsedge.com/product/
July 17, 2025 at 11:57 AM
analyticsedge.com
Analytics Edge now supplies 'incomplete data' as an optional (0/1) column for all Google Search queries -- including in the free Exporter GSC!
www.analyticsedge.com/product/ #GSC #GoogleSearchConsole #SEO
July 16, 2025 at 7:12 PM