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.

Run this on your file Download the template CSV

Before you run it: Replace Example Wine with your brand and the topic options with your site's own sections. You can edit every question in the runner.

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
`query`	The search query from the Performance report
`page`	The URL that ranked for the query
`clicks`	Clicks in the period
`impressions`	Impressions in the period
`position`	Average position

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 query 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
`branded`Yes or no	Does the query contain the brand name Example Wine, or a misspelling of it?	yes The query contains the brand name or a misspelling of it no The query does not mention the brand
`topic`Pick one	Which topic of the site is the query about?	red wine Red wines, grapes or regions known for red white wine White wines, grapes or regions known for white natural wine Natural, organic, biodynamic or low-intervention wine wine club Subscriptions, clubs or monthly boxes other None of the topics above
`buying_stage`Scale	How close to a purchase is the person searching this query?	learning wants information about the subject comparing wants options, reviews or prices ready to buy names a product or service to get, or says buy, order or subscribe Lowest to highest
`page_fits`Yes or no	Judging from the page URL, does the ranking page cover what the query asks for?	yes The URL points to a page about the query's subject no The URL points to a page about something else
`ai_answerable`Yes or no	Could a chat assistant answer this query in full, so the person has no reason to visit a site?	yes A short written answer settles the query no The person needs a site: to buy, browse, use a tool or read a long source

Example row

Column	Value
`query`	natural wine subscription
`page`	https://example.com/pages/wine-club
`clicks`	42
`impressions`	1810
`position`	6.3

Answers from a test run on this row

Column	Answer	Confidence
`intent`	transactional	98%
`branded`	no	96%
`topic`	natural wine	76%
`buying_stage`	ready to buy: names a product or service to get, or says buy, order or subscribe	80%
`page_fits`	Unsure	71%
`ai_answerable`	no	90%

More marketing use cases

Use case	What it does	New columns
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`
Keyword research list	Decide which page type each keyword needs before you plan content.	`intent` `page_type` `local` `question`