glossary

Content Inventory Template, Tools and Examples

A content inventory lists every URL on your site with its traffic and status. Copy the free template, pick the tools, and see a worked example.

updated:

A content inventory is a structured catalog of every URL on your site (title, type, owner, dates, traffic, and status) assembled in one place so you can see what you actually have before you decide what to do with it. In SEO, it is the raw dataset every serious content project runs on: migrations, redesigns, pruning, and refreshes all start here. The practice comes from UX and content strategy, where the inventory is the first step of information architecture work; SEO adds search data to every row. We never start an SEO content audit without one, because you can’t fix a site you haven’t fully mapped.

Content Inventory

A content inventory is a complete, itemized list of all content assets on a website (pages, posts, PDFs, media) capturing identifiers and attributes (URL, title, type, author, last-modified date, status, word count, traffic) so the content can be managed, migrated, or optimized.

Why a Content Inventory Comes First

Most teams skip the inventory and jump straight to opinions: “this post feels old,” “we should add a landing page.” That’s how you end up with 1,400 indexed URLs, no idea which earn traffic, and three pages fighting over the same query. An inventory replaces vibes with a dataset.

The point is leverage. Once every URL sits in one sheet next to its traffic, last-updated date, and indexation status, decisions get fast and obvious. You can see thin content at a glance, spot orphaned content with zero internal links, and, on large sites, find the dead weight eating your crawl budget.

What a good inventory buys you:

  • Visibility. Every asset surfaces, including the forgotten 2019 pages no one remembers publishing.
  • Prioritization. High-traffic pages, duplicates, and zombie URLs separate themselves once the data is side by side.
  • Migration safety. It becomes the single source of truth for redesigns and CMS moves, so nothing gets lost and every redirect is planned in advance.
  • SEO triage. Missing metadata, redirect chains, and unindexed pages become a punch list you can work through.
  • Governance. Ownership, status, and editorial workflow get written down where the whole team can see them.

No dashboard theater here: an inventory is just a clean spreadsheet (or database) that turns “the site feels messy” into a list of URLs you can actually act on.

Content Inventory vs. SEO Content Audit

These two get used interchangeably, and that confusion costs teams real time. The inventory is the what. The audit is the so what. You build the inventory first (objective, exhaustive), then layer the audit’s judgment on top. A content audit without an inventory underneath it is just guesswork with a deck.

DimensionContent InventoryContent Audit
NatureObjective snapshotQualitative judgment
QuestionWhat do we have?What should we do about it?
OutputSpreadsheet of every URL + attributesScorecards, gap analysis, action plan
Who runs itContent manager, dev, analystSEO, content strategist, UX, stakeholders
WhenFirst step of any content projectAfter the inventory, when you need decisions
ToolsCrawler, CMS export, GSC, analyticsInventory data + criteria + business context

Inventory = what you have. Audit = what you should do about it. They run in sequence: build the list, then bring opinions.

An SEO content audit is that second step with search data as the judge. For each URL in the inventory, it asks four questions: does the page earn clicks or impressions, does it have backlinks, does it match the intent of the query it targets, and is another page on the site competing for the same query? The answers become the status tags in step 5 below.

How to Build a Content Inventory

You don’t need exotic tooling. A crawler, your analytics, Search Console, and a spreadsheet will carry most of this. Here’s the workflow we use.

1. Define scope

Decide what you’re inventorying: the whole site, just /blog/, product pages, a single content type, or a date range. Scope keeps the project finishable. A 50-page site is one afternoon. A 20,000-URL ecommerce catalog needs sampling and a database, because a spreadsheet that size gets slow to filter and easy to break.

2. Export every URL in scope

Pull URLs from multiple sources and reconcile them, because no single source is complete:

  • Crawler (Screaming Frog, Sitebulb) for what’s linked and reachable.
  • XML sitemap for what you think should be indexed.
  • Google Search Console for what’s actually getting impressions. The export in the Search Console interface stops at 1,000 rows, so on a bigger site pull pages through the API (up to 25,000 rows per request) or the BigQuery bulk export.
  • CMS export for everything, including unlinked drafts and old pages.

