Keyword Mapping: How to Assign Keywords to Pages (With Template)

Last reviewed: October 2026

Keyword mapping is the process of assigning each target keyword cluster to exactly one URL on your site, based on search intent. A keyword map gives every page one primary keyword, a handful of secondary keywords that share its intent, and a clear action: optimize, create, merge, or leave alone. Done well, it stops your own pages from competing with each other.

This guide covers what a keyword map is, the columns it needs, a step-by-step process for building one, a test for deciding whether two keywords belong on the same page, a worked example for a service business, and how to fix cannibalization when the map exposes it. It also covers how the same map supports visibility in AI search.

What is keyword mapping?

Keyword mapping is the practice of matching groups of keywords to specific pages so that every URL has one clear search job. The output is a keyword map: a spreadsheet that lists each page, its primary keyword, its secondary keywords, the intent it serves, and what needs to happen to it next.

A few terms you will see throughout this guide:

• Primary keyword: the main query a page is built to rank for. One per page.
• Secondary keywords: close variants, sub-questions, and modifiers that share the primary keyword’s intent and get answered on the same page.
• Cluster: a group of keywords that Google treats as the same search need, so one page can rank for all of them.

Why keyword mapping matters

Keyword mapping matters because it gives every page a distinct purpose. That prevents your pages from splitting rankings for the same query, forces you to match each URL to one search intent, exposes content gaps before you write, and turns a vague keyword list into a specific to-do list for writers and developers.

The rule most practitioners agree on is simple. Practical Ecommerce’s long-running SEO series puts it bluntly: do not assign the same keyword to multiple pages, and if you cannot find a unique keyword for a page, question whether the page needs to exist. Here is what that discipline buys you:

• Fewer self-inflicted ranking problems. When two pages chase one query, links, clicks, and relevance signals get split between them. A map catches this before you publish the second page.
• Intent clarity per URL. A page that tries to be a pricing page, a how-to guide, and a service page at once rarely wins any of those searches.
• Smarter internal linking. Once you know which URL owns which topic, you know where every internal link should point.

Google’s own guidance supports the per-page focus. Its SEO Starter Guide says a good title “is unique to the page, clear and concise, and accurately describes the contents of the page.” You cannot write a unique, accurate title for a page whose job overlaps with three others.

What goes in a keyword map: the columns

A useful keyword map needs about ten columns: the URL, page type, primary keyword, secondary keywords, search intent, funnel stage, current ranking position, an action status, a parent pillar, and a last-reviewed date. Volume and difficulty are helpful but secondary. The non-negotiables are URL, primary keyword, intent, and action.

Tool vendors publish slightly different templates. Semrush’s template tracks pillar pages, subpages, keywords, volume, difficulty, target URL, a “To optimize” or “To create” status, and a last-updated date. Ahrefs’ version organizes by topic, with traffic potential, secondary keywords, an action of create, optimize, or no action, and an assignee. The template below combines both and adds the intent and pillar fields that make the map useful for site architecture.

Volume and difficulty help you rank the work, but they should never override intent. A high-volume keyword mapped to the wrong page type rarely ranks.

How to build a keyword map, step by step

To build a keyword map, inventory every indexable URL, gather keywords from Search Console and research tools, cluster keywords by SERP overlap, assign one primary and several secondary keywords to the best-matching URL, map leftover clusters to new pages, and set an action for each row. Then review it on a fixed schedule.

1. Inventory your URLs. Export every indexable page from your sitemap or a crawler. Skip utility pages such as thank-you pages. Note each page’s type.
2. Pull the queries each page already earns. In Google Search Console, open the Performance report, switch to the Pages dimension, click a URL, and read its Queries tab. This shows the intent Google already associates with the page, which is often different from what you intended.
3. Gather your target keywords. Combine Search Console queries with research from your tool of choice. If you do not have a clean list yet, start with a structured keyword list for SEO organized by service and topic.
4. Cluster by SERP overlap, not by wording. Search each candidate keyword and compare the top results. As Ahrefs explains, if the results for two keywords are similar, you can infer they have the same or similar intent and should be mapped to the same page. The next section gives a practical test.
5. Pick the primary keyword for each cluster. Choose the phrase that best describes the whole cluster and has meaningful demand. The rest of the cluster becomes secondary keywords.
6. Assign each cluster to one URL. Match by intent and page type first, then by existing rankings. If a page already ranks on page one or two for a cluster, it usually owns that cluster.
7. Map gaps to new pages. Clusters with no matching URL get a row marked “NEW” with a proposed slug, page type, and parent pillar. This becomes your content backlog.
8. Flag conflicts. Any cluster that two existing URLs both rank for is a cannibalization candidate. Mark the action as merge, differentiate, or redirect.
9. Set an action and owner, then plan. Give every row an action and an owner, then sequence the work by business value in your SEO content plan.

