SEO

How to Do Keyword Research That Maps to Real Pages

8 min read
Difficulty
Beginner to moderate
You need
Search Console access, a spreadsheet
Optional
A Google Ads account for Keyword Planner
On this page
  1. What keyword research is for
  2. Where keyword data comes from
  3. Steps
  4. What a finished keyword map looks like
  5. Troubleshooting
  6. Common questions

Keyword research is the process of finding the words people type when they need what you offer, then deciding which page on your site should answer each group of them. Start from your services, pull the searches you already show up for, expand with Google's free tools, check the results page for intent, and record every keyword group against one URL. This guide is part of our technical SEO guide.

You'll need access to Google Search Console for your site and a spreadsheet. Keyword Planner is optional, and it needs a Google Ads account with billing details entered.

What keyword research is for

Keyword research isn't about collecting the biggest numbers. Its job is to connect three things: what buyers search, what they actually want when they search it, and which page on your site will serve them.

Done well, it tells you which pages to write, which to merge and which to leave alone. It also stops two common mistakes. The first is writing many near-identical pages for small wording changes. Google says creating separate content for every variation of a query, mainly to manipulate rankings, violates its scaled content abuse policy. The second is stuffing one page with every phrase you found, which Google treats as keyword stuffing.

The output is a keyword map: a simple table with one row per keyword group and one target URL each.

Where keyword data comes from

Each free Google tool shows a different slice of search behaviour, and none of them gives the full picture on its own.

Free Google keyword data sources and what each one can't tell you
SourceWhat it showsWhat it can't tell you
Search ConsoleReal queries your site already appears forSearches you don't show up for yet
Keyword PlannerKeyword ideas and monthly search estimatesExact counts or very low-volume terms
Google TrendsRelative interest over time, 0 to 100How many people actually searched
The results pageThe kinds of pages Google ranks nowWhy those pages rank

Use Search Console for proof, Keyword Planner for breadth, Trends for direction and the results page for intent.

Steps

  1. List what you sell in your customers' words.

    Write every service, product and problem you solve as a short phrase. Then rewrite each one the way a customer says it. Pull wording from sales calls, enquiry emails and the questions people ask before they buy. Google's own starter guide notes that experts and newcomers search differently, with "charcuterie" versus "cheese board" as its example. Keep both versions. This seed list is your starting point for every tool below.

  2. Pull the queries you already appear for.

    In Search Console, open the Performance report, set the date range to the last few months and view the Queries tab. Sort by impressions. Queries with plenty of impressions but an average position just below the top results are near-misses that a better page could win. Export the list to your spreadsheet. If your site is new, this report will be thin, so lean on the next step.

  3. Expand the list with Keyword Planner.

    In Google Ads, open Keyword Planner and choose "Discover new keywords". Enter a few seed phrases, or a page URL, and review the ideas. Add relevant ones to your sheet with their monthly search estimate. Treat the estimates as ranges for comparing terms, not exact counts. Ignore any figures about ad costs: they describe paid search, not organic demand.

  4. Check direction and seasonality in Google Trends.

    Compare your main candidates in Trends over the past five years. Google scales the data from 0 to 100 against all searches for that place and time, so it shows relative interest, not volume. Use it to spot terms that are rising or fading, and seasonal peaks you should publish ahead of.

  5. Read the results page for each candidate.

    Search each main keyword in a private window and look at what ranks. Guides, service pages, product listings, maps and videos each signal a different need. If the top results are all how-to articles, a sales page is unlikely to fit. Write the dominant page type next to each keyword. Our article on search intent explains how to read this.

  6. Group keywords by intent, one page per group.

    Put keywords together when the same page would answer them and their results pages look alike. Give each group a primary keyword, usually the clearest phrasing, and list the variations under it. Keywords that share words but show different kinds of results belong in different groups. One group should mean one page.

  7. Prioritize by value, fit and effort.

    Score each group on three questions. Does it match something you sell? Can you write the best answer on the web for it, from real experience? How much work is the page? Volume breaks ties. A small, specific group tied to a core service usually beats a big, vague one. If you need visibility tomorrow rather than in months, read SEO vs paid ads first.

  8. Map each group to a URL and log it.

    Assign every group to an existing page or a new one, and never two groups with the same intent to different pages. Record the target URL, status and date in your sheet. When you write or update the page, use the primary keyword in its title and main heading, and the variations naturally in the copy.

