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.
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.
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.
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
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.
| Tab | What it answers | Main sources |
|---|---|---|
| Monthly KPIs | Did SEO bring business this month, and is it on track? | GA4, CRM, Search Console, Ahrefs, Business Profile |
| Top pages | Which landing pages bring clicks and leads, and what to do with each | Search Console Pages report, GA4 conversions |
| Work done | What was delivered, so results can be explained | Your project tracker |
| AI visibility | Does ChatGPT, Gemini or Perplexity mention and cite you? | Fixed prompt set, Ubersuggest AI Visibility, Ahrefs Brand Radar |
| Next month | The three to five actions with an owner and a KPI | The analysis above |
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.
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.
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.
Monthly for most businesses, with a quarterly review that compares the same months of the previous year to remove seasonality.
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.
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.
As context, yes; as the headline, no. Rankings vary by location and device and do not pay the bills. Lead with leads and revenue.
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.
Updated November 2026. Figures from Pencil Speech projects state the tool and the period. Ahrefs traffic figures are third-party estimates, not client analytics.
Graduated in Social Communication magna cum laude from the Central University of Venezuela. I like to find the why behind things. The best way to understand a subject is by explaining it. SEO Consultant at Pencil Speech.
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.