Track keyword rankings by recording a fixed keyword set, checking positions on a set schedule, and logging movement in one sheet so changes can be compared over time.
Ranking data is a measurement, not a verdict. A position moves because Google re-evaluated a page, a competitor improved, a search result layout changed, or the query itself shifted meaning. Treating each movement as a signal to investigate keeps the routine useful instead of noisy.
This guide covers how to track keyword rankings with a repeatable routine, what belongs in a tracking sheet, how desktop, mobile, and local results differ, when free checkers are enough, and what ranking movement can and cannot prove.
How to track keyword rankings with a repeatable weekly routine
A weekly routine works because it is frequent enough to catch meaningful movement and slow enough that normal fluctuation does not trigger panic. The routine below assumes a small keyword set, roughly 10 to 50 terms, which is manageable without automation.
- Lock a keyword list of 10 to 50 terms that match real search intent for the business, and freeze it for at least a quarter so comparisons stay valid.
- Record the starting position for each keyword, plus the URL that ranks, before any changes are made.
- Check positions on the same day each week, using the same device setting and location setting every time.
- Log each result in one sheet with the date, keyword, position, ranking URL, and any SERP features present.
- Flag only movements of three or more positions, or any keyword that enters or leaves the top 10, for closer review.
- Review flagged keywords against the page that ranks, then decide whether the cause is content, competition, or a layout change.
- Record what was changed and when, so the next few weeks of data can be read against that change.
The discipline matters more than the tool. A spreadsheet updated every week for six months tells a clearer story than a dashboard nobody opens.
Which signals belong in a keyword tracking sheet
A tracking sheet earns its keep when every column answers a question someone will actually ask later. Position alone is thin. Position plus the ranking URL plus the date explains most movement.
Useful columns include the keyword, the target page, the current position, the previous position, the change, the date checked, the device and location setting used, and any SERP features occupying space above the organic results. A notes column for changes made that week closes the loop.
Grouping keywords by intent keeps the sheet readable. Branded terms, service or product terms, and informational terms behave differently and should not be averaged into one number. A drop in a branded term usually means something different from a drop in a commercial term.
Two numbers with units are worth carrying alongside position: the number of keywords in the top 10, and the number of keywords tracked in total. Both are simple counts, and both make weekly progress visible even when individual positions bounce.
Track Keyword Rankings across desktop, mobile, and local results
Positions are not a single number. The same query can return different results depending on device, location, and the presence of local or AI-generated elements in the result page.
Desktop and mobile results can diverge because page experience and layout are assessed differently, and because mobile result pages often carry different feature blocks. Checking only one device hides half the picture for any business whose audience is mobile-heavy.
Local results add another layer. Searches with local intent frequently surface a map pack above the organic listings, and the businesses shown there are drawn from a different set of signals than the ten blue links. A site can rank well organically and still be absent from the map pack, or the reverse.
For a business serving a defined area, tracking a location-specific version of each keyword is more informative than tracking the national version. The Sinar Saredah Sdn Bhd case study is a working example: a laundry and dry cleaning service that was buried on page 3 or 4 of Google results for searches like "dry cleaning near me" before location-specific landing pages, schema markup, and Google Business Profile optimisation were applied. Local search visibility increased by 420%, and the client reached the #1 spot in the Google Local Pack for their primary locations.
That case also shows why local tracking needs its own column. The map pack position and the organic position are separate measurements, and both belong in the sheet if local visibility is the goal.
Choosing between free rank checkers and paid rank trackers
Free checkers answer a single question well: where does this page sit right now for this keyword in this location. Paid trackers answer a different question: how has this set of keywords moved over months, across locations and devices, without manual checking.
The trade-off is time against money. Free tools cost nothing but require manual entry, which becomes impractical past a few dozen keywords or a few locations. Paid tools automate collection and keep history, which is what makes trend analysis possible.
| Approach | Cost model | Location coverage | History depth |
|---|---|---|---|
| Free rank checkers | No cost, manual checks | Usually one location per check | Depends on manual record-keeping |
| Paid rank trackers | Subscription or per-keyword pricing | Multiple locations per keyword | Stored automatically over time |
Google Search Console is a third option that sits outside both categories. It reports on queries the site already appears for, which makes it useful for discovering keywords worth adding to the tracked set, and less useful for tracking a fixed list chosen in advance.
A practical middle path for a small team is to run a manual sheet for a tight keyword set, then move to a paid tracker once the set grows past what can be checked by hand in one sitting. The decision point is workload, not budget.
How often ranking data should be refreshed
Weekly is the common working cadence for a small keyword set. Daily checking produces more noise than signal for most sites, because normal position fluctuation between adjacent results is routine and does not indicate a real change.
Monthly review is enough for slow-moving informational keywords, and quarterly is enough for a keyword set that is not being actively worked on. The right cadence follows the work: if nothing changed on the site that week, a weekly check mostly confirms stability.
One constraint deserves stating plainly. No supplied evidence establishes how frequently any specific rank-tracking tool refreshes its underlying data, so refresh intervals should be confirmed with each tool's own documentation rather than assumed. The same applies to plan limits and free-tier keyword caps, which change and should be checked at the source before committing to a tool.
Consistency beats frequency. A check every Monday morning at the same location setting produces comparable data. Checks scattered across different days, devices, and locations produce a chart that cannot be read.
What ranking movement does and does not prove
A position change proves that the result page changed for that query under those conditions. It does not prove why.
Movement can follow a content update, a competitor's improvement, a change in how Google interprets the query, a shift in the mix of features on the result page, or a personalisation and location effect. Separating these causes requires looking at the ranking URL, the competing results, and the features present, not just the number.
Rankings also do not measure revenue. A keyword moving from position 12 to position 6 is progress, but whether it produces enquiries depends on search volume, intent, and what the page offers once someone arrives. Tracking rankings alongside organic traffic and conversion data gives a fuller picture than either metric alone.
Two limits are worth holding onto. First, a single week of data is not a trend; three or four consecutive weeks of movement in the same direction is. Second, ranking data cannot confirm that a specific change caused a specific movement, only that the two coincided. Keeping a dated log of changes is what makes correlation visible at all.
For teams that want the tracking routine built into a wider search system rather than maintained by hand, Blackstone Intelligence works on SEO and search systems including local search optimisation, service-page structuring, and search-ready content. The company is based in Kuching, Sarawak, and its published SEO packages include SEO Revamp at RM300 per page, SEO Power at RM5,000 one-time, SEO ULTRA at RM2,000 per month for six months, and a Full SEO Audit at RM500 per audit. Terms and conditions apply to all services.