What a finished keyword map looks like

A keyword map doesn't need special software. One row per keyword group is enough, as long as every row has exactly one target URL and a status. Columns for the variations, the dominant result type and the date you last checked the results page make it easier to maintain.

Here is a hypothetical example for a commercial cleaning company:

Example keyword map (hypothetical business, no volumes shown)
Primary keywordIntentTarget URLStatus
office cleaning serviceDo: hire a provider/services/office-cleaningUpdate title
how often should offices be cleanedKnow: guidance/blog/office-cleaning-frequencyNew page
commercial cleaning checklistKnow: template/blog/commercial-cleaning-checklistNew page
post-construction cleaningDo: hire a provider/services/post-constructionLive

The next job is to turn each mapped keyword into a strong title tags and meta descriptions pair. If you'd rather hand the research off, our in-house SEO team does keyword research, briefs and pages built around real search intent.

Troubleshooting

Keyword Planner shows no data for a keyword

Cause: Keyword Planner doesn't show very low-volume or sensitive keywords, and its help page says those terms aren't discoverable or forecastable. Many specific, high-intent phrases fall into that group, especially for niche services. A missing number doesn't mean nobody searches it.

Fix: look for the phrase in Search Console instead, where real queries appear even at small volumes. Check whether Google shows search suggestions or related searches for it, which is a sign people do search it. Then compare it with a broader term in Google Trends. If the phrase describes exactly what you sell, keep it in the map even without a volume figure, and judge it by the enquiries the page brings.

Two of your pages compete for the same keyword

Cause: two pages were written for the same intent, often a blog post and a service page, or an old page and its newer replacement. Search Console shows both URLs for the same query, and neither ranks as well as one strong page would.

Fix: in the Performance report, filter by the query and switch to the Pages tab to see which URLs appear. Decide which page best serves the intent and make it the only target in your keyword map. Merge the useful content from the other page into it, then redirect the weaker URL or change its focus to a different intent. Update internal links so they point to the page you kept.

A keyword brings traffic that never converts

Cause: the page matches the words but not the need. A how-to article can rank for a phrase that buyers and do-it-yourselfers both use. Or the keyword is broad, and most of the people searching it are early in their research and not ready to contact anyone yet.

Fix: re-read the results page and your Search Console queries for that page. If most searchers want to learn, keep the article helpful and add a clear, relevant next step rather than a hard sell. Then find the narrower phrases buyers use, such as a service name with "cost" or "for" plus their industry, and map those to your service pages.

Common questions

How many keywords should one page target?

One main topic, plus the close variations people use for the same need. Google's language systems understand related wording, so you don't need a separate page for every phrasing. If two keywords would be answered by the same page and the results pages look alike, group them. If the results show different kinds of pages, they need different pages on your site.

Are free keyword tools accurate enough?

For planning, yes, as long as you treat the numbers as estimates. Search Console shows real queries for your own site, but only ones you already appear for. Keyword Planner gives monthly search estimates and hides very low-volume terms. Google Trends shows relative interest on a 0 to 100 scale, not search counts. Use them together and compare terms, rather than trusting one number.

Should I target high-volume keywords first?

Usually not. Broad, high-volume terms are often vague about what the searcher wants, and many big sites already compete for them. Start with specific keywords that match a service you sell and a page you can make the best answer for. They bring fewer visits, but the visitors are closer to buying, and early wins there help you learn what works.

How often should keyword research be repeated?

Review the keyword map every quarter and redo the full research once a year, or when you add a service. Search Console will show new queries your pages start to appear for, and Trends will show shifts in interest. Language changes too: new product names and new ways of asking questions appear, so a map that never changes slowly drifts away from how buyers search.

← Back to SEO

Rankings that compound

In-house keyword research, technical SEO and content, custom-quoted. Quote within 24 hours.

5.0-star Google rating (24 reviews) · BBB Accredited, A rating