The classic keyword research mistake is sorting a spreadsheet by search volume and writing for the top rows. Volume tells you how many people type a phrase; it says nothing about what they want, whether they will ever buy from you, or whether you can realistically rank. Intent, value, and winnability are the columns that matter.
Classify by intent before anything else
- Informational: the searcher wants to learn; content here builds audience and topical authority.
- Commercial investigation: comparisons, alternatives, and best-of lists; the searcher is shortlisting.
- Transactional: ready to act; these pages earn revenue directly.
- Navigational: they want a specific site; usually not worth targeting unless it is yours.
The search results page is your ground truth for intent. If a query returns ten listicles, Google has decided what searchers want, and your product page will not break in regardless of optimization.
Weigh value against winnability
A keyword is worth pursuing when the traffic would plausibly convert and the current results are beatable. Look at who ranks: if the first page is entirely major publishers and you are a new domain, target the longer-tail variants those sites cover only shallowly. Specificity is the smaller site's advantage, since a page precisely answering a narrow question routinely outranks a giant's generic chapter.
Organize into clusters, not a list
Group related queries into topics, one primary page per topic, supporting pages for subtopics, all interlinked. Clusters concentrate authority and match how engines evaluate expertise. Revisit rankings quarterly: queries where you sit on page two are your cheapest wins, because half the work is already done.