Keyword research list

Decide which page type each keyword needs before you plan content.

Run this on your file Download the template CSV

Columns to upload

Name the columns in your CSV like this. Extra columns are fine: every column of the row is sent with the questions.

Column	What it holds
`keyword`	The keyword
`volume`	Monthly search volume

Questions

Each question adds a column to your file. The answer is one of the listed values, or Unsure when the model's confidence is below the cutoff: 70% for pick-one and scale questions, 80% for yes or no.

New column	Question	Possible answers
`intent`Pick one	What does the person searching this keyword want?	informational To learn or understand something commercial To compare products, brands or options before buying transactional To buy, order, subscribe or book now navigational To reach one specific site, brand or page
`page_type`Pick one	Which kind of page would best answer this keyword?	blog post An article that explains or teaches category page A page listing many products of one kind product page A page for one product comparison A page comparing two or more named options tool A calculator, quiz or other interactive tool
`local`Yes or no	Does the keyword ask for something near a place, or name a city or region to shop in?	yes It names a place or says near me no It names no place to shop in
`question`Yes or no	Is the keyword phrased as a question?	yes It is a question, or starts with how, what, why, which, when, can or is no It is not a question

Example row

Column	Value
`keyword`	orange wine vs rosé
`volume`	1900

Answers from a test run on this row

Column	Answer	Confidence
`intent`	informational	96%
`page_type`	comparison	100%
`local`	no	98%
`question`	no	92%

More marketing use cases

Use case	What it does	New columns
Google Search Console queries	Sort the search queries that bring people to your site by intent, topic and buying stage, and flag pages that do not answer the query.	`intent` `branded` `topic` `buying_stage` `page_fits` `ai_answerable`
Google Ads search terms	Find the search terms that spend money without buying intent, so you can add them as negative keywords.	`relevance` `intent` `competitor` `add_negative`
Ad copy review	Check a batch of ad headlines and descriptions for the claim they make, how specific they are, and wording ad platforms often reject.	`claim` `specific` `has_number` `unproven_superlative`
Social media comments	Sort comments on your Instagram, Facebook or TikTok posts so the ones that need a reply get one first.	`type` `sentiment` `needs_reply`
Blog and content inventory	Label every page of a content audit by format and funnel stage, and flag dated titles on subjects that come back every year, so you can update them.	`format` `funnel_stage` `recurring` `dated_title`