Keyword mapping is the process of assigning specific keywords, or clusters of related keywords, to individual pages on your website so each URL targets one clear search intent. Done properly, it prevents pages competing against each other for the same query, gives every page a defined job, and creates a structure that both search engines and readers can follow.

A keyword map that works well typically achieves three things: it eliminates keyword cannibalisation between pages, assigns a clear action (create, optimise or leave alone) to every URL, and improves overall topical coverage across the site. This guide covers the full process, from research through to a working spreadsheet, plus the tools, common mistakes, and a worked example you can adapt to your own site.

Assigns keyword clusters to specific URLs, not vague topic areas
Reduces competing pages fighting for the same search terms
Gives every page a clear next action rather than leaving content decisions to guesswork

Key Takeaways

Keyword mapping works because it assigns one clear intent and one clear action to every page, which eliminates the internal competition that quietly suppresses rankings.

Point	Details
Assign one intent per page	Map each keyword cluster to a single URL to avoid cannibalisation between pages.
Use action statuses	Label every page create, optimise, or no action to prioritise your workload.
Cluster by SERP overlap	Compare top search results for candidate keywords to confirm they share intent.
Review quarterly at minimum	Audit the map every three months, plus after major algorithm or competitor changes.
Get expert help implementing	MedwayWebDesign turns a finished keyword map into optimised pages and site structure during redesign or new builds.

Understanding keyword mapping: what the spreadsheet actually contains
Why does keyword mapping matter for SEO?
How do you do keyword mapping step by step?
Which tools and templates work best for keyword mapping?
How do you turn the map into action on your site?
How often should you update your keyword map?
What mistakes ruin a keyword map?
What does a small e-commerce keyword map look like?
How does an agency apply keyword mapping in real projects?
What should you prioritise in your first mapping session?
How can MedwayWebDesign help you put your map into practice?
Frequently asked questions
Sources

Understanding keyword mapping: what the spreadsheet actually contains

A working keyword map is, at its simplest, a spreadsheet. But the columns you choose determine whether it actually helps you make decisions or just sits there as a list of words. A well-built map usually includes:

Primary keyword: the single term the page is built to rank for
Secondary keywords: supporting terms and variants the page should also cover
Search intent: informational, commercial, or transactional
Target URL: the specific page the cluster is assigned to (existing or planned)
Action: whether the page needs to be created, optimised, or left as it is
Priority or traffic potential: an estimate of how much the topic is worth pursuing

Understanding a few core terms makes the rest of this guide easier to follow. A cluster is a group of keywords that share the same underlying intent and could reasonably be answered by one page. A pillar page is the broad, authoritative page that anchors a topic, with narrower subpages linking back to it. Primary versus secondary keywords simply distinguishes the main target from the supporting terms that reinforce it. Intent categories (informational, commercial, transactional) tell you what the searcher wants to do next, which shapes the content itself. Clusters map naturally onto site hierarchy: pillar pages sit at the top, subpages sit beneath them, and internal links connect the two in both directions.

Why does keyword mapping matter for SEO?

The clearest benefit of keyword mapping is that it stops your own pages from competing with each other. When two URLs both chase “best running shoes for beginners,” Google has to guess which one to rank, and both usually suffer as a result. A good map catches this before it happens by reducing duplicate pages competing for the same queries and making it obvious which page deserves the traffic.

Beyond avoiding cannibalisation, mapping clarifies priorities. Rather than producing content reactively, you can see at a glance which topics are covered, which need improvement, and which gaps remain unaddressed. That structure feeds directly into a content calendar, and it supports a site architecture that reflects genuine topical authority rather than a scattered collection of blog posts.

Mapping compounds over time. Every topic you map makes the next decision easier, and the resulting structure supports clearer interlinking and content priorities across the whole site.

There’s also a newer reason to take mapping seriously: AI-driven search. Systems that answer queries through “query fan-out” (breaking one question into several sub-queries and assembling an answer from multiple sources) favour sites where content is organised into clear, well-structured clusters. A messy, unmapped site makes that assembly job harder; a mapped one makes it easy.

Fewer pages competing for the same rankings
A clear, prioritised list of what to build or fix next
Internal linking that reinforces topical authority instead of scattering it
Better positioning for AI systems synthesising answers from multiple pages

How do you do keyword mapping step by step?

Building a keyword map from nothing feels daunting for about ten minutes, then becomes mechanical. The process breaks into six stages.

1. Gather your keyword research. Pull keyword ideas from a research tool, your existing Search Console data, competitor pages, and customer language you have heard directly (support tickets, sales calls, reviews). Cast a wide net at this stage; you will narrow it down later.

2. Audit your existing pages. Before assigning anything new, list every page currently live on the site along with the keywords it already ranks for or was written to target. This step catches pages you had forgotten about and stops you from accidentally duplicating something that already exists.

