What reporting really costs an agency
Reporting is one of the largest hidden costs in agency work. AgencyAnalytics’ benchmark research found nearly half of agencies spend one to four hours a week per client on reporting. Across 20 clients, that can approach a full-time role spent copying numbers rather than improving results.
Most of that time goes to three tasks: exporting data from several tools, reshaping it into the same format every month, and writing the commentary that explains what changed. The first two are mechanical. The third is where your expertise shows, but even it follows patterns.
What clients actually read
Clients rarely study every chart. Most want quick answers to four questions:
- Are we growing?
- Why did things change?
- What did you do this month?
- What happens next?
A good AI-assisted report puts those answers on the first page and keeps the detailed tables as an appendix. That structure also happens to be what language models write well.
One-time setup for multiple clients
- Ask each client to add your agency’s Google account as a user on their Search Console property, and do the same in Bing Webmaster Tools.
- In GSC MCP Server, connect that Google account and Bing account. Every property they can see becomes available, so one connection can cover many clients.
- If some clients insist on their own accounts, connect those separately and label them, for example “Client – Northwind”.
- Add the server to the assistant your team uses. See the connection guide for Claude, ChatGPT and Cursor.
The monthly workflow, step by step
Step 1: Portfolio overview
Start with every client at once. The multicall tool runs several requests in one go, so this takes seconds.
For every connected property, compare September with August: clicks, impressions, CTR and average position, with percentage changes. Sort by the largest click change and flag any property down more than 10%.
This tells you where to spend your time before you write a single report.
Step 2: Per-client drill-down
For client-site.com, compare September with August. List the top 10 gaining and top 10 losing queries and pages by clicks. Then compare September with September last year to separate seasonality from real change.
Step 3: Explain the changes
Give the assistant the context only you have: releases, content published, campaigns, known algorithm updates.
Context: we published six articles on onboarding and fixed redirect chains on 12 September. Using the data above, write three short paragraphs explaining what drove the change in clicks, in plain language for a non-technical marketing director.
Step 4: Find next month’s actions
Find striking distance and low-CTR opportunities for client-site.com. Recommend the five actions with the best expected impact next month, each with the target page and the reason.
Our striking distance playbook and cannibalization guide explain how to judge those recommendations.
Step 5: Add Bing
Add a short Bing section: clicks and impressions this month vs last, top five pages, and whether pages in Bing’s index changed.
Clients increasingly ask about AI search visibility. A Bing section gives you something concrete to report; see why Bing matters for ChatGPT and Copilot.
A report structure that works
| Section | Contents | Source |
|---|---|---|
| 1. Summary | Three to five sentences: result, reason, next step | AI draft, strategist edit |
| 2. Headline metrics | Clicks, impressions, CTR, position; MoM and YoY | compare_search_periods |
| 3. What changed | Top gaining and losing pages and queries | compare_search_periods |
| 4. Work completed | Tasks shipped this month | Your project tracker |
| 5. Opportunities | Prioritised actions for next month | get_search_opportunities |
| 6. Technical health | Sitemaps, indexing checks on key URLs | list_sitemaps, inspect_url |
| 7. Bing and AI search | Bing performance and index trend | get_bing_crawl_stats |
Save your final prompt sequence as a team template, for example in a Claude Project or a shared document, so every strategist produces the same structure.
Keeping AI-written reports accurate
- Ask for the table behind every claim. “Show the numbers you used” turns a paragraph into something you can verify.
- Spot-check headline figures in Search Console before sending. It takes two minutes.
- Explain data quirks once. Query totals are lower than page totals because Google anonymises rare queries, and recent days may still change. Put a short note in your template so clients do not worry.
- Keep comparison windows identical in length and day-of-week mix.
- Never let the AI invent causes. If it cannot see a reason in the data, the narrative should say so.
Scaling to dozens of clients
- Run the portfolio overview first every month and triage: green clients get a short report, red clients get a deeper look.
- When a client drops sharply, switch to the traffic drop diagnosis checklist before writing anything.
- Use one conversation per client to keep context clean.
- Watch tool-call usage. A full monthly report usually takes a few dozen calls per client; the Agency plan covers 50,000 a month.
Turning saved hours into margin
If reporting drops from three hours to forty-five minutes per client, a 20-client agency recovers roughly 45 hours a month. You can keep that as margin, reinvest it in implementation work clients can see, or offer mid-month check-ins that were not profitable before.
The point is not to send more reports. It is to send clearer ones and spend the rest of the time moving the numbers.
Frequently asked questions
Can AI write my SEO client reports?
AI can gather the data and draft the narrative, which is most of the time spent. A strategist should still review the numbers, add context the data cannot show, such as site releases or campaigns, and own the recommendations.
How do I keep client data separate?
Label each connected account clearly and name the property in every prompt. Start a fresh conversation per client so earlier client data is not in context, and follow your clients’ policies on which AI providers may process their data.
Can I report on clients whose Search Console I don’t own?
Yes, as long as the Google or Bing account you connect has been added as a user on the client’s property. Any permission level that can view the Performance report is enough for reading data.
Which plan suits an agency?
The Agency plan covers 20 Google or Bing accounts and 50,000 tool calls a month, with every property inside those accounts available. Smaller consultancies often start on Pro, which covers 5 accounts.
Does this replace Looker Studio dashboards?
Not necessarily. Many agencies keep a live dashboard for clients who like to self-serve and use AI to write the monthly narrative and answer one-off questions. The two work well together.