KeySendGoogle Ads reporting for agencies and freelancers: a workflow for many clients
Published · Updated · KeySend
Agency Google Ads reporting holds up when every client has the same five parts: a written definitions sheet, a fixed calendar, a data check, a commentary check and a decision log. This guide shows each part with examples, compares the tooling options, and says where KeySend fits for a freelancer or a small agency.
What breaks first when the client list grows
With two clients, one person remembers which conversion action matters, which campaigns are brand, and when each report is due. With eight clients, that memory fails. The usual symptoms are a report that counts the wrong conversion column, a month compared with a period that had a different campaign set, or a summary that says a cause the data does not show.
The fix is a process that is the same for every client, with content that is different for every client. Standardize the definitions, the dates, the checks and the handoff. Let the interpretation and the actions follow each business.
Write one definitions sheet per client
Keep a one-page sheet beside each client's recurring report task. A replacement account manager should be able to produce a correct report from it without a call. The example below is hypothetical.
| Field | Example entry | Why it matters |
|---|---|---|
| Account and customer ID | Harbour Dental, 123-456-7890 | Stops a report from pulling the wrong account in a manager account |
| Recipient and their decision | Practice owner; decides the monthly budget | Sets what the summary must answer first |
| Results column | Conversions (primary actions only): booked appointment form | Conversions holds primary actions; All conversions adds secondary and other actions, so the two columns give different totals |
| Comparison | Previous calendar month; same month last year in December | Prevents a different comparison each month |
| Time zone and currency | Eastern Time (US), USD | Google Ads reports use the account time zone |
| Campaign groups | Brand, non-brand search, Performance Max | Keeps groupings stable from month to month |
| Tracking contact | Office manager, confirms form and call tracking | Gives you one person to ask when conversions drop to zero |
Set a calendar that allows for conversion lag
Google Ads attributes conversions to the date of the click or impression, and Google says it can take up to 7 days for conversion data to fully appear. A monthly report pulled on the 1st will therefore often show fewer conversions for the last days of the month than the same report pulled a week later. If you send on the 1st, say so in the report and note the extraction date. If clients compare your numbers with their own CRM, agree on one rule and keep it.
Spread the work so it does not all land on the first working day. A hypothetical calendar for a small team:
| When | Task | Owner |
|---|---|---|
| Every working day | Check spend, stopped campaigns and conversions at zero | Account owner |
| Every Monday | Review the last 7 days against the 7 days before | Account owner |
| Day 3 of the month | Pull last month's data, fill the report, run the data gate | Account owner |
| Day 4 | Write the summary and actions, run the commentary gate | Account owner, then reviewer |
| Day 5 | Presentation gate, send, record the decision | Reviewer or sender |
Run QA in three gates
Check the data before you edit the words. There is no value in polishing a summary that compares two different sets of campaigns.
- Data gate: confirm the account ID, the dates, the comparison dates, the currency and the results column. Compare the report total for cost with the total in the Google Ads Campaigns table for the same dates.
- Commentary gate: every sentence with a number must match the table. Every cause must be marked as confirmed (a recorded change, such as a budget edit, that the numbers support) or as possible. Every action has an owner and a date.
- Presentation gate: open the file the client will receive. Check the logo and client name, page breaks, chart labels, and that no other client's data is in it.
A worked check: blended ratios
Hypothetical figures. Campaign A spends $100 for 10 clicks (CPC $10). Campaign B spends $900 for 30 clicks (CPC $30). The average of the two CPCs is $20. The account CPC is $1,000 ÷ 40 clicks = $25. Recalculate every account-level ratio from summed cost and summed clicks or conversions. Never average the campaign ratios.
Give each step an owner, even on a team of one
In an agency, the account owner pulls the data and writes the first draft, a reviewer runs the commentary gate, and whoever sends the report runs the presentation gate. A freelancer does all three, so separate them in time: do the data gate on one day and read the commentary fresh the next morning. A checklist that you tick in writing catches more than a mental pass.
Keep a decision log per client: the date, what the client approved, who makes the change, and when you will look at the result. Next month's report then starts from those decisions instead of from a blank page.
Write commentary that separates what happened from why
Clients act on causes, so a wrong cause costs more than a missing one. Compare these two versions of the same hypothetical paragraph.
- Before: CPC went up because competitors are bidding more, so we need more budget.
- After: Average CPC rose from $2.10 to $2.65. Search lost IS (rank) rose in the non-brand campaign, which fits higher competition, but the data does not confirm it. We changed nothing in that campaign this month. Proposal: keep the budget and test a bid strategy target change for 14 days.
Tooling options for agency reporting
Native Google Ads covers more than many agencies use. Statistics tables download as Excel CSV, TSV, PDF, XLSX, XML or Google Sheets, and you can schedule them by email. Scheduled reports go only to people who have access to the Google Ads account, so a client without access cannot receive them directly.
Data Studio (formerly Looker Studio; Google renamed it on 2026-04-16) is free for creators and viewers, connects to Google Ads, and can email a report as a PDF on a schedule. You build and maintain each report yourself. Its Google Ads connector covers up to 50 sub-accounts per data source for manager account users.
Dedicated reporting platforms add white-label branding, client portals and many data sources. They price per client, per dashboard or per data source, so cost grows with the client list in different ways. Check each vendor's pricing page against your own number of clients and sources.
Where KeySend fits for freelancers and small agencies
KeySend covers the daily check and the first draft of the commentary for a small number of Google Ads accounts. It connects with a Google sign-in, only reads the Ad Account, and never changes a campaign. Every morning it writes an Update in plain English for each Ad Account: what changed in spend, conversions and Campaigns, with the evidence. Code calculates every number; AI only words the text. A Cause is labelled Confirmed or Likely, which matches the commentary gate above.
It also gives you rule-based Findings, such as a Campaign limited by budget or search terms with spend and no conversions, and Recommendations that state the problem, what it costs, the change to make and the numbers behind it. Alerts email you the morning after a Campaign stops or spend doubles. Each Account change that belongs to one Campaign gets a Follow-up after 14 complete days. A weekly email arrives each Monday. The Export is a PDF of one Ad Account or one Campaign with your client's name, logo and accent colour.
Check the limits against your client list before you start:
- Google Ads only. Meta, GA4 and LinkedIn data are not included.
- Up to 5 Ad Accounts per $49 per month Subscription (plus tax), whatever the ad spend.
- One User per Workspace. There are no team seats and no client login or client portal.
- The Export is PDF only, for the last 7 or the last 30 days. It does not cover a chosen calendar month or a custom date range.
- You download the PDF and send it. KeySend never sends it to a client.
- KeySend is read-only. You make every change in Google Ads yourself.
Review the workflow after each cycle
After each monthly cycle, note which numbers a client questioned, which sections nobody read, and which actions were approved. Remove the unread sections. Add evidence where questions repeat. Record your own time per step (data pull, fixes, writing, review, follow-up questions) so you can see which step to change next. If a client asks what they will see from you, the page for agency clients shows the KeySend side, and how KeySend handles Google data answers the access question.
