How to Build a Keyword Ranking Report Clients Actually Read

A keyword ranking report clients actually read is one page, grouped by the pages that earn money, and led by the movements that changed something, not a raw export. As of July 2026, Google Search Console keeps a rolling 16 months of data and reports an average position blended across every location and device, so a free report built from it carries a caveat in its header. SE Ranking’s Core plan (£95 a month, or £76 billed annually, as of July 2026) tracks 2,000 keywords daily and includes 10 reports in its Report Builder; Semrush’s entry SEO plan at $139 (about £102) a month tracks 500. Below: what goes in, how often to send it, a worked example, and three ways to build it.

Disclosure: some links on this page are affiliate links. If you buy through one we may earn a commission at no extra cost to you. We only recommend tools we would genuinely use.

What a keyword ranking report is, and what it is not

A keyword ranking report is a dated snapshot of where a fixed set of keywords rank, which page ranks for each, how far each has moved since the last snapshot, and one line on why. It is one section of the monthly report in our client SEO report template, not the whole document.

It is not an outcome. Rankings are an input metric: they show whether pages are moving into positions that can earn clicks. Search Console clicks and the month’s enquiries show whether they did.

Our guide to how to track keyword rankings covers the tracking side (which tool, which settings, why Search Console’s average position misleads), while this post covers the report itself: what goes in, how often it goes out, how to build it, and how to present it. Both sit in our SEO tools hub.

The seven columns worth including

Seven columns, in this order.

1. Keyword. The phrase tracked, as a customer types it.
2. Page. The URL that ranks for it, so the wrong page ranking is visible.
3. Position. On the report date, from a fixed location and device.
4. Change. Places moved since the previous report.
5. Search volume, as a guide. A tool’s estimate, labelled as one, used to sort the rows.
6. SERP feature. Whether a map pack, snippet or AI Overview sits on that page, and whether the client owns it.
7. Note. What changed and what happens next. Clients read this column first, so write it last.

A fictional four-row set for a Cambridge roofing firm, with volume in bands because any single figure is an estimate:

Keyword	Page	Position	Change	Volume (guide)	SERP feature	Note
roof repairs cambridge	/roof-repairs/	3	+4	Medium	Map pack above	Rewritten 6 July; top organic result
emergency roofer cambridge	/emergency-roofing/	12	0	Low	Map pack above	Stuck on page two; reviews push next
slate roof cost	/blog/slate-roof-cost/	5	new	High	Snippet, not owned	Published 14 July; adding a costs table
roofers near me	/roof-repairs/	18	-6	High	Map pack and AI Overview	New AI Overview pushed organic down; watching

Weekly versus monthly: the cadence that works

Track daily, report monthly. Most reporting arguments come from confusing the two.

Daily tracking is the standard on the tools we recommend: as of July 2026 SE Ranking checks the top 100 daily on every plan, and Semrush Position Tracking updates daily on every paid plan.

Weekly reports to clients are different. Positions wobble day to day, and a weekly table turns every wobble into a worried email and an hour explaining that nothing happened. Monthly is the right default for almost every retainer, with a short note between reports only when a money keyword falls off page one or something equally material happens. The free version has an extra reason to be monthly: a Search Console position is an average over the impressions in your date range, and a full month gives it enough to settle.

Three ways to build the report, compared

Here is how the three routes compare, all as of July 2026; our best rank tracking software comparison covers the wider field.

	Search Console plus spreadsheet	SE Ranking, Core plan	Semrush Position Tracking, SEO plan
Cost	Free, plus your time	£95 a month, or £76 billed annually	$139 (about £102) a month, or $117.33 (about £86) billed annually, USD before VAT
Updates	Average position over your date range	Daily, top 100, desktop and mobile separated	Daily on every paid plan, desktop and mobile split
Local tracking	Country level only	City level, 190+ countries; map tracker to street level	City or postcode level
History	Rolling 16 months, then deleted	Six months on Core, all time on Growth	No figure we have verified
Export and reporting	Performance report export, or the free API	Report Builder, 10 scheduled reports; Agency Pack white label, £49 a month, annual only	Exports on paid plans, off during the 7-day trial; My Reports from $10 (about £7) per report a month

The free build: Search Console plus a spreadsheet

For a small site with a handful of pages this is genuinely enough, and we say that as an agency that earns a commission when readers buy paid tracking.

1. Set the date range. Open the Performance report, set it to the month you are reporting on, and filter the country to the United Kingdom.
2. Export queries and pages. Keep only your frozen panel of 50 to 200 keywords, each mapped to its page.
3. Add the page column. Filter by each keyword to see which page Google showed; the wrong page ranking is a common problem a report catches.
4. Paste last month beside this month. Two position columns and a change column.
5. Fill the SERP feature column by looking. The export gives query, page, country and device and nothing about the layout above you, so open the results and record it yourself; a private window still localises, as our guide to checking your Google rankings properly explains.
6. Write the caveat and archive the export. Positions are averages blended across every location and device, the location filter stops at country level, and Google hides rarely searched queries. “Search Console keeps data for the last 16 months”, in Google’s words, so a dated copy each month is free insurance.

Our best free rank tracker post covers where each free option runs out.

