Mike Sullivan

Mike Sullivan

@analyticsedge.com

From electronics manufacturing engineer to CIO to entrepreneurship over 40+ years. Now simplifying spreadsheet report automation. SEO, PPC and more.

317 followers229 following150 posts

Did you know you could get all your #GSC and #GA4 data in #Excel without #MCP servers? Analytics Edge has been doing it for over a decade. No account or row limits, no API knowledge, no AI hallucinations, no coding; just simple wizard selections. Cheaper than an AI subscription.

Experimental...a local GA4 MCP server with a simple installer that doesn't require the AI to figure out how to work with the APIs. Premise: AI's shouldn't be forced to work with raw API methods. Using AE connector tech should dramatically reduce the effort to query and process the responses.

View full thread

- installation is a breeze. No command line mumbo-jumbo. Simple logins avoid the whole project/credential file nightmare. - building a local MCP server with a user interface opens up a lot of possibilities.

- does the data have to be sent back to the AI, or could it be displayed/saved locally for privacy and use the AI just for query generation? - more connector functionality to be exposed, but need to think about how to implement it to make life easier for the AI. ....so many ideas...

Experimental...a local GA4 MCP server with a simple installer that doesn't require the AI to figure out how to work with the APIs. Premise: AI's shouldn't be forced to work with raw API methods. Using AE connector tech should dramatically reduce the effort to query and process the responses.

Thoughts so far: - it's not significantly faster, although no direct comparison tests have been run yet -- I want to compare tokens used; they should be a lot lower. - getting an AI to NOT use the API terminology was surprisingly difficult --I had previously installed the official analytics-mcp.