If you’ve made it this far, you’ve probably been told that SEO starts with keywords. And they’re right. But there’s a big lie circulating on the internet: Keyword Research isn’t about downloading a list of 5,000 words into Excel and praying that Google will love you.
I’ve been doing SEO for 10 years, and I can assure you that the secret isn’t in finding “the magic word,” but in understanding what your audience is looking for, with what intention, and at what stage of the buying process they are.
Now, I’m going to teach you my step-by-step method for doing professional keyword research, using a real example that we can all understand: running shoes. And at the end, I’ll show you where I organize all this so I don’t go crazy.
In this guide, you will learn:
- What is a keyword research
- How to do keyword research step by step
- How to find profitable long-tail keywords
- How to analyze search intent
- How to avoid SEO cannibalization
- How to structure your website with topic clusters
- Common mistakes to avoid
- What tools to use
What exactly is keyword research and why is it so important?
Keyword research is the process of identifying which terms your potential customers use in search engines and, more importantly, understanding what they expect to find.
It’s not just about attracting traffic. It’s about attracting the right traffic. If you sell high-end running shoes, it’s no use ranking for “cheap shoes.”
Good research allows you to:
- Understand demand: What is your audience looking for?
- Structure your website: Create a logical information architecture.
- Avoid cannibalization: Don’t compete against yourself with two identical pages.
How to do keyword research step by step
Step 1: Define the business context and buyer persona (Identification of Seed Keywords and Market)
Seed keywords are the fundamental terms that define the core of the business. They are not extracted from SEO tools, but from the company’s product inventory and value proposition. These words serve as initial input for the algorithms of the analysis tools.
For a sports e-commerce site, the seeds are derived from the main categories:
- Running shoes
- Trail running
- Marathon training
Buyer Persona Analysis
Before expanding the seeds, it is necessary to define the user’s pain points to anticipate search patterns:
- Technical problem: Pronation, flat feet, plantar fasciitis.
- Context of use: Asphalt, mountain, competition, daily training.
- Level of experience: Beginner (looking for guides) vs. Athlete (looking for technical specifications).
Step 2: Keyword expansion (Head, Middle, and Long Tail)
The objective of this phase is to multiply seed words to cover the entire search spectrum. Tools such as Google Keyword Planner, Ahrefs, or Semrush are used to extract semantic variations.
The Long Tail Concept
In SEO, keywords are distributed along a demand curve:
- Head Terms: Generic terms with high search volume (SV) and high competition (KD). They tend to have ambiguous intent. Example: “Running shoes.”
- Middle Tail: Terms with moderate specificity. Example: “Men’s running shoes.”
- Long Tail: Very specific phrases (3+ words), lower individual volume, but high conversion rate and lower difficulty. Example: “Best running shoes for flat feet 2026.”
The tactical action here is prioritizing Long Tail terms allows you to capture qualified traffic with lower acquisition costs and faster positioning.
Step 3: Analyze search intent
Google uses natural language processing algorithms (such as BERT and MUM) to understand what the user wants to achieve. Aligning the type of content with the intent is the most critical ranking factor.
Keywords should be labeled into four categories:
- Informational (Know): The user is looking to resolve a question.
- Keyword: “How to wash running shoes.”
- Digital asset: Blog post, guide, tutorial.
- Navigational (Go): The user is looking for a specific URL.
- Keyword: “Nike official store.”
- Digital asset: Homepage.
- Commercial Research (Investigate): The user compares options before buying.
- Keyword: “Best trail running shoes reviews.”
- Digital asset: Listings, comparison tables, reviews.
- Transactional (Do): The user is ready to convert.
- Keyword: “Buy Brooks Ghost 15 size 10.”
- Digital asset: Product detail page (PDP), category page (PLP).
Common mistake: Trying to position a product detail page for an informational search (e.g., “best running shoes for beginners”) results in a high bounce rate and loss of ranking.
Step 4: Filtering and Prioritization Metrics (volume and difficulty)
Once the raw list of keywords (Raw Data) has been obtained, filtering based on SEO metrics is applied to select viable terms.
Key Metrics:
- Search Volume (SV): Monthly average number of searches. Indicates traffic potential.
- Keyword Difficulty (KD): Logarithmic estimate (0-100) of the difficulty of ranking in the Top 10, based mainly on the backlink profile of current competitors.
Selection Framework
For domains with low authority (low DR/DA), a low KD strategy (<30) is recommended.
- High SV / High KD: Discard or save for the long term.
- Low SV / Low KD: Immediate opportunity (low-hanging fruit).
- High SV / Low KD: Unicorns (highest priority).
Step 5: Clustering and topic authority
Keyword Clustering consists of grouping semantically related terms under a single master URL (Pillar Page or Cluster Content). This prevents SEO cannibalization, where multiple pages on the same site compete for the same keywords.
Clustering Example: Running Shoes Niche
| Keyword Variation | Cluster (Topic) | Search Intent | Target URL |
| how to wash running shoes | Running Shoes Care | Informational | /blog/guide-wash-shoes |
| cleaning running shoes | Running Shoes Care | Informational | /blog/guide-wash-shoes |
| how to dry sneakers | Running Shoes Care | Informational | /blog/guide-wash-shoes |
| best running shoes for flat feet | Best Running Shoes | Commercial | /blog/best-flat-feet-shoes |
| nike mens running shoes | Mens Running Shoes | Transactional | /shop/mens-running/nike |
Result: Instead of creating three weak articles on cleaning, a single authoritative guide covering “washing,” “cleaning,” and “drying” is created, increasing thematic relevance.
Step 7: Prioritize according to business impact
Here is the technical section on prioritization, written to fit seamlessly into the existing guide. It uses the Running Shoes example and adheres to your strict content rules.
Sorting keywords by Search Volume (SV) is the most common mistake in SEO strategy. High traffic does not correlate with high revenue. To prioritize for business impact, you must analyze the Revenue Potential of a keyword relative to the Effort required to rank.
Use the C.P.C. Framework (Conversion, Product, Competition) to assign a priority level to each keyword.
1. Conversion Probability (Intent Proxy)
Not all clicks are equal. You can estimate the conversion rate based on the intent stage:
- Transactional (High Impact): “Buy running shoes online” (~3-5% conversion rate).
- Commercial (Medium Impact): “Best running shoes reviews” (~1-2% conversion rate).
- Informational (Low Impact): “How to tie running shoes” (<0.5% conversion rate).
Tactical Tip: Check the CPC (Cost Per Click) metric in your SEO tool. If advertisers are paying $5.00 per click for a keyword, it has high business impact. If the CPC is $0.00, the traffic likely does not convert.
2. Product Value Alignment
Prioritize keywords that lead to your highest-margin or best-selling products.
- Scenario A: “Cheap running socks” (Volume: 5,000 | Product Value: $10).
- Scenario B: “Carbon fiber marathon shoes” (Volume: 500 | Product Value: $250).
Analysis: Ranking for Scenario B requires 10x less traffic to generate the same revenue, assuming similar conversion rates. Always prioritize high-ticket item keywords over generic high-volume terms.
3. The Priority Matrix (Impact vs. Effort)
Combine the metrics to categorize your keyword list into four execution quadran
Critical Mistakes in Keyword Research
Even with the right tools, misinterpreting data can compromise your SEO strategy. Avoid the following patterns:
- Obsession with Volume (Vanity Metrics): Prioritizing keywords with 10,000 monthly searches but high difficulty, ignoring keywords with 200 searches and high transactional intent. Traffic without conversion is a server cost, not a benefit.
- Ignoring the Real SERP: Blindly trusting a tool’s metrics without looking at Google’s results. If the tool says it’s “easy” but the first page is full of Amazon, Wikipedia, and Government, the real difficulty is extreme.
- Keyword Stuffing in 2026: Trying to repeat the exact keyword multiple times in the content. Current algorithms prioritize semantic richness and topic coverage (LSI) over keyword density.
- Unintentional Cannibalization: Creating multiple articles for minor variations (“cheap sneakers” vs. “affordable sneakers”). Google won’t know which one to index and will divide the authority between the two, causing them to drop in the rankings.
- Seasonal Myopia: Optimizing a strategy based on volume data from a peak month (e.g., December) without annualizing demand.
What tools to use for keyword research
The selection of tools should be based on the phase of the process, not on the popularity of the software. The following tiered stack is recommended:
1. Data Extraction (Discovery)
- Google Keyword Planner (Free): Primary source of data. Ideal for “Broad Match” search volumes and seasonal trends, although it hides exact data if there is no investment in Google Ads.
- Google Trends: Vital for validating the seasonality of a keyword (e.g., differentiating “Black Friday” peaks vs. stable demand).
- Google Search Console: The only source of actual performance data (impressions/clicks) for optimizing existing content.
2. Competitor Analysis and Metrics (Intelligence)
- Ahrefs / Semrush (Paid): Industry standards. Necessary for obtaining difficulty metrics (KD), content gap analysis, and seeing exactly which keywords your competitors are ranking for.
- Keywords Everywhere / Surfer SEO (Plugins): Useful for on-the-fly analysis directly in SERPs (Search Engine Results Pages).
3. Management and Architecture (Management)
- Notion (Productivity): The operating environment for centralizing strategy. Allows you to link research with the editorial calendar and production status, overcoming the rigidity of Excel.
The problem you have now is, where do I put all this?
Doing this in Excel is a nightmare. Endless rows, cells that get deleted, colors that don’t make sense, and tabs that you end up closing out of boredom.
SEO needs to be visual. You need to see where each word is in the funnel and whether you’ve already written content about it or not.
That’s why I created the Notion Keyword Planner Template.
It’s the exact template I use, designed to take you from research to action.
- ✅ Visual Cluster System: Automatically group your topics.
- ✅ Intent Tags: Differentiate at a glance between what’s for the blog and what’s for the store.
- ✅ Content Pipeline: Move your words from “Idea” to “Published” on a Kanban board.
I’ve included the complete Running Shoes example within the template so you can see exactly how a winning strategy is structured from the get-go.
[Download the Notion Keyword Planner here and start organizing your SEO today]
