Skip to content
Home β€Ί Templates β€Ί Keyword Research Framework
RR Web Services Free template

Keyword Research
Framework

Most keyword research starts with volume and difficulty. This framework starts with 2 questions that filter out 60% of keywords before you even open a tool: does Google show businesses like mine for this search, and is there room for me in those results?

1
Understand the business
Understand the business before you open a keyword tool
2
Gather seed keywords
Build a broad list from 5 specific sources
3
Intent check
Filter by what Google shows for each keyword
4
Room to rank
Check whether there's real room in each set of results
5
Scoring and priorities
Score and rank the keywords that passed
6
Map keywords to pages
Give each page one keyword, ready to brief
8
Tabs
6
Phases
2
Key filters
Free
Always
An intent check: see what Google shows before you spend time on difficulty scores
A room-to-rank check: content gaps, weak results and local intent reviewed for each keyword
Priority scores that combine 4 measures (volume, ease, intent and room to rank) into one number
A page map with one main keyword per page, supporting keywords, content type and a status tracker
Filled in with real examples, so you can see how it works and adapt it to your niche
Keyword Research Framework

Google Sheets, 8 tabs, a guided 6-phase process, lifetime access

Free, with no payment needed

Enter your details to get the editable Google Sheets version. You can view the full framework on this page and use your copy to work through it with your own clients.

We won't spam you, and you can unsubscribe at any time.

What you get
Cover tab for client details
Phase 1: understand the business (10 questions)
Phase 2: gather seed keywords (5 sources)
Phase 3: check intent, with a guide to search results
Phase 4: check room to rank (3 signals)
Phase 5: priority scores (calculated for you)
Phase 6: map keywords to pages, with a status tracker
A master keyword list with summary numbers
Use it on as many client projects as you like
Here's your copy

Click below to open the Google Sheets template, then choose Make a copy from the File menu to save your own editable version.

Open the Google Sheets template Questions? Message us anytime
The 2 filters that set this framework apart
01
Intent check: does Google show businesses like mine?
Before you check volume or difficulty, search the keyword in Google and look at what ranks. Is it businesses like yours, or tutorials, forums and product reviews? A plumber targeting "how to fix a leaking pipe" is chasing results full of DIY guides, not service businesses.
Example: "emergency furnace repair chicago" shows service pages and a local map pack, so go ahead. "How to fix a furnace yourself" shows DIY tutorials and YouTube videos, so skip it: it's the wrong audience.
02
Room to rank: is there space for me?
Keyword difficulty scores tell you how hard a keyword is overall. They don't tell you whether there's a specific gap you can fill. Missing angles, weak results in the top 10 and local intent all create openings a difficulty score misses.
Example: KD 35 with every competitor at DR 70+ is hard to break into. KD 35 with 2 thin directory listings and a 2019 blog post in the top 10 is a clear gap, so target it now.
1
Understand the business
Phase 1 of 6
Keyword research without business context produces a list of keywords with good volume that the business has no right to rank for and no way to convert. This phase makes you ask the right questions first.
What this phase covers
  • β€’ The business model, services and what drives revenue
  • β€’ The ideal customer, described specifically
  • β€’ The problems customers have before they find you
  • β€’ How customers describe what they need (not how the business describes it)
  • β€’ The top 3 to 5 competitors who rank well
  • β€’ The geographic scope: local, national or global
2
Gather seed keywords
Phase 2 of 6
Seed keywords are starting points, not final targets. The goal here is breadth, because you'll filter hard in Phases 3 and 4. Aim for 30 to 80 seed keywords across all 5 sources.
The 5 sources
  • β€’ Conversations with the business: the searches customers make
  • β€’ Competitor analysis: what drives their top pages
  • β€’ Your Search Console data: impressions you aren't making the most of
  • β€’ Customer language: word for word from calls and reviews
  • β€’ Google Suggest and People Also Ask: free and very relevant
3
Intent check
Phase 3 of 6
The first filter. For each seed keyword, open Google in a private window and look at what ranks. This one step removes keywords that have volume but will never convert for your type of business.
Types of search results and what they mean
  • β€’ Service pages: buyers, so go ahead
  • β€’ How-to articles: research, so skip for service pages
  • β€’ Products and online stores: wrong audience, so skip
  • β€’ A strong local map pack: local intent, so go ahead for local businesses
  • β€’ Forum and Reddit results: early research, so use for blog content only
  • β€’ An AI Overview at the top: far fewer clicks, so skip or aim to be its source
4
Room to rank
Phase 4 of 6
The second filter. Even if the intent is right, can this site rank? Look past difficulty scores for the 3 signs that show a real opening.
The 3 signs of an opening
  • β€’ Missing angles: the top 10 results don't cover specific angles you can own
  • β€’ Weak results: thin content, low DR, old dates or forum posts near the top
  • β€’ Local intent: local businesses ranking with much lower DR than a national competitor would need
  • β€’ Difficulty guide: KD 0 to 20, target now; KD 21 to 40, target with strong content; KD 41+, build authority first
5
Scoring and priorities
Phase 5 of 6
Score each keyword that passed both filters on 4 measures to get a ranked list. The priority score calculates itself, and the framework assigns a tier so you know exactly what to work on first.
Scoring measures (each from 1 to 5)
  • β€’ Volume score: monthly searches
  • β€’ Ease score: KD and weak results combined
  • β€’ Intent score: how close the searcher is to buying
  • β€’ Room score: how strong the 3 signs are
  • β€’ Priority score: all 4 added up (20 at most)
  • β€’ Tier 1 (16 to 20): target now. Tier 2 (11 to 15): target soon
