SEO KPI scorecard
Ten KPIs that tie to traffic and revenue, each with its source, how to measure it and a target column.
Free, no sign-up · works in Excel, Google Sheets, Numbers, Notion or any Markdown editor
At a glance
- Sections
- 4
- Type
- Scorecard · spreadsheet
- Formats
- xlsx · csv · md
- Cost
- Free, no sign-up
- From the guide
- SEO KPIs: the 10 metrics worth reporting
The whole template, on one page.
The downloads hold exactly this. Jump to a section from the list.
SEO KPI scorecard: [Site] · [Period]
01Scorecard
Pick three or four headline KPIs (usually non-brand clicks, organic key events and one ranking KPI) and report the rest as diagnostics.
| # | KPI | Source | How to measure | Report | This period | Previous | Change | Target | Status |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Non-brand clicks | Search Console | Query filter excluding brand terms (Custom regex), or the Branded / Non-branded filter | Monthly, with trend | |||||
| 2 | Impression share of a keyword group | Search Console + keyword tool | Group impressions ÷ total monthly searches for the same keywords | Quarterly | |||||
| 3 | Weighted position for tracked keywords | Search Console | Sum of position × impressions ÷ total impressions | Monthly | |||||
| 4 | Top-3 and top-10 keyword counts | Search Console | Tracked keywords with an average position of 3.0 / 10.0 or better | Monthly | |||||
| 5 | CTR vs expected CTR by position | Search Console | Median CTR per whole position from your own non-brand queries; flag queries well below it | Monthly, as a work list | |||||
| 6 | Pages with clicks | Search Console | Rows in the Pages tab with clicks above zero | Monthly | |||||
| 7 | Content decay count | Search Console | Pages 30% or more below their best month, in clicks per day | Quarterly | |||||
| 8 | Organic key events and revenue | GA4 | Traffic acquisition, Session default channel group = Organic Search | Monthly | |||||
| 9 | AI Overview exposure | Search Console (estimated) | Share of impressions and CTR of long, question-style queries; label it an estimate | Quarterly | |||||
| 10 | Share of voice in a keyword group | Search Console or rank data | Impressions × expected CTR at your position ÷ the same at position 1 | Quarterly |
02Targets
Set targets from 16 months of your own data, as a range, and write down what is outside SEO's control.
| KPI | Same period last year | Last 3 months trend | Conservative target | Expected target | Outside SEO's control |
|---|---|---|---|---|---|
03Vanity metrics to drop
| Drop | Use instead |
|---|---|
| Total keywords ranked | Top-3 and top-10 counts |
| Site-wide impressions | A keyword group's impressions |
| Third-party authority scores | Outcome KPIs (fine for link prospecting only) |
| Bounce rate and time on page | Organic key events |
| Number of articles published | Pages with clicks |
| All clicks, brand included, as the headline | Non-brand clicks, with brand clicks on their own line |
04Reporting cadence
| Frequency | KPIs |
|---|---|
| Weekly, internal only | Alerts for drops in non-brand clicks or top-10 keywords |
| Monthly | 1, 3, 4, 5, 6 and 8, vs the previous month and the same month last year |
| Quarterly | 2, 7, 9 and 10, with progress against targets |
The .xlsx, .csv and .md downloads contain the same content.
How to use it.
4 steps, start to finish.
- 01
Agree on the headline KPIs
Pick three or four that you'll be judged on. The rest stay on the sheet as diagnostics.
- 02
Split brand from non-brand
Set your brand terms once (with misspellings) and use the same regex in every report, so the numbers stay comparable.
- 03
Fill the comparison columns
This period, the previous period and the change. For seasonal sites, compare with the same period last year as well.
- 04
Set targets as a range
Start from 16 months of your own data: last year's same period plus the last three months' trend, then a conservative and an expected case.
With Serplyze
Fill this automatically from your Search Console with Serplyze
Serplyze builds several of these KPIs from your Search Console data every day: non-brand clicks once you set brand terms, average rank and top-10 counts of your tracked keywords as report KPI tiles, the ranking spread, content decay and AI search exposure (kept apart as estimates). GA4 key events and keyword-tool volumes still come from those tools.
Questions.
Non-brand clicks are the headline number, followed by organic key events and revenue from GA4 and a ranking KPI such as top-10 counts. The other KPIs on the scorecard are leading indicators of those.
A plain average misleads: adding new keywords at position 40 makes it worse though nothing dropped, and losing a weak keyword makes it better. Weighting by impressions and showing top-3 and top-10 counts next to it keeps it honest.
Not directly. Search Console includes AI Overviews and AI Mode in the Web search type without separating them, so any AI Overview figure is an estimate and should be labelled as one.
No. GA4 doesn't know which query brought a session, and consent banners and ad blockers mean it sees fewer visits. Report the two side by side instead.
More free templates.
All templates- Report
Monthly SEO report template
Nine sections that answer what happened, why, and what you do next, in under five minutes of reading.
Open the template - 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