Keyword ranking report template

A keyword ranking report template: tracked keywords with position changes, a ranking distribution, and the commentary that makes the movement mean something.

How to use it: paste your rank tracker's export into the table, then write the commentary. Rankings are a leading indicator, so pair this report with traffic and leads rather than sending it on its own.

Example report: Ledgerline, August 2026. Prepared for Ledgerline, a fictional accounting software company. Source: rank tracker, US, desktop, checked daily; positions are the last seven days' average.

Summary#

14 of 40 tracked keywords rank in the top three, up from 11 in July.
"small business bookkeeping software", the highest-volume target, moved from 9 to 6.
Two keywords fell out of the top ten after a competitor published a comparison page. Our response is in the plan below.

Ranking distribution#

Position	August	July	Change
1–3	14	11	+3
4–10	13	15	-2
11–20	8	9	-1
21–50	4	4	0
Not ranking	1	1	0

Tracked keywords#

Keyword	Monthly searches	August	July	Change	Ranking page
small business bookkeeping software	6,600	6	9	+3	/bookkeeping-software
invoice software for contractors	1,900	2	4	+2	/invoicing/contractors
accounting software for nonprofits	1,600	3	3	0	/nonprofits
quickbooks alternative	4,400	12	8	-4	/compare/quickbooks
xero vs quickbooks	8,100	14	7	-7	/compare/xero-quickbooks
how to reconcile a bank statement	2,900	1	2	+1	/guides/bank-reconciliation
1099 filing software	1,300	5	6	+1	/1099

Trimmed to seven rows for the example. A real report lists every tracked keyword.

What moved and why#

Gains came from the refreshed bookkeeping page (new pricing table, customer quotes) and from internal links added from twelve guide articles.
Losses on the two comparison terms coincide with a competitor launching a side-by-side comparison with pricing on 12 August. Our comparison pages still describe features in paragraphs.

Next month#

Rebuild both comparison pages as tables: price, invoice limits, payroll, integrations, support hours.
Add the 1099 filing deadline calendar to /1099 ahead of January demand.
Add eight new keywords around payroll to the tracker, since the payroll page launches in October.

About this report#

Positions are desktop US results, averaged over the last seven days to smooth daily swings. Monthly searches come from the rank tracker's volume data. A ranking is not a visit: see the monthly SEO report for clicks and sign-ups.