AI ads infrastructure
AI Google Ads Weekly Report (Auto-Generated)
Generate a Google Ads weekly report in Claude in 60 seconds. The exact prompt, what's included, sample output, and how to share it with clients.
A weekly Google Ads report — the kind you'd send a client or VP of Marketing — usually takes 30–60 minutes to assemble. Pull data from the Ads UI, build a deck or doc, write commentary, format charts. Claude can produce the same report in about 60 seconds when connected to your account through an MCP server. This page shows the exact prompt, what's in the report, and how to format it for sharing.
The prompt
You: "Generate a weekly Google Ads report for last week vs. the prior week. Include: spend, conversions, CPA, ROAS, top 5 wins (campaigns where performance improved most), top 3 concerns (campaigns where performance dropped), search term highlights, change log, and a 3-bullet exec summary. Format it as markdown ready to paste into a doc."
What Claude pulls
Claude calls runScript with a parallel GAQL fan-out across these surfaces:
- Campaign-level metrics for last week and the prior week (spend, conversions, conversion value, CPA, ROAS, CTR).
- Week-over-week deltas computed in-script.
- Search term report filtered to last week's top 50 by spend.
- Change history — every write applied during the reporting period (yours, the team's, or Claude's).
- Quality score snapshot for keywords driving 80% of spend.
Sample report
## Weekly Google Ads Report — Apr 21–27, 2026
**Exec summary:** Spend up 8%, conversions up 14%, CPA down 5%. Brand campaign drove most of the gain. PMax mobile CTR dropped meaningfully — investigate landing page.
**Spend:** $14,820 (+8% WoW). Conversions: 142 (+14%). CPA: $104 (−5%). ROAS: 4.1x (+11%).
**Top wins:** Brand Search (+22% conv, no extra spend), Boarding Services (+18% conv), Local Daycare (+9% conv).
**Top concerns:** PMax Holiday (mobile CTR dropped from 4.2% to 2.1%), Grooming Search (CPA up 31%).
**Search terms:** 'overnight pet boarding near me' top by conv (12 conv, $32 CPA). Added 'free' as negative across 3 campaigns Wed.
**Changes this week:** 47 keywords paused (zero conv 90d), $200 daily budget shift Brand → Boarding, new RSA variants live in Daycare.
Tweak it for your audience
- Client-facing — ask Claude to soften the language and lead with the win narrative; drop technical jargon like "GAQL" or "impression share lost to budget."
- Internal team — ask for the diagnostic version with raw deltas, hypothesis tags on every metric drop, and recommended actions.
- Email-ready — "format it as a 6-line email I can paste into Gmail" produces a tight summary instead of a full doc.
- Slack-ready — "format it as a Slack message with bullet points" — works great for #marketing channels.
Schedule it
Two patterns. (1) Manual every Monday — open Claude, paste the prompt, share the output. Takes 2 minutes. (2) Automated via Claude API — schedule a weekly job that calls Claude with the prompt against the NotFair MCP, posts the result to Slack or email. The second path requires light dev work; the first works for most agencies and in-house teams.
FAQ
Try MCP with Google Ads
Connect your Google Ads account to NotFair in 30 seconds and start querying campaigns from Claude.