Once the map exists, each row tells you which phrase goes in the title, H1, and opening paragraph. For placement rules, read this guide on how to add SEO keywords to your website without stuffing.

How to decide if two keywords belong on the same page

Two keywords belong on the same page when Google returns substantially the same results for both. If the top results overlap heavily, the searches share intent and one page can rank for both. If the results barely overlap, or the page types differ, each keyword usually needs its own URL.

Wording is a weak signal. “Keyword mapping” and “keyword map template” look nearly identical, but one searcher may want an explanation and the other a downloadable sheet. Only the results page tells you how Google interprets them.

My working rule: search both keywords in a clean browser and count how many URLs appear in both top-ten lists. Treat the thresholds below as a starting heuristic, not a law, and adjust them for your market.

Beyond a few dozen keywords, clustering tools and SERP APIs automate the same comparison.

Worked example: a keyword map for a service business

Here is an illustrative keyword map for a hypothetical regional accounting firm offering tax preparation, bookkeeping, and fractional CFO services. It shows how one service area splits into separate URLs by intent. The keywords are realistic examples, not measured search volumes, so validate them against your own data before using them.

Start with the problem. The firm’s site has a “Services” page that lists everything, a blog post titled “Do You Need a Bookkeeper?”, and a bookkeeping service page. Search Console shows the blog post and the service page both earning impressions for “small business bookkeeping services.” That is a cannibalization signal. The map resolves it like this:

Notice what happened. The blog post was not deleted; it serves a real informational need, so it was narrowed to that need and pointed at the service page. “Fractional CFO cost” got its own page because pricing searches often return different results than service searches (confirm with the overlap test). The Services hub stopped competing and now just routes people and links.

The same structure works for law firms, agencies, and consultancies: a commercial page per service, supporting articles that link up to it. That is the hub-and-spoke model in this pillar page strategy guide.

How to fix keyword cannibalization with your map

To fix cannibalization, pick the URL that should own the query, then either merge the weaker page into it, differentiate the weaker page toward a different intent, or redirect it. Use a 301 redirect when the weaker page has no unique purpose. Use a canonical tag only when both pages must stay live.

Confirm it first. In Search Console’s Performance report, filter to the query and open the Pages tab. If two of your URLs both collect impressions for it, you have a candidate. Not every overlap hurts; act when rankings are unstable, the wrong page shows, or neither page reaches page one.

Google’s documentation backs this order of preference. On consolidating duplicate URLs, it describes redirects as “a strong signal that the target of the redirect should become canonical” and sitemap inclusion as only “a weak signal,” and notes the methods “can stack and thus become more effective when combined.” For pages that are moving for good, its redirects guide advises: “use a permanent server-side redirect whenever possible.” It is also worth knowing that, per the SEO Starter Guide, duplicate content “is not a violation of our spam policies, but it can be a bad user experience.” Cannibalization is an efficiency problem, not a penalty.

Mapping service and location pages without creating doorway pages

Map one service or location page only when it can offer genuinely different content for that searcher. Pages that swap a city name into the same template to catch similar searches risk falling under Google’s doorway abuse policy. A keyword map should make each location page’s unique substance explicit before anyone writes it.

“Service plus city” keywords are where mapping most often goes wrong. Google’s spam policies define doorway abuse as pages “created to rank for specific, similar search queries,” and list “having multiple domain names or pages targeted at specific regions or cities that funnel users to one page” as an example.

Use the map to apply a simple test before you create a row:

• Do you actually serve this location? If not, do not map it.
• What is different on this page? Local regulations, team members, case types, pricing, or proof specific to that market. Put the answer in a notes column.
• Does the SERP want a local page? If results for “service + city” are dominated by local packs and the same national pages as the unmodified term, a single strong service page plus a solid Google Business Profile may serve you better.

The same logic applies to service-by-industry pages. If you cannot list unique proof and examples for a row, the keyword belongs as a secondary keyword on the parent service page.

How keyword mapping supports AI search

Keyword mapping supports AI search because answer engines pull from pages that are indexed, clearly focused, and easy to quote. Google says its AI features may issue multiple related searches across subtopics, so a site with one clear page per subtopic gives those systems a precise page to cite for each sub-question.

