Weekly Client Reports for 20 Ad Accounts in About an Hour

What goes in a weekly report

Clients do not want a dashboard every week. They want to know whether things are fine, what I did, and what happens next. My weekly email has four parts and fits on one screen.

• The headline: spend and results (leads, sales or calls) for last week, next to the week before.
• Per channel: Google Ads and Meta in one or two lines each, with cost per result.
• What I changed last week, in plain words: negatives added, budgets moved, creative swapped.
• What I plan this week, and anything I need from the client (new photos, an answer about an offer).

Completed weeks only

A report that compares "the last 7 days" on a Friday compares a different stretch for every client and includes days where conversions are still coming in. I always report the last completed Monday-to-Sunday week against the one before, and I give the dates in the prompt. agency_weekly_report gives a quick rolling last-7-days view across Google Ads, Meta and GA4 for one client, which is useful mid-week. For the client email I ask for explicit dates instead, so every number refers to the same two weeks.

For each of my clients, pull last Monday to Sunday and the Monday to Sunday before it:
- Google Ads: spend, clicks, conversions, cost per conversion
- Meta: spend, leads or purchases, cost per result
- GA4: sessions and key events from paid traffic
Show one short table per client with both weeks and the change. Mark any number that moved more than you would expect from normal week-to-week noise, and do not explain it yet.

Cross-channel numbers that disagree

Google Ads, Meta and GA4 will not agree on conversions. Each counts with its own attribution, and a lead that clicked a Google ad after seeing a Meta ad can show up in both. I do not add them together and call it a total. For clients where it matters, agency_cross_platform_overview pulls Google Ads, Meta and GA4 together and uses GA4 as the reference for conversions. In the report I name the source next to each number, so the client never sees two different lead counts without an explanation.

Writing the client email

Once the numbers are checked, I ask Claude to draft the email for each client in the tone I use with them. Some clients want two lines, some want the table. I keep a short note per client with their preferences, and paste it in. Claude drafts; I send. MCP Ads does not send email for me, and I would not want it to. I read each draft, fix anything that sounds unlike me, and send it from my own inbox.

Write the weekly email for the dental client using the table above. Tone: friendly, short, no jargon. Structure: one sentence on how the week went, the numbers for both weeks, what I changed last week (I added 14 negative keywords and lowered the Meta budget on the Whitening campaign), what I plan this week, and one question for them about the December offer. Use only numbers from the table. If a number is missing, say so instead of estimating it.

Keeping it honest

An AI-written report is only as trustworthy as the checks around it. These are the rules I hold to.

• Every number in the email must come from the platform data in the same conversation. I tell the assistant not to estimate, round in a flattering direction or fill gaps.
• I spot-check two or three numbers per client against Google Ads, Ads Manager or GA4 before sending.
• A bad week is reported as a bad week, with the reason if I know it and "I am looking into it" if I do not.
• I do not take credit for changes in a week I did not change anything.

Where the hour goes

Pulling numbers for all clients takes a few prompts and some waiting. Reading them, spotting the two or three accounts that need a real explanation, and editing the drafts is the rest of the hour. The accounts with a problem get a longer note and usually a call; the rest get the short email. If you want to set this up, the quickstart connects an account in a few minutes, and the agencies page covers workspaces and team roles.