A one-command diagnostic tool that scans 90 days of Google Ads data, runs 7 structural checks, scores the account health out of 100, and outputs a client-ready PDF report with colour-coded critical issues and a prioritised 30-day action plan — in under 60 seconds. Built and validated on a live account managing $39,551 in spend across 95 campaigns.
See It In Action
The Problem
When did you last do a proper audit of a Google Ads account? Not a quick scan — a real audit. Every campaign, every keyword, every search term, every quality score, every budget utilisation rate. Most accounts never get one because doing it properly takes a week and costs more than most brands want to spend.
So problems compound quietly. A keyword loses quality score and nobody notices until CPC doubles. A campaign runs for 6 months with a single ad and nobody tests anything. A budget gets set and underspends every day while growth sits waiting. This tool surfaces all of it in 60 seconds — not as a wall of data, but as a prioritised list of exactly what to fix first and why it matters in rupees.
The Solution
An automated Python script connects to Google Ads via MCP inside Claude Code. One command is all it takes — the script pulls 90 days of data, runs all 7 checks, generates the Claude analysis, and saves a client-ready PDF automatically.
Step One - Connects to Google Ads via MCP and pulls 90 days of data across all campaigns, ad groups, keywords, and search terms — storing everything as structured DataFrames ready for 7 diagnostic checks across all dimensions simultaneously
Step two — Runs 7 checks — wasted spend keywords, search term leaks, low Quality Score keywords, zero-conversion campaigns, ad groups with single ads, underutilised budgets, and high-impression zero-click keywords — each producing a flagged issues list with exact spend affected in rupees
Step three — Sends all findings to Claude API which writes an executive summary, calculates an account health score out of 100, identifies the top 3 critical issues with revenue impact, and produces a prioritised 30-day action plan — then formats everything into a professional PDF with cover page, colour-coded issue cards, and full findings table
The Impact
Project Visual
Tools & Stack