Keyword research template and coverage register
Enter keyword observations and page decisions to create an editable research register, keeping measured demand, intent and ownership separate. Your records stay in this browser.
Your coverage worksheet
Row 2: Missing metric; Duplicate observation Row 4: Missing metric; Duplicate observation
Keep observations separate from decisions
This keyword research template puts your saved observations beside your content decisions. It keeps a blank metric blank. An entered zero stays zero.
Paste rows from a spreadsheet in this order: keyword, market, source reference, source date, metric name, metric value, intent, decision, page path, section, owner, review notes.
Use tabs between cells and a new line for each observation. Omit a header row. Keep empty cells between their tabs. The editor accepts up to 500 rows.
Give each metric its own row and name its basis, such as monthly searches or impressions for a stated period. Enter source dates as YYYY-MM-DD. A blank date receives a flag.
A blank metric or the word null receives a Missing metric flag. Neither becomes zero. Intent and page ownership come from your entries. This tool does not collect search demand or infer intent.
Build a coverage worksheet
The opening records are fictional. The linen shirt row has 120 illustrative monthly searches and a primary decision for /linen-shirts/. That figure is invented for this example.
Linen shirts online has a supporting decision for the same page, under Buying options. Its metric is blank. Linen shirt sewing pattern has an excluded decision because the fictional catalogue sells finished clothing.
The fourth row repeats linen shirts online with the same market, source, source date and metric name. Both observations receive Duplicate observation flags. Their notes stay separate.
Duplicate checks ignore surrounding spaces and letter case in those five identity fields. They do not merge records or decide whether similar queries belong on one page.
Enter primary, supporting or excluded in the decision column, or leave it blank while you review. Leave the page path empty when no page owns the query. Record a responsible team in Owner.
Export the research record
Edit the source records on the left to update the worksheet. Copy worksheet includes the column headings and flags. Paste it into a spreadsheet to continue editing.
Download CSV preserves your source references and review notes with the decision and owner columns. CSV cells beginning with a spreadsheet formula marker receive a leading apostrophe for safer opening.
Keep a copy of the source records before closing this page. The tool does not save them automatically. To reuse spreadsheet rows here, paste only the 12 input columns without headings or the Flags column.
Use the keyword research guide in the related reading for collecting evidence and grouping queries. Return here once you have observations and explicit page decisions to record.