SEO Reporting That Clients Actually Read: Template + Process

First published: 17 June 2026 · Last updated: 17 June 2026

LAYER 1

Business outcomes

Revenue from organic, leads, pipeline, attributed conversions. The number the client's boss asks about.

1 page

LAYER 2

Search outcomes

Rankings on tracked keywords, clicks, impressions, AI citation count, top-performing URLs.

2-3 pages

LAYER 3

Work log + next month

What we shipped, problems we solved, what is queued for next month. The justification for the retainer.

3-4 pages

APPENDIX

Vanity metrics

Domain Rating, total backlinks, total keywords, ranking distribution. Available if asked, not in the executive summary.

1-2 pages

The state of SEO reporting in 2026 is roughly the same as it was in 2018, which is the problem. Most agency reports we have inherited from prior providers (we audit a lot of them when we onboard a new client) follow the same broken pattern: a 14-page PDF dominated by a Google Analytics screenshot, a Search Console screenshot, a list of every keyword whose rank changed, and a section called "next steps" that says "continue optimisation". The client's CFO reads page one. The marketing manager skims pages two and three. Everyone forgets it by the next monthly call. Reports that earn renewals are structured the opposite way. They open with a number the CFO recognises (revenue from organic, qualified leads attributed to search, pipeline added), drill into the search-side mechanics that produced that number, and then spend the bulk of the page count on the work itself. The shape matters because executive attention is front-loaded: the first 90 seconds of report-reading determines whether you keep the account. This guide is the practitioner version. We cover the template architecture, the metrics that earn the renewal versus the ones that lose it, the presentation format for monthly versus quarterly, and the protocol for the inevitable bad-news month. For broader context on the tools that feed the report, our existing Ahrefs vs Semrush vs Moz comparison covers the data-source layer.

Why Most SEO Reports Fail to Earn Renewals

Three failure modes recur across the reports we audit: Failure 1: Vanity-metric domination. The report leads with Domain Rating, total backlinks, or "keywords ranking in top 100" and treats these as proof of value. The problem is that these numbers move slowly, are gameable, and have no causal connection to the revenue the client cares about. A six-month run of "DR up 4 points, total backlinks up 1,200" looks impressive in isolation and means almost nothing if organic-attributed revenue is flat. Failure 2: Data dump without narrative. The report shows 14 charts, no commentary. The client is left to figure out what each chart means and what the agency did to influence it. This is the agency abdicating its job. The narrative is the deliverable. Charts are evidence. Without narrative, you are billing retainer rates for what is essentially a Looker Studio dashboard the client could build themselves. Failure 3: No work log. The report has no record of what the agency actually did. No content shipped, no technical fixes, no link-building activity, no keyword-targeting decisions documented. When the renewal conversation comes up and the client's CFO asks "what did we get for $8,000 a month for the last six months", there is no defensible answer in the document trail. The corrective is structural. Build the report around what the client actually needs to make the renewal decision: did SEO produce business outcomes, what is the search trajectory, and was the work the agency did worth the retainer? Everything else is secondary.

The Three-Layer Template (with Section-by-Section Breakdown)

The template architecture is shown in the hero infographic above. Here is the section-by-section content for each layer.

Layer 1: Business Outcomes (1 page, 90-second read)

This is the executive summary. The CFO reads only this page. Everything else exists to justify the numbers here. Required elements:

1. Headline number. One sentence: "Organic search produced $84,300 in attributed revenue this month, up 12% MoM and up 38% YoY." Pick the metric that is closest to revenue for the client's business model. For ecommerce, that is GA4 attributed revenue from organic. For lead-gen, that is qualified leads (with definition) and pipeline added. For B2B SaaS, that is trials, demos, or whatever the funnel-top conversion event is.
2. Three to five supporting metrics with MoM and YoY deltas. Organic sessions, organic conversions, conversion rate, average order value or lead-to-customer rate, and (in 2026) AI-driven referral traffic from ChatGPT, Perplexity, Copilot.
3. One paragraph of context. What drove the headline number? Was it a content win, a technical fix, a seasonality boost, an algorithm update? Two to four sentences, not a thesis.
4. The single most important next-month focus. One sentence. "Next month we ship the local-SEO programme for the new Jurong location, which we project will lift branded local search by 30% by August."

That is the entire page. Restraint is the design choice. A page with one number, three deltas, and a sentence of plain English will outrank a 12-chart dashboard for executive attention every single time.

Layer 2: Search Outcomes (2-3 pages)

This is for the marketing manager who actually owns the SEO programme on the client side. They want to see the search-side mechanics that produced the business outcome above. Required elements:

