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.

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
`url`	Page URL
`title`	Page title
`word_count`	Number of words on the page
`last_updated`	Date the page was last edited
`sessions`	Sessions in the last 12 months

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
`format`Pick one	What format is the page, judging from its title and URL?	how-to Teaches how to do something list A list or roundup guide An explainer or long guide on a subject news An announcement or news item product A product, collection or landing page
`funnel_stage`Scale	How close to buying is the reader this page is written for?	learning about the subject comparing options ready to buy Lowest to highest
`recurring`Yes or no	Is the page's subject something that comes back every year, such as a holiday, season or annual event?	yes The subject recurs every year no The subject happens once or has no date
`dated_title`Yes or no	Does the title contain a year, season or event that is now in the past?	yes The title names a past year, season or event no The title names no date

Example row

Column	Value
`url`	https://example.com/blog/best-wines-for-thanksgiving-2022
`title`	Best Wines for Thanksgiving 2022
`word_count`	640
`last_updated`	2022-11-10
`sessions`	95

Answers from a test run on this row

Column	Answer	Confidence
`format`	list	99%
`funnel_stage`	comparing options	80%
`recurring`	yes	95%
`dated_title`	yes	98%

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