KEYWORD RESEARCH WORKSHEET FOR SEO

Guide: https://qreativa.com/guides/keyword-research/

HOW TO OPEN THE FILES

Import the CSV into your spreadsheet using UTF-8 encoding and a semicolon delimiter. Fields are enclosed in quotation marks. Set the columns to text to preserve queries, URLs, and ranges without automatic conversion. The blank template contains headers only; add as many rows as you need.

Use one row per query. Several rows can belong to the same group and share a destination URL. Group by destination to identify the work needed: two variants of the same need do not require two pages.

THE EXAMPLE FILE

The seven rows describe a fictional company that sells and installs new vinyl and aluminum windows in Denver. It does not sell used windows or install window screens. Business sources, queries, content, and result formats are simulated. No search result URL, observation date, or volume is presented as measured. Page paths are illustrative and are not Qreativa pages.

KW01 and KW02 belong to one task. Together with KW03 and KW04, they produce three tasks across three URLs: two updates and one new page. KW05 and KW06 are excluded; KW07 still needs verification. Volumes and collection dates are blank because they were not measured. Do not change a status from "simulated" to "verified" for your site without performing the actual checks.

FIELDS, IN CSV ORDER

id: A unique row identifier, such as KW01.
data_type: Use "real" for your own research or "simulated" for a teaching example. Also identify an unobserved suggestion as a hypothesis in its source.
query: The search phrase to examine, kept in the wording you collected.
query_source: Search Console, customer question, internal site search, search suggestion, keyword tool, competitor page, or hypothesis.
source_reference: Export filename, reference to an anonymized question, page URL, or the starting term used to find suggestions. Do not include personal information.
collection_date: The actual date you checked the query and results, in YYYY-MM-DD format. If you use an earlier export, record its date in the source reference.
market_language: Country, location where relevant, and audience language. For quantitative measurements, also preserve filters in the original export.
device: Desktop, mobile, all if the data combines devices, or "not recorded".
task: What the person wants to do or decide. Use a concrete description instead of a generic label.
intent: A category you can filter by, such as informational, commercial comparison, local commercial, transactional, navigational, or mixed.
serp_format: Page types in the results, such as service pages, categories, products, guides, or comparisons. Note maps, ads, and other features separately. Use "not checked" until you have reviewed the results.
serp_evidence: URLs you actually opened, with a note on the answer they provide. Separate multiple references with a vertical bar. Do not invent URLs.
group: A shared name for queries that need the same answer. Use it to identify variants and duplication in the list.
existing_url: A current URL you reviewed on your site, or "none". A candidate page does not automatically become the chosen destination. If there are several candidates, separate them with a vertical bar and explain the conflict in the reason field.
destination_url: The existing or proposed URL assigned to the group. Use full URLs for actual research. Leave blank for excluded queries and pending assignments.
decision: Create, update, keep, or exclude. Leave blank when verification is incomplete. "Exclude" removes the query from consideration; it does not call for deleting a page.
reason: The observation that supports the decision or explains the uncertainty. For an update, specify what the page lacks.
verification_status: Use "verified" after performing the checks, "needs verification" when essential evidence is missing, and "simulated" only for example decisions.
next_check: The specific check or material still needed. This can record a requirement before writing even when the destination assignment has been verified.
monthly_volume: The value or range returned by your chosen source. Leave blank if unavailable. Do not substitute Search Console impressions or a Google Trends index.
volume_source: The tool, market, and network the value refers to. Write "unavailable" if it is missing. Record the source even when the value is zero.
volume_period: The period covered by the volume figure, such as the start and end dates of the export. Leave blank when no data is available.

WORKING ORDER

Collect queries and sources. Exclude requests outside the offering and explain why. For the remaining queries, read the results, describe the task, and compare existing pages. Group variants, assign a destination, and record the decision and reason. If the choice depends on missing evidence, leave it pending.

Before moving rows into a content plan, filter for verified entries and group them by URL. Keep excluded queries and outstanding checks separately. Revisit assignments when the offering changes or new relevant questions emerge.