The master plan spreadsheet is the least glamorous and most important asset in a content operation. It is the single document that decides what gets built, in what order, by whom, and how each page connects to the rest. Run a directory site without one and you will publish duplicates, leave orphans, and cannibalise your own keywords within months. Run one well and you have a queue the whole factory can work through without ever stepping on its own feet. Here is how to build it.
One source of truth, or none
The plan only works if it is the single place the truth lives. The moment you have two lists, a spreadsheet and a notion of what is in someone's head, they drift, and the drift becomes duplicated work and contradictory decisions. Everything about a page that matters to the operation goes in the plan, and decisions are made by editing the plan, not by messaging someone. This sounds obvious and is the rule most often broken, usually by teams who think they are too small to need it. They are exactly the teams who later cannot tell what they have published.
The columns that matter
A useful plan is not a long list of columns, it is the right ones. Each row is one page, and the columns capture everything the factory needs to act.
- Title and slug: the human title and the URL it will live at, so the structure is visible.
- Primary keyword and intent: the one keyword the page targets and the search intent behind it. One keyword to one row, always.
- Pillar and cluster: where the page sits in the topic structure, so the link graph stays coherent.
- Internal links: the up, across, and out links the page must carry, planned before drafting so nothing ends up orphaned.
- Author: the named person responsible, which the page needs for trust and the operation needs for accountability.
- Status: where the page is in the factory, from planned through researched, drafted, reviewed, and published.
- Last reviewed: the date the page was last checked, so refresh work is visible rather than forgotten.
These columns are what let the plan feed the five station factory directly. The wider system that consumes this plan is described in building a content factory.
The one keyword rule
The single most valuable discipline the plan enforces is one keyword to one page. When two pages chase the same keyword they compete with each other, split their ranking signal, and confuse the search engine about which to show. This is keyword cannibalisation, and it is entirely self inflicted. The plan prevents it structurally: before a new page is added, you check that its keyword is not already claimed by another row. If it is, you either strengthen the existing page or pick a more specific angle. This one check, applied at plan time, saves more ranking value than almost any optimisation you can do after the fact.
Status as the heartbeat
The status column is what turns a static list into a working queue. At a glance you can see how many pages are planned but not started, how many are stuck in review, and how many shipped this week. This is the data that tells you whether the factory is flowing or jammed, and it is the basis for a steady build cadence rather than a feast and famine cycle. We use it to keep production even, which matters because a smooth cadence is far easier to maintain at quality than a series of sprints, as we explain in the daily build cadence.
Planning the link graph up front
The most overlooked use of the plan is designing the internal link structure before any page is written. Because every row records the links a page should carry, you can see the whole graph forming: which pages point up to a pillar, which connect across to siblings, which lead out to a conversion page. Planning this in the spreadsheet means no page ships orphaned and link value flows where you want it. Trying to retrofit internal links across thousands of published pages is miserable; planning them in the rows is trivial.
Keep it boring and keep it current
A master plan earns its value only if it stays current. A plan that is three weeks out of date is worse than none, because people trust it and act on stale information. The fix is to make updating the plan part of the work, not an afterthought: a page advances in the plan the moment it advances in reality. We keep ours deliberately plain, a spreadsheet anyone can read, because the goal is reliability, not cleverness. This single document is the backbone of how we run every property, and the operating philosophy behind it is set out in our portfolio. Build the plan first, keep one keyword to one row, and the rest of the content operation has something solid to stand on.
We run every site on the Kings Hospitality Group one row one page rule: a page does not exist in our operation until it has a row, and a keyword belongs to exactly one row. This is the simplest guardrail we use and, in our experience, the one that prevents the most damage, because it kills keyword cannibalisation and duplicate work before they ever reach the drafting desk.
Common questions
What columns does a master plan spreadsheet need?
At minimum: title, primary keyword, search intent, target URL, pillar, internal links, author, status and last reviewed date. These let you prevent duplication, assign work, and see progress at a glance.
Why one keyword per row?
Because two pages targeting the same keyword compete with each other and split their own ranking signal. One keyword to one row, and one row to one page, keeps every page distinct and prevents cannibalisation.