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.

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

The whole template, on one page.

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

seo-kpi-scorecardSpreadsheet preview

SEO KPI scorecard: [Site] · [Period]

Compared with: [previous period] and [same period last year]

01Scorecard

Pick three or four headline KPIs (usually non-brand clicks, organic key events and one ranking KPI) and report the rest as diagnostics.

#KPISourceHow to measureReportThis periodPreviousChangeTargetStatus
1Non-brand clicksSearch ConsoleQuery filter excluding brand terms (Custom regex), or the Branded / Non-branded filterMonthly, with trend
2Impression share of a keyword groupSearch Console + keyword toolGroup impressions ÷ total monthly searches for the same keywordsQuarterly
3Weighted position for tracked keywordsSearch ConsoleSum of position × impressions ÷ total impressionsMonthly
4Top-3 and top-10 keyword countsSearch ConsoleTracked keywords with an average position of 3.0 / 10.0 or betterMonthly
5CTR vs expected CTR by positionSearch ConsoleMedian CTR per whole position from your own non-brand queries; flag queries well below itMonthly, as a work list
6Pages with clicksSearch ConsoleRows in the Pages tab with clicks above zeroMonthly
7Content decay countSearch ConsolePages 30% or more below their best month, in clicks per dayQuarterly
8Organic key events and revenueGA4Traffic acquisition, Session default channel group = Organic SearchMonthly
9AI Overview exposureSearch Console (estimated)Share of impressions and CTR of long, question-style queries; label it an estimateQuarterly
10Share of voice in a keyword groupSearch Console or rank dataImpressions × expected CTR at your position ÷ the same at position 1Quarterly

02Targets

Set targets from 16 months of your own data, as a range, and write down what is outside SEO's control.

KPISame period last yearLast 3 months trendConservative targetExpected targetOutside SEO's control

03Vanity metrics to drop

DropUse instead
Total keywords rankedTop-3 and top-10 counts
Site-wide impressionsA keyword group's impressions
Third-party authority scoresOutcome KPIs (fine for link prospecting only)
Bounce rate and time on pageOrganic key events
Number of articles publishedPages with clicks
All clicks, brand included, as the headlineNon-brand clicks, with brand clicks on their own line

04Reporting cadence

FrequencyKPIs
Weekly, internal onlyAlerts for drops in non-brand clicks or top-10 keywords
Monthly1, 3, 4, 5, 6 and 8, vs the previous month and the same month last year
Quarterly2, 7, 9 and 10, with progress against targets

The .xlsx, .csv and .md downloads contain the same content.

Preview of the SEO KPI scorecard; the downloads hold the same content.

How to use it.

4 steps, start to finish.

  1. 01

    Agree on the headline KPIs

    Pick three or four that you'll be judged on. The rest stay on the sheet as diagnostics.

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

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

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