SEO Report Template for Clients: What to Put In and What to Leave Out
A good SEO report template puts the client’s own business number in the first two lines, explains every movement up or down in the same plain voice, and ends with one thing you need from them. Leave out the ranking tool screenshots, the list of every task you did and any rise you can’t honestly say you caused.
This guide is for SEO agencies, marketing agencies and freelancers on retainer, from beginner to expert. It works whether you send ten reports a month or haven’t sent your first one yet.
This guide is part of the free course Agency AI Client Report Generator. If you want the prompts that build this SEO report template for you, the free Agency AI Client Report Generator course walks you through six of them, using a demo month if you have no client yet. It’s free, with no card.
Start the free course →Why most SEO reports get filed, not read
Most clients experience your SEO work as one document a month. They don’t see the fixes or the briefs. They see the report, and renewal is decided across eleven ordinary months of it, not at the renewal meeting.
Four habits lose it:
- Leading with activity. “Published four posts, fixed crawl errors.” The client can’t tell whether any of it worked, so the fee starts to look like a subscription to effort.
- Burying the bad month. Clients notice what is missing far more reliably than what is there.
- Claiming every rise. If you claim the seasonal lift in spring, you own the seasonal drop in autumn.
- Asking for nothing. A report that needs no reply gets no reply, and you find out how the client felt at renewal.
The trap is that accurate and useless are not opposites. Impressions, clicks and average position can all be correct and still describe a month the client didn’t have. If organic sessions rose but enquiries fell, it was a bad month for the business, whatever the dashboard says.
What to put in an SEO report template
Six sections, in this order:
- Their number first. Enquiries, bookings, sales or calls from organic search, with last month beside it. If you aren’t sure which number matters, they have almost certainly told you already.
- What moved and why. Rises and falls in the same plain tone. Sort each movement into three groups: what you caused, what you didn’t (seasonality, a competitor, a Google update, their own promotion), and what you can’t explain yet.
- What it means in money. Their revenue, bookings or hours. Nobody renews a retainer because average position improved.
- What you don’t know. Tracking gaps, a form that stopped recording, date ranges that don’t match. The gap you hide is the one they find.
- What happens next month. Two or three specific actions with dates, so next month’s report can open by saying whether you did them.
- One ask. Access, an approval or a figure. Exactly one, every month. It turns a document into a conversation.
The same six sections work as a marketing report template for social, PPC or email clients too. Only the lead number changes.
What to leave out
- Raw ranking screenshots. Pick the few keywords tied to pages that bring in money and describe them in a sentence.
- A list of every task. Keep a task log in a shared sheet if they want it.
- Words the client never uses. Write “people who found you on Google”, not “organic SERP visibility”.
- Any estimate you can’t back. If you don’t have their average order value, ask for it. An invented figure contaminates every conclusion after it.
How to build the report with Claude, step by step
- Export last month’s data as it comes: Search Console, analytics and the client’s own enquiry or sales figure. Don’t tidy it first.
- Tell Claude the truth about the month, including any weeks you were waiting on the client and did little.
- Ask Claude to sort every movement into caused, not caused and unexplained. Once something is in “not caused”, it stays there.
- Draft the report from that sorted list, not from the raw data.
- Write a covering note short enough to read on a phone.
- Check the draft against your analysis. If it reads as cheerful good news, something has usually been left out.
Two prompts to start with. Square brackets mark what only you can fill in.
I am writing a monthly SEO report for [client business name], a [type of business] in [town or market]. The number their business runs on is [enquiries / bookings / sales from organic search]. Here are last month's raw exports: [paste exports]. Here is what I actually did this month, including any quiet weeks: [your honest work log]. Sort every movement into three lists: caused by our work, not caused by our work, and cannot explain yet. Give the evidence for each. Do not estimate any figure I have not given you. Ask me for it instead.
Using only the three lists above, write a two-page report for the owner, not for a marketer. Open with [their number] and last month's comparison in the first two lines. Explain falls in the same tone as rises. Name anything we don't know. List two or three dated actions for next month. End with one request: [the one thing you need from them]. Then write a covering note under 120 words.
Worked example (fictional demo)
Harbour Street Physio is a fictional demo clinic, not a real client. In the demo month, clicks and impressions from Google both rose. A platform-style report would lead with that. But the clinic’s number is first appointments booked through the website, and those fell, because the booking form stopped working for six days.
The honest report opens: “Website bookings for first appointments were down on last month. Most of the drop came from six days when the booking form wasn’t working, which we found and fixed on [date]. Search traffic itself rose.” It credits one thing the agency did cause, a new treatment page, names the spring rise as seasonal, and asks for one thing: access to the booking system’s own figures, so next month’s numbers match.
Common mistakes
- Sending the platform’s automatic PDF and calling it a report.
- Explaining only the good months.
- Keeping a tracking problem quiet until the client spots it.
- Letting AI fill in figures you never gave it.
- Sending the report with no covering note, so it lands as an attachment nobody opens.
Get the full reporting workflow
Honest reports are also how you win the next client, because retention and referrals are the cheapest acquisition there is. If you’re still at the stage of getting SEO clients, that guide covers the first steps.
The free Agency AI Client Report Generator course is four short lessons, six prompts and a recorded demo on a deliberately untidy month of exports. You finish with a two-page report that leads with the client’s number, a covering note written for a phone, and an internal note on upsell and churn risk that you never send. It’s free, with no card and lifetime access, and it sets up your client reporting whether you have clients yet or not.
FAQ
How long should an SEO report be?
Two pages is enough for most retainers. If a client wants more detail, share a task log separately.
Should I include keyword rankings?
Only a few, tied to pages that bring the client money, written as a sentence about what changed for the business.
What if the month was bad?
Say so in the first two lines, in the same tone you would use for a good month. Then explain what caused it, including when it was outside your control and when it wasn’t.