3. Cluster keywords by intent and topic. Group keywords that a single page could genuinely satisfy. The most reliable test is to check SERP similarity between keywords: search each term and compare the top results. Strong overlap means the keywords share intent and belong in the same cluster; little overlap means they need separate pages.

4. Map each cluster to a URL. Every cluster gets assigned to either an existing page or a page you plan to build. Experts generally recommend a top-down approach: start with broad pillar topics, then work down into long-tail subtopics, so the resulting hierarchy signals authority rather than reading as a random list of articles.

5. Choose primary and secondary keywords for each page. Pick one primary term the page is built around, then two or three secondary terms it should naturally cover in its headings and body copy. Resist the urge to target five primary keywords on one page; that dilutes focus rather than sharpening it.

6. Set an action and a priority. Categorise each row as Create (the topic has no page yet), Optimise (a page exists but underperforms), or No action (the page already ranks well and doesn’t need touching). Then rank rows by priority, using search volume, keyword difficulty, and estimated traffic potential to decide what to tackle first, a method recommended for prioritising standalone pages.

Here’s what to record in each column of your spreadsheet:

Primary keyword: the exact term the page is optimised around
Secondary keywords: three to six supporting variants
Intent: informational, commercial, or transactional
URL: live page address or a working title for a planned page
Action: create, optimise, or no action
Priority: high, medium, or low, based on volume and difficulty
Notes: anything specific, such as a competitor doing this well or an internal linking opportunity

Pro Tip: When two keywords feel like they might overlap, don’t guess. Search both in an incognito window and count how many of the top five results are identical. If three or more match, treat them as one cluster rather than splitting your content thin across two pages that will only compete with each other.

Knowing when to merge clusters versus split them is arguably the hardest judgement call in the whole process. Merge when SERPs overlap heavily and the keywords represent minor phrasing differences of the same question. Split when the top results diverge, even if the keywords look similar on paper, because that usually signals Google has already decided they serve different purposes.

Which tools and templates work best for keyword mapping?

You don’t need expensive software to build a keyword map, but the right tool speeds up the research stage considerably.

Semrush: strong for keyword clustering and comes with its own keyword mapping guide and downloadable template, useful if you want the research and the mapping framework from one source.
Ahrefs: particularly good for checking keyword difficulty and SERP overlap, which makes the clustering step in the workflow above faster and more accurate.
Mangools: a lighter-weight, budget-friendly option for keyword research and SERP analysis, well suited to small businesses mapping a first site.
Google Keyword Planner: free once you have a Google Ads account, and reliable for search volume estimates even if you have no intention of running paid campaigns.
Google Sheets or Microsoft Excel: where the actual map lives. Neither tool does research for you, but both host the template perfectly well and make sharing with a team straightforward.

Several established SEO guides, including Semrush’s, publish ready-to-copy spreadsheet templates with the columns already built in. Grab one, duplicate it into your own Google Sheets or Excel file, and adapt the columns to match your site rather than building a template from a blank sheet.

Treat tool metrics as a starting point, not the final word. Search volume and difficulty scores tell you what’s worth pursuing; a manual SERP check tells you whether your assumption about intent is actually correct, combining metric-driven decisions with qualitative checks before you commit a page to a cluster.

How do you turn the map into action on your site?

A keyword map that never leaves the spreadsheet has achieved nothing. The value comes from using it to drive specific changes.

For pages marked optimise, work through a consistent checklist: update the title tag and H1 to include the primary keyword, check that headings reflect the secondary terms, confirm the body copy actually covers the intent (not just the words), review structured data and meta descriptions, and check canonical tags haven’t quietly pointed the page’s authority somewhere else.

For pages marked create, decide first whether the topic genuinely needs a standalone page or whether it fits as a section within an existing one. A rule of thumb: if the SERP check from the mapping stage showed distinct top results, build a new page; if it overlapped heavily with an existing one, expand that page instead. This decision matters most during a redesign project, where it’s easy to accidentally merge or split pages without checking the map first.

Internal linking is where the map earns its keep structurally. Link from pillar pages down to subpages using anchor text that reflects the target page’s primary keyword, and link back up from subpages to reinforce the pillar’s authority.

Track rankings for both primary and secondary keywords, not just the primary term
Monitor organic traffic and clicks at the page level, not just site-wide
Watch impressions in Search Console for early signals before rankings move

How often should you update your keyword map?

A keyword map is a living document, not a one-off exercise. A static map becomes a liability, because search intent shifts and competitors publish new content that changes what “ranking well” actually requires.

Audit the full map at least quarterly. Outside that schedule, review it immediately after a significant algorithm update, when a competitor publishes something that outranks you, or when you notice a sudden, unexplained shift in rankings for a mapped term.

