Skip to content

Cookie settings

Necessary · always on

Sign-in, security and remembering this choice. The site doesn't work without them.

Analytics

Counts visits and how pages are used, so we know what to improve. Google Analytics, Microsoft Clarity.

Marketing

Measures which ads bring visitors and lets us show ads to people who visited. Meta, Google Ads.

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

The whole template, on one page.

The downloads hold exactly this. Jump to a section from the list.

monthly-seo-report-templateDocument preview

SEO report: [Site] · [Month YYYY]

Period: [1–30 Month] vs [previous period / same month last year]

Data: Google Search Console (clicks, impressions, CTR, position), GA4 (organic sessions, conversions)

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

KPIThis periodPreviousChangeTargetStatus
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

  1. [Action] · owner: [name] · expected effect: [metric]
  2. [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.

Preview of the Monthly SEO report template; the downloads hold the same content.

How to use it.

5 steps, start to finish.

  1. 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.

  2. 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.

  3. 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.

  4. 04

    Write the summary last

    Three bullets: the result, the reason, the decision. Delete any line you have nothing honest to say about.

  5. 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.