Google’s documentation on AI features and your website states that AI Overviews and AI Mode “may use a ‘query fan-out’ technique, issuing multiple related searches across subtopics and data sources, to develop a response.” It also says “there are no additional requirements to appear in AI Overviews or AI Mode, nor other special optimizations necessary,” beyond being indexed and eligible for a snippet. In other words, the fundamentals carry over.

A keyword map helps in two practical ways:

• Your secondary keywords become the sub-questions. When you map “fractional CFO cost” and its variants to one page, you are mapping the fan-out queries an AI system might run. Answer each one directly under its own heading.
• One page per subtopic avoids mixed signals. If three pages half-answer the same question, none is the obvious source to cite.

How to maintain your keyword map

Review your keyword map at least quarterly, and update it any time you publish, merge, or redirect a page. Each review should check new Search Console queries, pages that lost position, new cannibalization pairs, and rows still marked “create.” A map that is not maintained drifts out of sync with the site within months.

Semrush recommends updating the map at least quarterly, and more often when your content strategy changes significantly. A practical review routine:

1. Export the last 90 days of Search Console queries by page and look for queries landing on the wrong URL.
2. Check every query where two of your URLs both earn impressions.
3. Add new queries to the cluster and page that already own them, as secondary keywords.
4. Promote a secondary keyword to its own row only when its results diverge from the parent page’s results.
5. Update the action column and the last-reviewed date on every row you touched.

Make the map the gate for new content. Before anyone writes a new article, they search the map for the keyword and its close variants. If a row exists, the work becomes an update, not a new URL.

Common keyword mapping mistakes

The most common keyword mapping mistakes are clustering by wording instead of results, assigning one keyword to several pages, forcing a keyword onto the wrong page type, mapping every variant to its own thin page, and building the map once and never updating it. Each one recreates the problems the map exists to prevent.

• One keyword, several owners. If the same primary keyword appears in two rows, one of them is wrong.
• Wrong page type. A commercial keyword on a blog post fights what Google already rewards.
• Stuffing secondaries. Google’s Starter Guide notes that keyword stuffing “is against Google’s spam policies.” Secondary keywords should shape headings and answers, not be repeated mechanically.
• Relying on meta keywords. The same guide states that “Google Search doesn’t use the keywords meta tag.” The map lives in your spreadsheet, not in a hidden tag.

Keyword mapping sits inside a broader SEO keywords strategy, which covers how you choose and prioritize the clusters in the first place. If you want a second set of eyes on your map, or help turning it into a quarterly content and SEO plan, you can book a consultation and we can walk through it together.

Frequently asked questions

What is keyword mapping in SEO?

Keyword mapping is the process of assigning groups of related keywords to specific pages on your site based on search intent. Each page gets one primary keyword and several secondary keywords that share its intent. The result is a keyword map, usually a spreadsheet, that shows which URL owns which topic and what action each page needs next.

How many keywords should I map to one page?

Map one primary keyword per page, plus as many secondary keywords as share the same intent. In practice that is often three to ten close variants and sub-questions. The limit is not a number but intent: if a keyword returns noticeably different search results from the primary keyword, it usually needs its own page.

How do I know if two keywords should target the same page?

Search both keywords and compare the top ten results. If several of the same URLs appear for both and the page types match, Google treats them as the same intent, so one page can rank for both. If the results barely overlap or show different page types, such as guides versus service pages, map them to separate URLs.

What columns should a keyword map template include?

At minimum: URL, page type, primary keyword, secondary keywords, search intent, and action (create, optimize, merge, redirect, or no action). Useful additions are funnel stage, current Search Console position, parent pillar page, owner, and a last-reviewed date. Volume and difficulty help with prioritization but should not override intent.

How does keyword mapping prevent keyword cannibalization?

A keyword map lets each primary keyword appear in only one row, so only one URL is built to rank for it. Before anyone creates a new page, they check the map. If a row already covers the topic, the work becomes an update to that page instead of a competing new URL, which keeps ranking signals concentrated.

How often should I update my keyword map?

Review it at least quarterly and whenever you publish, merge, or redirect a page. Each review should check new Search Console queries, queries landing on the wrong URL, pairs of pages sharing impressions for one query, and rows still marked create. A map that is not maintained quickly drifts out of sync with the site.

Do I need a separate keyword map for AI search?

No. Google says there are no additional requirements or special optimizations needed to appear in AI Overviews or AI Mode beyond being indexed and eligible for a snippet. Add the question-style queries you find in Search Console and People also ask boxes as secondary keywords on the page that owns the topic, and answer each one directly.