The gaps between these lists are themselves findings: sitemap URLs the crawler never reached are often orphaned content.

3. Capture the baseline fields

For each URL, record the descriptive data. At minimum:

FieldSourceWhy it matters
URLCrawl / sitemapThe primary key
Page titleCrawlDuplicate/missing titles surface fast
Meta descriptionCrawlSpot blanks and stale copy
Content type / templateCMS / crawlGroup by post, LP, doc, product
Author / ownerCMSAssigns accountability
Publish + last-updated dateCMSReveals stale, never-refreshed pages
Word countCrawlFlags thin content candidates
Indexation statusGSCFind pages Google ignores

4. Layer in performance data

The inventory becomes a decision tool the moment you bolt metrics onto each row:

  • Traffic: sessions and users (GA4).
  • Search: clicks, impressions, average position (Search Console); backlinks and referring domains (Ahrefs/Semrush).
  • Engagement: average engagement time and engaged sessions (GA4).
  • Conversions: form fills, key events, revenue.

Use 12 to 16 months of search data where you have it, so seasonal pages don’t get cut for a quiet quarter.

5. Tag a status per URL

Now you can make calls. Tag every row Keep / Update / Consolidate / Remove:

  1. Keep: performs well, factually current, leave it.
  2. Update: high potential, stale or under-optimized; queue a content refresh.
  3. Consolidate: multiple pages cannibalizing one query; merge and 301 to the strongest URL.
  4. Remove: thin, dead, or duplicate, with no clicks and no backlinks. Redirect it only when another page covers the same thing. Google can treat a redirect to a loosely related page (often the homepage or a hub) as a soft 404, so otherwise return a 404 or 410 and clean up any internal links to the 404s.

This is also where you catch a duplicate without user-selected canonical: pages Google clustered and chose a canonical for, against your intent.

Content Inventory Template

Copy this into Sheets or Airtable. One row per URL, one tab per content type if the site is large:

URL,Title,Meta Description,Type,Owner,Published,Last Updated,Word Count,Indexed,Clicks,Impressions,Avg Position,Sessions,Conversions,Backlinks,Status,Action,Notes
/blog/example/,Example Post,An example meta...,Blog,Maya,2022-03-04,2024-11-01,1240,Yes,310,8800,7.4,290,4,12,Update,Refresh stats + add internal links,Outdated 2022 data
/services/pseo/,PSEO Services,Programmatic SEO done right,Landing,Sam,2025-01-10,2026-05-02,890,Yes,540,15200,3.1,610,9,28,Keep,-,Top performer

The columns that earn their keep are Last Updated, Indexed, Avg Position, and Action; that quartet drives almost every refresh, prune, and consolidation decision. Everything else is supporting context.

Content Inventory Example

Here is what the decision columns look like on a filled-in website content inventory. The rows are illustrative, with search data over 12 months:

URLClicksBacklinksLast updatedStatusWhy
/pricing/4,210182026-08KeepEarns, current, converts
/blog/seo-checklist-2023/96072023-02UpdateDemand is real, the page is stale
/blog/what-is-seo/ and /blog/seo-basics/140 and 952 and 02021-05ConsolidateTwo pages, one query; merge into the stronger URL
/news/office-move-2019/002019-11RemoveNo clicks, no links, no purpose; return a 410
/tag/marketing-tips/30n/aRemoveThin archive page; noindex or drop it

Every verdict comes from the row’s own numbers, which is what makes the decisions defensible when someone asks why their favorite post is gone.

Content Inventory Tools

Which SEO tools are best for building a content inventory? The ones that fill different columns, used together:

ToolWhat it adds to the inventoryCost
Screaming Frog SEO SpiderURLs, titles, meta, headings, word count, status codes, canonicalsFree up to 500 URLs, paid license above
SitebulbThe same crawl data, with prioritized issue hintsPaid
Google Search ConsoleClicks, impressions, position, indexing statusFree
GA4Sessions, engagement, key eventsFree
Ahrefs or SemrushBacklinks and referring domains per URL, estimated trafficPaid (Ahrefs Webmaster Tools is free for sites you verify)
Your CMS exportEvery page, including unlinked ones, with authors and datesFree
Sheets, Airtable or a databaseThe inventory itself, joined on URLFree to paid