1. Tracked keyword movement table. Top 30 priority keywords (not all 800 the client ranks for). Show current position, prior month position, change, search volume, and the URL that ranks. Highlight movements over 5 positions.
2. Click and impression chart. Search Console clicks and impressions for the last 90 days, with annotations on algorithm updates and major content launches.
3. Top winning and losing URLs. Top 10 URLs with the largest click gain and the top 10 with the largest click loss, MoM. The losing-URL list is more important than the winning one because it forces the conversation about what to fix.
4. AI search visibility. Citation counts in ChatGPT, Perplexity, Google AI Overviews on a tracked prompt set. This section is new in 2026 and the single biggest signal that the agency is keeping up with the search shift. See our AI SEO audit workflow for the underlying methodology.
5. Featured snippet and AI Overview captures. Which of the client's URLs are sourced as featured snippets or AI Overviews this month, with the query that triggered them.

The tone of this layer is diagnostic. Each table or chart gets one to three sentences of commentary explaining what changed and why.

Metric

Position

Why

Organic-attributed revenue or qualified leads

Page 1, headline

The number the CFO asks about. Closest to the business.

Organic conversion rate, AOV, lead-to-close

Page 1, supporting

Explains why revenue moved.

AI referral traffic (ChatGPT, Perplexity, Copilot)

Page 1, supporting

2026 signal that the agency is current.

Tracked keyword movements (top 30 priority)

Layer 2

Mechanism behind the revenue movement.

GSC clicks and impressions, 90-day trend

Layer 2

The leading indicator for revenue.

AI citation count on tracked prompts

Layer 2

Visibility in zero-click AI surfaces.

Domain Rating / Authority

Appendix

Slow-moving, gameable, no direct revenue link.

Total backlinks, referring domains

Appendix

Available if asked. Not headline material.

Total keywords ranking in top 100

Appendix

Inflated by long-tail noise. Misleading.

Bounce rate, pages per session

Appendix or omit

Engagement metrics that GA4 has largely deprecated as standalone signals.

Layer 3: Work Log + Next Month (3-4 pages)

This is where the renewal conversation is won. The client signed up for service. This section proves the service was delivered. Required elements:

1. Content shipped. Every blog post, landing page, programmatic page, or content update that went live this month. Include URL, target keyword, current rank, and (after 60-90 days) traffic.
2. Technical work shipped. Every redirect, schema deployment, INP fix, indexability fix, internal link improvement, with before/after measurements where applicable.
3. Link-building activity. Every link earned this month with referring domain, anchor text, target page, and (where relevant) DR or organic traffic of the linking site. If you do digital PR, include reach metrics.
4. Local SEO work (if applicable). GBP posts, photo uploads, citation builds, review responses.
5. AI search work (2026 standard). Schema deployments specifically for AEO, prompt-test results, GEO content optimisations, citation-tracking commentary.
6. Issues identified and resolved. Any indexability problems, manual actions, broken redirects, or other emergencies that came up and how they were handled.
7. Next-month plan. Specific deliverables with target dates. Not "continue optimisation". Specific things: "ship 4 blog posts targeting [cluster], complete schema rollout on product pages, submit 3 PR pitches".

The discipline of this section is specificity. Generic statements ("worked on technical SEO this month") signal that nothing was actually done. Specific statements ("deployed FAQPage schema across 47 service pages, observed 3 new AI Overview citations within 14 days") signal craft and effort.

The Cadence Stack: Weekly, Monthly, Quarterly

Different audiences want different rhythms. The cadence stack we run for retainer clients:

Cadence

Format

Audience

Purpose

Weekly

Live dashboard (Looker Studio, AgencyAnalytics, DashThis)

Marketing manager + SEO lead

Self-serve diagnostic, no narrative needed

Monthly

8-10 page PDF + 30-min call

Marketing manager + occasional CMO

Recap + work log + next-month plan

Quarterly

15-20 page deck + 60-min strategic review

CMO + CFO + sometimes CEO

Strategic recalibration, budget conversation, renewal

Annual

Full-year executive summary + next-year plan

Board-level if applicable

Big-picture ROI, multi-year roadmap

The weekly dashboard is unattended. Live pull from GA4, GSC, Ahrefs or Semrush, and the AI visibility tracker. The dashboard exists so that when the client logs in on a Tuesday morning to check rankings, they can. It is not a substitute for the monthly report. It is a self-serve channel that takes pressure off the monthly call. The monthly report is the core deliverable. PDF or Notion doc, 8-10 pages, accompanied by a 30-minute call to walk through it. Some agencies do video-walkthrough monthly reports (a Loom-style screen-share with commentary) and clients tend to love these because they replicate the call in async form. The video version still needs the underlying document because written reports are searchable and forwardable. The quarterly review is the renewal conversation in disguise. The deck format here forces a recalibration: are we still working on the right things? Is the keyword list still right? Has the search landscape shifted (it has, every quarter, in 2026)? This is the right cadence to introduce major strategic shifts, propose budget changes, or have the difficult conversation about a vertical that is not working.

