Most keyword research is a waste of time
I see the same pattern constantly: someone exports thousands of keywords from Ahrefs, sorts by volume, and targets the biggest numbers. Three months later, they've published 50 articles and ranked for none of them.
The problem isn't their writing or their site. It's that they picked unwinnable battles. High-volume keywords are high-volume because they're competitive. Without serious authority, you're not going to rank.
This guide is about finding keywords you can actually win — not just keywords that look good in a spreadsheet.
The keyword research mindset shift
Before we get tactical, let's fix how you think about keywords:
Volume is not the goal
A keyword with 100 searches/month where you rank #1 gives you ~30 clicks. A keyword with 10,000 searches where you rank #47 gives you zero.
Target keywords you can actually rank for. You can always go after bigger keywords later when you have more authority.
Intent matters more than volume
100 visitors with high purchase intent beat 10,000 visitors who are just browsing. Focus on keywords that indicate someone is ready to take action.
Think topics, not just keywords
One piece of content can rank for hundreds of related keywords. Instead of targeting individual keywords, think about topics that cover multiple related searches.
Finding keyword opportunities
Here's my actual process for finding keywords worth targeting:
1. Start with competitor analysis
Your competitors have already done keyword research for you. Find sites that:
- Compete for your target customers
- Have similar authority to you (check Domain Rating)
- Are actively publishing content
Plug them into Ahrefs, Semrush, or Ubersuggest. Look at:
- What keywords are they ranking for that you're not?
- What content is driving their organic traffic?
- What topics are working for them?
The key insight: if a competitor with similar authority ranks for something, you probably can too.
2. Find low-competition opportunities
Filter for keywords where:
- Keyword Difficulty (KD) is low: Under 30 is a good starting point
- Results are weak: Look at the actual SERPs — are the ranking pages thin, outdated, or from weak sites?
- Volume exists: Even 50-100 searches/month can be worth it for the right intent
3. Identify question-based keywords
People asking questions are often earlier in the buying journey, but they're highly engaged. Look for:
- "How to [topic]"
- "What is [topic]"
- "Why does [topic]"
- "[Topic] vs [topic]"
- "Best [product] for [use case]"
Tools: AnswerThePublic, AlsoAsked, and the "People Also Ask" boxes in Google itself.
4. Look at "Keyword Golden Ratio" opportunities
The Keyword Golden Ratio (KGR) is: (allintitle results) / (monthly search volume).
If KGR is under 0.25, the keyword is underserved — there's search volume but few pages specifically targeting it. These are your quick wins.
Example: If "best CRM for real estate agents" has 200 searches/month and only 30 pages with that exact phrase in the title, KGR = 0.15. Worth targeting.
5. Mine your own data
Google Search Console shows queries you're already appearing for. Filter for:
- Queries with impressions but low CTR (you're ranking but not getting clicks)
- Queries where you rank on page 2 (close to ranking well)
- Questions that people search before converting (from your analytics)
Evaluating keyword intent
Intent determines whether traffic converts. Here's how to identify it:
Informational intent
Searcher wants to learn something. Keywords include "how to," "what is," "guide," "tutorial."
Good for: Building authority, capturing early-stage audiences, link building.
Converts: Slowly, through nurturing.
Commercial investigation intent
Searcher is researching before buying. Keywords include "best," "review," "vs," "comparison," "top."
Good for: Affiliate content, product comparisons, helping people choose your solution.
Converts: Better than informational, but still considering options.
Transactional intent
Searcher is ready to act. Keywords include "buy," "price," "coupon," "near me," "free trial."
Good for: Product pages, pricing pages, location pages.
Converts: Highest conversion rate.
Navigational intent
Searcher is looking for a specific site. "[Brand] login," "[Brand] pricing."
Good for: Making sure you rank for your own brand.
Converts: Already interested in you specifically.
How to verify intent
Actually Google the keyword and look at the results. Google shows you what intent they've determined:
- Mostly blog posts? Informational.
- Product pages? Transactional.
- Mix of comparisons and reviews? Commercial.
Match your content type to what's already ranking. If Google shows 10 blog posts, don't try to rank a product page.
Building a keyword strategy
Individual keywords aren't a strategy. Here's how to think bigger:
Topic clusters
Group related keywords around pillar topics:
- Pillar page: Comprehensive guide to the main topic
- Cluster content: Detailed articles on subtopics, linking to the pillar
- Internal linking: Connect everything together
Example for a project management tool:
- Pillar: "Complete Guide to Project Management"
- Clusters: "Agile project management," "Project management for remote teams," "Project management templates," etc.
Funnel mapping
Target keywords for every stage of your customer journey:
- Awareness: "What is [problem]" — educational content
- Consideration: "Best [solution] for [situation]" — comparison content
- Decision: "[Your brand] vs [competitor]" — conversion content
Prioritization framework
Score each keyword opportunity on:
- Difficulty: Can you realistically rank? (1-10)
- Business value: Does this attract your target customer? (1-10)
- Volume: Is there enough search volume to matter? (1-10)
Multiply the scores. Tackle highest scores first.
Tools I actually use
You don't need every tool. Here's what's actually useful:
- Ahrefs or Semrush: Pick one. Both do keyword research, competitor analysis, and rank tracking. Ahrefs has better backlink data, Semrush has more keyword data.
- Google Search Console: Free, shows real queries you rank for.
- Google Keyword Planner: Free with a Google Ads account. Good for volume ranges.
- AnswerThePublic: Great for question-based keywords. Free tier is useful.
- Ubersuggest: Cheaper alternative to Ahrefs/Semrush if budget is tight.
The bottom line
Good keyword research is about finding opportunities that match your authority level and business goals. Stop chasing high-volume keywords you can't win. Start with low-competition, high-intent keywords and work your way up.
The best keyword is one you can rank #1 for that brings visitors who become customers. Volume is just one factor in that equation.