A keyword list is not yet a content plan. Before writing, connect each query to a reader problem, a suitable page and an action that helps the reader. A small shortlist with recorded evidence is easier to execute than hundreds of terms chosen only because a tool assigns them a low difficulty score.
Download the blank keyword shortlist worksheet . This is a planning template; its fields contain no traffic forecasts or invented results.
Disclosure: Our related keyword research guide contains an affiliate link. This worksheet does not require a paid tool or a subscription purchase.
Cover: original AI-generated editorial illustration; not a screenshot of tool results.
Choose the audience before the query
Start with a specific service or project type. A freelance writer looking for clients and a business hiring a writer can use similar vocabulary while wanting different pages. Write the intended audience, country and language at the top of the worksheet.
Record the scope of every tool estimate. A global result is not evidence of demand in one country. If a tool returns no usable estimate, enter unknown rather than converting missing data into a claim that nobody searches for the topic.
Inspect what the searcher is trying to do
Read the current results for the candidate query in the intended market. Note the page types: guides, comparison pages, product pages, service directories or job listings. Then describe the task the reader appears to want completed.
Treat that description as an interpretation of the observed results, not a permanent fact. A query that mostly returns hiring marketplaces may require a service page rather than another software tutorial. If the evidence is mixed, record the uncertainty and investigate before creating a page.
Check the pages you already have
Search your own content inventory for the same problem. Record the existing URL and decide whether to update it, combine overlapping material, create a distinct resource or defer the candidate.
A new page needs a clear reason to exist. A downloadable checklist can serve a different task from a product review, but changing a few words in the title does not establish a new reader need. Keep one principal answer for each intent wherever practical.
Decide what evidence the page can add
List the sources, examples or original resources you can supply. If you have not used a product, describe its documented features and the questions a buyer should evaluate. Do not invent a benchmark or a numerical review score to make the page look more complete.
For a commercial topic, record the offer’s availability and the referral link actually issued to your account. A public affiliate program page does not prove that your account has been accepted. Leave the field blank when the relationship is not established.
Before buying a research subscription, use the freelance tool cost worksheet to record the payment commitment and the projects that would actually use it. A keyword estimate alone does not establish that the subscription will pay for itself.
Give the reader one useful next step
The primary action should follow from the page’s purpose. A planning guide might offer a worksheet; a buying checklist might help the reader inspect a current plan. Specify the action before writing the CTA so the page does not end with a generic sales pitch.
Use internal links to connect the resource to the next relevant decision. Our keyword research workflow explains the broader process; this worksheet records the decisions you make for individual queries.
Measure the shortlist after implementation
Save the publication or update date and use explicit date ranges when reading results. Record Search Console impressions and clicks separately from Analytics sessions and actions. Affiliate dashboard clicks, conversions, approved commission and cash received belong in separate fields as well.
Avoid treating a click as a sale or an estimated commission as money received. With a small sample, describe what happened and what remains unknown. Keep targets in the plan, measured values in the evidence log and assumptions beside any forecast.
The final shortlist should tell you what to work on next and why. Revisit it when search results, available offers or your own page performance change; do not keep publishing near-duplicate pages simply to satisfy an article count.