Presentation Format: PDF, Loom, Live Call, or Notion

Format influences whether the report gets read. PDF report. Familiar, forwardable, bossable. The default for accounts where the marketing manager needs to forward the report up the chain. Cons: static, requires effort to keep on-brand, not collaborative. Notion or Google Doc report. Collaborative, easy to update, easy to embed live charts. The default for tech-forward clients who want to comment in-line and see real-time dashboards. Cons: harder to forward up to leadership, looks less polished than a designed PDF. Loom-walkthrough video. Highest engagement format we have measured: in our portfolio, video-walkthrough reports have a 78% open rate versus 41% for PDF-only. The video forces narrative. Hard to skip past the executive summary when someone is talking through it. Cons: time-intensive to produce, harder to forward to non-technical stakeholders. Hybrid: PDF + 5-min Loom + 30-min monthly call. What we run. The PDF is the artefact. The Loom is the executive walkthrough for the busy stakeholder. The call is the working conversation. This costs roughly 2 hours of senior time per client per month, which is the right investment for a retainer over $5,000. The wrong format choice is a static PDF with no walkthrough video and no live call. That is "report and ghost" and it is the format that loses accounts.

How to Handle Bad-News Months

Every retainer has bad months. An algorithm update hits, a competitor launches a major content drop, a technical regression goes live, seasonality bites. The protocol matters more than the news. Rule 1: Surface the bad news in the executive summary, not page 7. Hiding a 22% organic decline in a chart on page 7 destroys trust when the client finds it. Lead with it. "Organic-attributed revenue down 22% MoM driven by the June core update affecting [X] pages. Recovery plan and timeline below." The CFO respects directness more than spin. Rule 2: Have a hypothesis within 48 hours. Bad-news months trigger client anxiety. The agency that diagnoses fastest keeps the account. Even a partial diagnosis ("our top-performing service page lost rankings on three queries; we are auditing the affected pages by Friday") buys 30 days of patience. Silence loses accounts. Rule 3: Tie the recovery plan to specific work. "We will publish three updated pillar pages, deploy schema fixes on the affected templates, and re-pitch our top-tier link prospects on the new content. Timeline: 4 weeks. Expected recovery: 60-80% of lost traffic by week 8." Vague recovery plans ("we will continue to optimise") are renewal-killers. Rule 4: Acknowledge what is outside SEO control. A core algorithm update, a new competitor with a $10M content budget, a Google product launch (AI Mode, AI Overviews) that vapourises a query category, are not the SEO team's fault but they are the SEO team's problem to navigate. Naming the external factor honestly is more credible than implying total control. Our existing helpful content update recovery guide covers the post-update protocol in depth. Rule 5: Never blame the client in writing. Even if the client refused to ship the technical fixes you flagged in March and that is the proximate cause of the August traffic drop, the report is not the place to litigate it. Document the recommendation in the work log ("technical fix X recommended in March, awaiting development resource to ship") and address the cause-and-effect in the live call.

The Tooling Stack That Feeds the Report

For an 8-10 page monthly report, the data sources you actually need:

1. GA4 for organic traffic, conversions, attributed revenue, AI referral traffic.
2. Google Search Console for impressions, clicks, CTR, query and page-level data, indexing status.
3. Ahrefs or Semrush for keyword rank tracking, backlink data, competitor benchmarking. Pick one. Running both is a budget waste unless you specifically need both for client deliverables.
4. An AI visibility tracker (Profound, AthenaHQ, Otterly, or our DIY methodology in our ChatGPT citation guide) for tracked-prompt monitoring across ChatGPT, Perplexity, Google AI Overviews.
5. A reporting layer to assemble the above. Looker Studio (free), AgencyAnalytics, DashThis, or a custom Notion template. The reporting layer is where the dashboard lives. The narrative document (the actual report) is still hand-written.

We deliberately avoid reporting tools that auto-generate "AI summary" commentary on charts. The narrative is the deliverable. Auto-generated summaries are blandly correct and read as agency boilerplate. Clients can spot the difference between a senior strategist's analysis and a GPT-generated paragraph and they pay retainers for the former.

A Worked Example: SG B2B SaaS Monthly Report (May 2026)