The SE Ranking build on the Core plan

SE Ranking is the route we recommend first, because the report is a by-product of the tracking rather than a separate job. As of July 2026 the Core plan costs £95 a month, or £76 billed annually, and tracks 2,000 keywords daily across 10 projects: around 4p per keyword per month on annual billing.

The tracker checks the top 100 daily, separates desktop from mobile, targets city level across 190+ countries, and flags 35+ Google SERP features, including AI Overviews and featured snippets, and whether your site has earned them, which fills the position, change and SERP feature columns without typing.

The report comes from the Report Builder: Core includes 10 reports, Growth (£209 a month, or £167.20 billed annually) includes 30, on a schedule you set, with Search Console, GA4 and Looker Studio integrations to put real clicks beside the positions. White labelling sits in the Agency Pack at £49 a month, annual billing only, with unlimited scheduled reports and 30 client seats. Historical rank data is six months on Core and all time on Growth, so Core users should archive each monthly report. The 14-day trial needs no card. Our full SE Ranking review covers the rest of the platform.

Try SE Ranking Free for 14 Days

The Semrush Position Tracking build

If the client already pays for Semrush, build the report there rather than adding a second subscription. As of July 2026 the entry SEO plan costs $139 (about £102) a month, or $117.33 (about £86) billed annually, USD before UK VAT, and includes 5 projects and 500 tracked keywords. Positions are recorded daily on every paid plan, desktop is split from mobile, locations go down to city or postcode level, and SERP features including AI Overviews are flagged.

Two cautions. Exports are disabled during the 7-day trial, which needs a card, so a trial cannot produce the report. And the Visibility score is a single percentage across every tracked position, moved most by high-volume keywords in high positions: judge it as a trend against its own history and read it beside real clicks from Search Console. Tracking alone does not justify that price for 500 keywords when dedicated trackers cover more for less. As of July 2026, My Reports costs $10 (about £7) per report a month for branded delivery, or $20 (about £15) with white labelling. Our Semrush Position Tracking setup guide covers the setup, and Semrush publishes the current limits.

How to present it so the client reads it

Lead with the movement that matters: three or four lines at the top saying which money keywords crossed onto page one or into the top three, which fell off, and what you are doing about each.

Group the rows by page or service, not alphabetically. A page up on every keyword is a page working; a page up on two and down on four is a page to look at.

Explain drops honestly, and open the results page before the page itself. A drop of six or eight places can mean the layout above the organic results changed, not that the page got worse, and the note column says which. If it is real, say so, say what caused it, and say what happens next. A bad month reported plainly builds more trust than a good month reported vaguely.

Put positions beside outcomes, so a top spot that earns nothing is visible as exactly that, and measure every report against a dated starting line: an SEO baseline report should be the first document of any engagement.

What we send clients is one page: the movements that matter at the top, rows grouped by page, positions beside Search Console clicks and the month’s enquiries, a note on every material change, and the same dated baseline every month. Our SEO tools for small business list covers the stack behind it.

The mistakes that get a ranking report ignored

• Too many keywords. Nobody reads a table of thousands. Report the 50 to 200 keywords mapped to money pages, keep the list frozen, and leave the long tail in the tracker.
• Vanity keywords. Ranking first for a term nobody searches is easy and worthless, and a client who checks one loses trust in every other row.
• A different layout every month. A report the client cannot lay beside last month’s is one they cannot read. Same columns, same order, same header, every time.
• The wrong rows for the client. A term they never asked about reported in full, and the one they check on their phone missing. Ask which searches they run, then make those rows easy to find.
• Mixing two kinds of position. A tracked position and a Search Console average are different measurements. Keep them in separate columns with honest headers.

Frequently asked questions

What should a keyword ranking report include?

Seven columns: keyword, the page that ranks for it, position on the report date, change since the last report, search volume labelled as an estimate, the SERP feature on that results page, and a one-line note on what changed. Group rows by page, lead with the movements that matter, and show positions beside Search Console clicks.

How often should you send a ranking report to a client?

Monthly, in the same week every month. Track daily, because daily data separates a real drop from ordinary turbulence, but report monthly, because weekly tables turn every wobble into a worried email. As of July 2026 SE Ranking checks positions daily on every plan and Semrush on every paid plan.

Can you get a keyword ranking report for free?

Yes, from Google Search Console and a spreadsheet. Export the queries and pages for the month, keep your frozen panel, and put last month’s positions beside this month’s. The caveats are fixed: positions are averages blended across every location and device, the location filter stops at country level, rarely searched queries are hidden, and history is a rolling 16 months.

Why does my ranking report not match what I see in Google?

Because you are looking at different things. Googling yourself shows results personalised and localised to you. A rank tracker checks from a fixed location and device on a schedule, and Search Console reports an average across every impression. A tracked 4, an average 8.5 and a 2 on your own phone can all be true at once.

How many keywords should a ranking report track?

Fewer than the tracker follows. Track whatever the panel needs, then report only the rows a client will read: every keyword mapped to a money page, grouped so each page occupies a block of rows on one page of the report. If the table runs past a single page, move the long tail into an appendix and keep the movements that matter at the top.