Keyword research is not a list-building exercise. It is deciding which questions you will answer. Having 5,000 terms in a spreadsheet means nothing.
Where the data comes from
- Search Console: the most valuable source. Queries where you already get impressions but few clicks are your fastest wins.
- Autocomplete: type your topic and walk the alphabet. It shows real user language.
- People Also Ask: the user’s next question.
- Competitor analysis: pages driving traffic for competitors that have no equivalent on your site.
- Customer touchpoints: support tickets, sales calls, reviews. The most original terms come from here.
Classify by intent first
Intent comes before volume. Four types:
- Informational: "what is core web vitals" — answered with blog content
- Navigational: "loopcode login" — answered with brand pages
- Commercial investigation: "best seo tool" — answered with comparisons and reviews
- Transactional: "seo consulting pricing" — answered with service and product pages
Misread the intent and no amount of content quality will rank you. The most reliable way to learn a term’s intent: search it and look at what kind of pages fill the top ten. If they are all product pages, you will not compete there with a blog post.
Assess difficulty honestly
Tool "difficulty" scores are approximations. Manually inspecting page one is more reliable:
- Are the top ten all large, established brands?
- Do those pages go deep, or are they thin?
- Are the publication dates old? Old results mean opportunity.
- Do the results answer the question exactly, or only approximately? Approximate means you can do better.
Why long tail matters
Ranking first for "seo" takes years. Ranking for "ecommerce category page seo checklist" can happen in your first month. The second has lower volume but clearer intent — and it converts.
For a new site the rule is simple: set the broad high-volume terms as your target, but write the content against long-tail questions. As authority accumulates, the broad terms follow on their own.
Prioritisation
Score every term in three columns: business value, current position, estimated difficulty. What should float to the top: high business value, currently ranking between 5 and 20, moderate difficulty. These pay back fastest because you are not starting from zero.