Master keyword list: how to build one, map every keyword to a page, and keep it current

What is a master keyword list?

A master keyword list is a single, maintained sheet of every keyword your website targets, with each keyword grouped into a topic, labelled with a search intent, and assigned to exactly one URL. It replaces the scattered research files, rank tracker exports and content briefs most sites accumulate. When someone asks “do we have a page for this?” or “which page should rank for that?”, the master keyword list answers it.

It has three jobs:

• Inventory: what you rank for today, and how well.
• Map: which page owns each keyword, so no two pages compete.
• Plan: which keywords still need a page, in priority order.

If you have never reviewed what your site ranks for, run a keyword audit first. The audit's output, one action and one page per keyword, is the first draft of your master list.

What columns should a master keyword list have?

Keep the columns to what you will actually use to make a decision: the keyword, its topic and intent, the page it belongs to, its current numbers with their source, and its status. More columns than that tend to go stale first.

Example master keyword list

Here is what a few rows look like for an imaginary local plumbing company. Copy the header row into a spreadsheet to use it as a template.

Two rows already show the list earning its keep: the home page ranks for a query meant for the emergency page, and a blog post ranks for a price query that belongs on the service page. Both are fixed with internal links and clearer page titles, not new content.

Step 1: start from your Search Console queries

Begin with the searches Google already shows your site for, because they are measured demand that your pages already partly meet. In Search Console, open Performance → Search results, pick the last 3 months, and export the Queries table.

• The Performance report gives each query's clicks, impressions, click rate and average position. Switching to the Pages tab for one query shows which URL ranks for it.
• The interface exports at most 1,000 rows. Google's deep dive on Performance data says the Search Analytics API and Looker Studio connector return up to 50,000 rows per day, per site, per search type, if you need more.
• Queries searched by very few people are anonymized and never appear as rows, so the list will not account for every click. That is expected.

Remove queries that are irrelevant to your business before going further. Ranking for something is not a reason to target it.

Step 2: add keywords from your own research

Search Console only shows searches you already appear for, so add the topics your customers search that bring you nothing yet. Good sources, in rough order of reliability:

• Customers' own words. Questions from sales calls, support tickets, reviews and site search.
• Competitors' pages. The topics their sitemaps and menus cover that yours do not.
• A keyword tool. Google's Keyword Planner shows estimates of monthly searches; Google notes that very low-volume keywords may not be available. A free keyword research tool gives a quick volume check.

Record the volume's source and date next to it. Volume from a tool is an estimate; impressions from Search Console are a measurement. Keep them in separate columns.

Step 3: clean and de-duplicate

Normalize every keyword the way Search Console reports queries, lower-case with single spaces, then remove exact duplicates. This makes your list match Search Console rows directly when you refresh the numbers. Keep close variants such as plurals as separate rows for now; step 4 groups them under one topic rather than deleting them.

Step 4: group keywords by topic and intent

Group keywords that one page could fully answer into a topic, then label each keyword's intent. The test for a topic is simple: would a searcher for keyword A be happy landing on the page written for keyword B? If yes, they belong together.

1. Group by meaning, not by spelling

   “unclog a drain”, “blocked drain fix” and “how to clear a clogged sink” are one topic. Search the main ones yourself: if the same pages rank for both, Google treats them as one topic too.

2. Label intent from the wording

   Question words (how, what, why) are usually informational. Best, review, vs and alternatives are commercial. Price, cost, buy, book and hire are transactional. Login, contact and brand names are navigational.

3. Split a topic when intent differs

   “how to unclog a drain” and “drain cleaning cost” share words but not intent. One wants instructions, the other a price. They need different pages.

4. Pick the primary keyword

   For each topic, mark the keyword with the most impressions or volume as primary. It names the page's title and H1; the rest are covered in its sections.

Step 5: map every keyword to one URL

Give each topic exactly one target page, and every keyword in it that same target URL. This is the rule that makes a master keyword list worth having: if two pages are written for one topic, they will split its rankings.

• If a page already ranks for the topic, make it the target, even if another page seems better on paper. Strengthening a page Google already trusts is faster than starting again.
• If two pages already rank, pick one, merge the other into it, and redirect it. Google's canonicalization guide describes a permanent redirect as a strong signal for which URL should be canonical, and asks you to link internally to the canonical URL.
• If no page exists, set the status to “page planned” and leave the target URL as the slug you intend to use.

Then add a ranking URL column from Search Console. Every row where the ranking URL differs from the target URL is a to-do.

Step 6: set priority and status

Rank topics by how much demand they show and how much room your position leaves, then work from the top. A topic with thousands of impressions at position 12 is worth more than one with a hundred impressions at position 2.

Step 7: keep the master keyword list current

A master keyword list is only useful if its numbers are recent, so refresh it monthly and re-check the mapping every quarter.

• Monthly: update position, impressions and clicks from Search Console. Add new queries with real impressions. Flag new “wrong page” rows.
• When you publish a page: add its topic's keywords, set the target URL, and link to it from related pages.
• Quarterly: re-run the keyword audit, review “ignored” and “page planned” rows, and merge topics that turned out to be one.

Write for the reader, not the list. Google's guidance on helpful content asks whether content is made primarily to attract search engine visits; a page that exists only because a keyword is on a list fails that test.

What is master keyword research?

“Master keyword research” usually means doing keyword research once, across the whole site, into one list, instead of researching page by page. The method is the one above: collect every keyword from Search Console and research, group by topic and intent, and assign one page each. The difference from per-page research is that you see overlaps before you write, so you never brief two writers on the same topic.

How MrKeyword helps you build and keep a master keyword list

MrKeyword keeps the list next to your own Search Console numbers, so the refresh step is automatic.

• Keyword Lists hold up to 5,000 keywords per list, each list with a name, a tag and notes. Save keywords from Queries, Keyword Research or Rank Tracking, or paste up to 1,000 at a time; keywords are lower-cased and de-duplicated the way Search Console reports them.
• Each keyword shows the selected site's Search Console position, clicks and impressions for the last 28 synced days, and search volume only when MrKeyword has a Google Ads Keyword Planner figure for it. Anything else shows a dash.
• Export CSV gives keyword, volume, volume source, position, clicks, impressions, click rate, website, period, market and date added.
• Keyword Strategy groups your Search Console queries from the last 28 or 90 days into topics, names the page that wins each one, and suggests one step per topic: merge competing pages, create a page, or strengthen the page that ranks.
• Rank Tracking takes the mapping column: set a target URL and tags for each tracked keyword, by hand or in a CSV import, and it shows a Wrong page badge when Google ranks a different URL.
• The SEO opportunities inbox flags pages that compete for one query, and keyword research adds Keyword Planner volume for new topics.

See pricing for how many keywords each plan tracks.

What MrKeyword does not do

• Keyword Lists do not have target URL, topic or intent columns. The target URL lives on the tracked keyword in Rank Tracking; topics come from Keyword Strategy. Keep those columns in your own sheet if you want them in one place.
• It does not invent search volume. If no Keyword Planner figure is stored for a keyword, the volume column stays empty.
• Its topic grouping matches shared words and a built-in table of related terms, not an AI model, so read each group before you assign it a page.
• It does not scrape Google. Positions are Search Console and Bing averages over a period, and queries Search Console anonymizes cannot appear in any list.
• It does not decide which page should own a topic for you. It shows which page wins today; the choice is yours.

Questions and answers