A keyword-tool export is a list, not a content plan. It can contain duplicates, spelling variants, reversed word order and many phrases for the same task. Turning every row into a URL creates overlapping pages instead of useful coverage.
Keyword research and clustering should produce a map of needs, evidence and page owners. Use the English cluster worksheet to preserve decisions and unknowns.
Clean the list without losing its meaning
Remove blank lines and exact duplicates. Normalise superficial punctuation and casing while retaining the original wording where it helps interpretation. Review word-order variants rather than assuming every similar phrase is equivalent.
Set aside unrelated markets, languages and topics outside the offer. Record what was removed and why. Low or unknown volume alone is not a reason to discard a genuine user task.
Gather evidence before grouping
For each term, describe the reader's task and inspect results in the intended language and market. Record date, relevant settings, a consistent result sample, page types and notable result features.
Terms belong together when they share both a reader task and sufficiently similar result-page evidence. Shared words alone are inadequate: a DIY repair guide and a repair-service enquiry may need different owners.
Use search intent analysis to make the task clearer before drawing page boundaries. Keep mixed or uncertain cases visible.
Name clusters after needs
Use a plain label such as “request installation” or “choose a model”. Select one primary phrase that clearly expresses the task and supporting phrases for related questions. These are writing priorities, not instructions to repeat every keyword.
Each cluster should have an existing or proposed owner, its evidence, overlap decision and next action. An existing page may need a better section rather than a competing new URL.
When to merge and when to split
Merge variants when they share a task and result pattern. A price question may belong in the same service decision rather than create another thin page.
Split when the task or required page form is materially different and evidence supports it. Do not split merely because a tool reports separate volumes. Conversely, do not merge genuinely different needs because they share a noun.
Keep missing demand metrics unknown
Unknown volume remains unknown. Label country, language, source and collection date for measured values. A broader category's volume is not the exact long tail's volume, and search frequency is not customer conversion.
Fictional example: robotic mower services
Imagine a list with fourteen rows. Four are duplicate or blank, leaving ten terms. In an illustrative assessment, three concern installation, three maintenance and repair, three choosing a model and one buying a machine directly.
The imagined company installs and maintains mowers but does not sell standalone machines. It improves its installation and maintenance owners, considers one useful comparison page and declines a standalone shop page. An ambiguous repair term stays under review rather than automatically becoming another route.
Four clusters of three, three, three and one account for all ten terms. The arithmetic explains the example's structure; its queries, result counts and decisions are invented, not research findings or forecasts.
Maintain the page map
| Field | Purpose |
|---|---|
| Query and task | Preserve wording and the reader's actual need |
| Evidence | Result observations, date and applicable market |
| Cluster and phrase role | Primary or supporting terminology |
| Page owner | Existing route or a justified proposed route |
| Decision | Improve, create, merge, investigate or decline |
| Unknowns | Missing or uncertain facts that affect the decision |
| Owner and next action | Responsibility for review and delivery |
Resolve uncertainty before building. Revisit the map when results, audience or offering change. For a new website, carry the ownership choices into the website brief so content structure and project scope address the same visitors.
See SEO services if you want the evidence reviewed or research undertaken. A completed worksheet remains a planning document, not proof of rankings, traffic or a service contract.