Keyword research ends with a list, and lists do not rank. The last mile is a system that decides order, keeps score and survives busy weeks, and it fits in one spreadsheet.
This is the capstone of everything this blog has covered: the pipeline behind the list, then the sheet that ships it.
The pipeline, assembled
Arriving mid-pipeline? The stages live in their own guides: seeds, the 7-step process, intent, difficulty and clustering.
The five-column sheet
| Topic (cluster) | Head keyword | Intent | Priority | Status |
|---|---|---|---|---|
| Cold brew ratios | cold brew ratio | Informational | 8 | Live |
| Maker roundup | best cold brew maker | Commercial | 9 | Drafting |
| Freshness | how long does cold brew last | Informational | 7 | Queued |
| Commercial brewers | commercial cold brew brewer | Transactional | 6 | Queued |
Five columns is deliberate. Every added column is friction, and friction is why content plans die in spreadsheets.
Scoring priority without a committee
Priority = value + winnability, each eyeballed from data you already collected.
Value: intent sharpness and CPC signal (the money columns). Winnability: difficulty and what the eyeball test showed. Score both 1 to 5, add them, sort descending, done.
Resist precision theater: the score's job is ordering the queue, and a rough order beats a perfect one that took three meetings.
Cadence beats bursts
Ship top-down on a rhythm you can keep: weekly is the classic because it survives real life while compounding fast, fifty-plus pages a year from one sustainable habit.
Two rules keep the queue honest. Easiest-first among equals: early wins teach you what Google thinks of the site. And nothing skips the queue without a rescore, or the plan becomes vibes with extra steps.
The quarterly loop
- Harvest: new Search Console queries, especially accidental rankings, feed back as seeds.
- Retire and rescore: shipped rows out, changed realities rescored.
- Refresh candidates: pages sliding in position get a refresh row, often outranking new content for effort.
- Reload: one fresh research pass tops the queue back up to a quarter's depth.
The loop is why the system stays alive: the plan consumes itself and regrows from your own performance data.
The whole system in one paragraph
Ten seeds, expanded free through autocomplete, filtered by volume, intent and difficulty, clustered into pages, scored once, shipped weekly, reviewed quarterly. Every stage free, every stage covered on this blog, and the only ingredient left is the habit.
The one-line takeaway: a content plan is clusters in a five-column sheet, ordered by value plus winnability, shipped on a cadence you can keep and reloaded quarterly from your own results. Research earns the list, the system earns the rankings.