Free template · Excel and Google Sheets

SEO report template: the monthly report we send clients (free download)

A free Excel template with the structure of our client reports: business KPIs first, then search, local and AI visibility, the work done and next month’s priorities. Works in Google Sheets and Looker Studio.

In short

A good SEO report starts with business results (organic leads and revenue), explains them with search data (clicks, impressions, CTR, rankings), shows the work completed and ends with three to five priorities for next month. Download our free SEO report template (.xlsx), with example data, drop-down lists and the formulas ready.

Download the template

SEO report template (.xlsx)

A Read me tab plus five tabs: Monthly KPIs, Top pages, Work done, AI visibility and Next month, filled with example data from a fictional business so you can see a finished report. Yellow cells are inputs; formulas calculate change vs last month and vs last year, status vs target, CTR, lead rate and AI mention rate. It prints one page per tab.

Download the Excel file

How to use it in Google Sheets

Upload the file to Google Drive, open it with Google Sheets and make a copy per client. To build a dashboard, connect the Monthly KPIs tab to Looker Studio as a data source; every tab has a single header row.

What is inside each tab

TabWhat it answersMain sources
Monthly KPIsDid SEO bring business this month, and is it on track?GA4, CRM, Search Console, Ahrefs, Business Profile
Top pagesWhich landing pages bring clicks and leads, and what to do with eachSearch Console Pages report, GA4 conversions
Work doneWhat was delivered, so results can be explainedYour project tracker
AI visibilityDoes ChatGPT, Gemini or Perplexity mention and cite you?Fixed prompt set, Ubersuggest AI Visibility, Ahrefs Brand Radar
Next monthThe three to five actions with an owner and a KPIThe analysis above

The KPIs, in the order that matters

  1. Business: organic leads (forms, calls, WhatsApp), qualified leads, revenue or pipeline.
  2. Website: organic sessions and organic conversion rate.
  3. Search: clicks, impressions, CTR, non-brand clicks, keywords in the top 3 and top 10.
  4. Authority: referring domains.
  5. Local: Business Profile calls and direction requests.
  6. AI: AI referral sessions and brand mentions in tracked prompts.

The order is deliberate. A report that opens with rankings invites the wrong conversation; one that opens with leads makes everyone focus on what SEO is for. This is the same structure we use in our client reports.

Common SEO reporting mistakes

  • Comparing a month with the previous one without checking seasonality or campaigns.
  • Mixing Search Console clicks and GA4 sessions as if they were the same metric.
  • Reporting third-party traffic estimates as real visits.
  • Listing tasks without connecting them to a result or a priority.
  • Fifty charts and no decision at the end.

Use the template together with our guide to SEO metrics, the SEO checklist, our SEO forecast guide and the free SEO infographics. To measure visibility in AI answers, read LLM SEO.

Frequently asked questions about SEO reports

What should an SEO report include?

Business results first (organic leads, qualified leads, revenue), then the search metrics that explain them (clicks, impressions, CTR, rankings), the work done that month, AI visibility and the priorities for next month.

How often should I send an SEO report?

Monthly for most businesses, with a quarterly review that compares the same months of the previous year to remove seasonality.

Is this template free?

Yes. It is licensed CC BY 4.0: you can use and adapt it, including with your own clients, as long as you credit Pencil Speech with a link.

Does it work with Google Sheets and Looker Studio?

Yes. Upload the .xlsx to Google Drive and open it with Google Sheets; each tab has one header row, so you can connect it to Looker Studio as a data source.

Should I report keyword rankings?

As context, yes; as the headline, no. Rankings vary by location and device and do not pay the bills. Lead with leads and revenue.

Want us to fill this report for you every month?

Our SEO plans include a monthly report with leads, search data and AI visibility, and a meeting to decide next steps. From USD 972 per month.

Sources and editorial notes

Updated November 2026. Figures from Pencil Speech projects state the tool and the period. Ahrefs traffic figures are third-party estimates, not client analytics.

Scroll to Top

Thanks! We received your information and will contact you within 24 business hours. Check your inbox: we sent you the link to book a free call.

Prefer to talk now? Message us on WhatsApp.

WhatsApp