This post is based on a real Loom walkthrough I recorded for a client after finishing a keyword strategy deliverable. I am turning the main points into a question-and-answer format because that is the easiest way to explain what the deliverable is actually supposed to do.
A keyword spreadsheet can look impressive and still leave a client unsure what to do next. The useful part is not the export itself. The useful part is the answer to the questions behind it: which keywords matter, which page type fits, which opportunities are realistic, and what should happen first.
Here is how I think through those questions when I build a keyword strategy guide.
What is a keyword strategy guide?
A keyword strategy guide is the practical layer on top of keyword research. It explains which keywords matter, why they matter, what kind of page each keyword needs, and which actions should happen first.
The keyword export gives you data. The guide turns that data into decisions.
That distinction matters because a spreadsheet can contain hundreds of rows without making the next step obvious. A good guide should reduce that confusion. It should help the client understand the current SEO reality, the competitor gaps, the commercial opportunities, the blog opportunities, and the first month of work.
Why is the spreadsheet not enough by itself?
Because keyword data does not automatically explain priority.
A spreadsheet may include search volume, keyword difficulty, CPC, competitor URLs, ranking positions, local modifiers, and notes. All of that is useful, but the client still needs answers to simple questions:
- Which competitors are the right comparison set?
- Which keywords have real business value?
- Which keywords are realistic for the site right now?
- Which keywords need landing pages?
- Which keywords need blog posts?
- Which pages should be built or improved first?
If the spreadsheet does not answer those questions, it is research, not strategy.
What current reality should I explain first?
I like to start by explaining where the site stands before recommending new work.
If the client is not ranking for much yet, that does not always mean the market is impossible. Sometimes the site has a weak authority profile and needs a slower plan. Sometimes the site has enough authority, but the right pages simply do not exist yet. Those are very different problems.
If stronger competitors dominate every important query, the plan may need to start with lower-competition topics, technical cleanup, and link building. If weaker competitors are already ranking, the opportunity may be page targeting, search intent, and execution.
The guide should make that difference clear before it asks the client to create more pages.
Which tabs make the keyword strategy easier to use?
I prefer tabs that answer different decision questions instead of one massive table.
The read-me tab explains how to use the file. The competitor tab explains the comparison set. The keyword gap tab shows where competitors rank and the client does not. The local opportunity tab keeps location-based searches separate. The blog content tab collects informational topics that can support service pages.
Each tab should have a job. That way the client is not forced to sort hundreds of keywords mentally before understanding the plan.
How do I decide which keywords deserve priority?
I start with keywords that combine business value and a realistic path to rankings.
A high-volume keyword is not useful if it attracts the wrong audience. A low-difficulty keyword is not useful if it has no buyer or strategic value. Good prioritization sits in the middle.
Before I recommend a keyword, I usually ask:
- Does this keyword match a real service, offer, or audience the business wants?
- Does the searcher seem likely to compare, hire, book, buy, or request a quote?
- Are advertisers paying for this keyword?
- Are weaker competitors ranking for it?
- What page type is Google already rewarding?
- Can the client realistically create or improve the right page soon?
CPC can help here, but it is only a clue. I still want to check the search results, the page type, the competitor strength, and the client’s real business priorities.
Why does search intent decide the page type?
Because the right keyword can still fail if it is matched to the wrong kind of page.
If the top results are blog posts and guides, Google is probably seeing informational intent. A service page may struggle there. If the top results are service pages, directories, or local landing pages, a blog post may not be the best match.
That is why I always check what already ranks before deciding what to build. A keyword strategy guide should not only say, “target this keyword.” It should say, “target this keyword with this kind of page.”
How do I map keywords to pages?
I keep the mapping simple enough that the client can use it later.
| Question | Likely answer | First action |
|---|---|---|
| Does the keyword describe a service? | Use a landing page. | Build or improve a commercial page. |
| Does the keyword ask for an explanation? | Use a blog post or guide. | Create a helpful article and link it to a service page. |
| Does the keyword include a location? | Use a local landing page. | Match the page to the local intent and service area. |
| Is the keyword broad and educational? | Use supporting content. | Build topical relevance and add internal links. |
There are exceptions, but this simple table prevents a lot of wasted content. It keeps the client from trying to rank a service page for an informational query or writing a blog post when the searcher wants to compare providers.
Which keyword should become the first landing page candidate?
The first landing page candidate should usually be a keyword that is close to revenue and realistic to compete for.
In the Loom, I pointed to a commercial service keyword because it had the right mix of signals. It matched a real service, had clear buying intent, showed commercial value, and had competitors that did not look impossible to beat.
That kind of keyword is useful because the next step is obvious. The client can build or improve a landing page with a strong title, clear sections, trust signals, examples, FAQs, internal links, and a practical call to action.
Which keyword should become the first blog post candidate?
The first blog post candidate should answer a real informational question that supports a commercial page.
I do not like choosing blog topics only because they have volume. A blog post should do a job. It can explain a problem, build topical depth, attract links, support a service page, or help the reader move toward a useful next step.
That is why the best early blog topic is often one that sits near the service, not miles away from it. It may not close the sale on its own, but it should make the related commercial page stronger.
What should the page blueprint include?
After choosing the keyword, the next question is not just whether the client can write the page. The better question is what the page needs in order to deserve a ranking.
For a landing page, the blueprint may include:
- H1 and title tag direction
- search-intent summary
- recommended section structure
- proof or trust signals
- internal links
- examples or use cases
- FAQs
- CTA placement
- notes from competitor pages
For a blog post, the blueprint may include the main question, supporting subtopics, examples, internal links to commercial pages, related questions, recommended CTA, and opportunities for images or diagrams.
This is where keyword research becomes content direction.
Want me to turn your keyword spreadsheet into a prioritized SEO roadmap?
I can map the best landing-page targets, blog topics, search-intent notes, internal-link opportunities, and first actions to take.
Why does client review still matter?
Because keyword research is an informed recommendation, not a replacement for business judgment.
A keyword can look good in a tool and still be wrong for the company. Maybe the client does not want that kind of lead. Maybe the service is not profitable enough. Maybe the offer has changed. Maybe the search demand is real, but the business does not want to be positioned that way.
That is why I ask clients to review the strategy instead of treating it as gospel. I bring the SEO logic. The client brings the business reality. The final plan gets stronger when both are present.
What common mistakes should the guide prevent?
A good keyword strategy guide should help the client avoid the predictable traps.
- Chasing search volume before business value
- Choosing keywords only because difficulty looks low
- Ignoring the page type Google is already rewarding
- Writing blog posts that never support commercial pages
- Treating CPC as proof instead of a clue
- Skipping client review
- Ending with vague advice instead of a first-month plan
The guide is not just a list of opportunities. It is a guardrail against bad SEO decisions.
What should happen in the first 30 days?
The first month should turn the strategy into a small, concrete sequence.
- Week 1: Review the keyword strategy guide, confirm the highest-priority services, and remove keywords that do not match the business direction.
- Week 2: Build or optimize the first commercial landing page around the strongest realistic service keyword.
- Week 3: Create the first supporting blog post around the best informational topic.
- Week 4: Add internal links, request indexing where appropriate, and start tracking impressions, rankings, clicks, and early engagement.
The plan does not need to be dramatic. It needs to make Monday morning obvious.
What is the practical takeaway?
The real value of a keyword strategy guide is not that it contains keywords. The value is that it tells the client what to do with them.
For this project, the strategy came down to a few answers. The client had more opportunity than the current rankings suggested. Some competitors were ranking because they had better-targeted pages, not because they were impossible to beat. The first priorities should be commercial keywords with realistic competition, then supporting blog content that matches informational intent.
A spreadsheet can show the opportunity. A good strategy guide turns it into a sequence.
Was this based on a real Loom walkthrough?
Yes. This post is based on a real Loom walkthrough I recorded after preparing a keyword strategy guide for a client.
The private client details, spreadsheet link, domains, and project context are not included here. The Loom is embedded above by request so you can see the walkthrough context, but the public value is the process: how to explain the spreadsheet, how to connect keyword data to page types, and how to turn the research into first actions.
Sources and reference links
- Google Search Central: SEO Starter Guide
- Google Search Central: Creating helpful, reliable, people-first content
- Google Search Central: Influencing title links in search results
- Google Search Central: Link best practices for Google
- WebDesy: How I Do Keyword Research
- WebDesy: How to Do Keyword Research in Ahrefs: A Compact SEO Workflow
Short FAQ
How is a keyword strategy guide different from keyword research?
Keyword research collects the data. A keyword strategy guide interprets the data and turns it into a plan for landing pages, blog posts, internal links, and first-month priorities.
Should blog posts or landing pages come first?
It depends on search intent. If the keyword has commercial intent and the top results are service pages, a landing page usually comes first. If the keyword is informational and the top results are guides or articles, a blog post is usually the better match.
How many keywords should one page target?
One page should have one primary keyword direction, with closely related secondary terms included naturally. If two keywords have different search intent, they usually need separate pages.
How soon can a new keyword strategy produce results?
The first pages can be planned and published quickly, but SEO movement usually takes time. Early signs may show up as impressions and indexing first, while rankings, clicks, and leads can take weeks or months depending on competition and site strength.