How to make monthly Google Ads reports for clients
· 3 min read
A client report needs four things: the headline, the numbers against last month, why they moved, and what you'll do next. Clients read the headline and the why. Everything else is copying, so stop doing it by hand.
What goes in the report
In this order:
- The headline. Did they get more for their money than last month?
- The numbers. Spend, results and cost per result, or revenue and return on ad spend for a shop. This month against last.
- Why. The one or two things that moved them.
- What's next. What you'll change this month, and anything you need from the client.
Keep each platform in its own currency. And never add Google's conversions to Meta's: each one credits itself by its own rules, so the same customer gets counted twice.
Every client's numbers in one prompt
With Adplane connected to Claude or ChatGPT, your assistant pulls each client's Google and Meta accounts and compares them with the month before.
September against August, each account in its own currency:
| Client | Platform | Spend | Results | Per result | August |
|---|---|---|---|---|---|
| Brightwater Dental (USD) | 2,140 | 64 conversions | 33.44 | 35.34 | |
| Thornbury Lettings (GBP) | 1,480 | 37 leads | 40.00 | 49.03 |
| Client | Platform | Spend | Revenue | ROAS | August |
|---|---|---|---|---|---|
| Kettle and Co (USD) | 3,300 | 13,860 | 4.2 | 3.9 | |
| Kettle and Co (USD) | Meta | 1,900 | 5,510 | 2.9 | 3.3 |
Brightwater and Thornbury both got cheaper per result; Thornbury most, 18% fewer pounds per lead. Kettle and Co is mixed: Google's return rose while Meta's fell from 3.3 to 2.9.
Subject: Your September ads
Hi Dana,
September was a good month on Google and a softer one on Facebook and Instagram.
Google brought in 13,860 dollars in sales from 3,300 in ads, about 4.20 back for every dollar, up from 3.90 in August. Most of the gain came from the Shopping campaign.
Facebook and Instagram brought in 5,510 from 1,900, about 2.90 per dollar, down from 3.30. The autumn photos have been running for seven weeks and people have stopped clicking as often, so I would like to try new ones in October.
These sales figures are as Google and Meta count them; your store's own totals are the final word. Could you send three or four new product photos this week?
You read the draft and send it yourself. Adplane reads the accounts and your assistant writes. Nothing gets emailed or scheduled for you.
Doing it every month
Save the prompt. Same message every month, same table. That's what makes month-to-month comparisons honest.
Write the why yourself. The numbers show what moved. You know why: the client ran a sale, a competitor showed up, it was a holiday. Two sentences of that are the whole value of the report.
Get their numbers too. For lead businesses, ask how many leads became customers, as in the post on cheaper leads. That turns "here are your clicks" into "here's what you got for your money".
Need a chart or a spreadsheet? Ask for it in the same conversation. Claude and ChatGPT can make one from the numbers.
New to Adplane? Install it and connect the logins that reach your clients' accounts. The weekly check-in post covers the lighter weekly version.
Read next
Try it in your own chat
Sign in with Google, connect your ad accounts, and ask your first question.