Monthly SEO report template
Nine sections that answer what happened, why, and what you do next, in under five minutes of reading.
Free, no sign-up · works in Excel, Google Sheets, Numbers, Notion or any Markdown editor
At a glance
- Sections
- 9
- Type
- Report · document
- Formats
- xlsx · csv · md
- Cost
- Free, no sign-up
- From the guide
- Free SEO report template (+ what to put in it)
The whole template, on one page.
The downloads hold exactly this. Jump to a section from the list.
SEO report: [Site] · [Month YYYY]
011. Executive summary
- [Headline result in one sentence, with the number]
- [Main reason, in one sentence]
- [The one decision or next step that matters most]
022. KPIs vs target
| KPI | This period | Previous | Change | Target | Status |
|---|---|---|---|---|---|
| Organic clicks (GSC) | on track / behind | ||||
| Non-brand clicks (GSC) | |||||
| Organic conversions (GA4) | |||||
| Keywords in top 3 / top 10 |
033. Wins and losses
Top 5 keywords or pages that gained clicks: [query/page, change, why]
Top 5 that lost clicks: [query/page, change, why, what we'll do]
044. Brand vs non-brand
Brand clicks: [n, change] · Non-brand clicks: [n, change]
[One sentence on what drove the non-brand change]
055. Content and pages
New/updated pages this period: [list, with early clicks/impressions]
Pages to refresh: [list, with the drop and the likely cause]
066. Technical notes
[Indexing, Core Web Vitals, crawl or migration issues; "None" is a valid answer]
077. Actions done
- [Date] [What changed] on [page/section]; result so far: [number or "too early"]
088. Next month's plan
- [Action] · owner: [name] · expected effect: [metric]
- [Action] · owner: [name] · expected effect: [metric]
099. Appendix
[Full keyword table, page table, country/device split, notes on data gaps]
The .xlsx, .csv and .md downloads contain the same content.
How to use it.
5 steps, start to finish.
- 01
Copy it once, keep the order
Paste the template into a doc, a slide or an email. Keep the same sections in the same order every month, so readers learn where to look.
- 02
Fill the evidence first
Sections 2 to 7 come from Search Console (Performance > Search results with the Compare tab) and GA4 (Traffic acquisition, filtered to Organic Search). Sort wins and losses by the change in clicks, not by position.
- 03
Split brand from non-brand
Use Search Console's Branded and Non-branded Query filter where it's offered, or a Query filter that excludes your brand terms with a regex.
- 04
Write the summary last
Three bullets: the result, the reason, the decision. Delete any line you have nothing honest to say about.
- 05
Send it on the same day
Same day each month, same people, same format. End the period a few days back, since Search Console's latest days are still preliminary.
With Serplyze
Fill this automatically from your Search Console with Serplyze
Serplyze's report generator builds these sections from your Search Console data: summary KPI tiles, brand vs non-brand, top movers, top pages and queries, content findings and the actions you logged with their before/after result. You write the executive summary; the report goes out daily, weekly or monthly as an email with a PDF, or as a read-only link.
Questions.
An executive summary, four to six KPIs against target, the biggest wins and losses with a reason each, brand vs non-brand clicks, content and technical notes, the actions done, next month's plan and an appendix with the full tables.
One to three pages. A weekly version is five to ten lines (KPIs, biggest movers, anything broken); a quarterly one adds year-over-year comparisons and next quarter's targets.
Same nine sections, different depth. A client report leads with business outcomes and the work done, with the top five wins and losses in plain language. An internal report goes deeper: top 20 movers, impressions, CTR, position spread and every open technical ticket.
Search Console withholds rare queries for privacy, so the query table covers fewer clicks than the page table. Say so once in the appendix instead of explaining it every month.
More free templates.
All templates- Brief
Content brief template
Turn a cluster of Search Console queries into a brief a writer can act on, with a success check set before you publish.
Open the template - Checklist
SEO audit checklist
Nine Search Console checks, in order, with where to click and what counts as a finding. One hour a month.
Open the template - Scorecard
SEO KPI scorecard
Ten KPIs that tie to traffic and revenue, each with its source, how to measure it and a target column.
Open the template