Most keyword lists fail in the same way: they are a pile of phrases with numbers next to them and no decision attached. The useful version sorts phrases by what the person wants, because that decides what the page must contain.
The four things people want
Learning or browsing. "how does pour over coffee work". They want an explanation. A product page will lose here, whatever you do to it.
Comparing. "chemex vs v60", "best pour over kettle". They are choosing between options. Comparison tables, honest pros and cons, and clear recommendations win.
Buying. "buy chemex tunisia", "pour over kit price". They are ready. Price, availability, delivery and a visible buy button matter more than prose.
Going to a specific place. "acme login". They know where they are going. Only the owner of that destination ranks, and trying to compete is wasted effort.
A fifth one matters if you serve a place: nearby. "coffee shop near me" needs a local page with an address, opening hours and a map.
Building the list
Start with one seed phrase that describes what you sell or explain. Then expand it in the ways people actually type:
- Questions: how, what, why, when, which, can
- Comparisons: vs, versus, alternative, or
- Buying words: price, cost, cheap, buy, best, review
- Qualifiers: for beginners, without a machine, near me, in Tunisia
Google's own autocomplete is the best free source: it shows what people type, in any language and country. Rankwell's keyword tool runs that expansion for you, about 38 lookups per topic, then labels each idea with the intent above and groups them into sub-topics.
Grouping into pages
A list of 300 phrases is not 300 pages. Group phrases that want the same answer:
- "pour over ratio", "pour over coffee ratio grams", "pour over ratio calculator" → one page about ratios.
- "chemex vs v60", "v60 or chemex for beginners" → one comparison page.
One page per idea, covering the variations naturally in the headings and text. Several thin pages competing for the same idea split your own traffic, and search engines pick one at random.
Deciding the order
For each group, ask three questions:
- Can we answer it better than what already ranks? Open the current results. If the top pages are thorough and yours would be thinner, pick another group.
- Does it lead anywhere? A guide with no path to what you sell is fine occasionally, not as a strategy.
- Is anyone actually searching for it? If Google's autocomplete suggests nothing around the phrase, few people type it.
Start with the groups where you can win and that lead somewhere. That is usually a mix of comparison and "ready to buy" phrases, with learning topics supporting them.
Volumes, and how to live without them
Exact monthly volumes come from Google Ads, and without ad spend they arrive as ranges like "1K–10K". Useful, not essential. What you can get free:
- How often a phrase appears across many autocomplete lookups, which shows what is commonly typed.
- Whether interest in the topic is rising or falling, from Wikipedia pageviews for the subject.
- What a country is searching for today, from Google Trends.
Rankwell shows all three. When you later connect Google Search Console, you get the real numbers for your own site: the searches that already bring you visitors, and where you sit for them.
Then write for the intent
The research decides the shape of the page: an explanation, a comparison, or a product page. Writing a 2,000-word essay for a phrase where people want a price is the most common way to waste a good keyword. Writing pages that answer the search covers that step.