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?
Google Sheets, 8 tabs, a guided 6-phase process, lifetime access
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.
Click below to open the Google Sheets template, then choose Make a copy from the File menu to save your own editable version.
- β’ 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
- β’ 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
- β’ 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
- β’ 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
- β’ 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
- β’ 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
| 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 |
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.
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.
Make the business case for content with a prioritized list that shows volume, difficulty, intent and revenue potential in one place.
Know exactly which keywords to brief for which pages before a single word is written. No more publishing content aimed at the wrong intent.
Offer keyword research as part of your SEO service, with a professional, repeatable framework you can use on every site you build.
See how professional keyword research works in practice: a complete way of making decisions, from understanding the business to mapping pages.
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.
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.