In-house SEO work
Marketing intelligence & Claude MCP website case study
Connecting marketing activity to business data.
In my in-house SEO manager role, I built a reporting platform connecting marketing, lead and sales data across international markets.
At a glance
- Search, advertising and sales
- BigQuery reporting views
- Dashboards and Claude analysis
The work
What I built
Bringing the sources together
The Python and BigQuery platform integrates GA4, Search Console, Google Ads, Meta Ads, Ahrefs, Google Trends, WooCommerce and Cin7. Reporting views and Looker Studio dashboards connect marketing activity with leads and sales.
AI with defined access
I integrated the Claude API for cross-channel analysis and management-reporting commentary. I also configured a Claude MCP connector with read-only BigQuery tools, authorised reporting views and a scoped service account, so the team can query approved data directly.
Controlled implementation
Alongside reporting, I built Python and WordPress REST API workflows for content, ACF and Yoast updates, including dry-run safeguards. This sits within my wider responsibility for technical SEO and migration QA across international sites. This project was delivered as an employee, not as a JimmyTech client engagement.
Follow the work
Related expertise
Have something similar in mind? Tell me what you need to build.
Discuss your project ↗Explore all work