6
Map keywords to pages
Phase 6 of 6
One main keyword per page and 2 to 4 supporting keywords. If 2 keywords would compete for the same page, that's a cannibalization risk to fix now, not after you publish.
What this phase produces
  • β€’ The target page URL (existing or new)
  • β€’ The main keyword and supporting keywords
  • β€’ The page type: service, location, pillar, blog, comparison or FAQ
  • β€’ Whether it needs a content brief, with notes
  • β€’ A target date and current status
  • β€’ Ready to hand to a developer or writer
Cover
Phase 0 of 6
Client info, an overview of the 6 phases and a how-to guide
Phase 1
Phase 1 of 6
10 guided questions to understand the business before you open a keyword tool
Phase 2
Phase 2 of 6
A 60-row seed keyword table with source tracking and intent notes
Phase 3
Phase 3 of 6
The intent check table, the first and most important filter
Phase 4
Phase 4 of 6
Room to rank: missing angles, weak results and local signals for each keyword
Phase 5
Phase 5 of 6
Priority scores, calculated for you, with a tier assigned to each keyword
Phase 6
Phase β€” of 6
Page mapping: one keyword per page, a status tracker and a content brief flag
Master list
Phase β€” of 6
Summary numbers and the full list of keywords that passed
RR_Keyword_Research_Framework.xlsx - Google Sheets
Keyword Type of results Shows my type of business? Local pack? AI Overview? Intent verdict
emergency boiler repair chicago Service pages and local pack Yes, plumbers and HVAC Yes, strong No βœ“ Go ahead
how to fix a boiler yourself How-to articles and YouTube No, DIY tutorials only No Yes βœ— Skip: wrong intent
boiler repair near me Local pack and service pages Yes, local businesses Yes, very strong No βœ“ Go ahead
best boiler brands 2025 Review and comparison sites No, product reviews No No Blog only
why is my boiler losing pressure How-to articles No, DIY guides No Yes Blog only
annual boiler service chicago Mixed: service and info Partly No No Go ahead with care
SEO consultants

Stop presenting keyword lists that look impressive but don't convert. This framework produces a checked list, in priority order, that your clients can understand and trust.

SEO agencies

Run keyword research the same way on every client account. Everyone on the team follows the same 6-phase process, with fewer dead ends and faster delivery.

In-house SEO managers

Make the business case for content with a prioritized list that shows volume, difficulty, intent and revenue potential in one place.

Content marketers

Know exactly which keywords to brief for which pages before a single word is written. No more publishing content aimed at the wrong intent.

WordPress developers

Offer keyword research as part of your SEO service, with a professional, repeatable framework you can use on every site you build.

People learning SEO

See how professional keyword research works in practice: a complete way of making decisions, from understanding the business to mapping pages.

Who this is not for

If you want a fully automated keyword tool that pulls data through an API with no manual work, this isn't it. This framework asks you to open Google, look at the results and use your judgment. That manual step is also what makes the results more accurate than an automated process. If you want software that does everything for you, use Ahrefs, Semrush or similar. If you want a keyword list you can rank for and convert from, this is it.

No. The framework uses Ahrefs and Semrush for volume and difficulty data, but the two most important phases, intent check and room to rank, use nothing but Google. You can do solid keyword research with just Google Search Console (for your existing data), Google search (to check results) and one keyword tool on a free plan for basic volume.
For a focused niche with 30 to 50 seed keywords, 2 to 4 hours from start to finish. Most of that time goes into Phases 3 and 4, checking search results by hand. That manual checking is what makes the results reliable, and rushing it is where most keyword research goes wrong.
Yes, with some changes. The intent check and room-to-rank phases work the same way. Phase 1 should focus on product categories and buying stages instead of services, and Phase 6 maps to category pages, product pages and supporting blog content instead of service pages. The framework isn't built for ecommerce, but the logic carries over directly.
Mixed results are common, and they're an opportunity, not a reason to skip. If a keyword shows some service pages and some articles, Google hasn't fully decided what people want. That uncertainty can work for you if you create content that clearly serves buyers. Use the notes column in Phase 3 to record it.
It depends on the niche and how much authority the site already has. A typical local service business might start with 50 to 70 seed keywords, narrow them to 15 to 25 in Phases 3 and 4, score them in Phase 5 and map them to 10 to 15 pages in Phase 6. Quality beats quantity: 10 well-chosen keywords you can rank for are worth more than 100 you have no realistic chance with.
Yes. The room-to-rank check in Phase 4 works just as well for keywords you already target. If you're on page two for a keyword, run it through Phases 3 and 4 to confirm the intent is right and there's real room to move up. Then the Phase 5 score shows how to prioritize it against new keywords.
The core logic (intent first, room to rank second) holds up and has been the basis of good keyword research for years. The tool recommendations and descriptions of search features are updated when big changes happen. The Google Sheets version you copy is always the current one, so check back now and then for updates.
Have us do the keyword research for you

The framework shows you how to find the right keywords. The SEO Clarity report is us doing it for you: a full keyword and competitor analysis for your site, delivered in 5 days with a content plan in priority order.