Track keyword rankings over time in an interactive spreadsheet. Log positions, URLs, and dates with trend charts and movement alerts.
This is a logbook, not a scraper: you record a keyword, its position on the search results page, the URL it belongs to, and the date, and the spreadsheet turns those rows into per-keyword history. It plots position over time as a trend chart and flags movement between consecutive logs with an alert. Rankings are checked by you, on your schedule; the tool's job is to keep that history comparable and legible. The thing people misread first: a lower number is a better rank, so a keyword that moved up has a smaller position, not a bigger one.
A concrete input and expected output from the current implementation.
Input
Three rows logged for the same keyword and URL on three consecutive Mondays: keyword: best running shoes | position: 12 | URL: example.com/best-running-shoes | 2026-07-01 keyword: best running shoes | position: 9 | URL: example.com/best-running-shoes | 2026-07-08 keyword: best running shoes | position: 4 | URL: example.com/best-running-shoes | 2026-07-15
Expected output
A series of three points, 12 then 9 then 4, plotted by date on a trend chart rising toward the top of the results. On the latest check the movement alert reads: up 5 positions since last log (9 to 4). The full logged history shows a gain of 8 positions since 2026-07-01.
Position 1 is the best rank, so the falling numbers 12, 9, 4 are an improvement. The last alert compares the two most recent logs: 9 to 4 is a gain of 5 positions. The same URL was logged each time, so the comparison is between like entries.
Each row records one observation: a keyword, its position, the URL it belongs to, and the date. Repeating the same keyword across rows creates a series. The spreadsheet groups rows by keyword and sorts each series by date, so a keyword checked weekly produces one row per week, with every position sitting next to the date it was observed on.
For each keyword, the latest logged position is compared with the previous log for that same keyword, and the difference becomes a movement alert: a smaller number is a gain, a larger one a drop. The trend chart plots each series in date order, so the line's slope shows how fast a page is moving, and missed checks show up as wider gaps between points.
By hand. The tool computes trends and alerts from the rows you log; it does not query search engines or fill positions automatically. If you miss a week, the history simply has a gap, and the next alert compares across that gap. For automated SERP checks, pair the sheet with a rank-checking service and paste its exports in.
It improved. Position 1 is the top of the page, so 3 is a better rank than 5. The tool treats a smaller number as a gain and flags that pair of logs as up 2 positions. The same convention applies to every keyword, so a series ending near 1 is a page sitting at the top of its results.
The example and behavioral notes were checked against the browser implementation. Standards and primary references below define the relevant format, formula, or platform behavior.
Shorten URLs with local redirect tracking via localStorage. See click counts and generate a QR code for each link.
Build UTM-tagged URLs for campaign tracking with source, medium, campaign, term, and content parameters.
Enter 2+ headlines and see simulated previews in Google results, email subject lines, and social posts side-by-side.
Count characters for Twitter/X, LinkedIn, Facebook, and Instagram with platform-specific limits and warnings.
Calculate click-through rates from impressions and clicks with industry benchmarks and trend analysis.
Check email subject line length against best practices for desktop and mobile with preview text optimization.