Dedicated content inventory software exists, mostly as part of content management and governance platforms. For an SEO project, a crawler plus Search Console joined on URL in a spreadsheet does the job, and you keep full control of the data.

Using the Inventory for a Migration

A migration is where an inventory stops being nice to have. The outline we run, and the one most migration decks should follow:

  1. Inventory every URL from the crawl, sitemap, Search Console and CMS, reconciled into one list.
  2. Attach the evidence per URL: GA4 sessions and key events, Search Console clicks and impressions, and backlinks.
  3. Decide per URL: keep and move, rebuild, merge, or retire.
  4. Map every old URL that stays or merges to its new URL. That map becomes the redirect file.
  5. Check on launch day that every mapped URL resolves, then watch Search Console and the 404 log for the next 90 days.

Our website migration SEO checklist covers each phase in detail. Once the inventory tells you how many pages are worth keeping, the free migration cost calculator turns that count into a budget range.

Where the Inventory Plugs In

A live inventory is infrastructure. Use it to enforce a clean SEO site structure, map orphans back into your topic clusters, and route internal links toward your pillar pages. Content inventory management means keeping that sheet current as pages are added, merged and retired, so the next decision starts from today’s site.

When a Content Inventory Becomes a Business Problem

Under a few hundred URLs, the template above and an afternoon get you there, and you don’t need us.

It turns into paid work when the inventory has to carry a decision with money on it. A migration is the usual one: every row becomes a line in the redirect map, and a URL missing from the sheet is a page that 404s on launch day. Pruning is the other: thousands of URLs, a Search Console export that stops at 1,000 rows, and nobody sure which pages earn.

On a website migration, we build the inventory from per-URL clicks and backlinks, decide keep, rebuild, merge or cut, and turn the result into the redirect map. On the Prawomat rebuild, that took 2,646 WordPress URLs down to about 1,370, each judged on its own clicks and backlinks.

Frequently Asked Questions

What is a content inventory in SEO?

A content inventory is a complete list of every URL on your site with its attributes (title, type, owner, dates, word count, indexation status) and its search performance (clicks, impressions, position, backlinks). It is the dataset you make SEO decisions from: what to keep, update, merge or remove.

What is the difference between a content inventory and a content audit?

A content inventory is an objective, complete list of every URL on your site and its attributes: the raw dataset. A content audit applies judgment to that dataset, scoring pages on quality, performance, and relevance to decide what to keep, update, merge, or remove. You build the inventory first, then audit it.

What should a content inventory include?

At minimum: URL, page title, meta description, content type, owner, publish date, last-updated date, word count, and indexation status. Add performance data (clicks, impressions, average position, sessions, conversions, and backlinks) to turn the inventory from a descriptive list into a tool you can actually make pruning and refresh decisions from.

How often should I update my content inventory?

Keep it as a living document. For high-velocity sites publishing weekly, refresh the inventory quarterly. For slower sites, twice a year is enough, with a full rebuild before any migration, redesign, or major pruning project. Stale inventories produce stale decisions.

Which SEO tools are best for building a content inventory?

A crawler (Screaming Frog or Sitebulb), Google Search Console, GA4, and a backlink tool (Ahrefs or Semrush), joined on URL in Google Sheets or Airtable. Screaming Frog’s free version covers sites up to 500 URLs. For very large sites (tens of thousands of URLs), move the data into a database, where it stays fast to filter.

Can a content inventory help with AI Overviews?

Indirectly. AI Overviews cite pages that answer a question clearly, and a site full of thin near-duplicates gives them fewer such pages to choose from. An inventory shows exactly which pages to consolidate, refresh, or remove, so the pages left standing are the ones worth citing.

where we come in

Migrating or pruning, with no clean list of what the site has?

We move sites to a new platform, domain or structure without losing rankings: URL mapping, redirects, launch checks and 90 days of watching the numbers.

2.9x

Prawomat: Daily Google clicks; 1.3x on the same dates in 2025

read the case study →

or ask a founder

30 min · intro, founder-to-founder

Book a call