Keyword Research & Mapping Template

Seed & Expansion Worksheet

Turn a handful of obvious terms into a structured long-list before you filter anything out.

Goal: build a broad, sourced keyword long-list you can filter later.

1. Seed terms

List the words your customer actually uses for what you offer:

• [Core product or service]
• [Category or use case]
• [Problem it solves]
• [Brand or competitor name]

2. Expansion sources

Run each seed through every source and capture what you find:

• Autocomplete: [Suggested phrases]
• Related searches and People Also Ask: [Questions found]
• Competitor pages and headings: [Terms they target]
• Search Console queries: [Existing impressions]

3. Record per keyword

For every term, note the keyword, monthly volume, and an intent guess:

• [Keyword], [Volume], [Intent guess]

Don't filter yet. Capture broadly; you'll cut in the next steps.

Search Intent Map

Sort every keyword by what the searcher wants, then match it to the right page type.

Goal: tag each keyword by intent so it lands on the page type that can actually rank.

Four intents and their pages

• Informational (learn): blog post, guide, or glossary. Example term: [How-to / what-is query]
• Commercial (compare): comparison, best, or review page. Example term: [Best / vs / alternatives query]
• Transactional (act): product, pricing, or signup page. Example term: [Buy / pricing / near me query]
• Navigational (find a brand): homepage or specific landing page. Example term: [Brand / login query]

Verify against the live SERP

Search the keyword and note what already ranks: intent is whatever Google rewards, not your assumption:

• Dominant result type: [Blog / product / comparison]
• SERP features present: [Featured snippet / shopping / map pack]
• Your matching page type: [Decision]

If your planned format doesn't match what ranks, change the format, not the keyword.

Keyword Prioritization Scorecard

Rank candidates by demand, difficulty, and business value so you work on the highest-leverage terms first.

Goal: score each keyword so effort goes to terms that can rank and actually matter.

Score each on 1–5

• Demand: search volume and trend. [1–5]
• Difficulty (inverted): can you realistically rank given your authority? Easier scores higher. [1–5]
• Business value: how close is this searcher to becoming a customer? [1–5]
• Content fit: do you have the expertise or assets to win? [1–5]

Priority score

Add the four for a 4–20 total, or weight business value ×2 when revenue is the priority. Record the total and tier:

• [Keyword]: total [Score], tier [Do now / Soon / Later]

Sanity checks

• A high-volume term with low business value is often a trap, deprioritize it.
• A low-volume term with high intent and easy difficulty is frequently your best early win.

Sort by score and commit to the top tier before touching anything below it.

Keyword-to-URL Map

Give every keyword exactly one home so two pages never compete for the same term.

Goal: assign one primary keyword per URL and prevent cannibalization.

Per URL, define one home

• URL: [Page URL or planned slug]
• Primary keyword: [One target term]
• Secondary keywords: [2–5 close variants and synonyms]
• Search intent: [Informational / commercial / transactional / navigational]
• Page type: [Blog / product / comparison / landing]

Cannibalization check

Before you finalize, confirm no other URL claims the same primary keyword:

• Conflicting URLs: [Any existing pages targeting this term]
• Resolution: [Merge / redirect / re-target / keep distinct]

If two pages share a primary term, consolidate them into the stronger URL and redirect the weaker one. Secondaries can repeat across pages; primaries cannot. One term, one page.

Topic Cluster Plan

Organize related keywords into a pillar page plus supporting cluster posts that link back to it.

Goal: group keywords into a pillar-and-cluster structure that builds topical authority.

1. Pillar page

Pick the broad, high-volume head term to anchor the topic:

• Pillar topic: [Broad subject]
• Pillar primary keyword: [Head term]
• Pillar URL: [Slug]

2. Cluster posts

List the specific subtopics and long-tail questions that each deserve their own page:

• [Subtopic keyword] → [Cluster URL]
• [Subtopic keyword] → [Cluster URL]
• [Subtopic keyword] → [Cluster URL]

3. Internal linking

• Every cluster post links up to the pillar using descriptive anchor text.
• The pillar links down to each cluster post.
• Anchor-text plan: [Preferred anchors]

This structure tells search engines the pillar is your authority page on the topic.

Competitor Keyword Gap Capture

Find the valuable terms competitors rank for that you don't, then prioritize the gaps worth closing.

Goal: surface keywords competitors win that you're missing, and decide which to chase.

1. Identify competitors

List the sites that consistently outrank you for your target topics:

• [Competitor 1]
• [Competitor 2]
• [Competitor 3]

2. Capture the gap

For each keyword a competitor ranks for and you don't, record:

• Keyword: [Term]
• Who ranks and position: [Competitor + rank]
• Your current status: [Not ranking / page 2+]
• Intent and page type needed: [Type]

3. Qualify the gap

• Relevance to your offer: [High / medium / low]
• Realistic to rank? [Yes / stretch / no]
• Action: [New page / improve existing / skip]

Ignore gaps that don't fit your business, even when the volume tempts you. Chase relevant, winnable terms first.

How many seed keywords should I start with?

Five to ten well-chosen seeds is plenty, because each one expands into dozens of related terms once you run it through autocomplete, related searches, and competitor pages. Quality matters more than quantity: pick seeds that genuinely describe what you offer and the problems you solve. You can always add more seeds later if a category feels thin.

What is keyword cannibalization and why does the map prevent it?

Cannibalization happens when two or more of your pages target the same primary keyword, so they compete against each other and split ranking signals instead of consolidating them. The Keyword-to-URL Map prevents this by assigning exactly one primary keyword to each URL. When you spot a conflict, the fix is usually to merge the weaker page into the stronger one and redirect it.

How do I judge keyword difficulty without paid tools?

Search the term and study page one directly: look at the authority of the sites ranking, how thoroughly they cover the topic, and whether big brands dominate. If the results are deep, established pages, the term is hard; if you see thin content, forums, or outdated pages, there's an opening. This manual read is less precise than a tool score but often more honest about whether you can realistically compete.

Should I target high-volume head terms or long-tail keywords?

Most sites should win long-tail keywords first, because they're easier to rank for and usually carry clearer, higher-converting intent. Head terms are valuable but competitive, so treat them as pillar pages that your long-tail cluster posts support over time. As your cluster builds authority, ranking for the broader head term becomes far more achievable.

How do I confirm the search intent of a keyword?

Don't rely on your assumption. Search the keyword and read what Google already ranks. If the page one is full of blog guides, the intent is informational; if it's product or pricing pages, it's transactional. The format that dominates the SERP is the format you need to match, so let the results decide the intent and page type for you.

How often should I revisit and update the keyword map?

Review it at least quarterly, and any time you launch a content batch or notice ranking shifts in Search Console. Search demand, competitors, and SERP layouts change, so a map that was accurate six months ago may now point you at the wrong intent or miss new opportunities. Treat it as a living document, not a one-time exercise.