Concrete example. Client: SG B2B SaaS, $7,500/mo retainer, 14 months in. Below is the page-by-page breakdown of the May 2026 report. Page 1 — Business outcomes. Headline: "Organic search produced 47 SQLs and SGD 184k in pipeline this month, up 9% MoM and up 41% YoY. The 47 SQLs converted at 22% to paid trials, generating SGD 21k MRR." Three supporting deltas. One context paragraph (mentioning the new comparison-page cluster shipped in March now driving 28% of SQLs). One next-month focus (international SEO programme launch for AU and MY). Pages 2-4 — Search outcomes. Top 30 keyword movement table. GSC trend chart with annotations on May core update (no impact, called out as the key resilience signal). Top winning URLs (the new comparison cluster) and top losing URLs (two legacy posts cannibalised by the new cluster, recommendation to consolidate). AI citation count: 14 new citations across ChatGPT, Perplexity, Copilot for tracked prompts. Featured snippet captures: 3 new on bottom-funnel queries. Pages 5-8 — Work log. 4 new comparison-page templates shipped. 6 blog posts. Schema rollout completed across product pages. 12 new backlinks (one Tier-1 publication, six Tier-2 industry sites). Local SEO not applicable (B2B SaaS). AI search work: deployed FAQPage and HowTo schema across the new comparison templates, observed first AI citation within 11 days. Issues: one indexability bug from May 14 deploy resolved within 48 hours, no traffic impact. Next month: AU and MY localisation, 4 more comparison pages, prep for Q3 link-building campaign. Page 9 — Appendix. DR up 1 point. Total backlinks up 47. Total keywords in top 100 up 312. Available if asked, not headline material. Total length: 9 pages. Reading time for the executive summary: 90 seconds. Total reading time end-to-end: 12 minutes. The client's CMO reads page 1. The marketing manager reads pages 1-8. The CFO sees only page 1, forwarded by the CMO. This split is intentional. The report is designed for it.

Frequently Asked Questions

How long should a monthly SEO report be?

8 to 10 pages for a retainer of SGD 5,000 to 15,000 per month. Longer reports lose readers; shorter reports underprove the work. The right length is whatever fits a 12-minute end-to-end read with a 90-second executive summary. The page count itself is not the value. The narrative density is. A tight 8-page report beats a sprawling 22-page report on every renewal metric we have measured.

Should I include keyword ranking tables in the report?

Yes, but limited to the top 30 priority keywords, not the full ranking universe. Full ranking tables (every keyword the client ranks for) are appendix material at best. The top-30 table forces prioritisation: which 30 queries actually matter for the client's business? That conversation alone is usually worth more than the table itself.

What about reporting on AI search visibility specifically?

Required in 2026. Our standard format is a tracked prompt set (20 to 50 prompts the client's customers might ask AI engines) tested monthly across ChatGPT, Perplexity, Google AI Overviews, and Copilot. Report citation count, citation rank when present, and direct comparisons against the top 3 competitors. Tools like Profound or AthenaHQ automate this; the DIY version is a spreadsheet plus monthly manual checks. See our Perplexity SEO guide and ChatGPT citation guide for the underlying methodology.

Should the report include attribution from organic to revenue?

Yes, and this is the single biggest reporting upgrade most agencies can make. Pull GA4 attributed conversions and revenue from the Organic Search channel, segment by landing page where useful, and surface the dollar figure on page 1. For lead-gen clients where revenue is opaque, substitute MQLs or SQLs with a documented conversion rate. The point is to translate SEO outputs into a number the CFO recognises.

How do I report on link-building work without inflating the numbers?

Show every link earned with referring domain, anchor text, target page, and a quality indicator (DR or organic traffic of the linking site). Avoid "total backlinks gained" as a headline number because it conflates one Forbes link with 200 directory submissions. The narrative point is the quality of the wins. If you earned one link from a Tier-1 publication and three from Tier-2 trade press, that is a strong month, even if total volume is low.

What is the right cadence for client review calls?

Monthly is the floor. Weekly is excessive for most retainers and burns senior time the client is paying for. Quarterly strategic reviews are essential and often skipped: this is the renewal conversation in disguise and the right time to reset keyword priorities, propose budget shifts, and discuss the next 90 days. For accounts above SGD 20,000/mo, a fortnightly working call between the marketing lead and the SEO strategist is common, separate from the monthly executive report.

Related reading

• Ahrefs vs Semrush vs Moz: the SEO data layer that feeds the report
• AI SEO audit workflow: the methodology behind the AI visibility section
• GEO optimisation tactics playbook: the work that gets reported on