Skip to content

How to make monthly Google Ads reports for clients

· 3 min read

AdplaneProduct team

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:

  1. The headline. Did they get more for their money than last month?
  2. The numbers. Spend, results and cost per result, or revenue and return on ad spend for a shop. This month against last.
  3. Why. The one or two things that moved them.
  4. 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.

Example conversation
You
Monthly numbers for all my clients: September against August, by platform. Spend, results and cost per result, or revenue and ROAS for Kettle and Co.
Your assistant

September against August, each account in its own currency:

ClientPlatformSpendResultsPer resultAugust
Brightwater Dental (USD)Google2,14064 conversions33.4435.34
Thornbury Lettings (GBP)Google1,48037 leads40.0049.03
ClientPlatformSpendRevenueROASAugust
Kettle and Co (USD)Google3,30013,8604.23.9
Kettle and Co (USD)Meta1,9005,5102.93.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.

You
Write Kettle and Co's summary as a short email to the owner. Plain words, no jargon.
Your assistant

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.

Sign up with Google
Monthly Google Ads and Facebook Ads reports for clients — Adplane