Keep a simple change log in a separate tab: date, what changed, and why. Six months from now, you’ll want to know whether a ranking drop followed a content edit or happened independently.

Check for intent drift on existing pages (has the SERP changed shape?)
Look for new long-tail opportunities that have emerged since the last audit
Scan for early signs of cannibalisation between newer and older pages

What mistakes ruin a keyword map?

Most broken keyword maps share the same handful of faults, and each one has a straightforward fix.

Vague primary keywords. “Shoes” tells you nothing about intent. Specify it: “best running shoes for flat feet” makes the page’s job obvious.

Duplicate mappings. Two rows pointing at two different URLs for the same keyword is cannibalisation waiting to happen. Consolidate them into one row and one page.

Over-targeting a single page. Cramming five unrelated primary keywords onto one URL dilutes focus. Split the content into separate pages that each do one job well.

Check every row: does the primary keyword clearly state searcher intent?
Search your list for repeated URLs mapped to different keywords
Count primary keywords per page; more than one or two is a warning sign
Confirm page-level intent against live SERPs before finalising any mapping

What does a small e-commerce keyword map look like?

Here’s a compact example for a small online shop selling running gear, showing how a pillar page and its subpages get mapped differently.

Primary Keyword	Target URL	Action
running shoes	/running-shoes (category page)	Optimise
running shoes for flat feet	/running-shoes/flat-feet	Create
best running shoe brands	/blog/best-running-shoe-brands	No action

The category page already ranks reasonably for the broad term, so it gets optimise, focused on improving its product page structure and internal links to subpages. The flat feet variant has distinct SERP results from the category page, meaning it deserves its own URL, so it’s marked create. The blog post already holds a solid ranking for the brand comparison term and needs nothing further right now.

Write a content brief for the new flat feet page before assigning it to a writer
Add internal links from the category page down to each new subpage
Set a rank tracking alert for all three primary keywords to monitor movement

How does an agency apply keyword mapping in real projects?

MedwayWebDesign builds a keyword map during the discovery phase of every project, before a single page is designed or redesigned. Every existing URL gets an action status, create, optimise, or no action, and that status feeds directly into the content brief each writer or designer works from.

The practical takeaway for any business: map before you redesign or launch, not after. Retrofitting a map onto a site that’s already live wastes far more time than building it into the plan from day one, particularly when the redesign touches user journeys as well as page structure.

Mapping happens during discovery, before design decisions are locked in
Every page carries a clear action status tied to its content brief
The map informs both content strategy and information architecture together

What should you prioritise in your first mapping session?

If you’re starting a keyword map for the first time, resist the temptation to map every page on the site in one sitting. Prioritise pages with clear commercial intent first, the ones closest to a sale or a lead, because getting those right delivers the fastest measurable return.

A map doesn’t need to be perfect to be useful. It needs to be actionable. A rough first pass that assigns clear actions to your ten most important pages beats a flawless spreadsheet covering two hundred pages that never gets used.

How can MedwayWebDesign help you put your map into practice?

Building a keyword map answers the strategic questions; implementing it well requires design and development work that most in-house teams don’t have time for. That’s where MedwayWebDesign fits in: rather than handing you another spreadsheet, we take the finished map and turn it into optimised pages, new content structures, and a site architecture that actually reflects your priorities, without the guesswork of doing it alone.

Our SEO optimisation work builds directly on mapping output: pages marked “optimise” get technical and on-page fixes, pages marked “create” go through proper content briefs, and the whole structure gets reviewed for internal linking before anything goes live. If you’re planning a redesign and want to keep the rankings you’ve already earned, mapping needs to happen before the wireframes, not after launch. Get in touch for a starter mapping and web design consultation and find out what your current site is missing.

Frequently asked questions

What is keyword mapping in simple terms?
Keyword mapping is assigning specific keywords or keyword clusters to individual pages on your website, so each page has one clear job and one clear search intent to satisfy.

How is keyword mapping different from keyword research?
Keyword research finds and evaluates potential terms to target; keyword mapping takes that research and assigns each term to a specific URL with a defined action, turning a list into a plan.

How often should I update my keyword map?
Audit it at least every quarter, and revisit it sooner after a major algorithm update, a competitor’s new content, or an unexplained ranking shift on a mapped term.

Do I need paid tools to build a keyword map?
No. Google Keyword Planner is free, and the map itself lives in Google Sheets or Excel. Paid tools like Semrush, Ahrefs, or Mangools speed up research and clustering but aren’t strictly required to get started.

What’s the biggest mistake people make with keyword mapping?
Assigning vague primary keywords that don’t reflect a clear search intent, which usually leads to duplicate mappings and pages competing against each other for the same rankings.

What is keyword mapping: a practical guide with template