A blog content inventory is a structured list of the articles, pages, and other content published on your website. Even a basic spreadsheet can reveal outdated posts, duplicate topics, missing information, and useful opportunities for future content.
What a Blog Content Inventory Includes
A content inventory is primarily an objective record of what exists. It is different from a content audit, which evaluates quality, performance, and strategic value. You can perform both tasks in sequence: first document your content, then decide what to keep, improve, combine, or remove.
For a simple blog inventory, record one row per published article. Useful fields include:
- Page title
- URL
- Content type
- Primary topic or keyword
- Publication date
- Last updated date
- Author
- Category and tags
- Status
- Organic traffic or page views
- Search ranking, if available
- Backlinks or referring domains
- Conversion goal
- Recommended action
- Notes
You do not need every possible field on the first day. Start with information that helps you make decisions. A small, accurate inventory is more valuable than a complicated spreadsheet nobody maintains.
Choose a Tool and Define the Scope
A spreadsheet is usually the best starting point. Google Sheets works well for teams because several people can edit the same file, while Excel is useful when you prefer local files or more advanced data analysis. Airtable, Notion, or a content management system export can also work, but avoid selecting a tool simply because it has more features.
Create a new sheet and decide what belongs in the inventory. A reasonable first scope might include:
- All published blog posts
- Resource guides and tutorials
- Evergreen landing pages that receive search traffic
- Important category or hub pages
You may exclude author archives, tag archives, search-result pages, privacy pages, and automatically generated URLs. Document these exclusions in a note so someone else understands why the inventory does not match the total number of URLs in your analytics platform.
If your site has thousands of URLs, begin with one blog category, one year of content, or your most important organic landing pages. A staged inventory is easier to complete and review than an enormous project that remains unfinished.
Create the Spreadsheet Structure
Set up the basic columns before collecting data. Keep the first version focused and add fields only when they support a real decision. The following structure is compact enough for a small blog but detailed enough for useful planning:
| Field | What to record | Why it matters |
|---|---|---|
| Title | Current page title | Identifies the content quickly |
| URL | Canonical page address | Prevents duplicate or missing records |
| Type | Guide, review, news, tutorial, or other | Helps compare similar content |
| Topic | Main subject or search intent | Reveals coverage and gaps |
| Published | Original publication date | Shows content age |
| Updated | Most recent substantial update | Flags stale articles |
| Traffic | Visits for a chosen period | Helps prioritize work |
| Status | Keep, update, merge, redirect, or remove | Turns data into action |
Use one consistent date format, such as YYYY-MM-DD. Decide whether traffic means sessions, users, page views, or organic clicks, and write that definition in the sheet. Mixing metrics makes comparisons unreliable.
Add a separate “Lists” or “Instructions” tab if several people will edit the inventory. Define approved values for fields such as content type, status, category, and search intent. Data validation dropdowns can prevent variations such as “Update,” “update,” and “Refresh” from being treated as different statuses.
Collect URLs from Your Website
The most reliable inventory combines several sources. No single source is guaranteed to include every useful page.
Start with your content management system. In WordPress, the Posts screen can provide titles, dates, authors, categories, and links. Export tools or plugins may produce a CSV. Other platforms often include a content export in their settings or reporting area.
Next, check your XML sitemap. A sitemap is useful for finding published URLs, especially when older posts are not linked prominently from the current navigation. Copy the URLs into the spreadsheet, then remove duplicates.
Use Google Search Console or another search-performance platform to find pages that received impressions or clicks. This can reveal articles missing from your CMS export, URLs with traffic that you did not know about, and old pages that still attract searches.
Your analytics platform can provide another useful list. Export landing pages for a defined period, such as the previous 12 months. Keep the date range consistent across the project. If a URL appears in analytics but not in your CMS list, investigate it rather than deleting it automatically; it may be an old URL, a campaign page, or a tracking variation.
For a small site, you can collect URLs manually by browsing the blog archive and categories. This is slower but practical when there are fewer than 100 articles. If you use a crawler, configure it to follow canonical URLs and distinguish internal redirects, broken links, and blocked pages.
Normalize and Clean the Data
Before evaluating content, make the inventory consistent. Cleaning prevents simple formatting differences from producing false duplicates.
Check each URL for:
- HTTP versus HTTPS
- A trailing slash versus no trailing slash
- Uppercase characters
- Tracking parameters such as
utm_source - Duplicate URLs caused by pagination or printer versions
- Redirected URLs
- Canonical URLs that point somewhere else
Keep the final canonical URL in the main URL column. If an old address redirects to it, record the old address in a separate “Redirect or alias” column when that history matters.
Standardize titles by copying the current page title from the site rather than relying only on an old export. Remove accidental leading spaces and check for duplicate titles. Two articles with nearly identical titles may target the same search intent, but that is a judgment to make later, not proof that one should be deleted.
Use filters to find blank fields, duplicate URLs, and inconsistent categories. Spreadsheet formulas can help. For example, a duplicate-check column can flag repeated URLs, while conditional formatting can highlight missing publication dates or articles older than a chosen threshold.
Add Topic and Search Intent
A title alone does not explain what an article is supposed to accomplish. Add a primary topic and search intent to make the inventory strategically useful.
Common intent categories include:
- Informational: the reader wants an explanation or answer
- Commercial investigation: the reader is comparing options
- Transactional: the reader is ready to buy, sign up, or take action
- Navigational: the reader is looking for a particular brand, product, or page
Assign one primary topic per article, even if the article covers related subjects. Use a short, human-readable label such as “email list building” or “beginner gardening,” not a long collection of keywords.
Look for clusters of articles covering the same subject. A cluster may indicate strong topical depth, but it may also contain overlapping pages competing for the same query. Compare the actual purpose, audience, and recommended action of each article. If two posts answer essentially the same question, mark them for a possible merge rather than immediately removing either one.
Also record important topics that have no matching article. These gaps can become future briefs, but validate demand, audience value, and business relevance before adding them to the editorial calendar.
Record Performance and Business Value
Performance data helps you prioritize, but it should not be the only measure of value. A low-traffic article may support a high-value service, answer an important customer question, or attract links that help other pages.
Choose a consistent reporting period, such as the previous 12 months, and record the date range in the sheet. Depending on your tools, include organic clicks, impressions, average position, page views, engaged sessions, conversions, email signups, or assisted revenue.
Add a simple value rating if detailed conversion data is unavailable:
- High: directly supports revenue, leads, subscriptions, or a strategic product
- Medium: builds trust, attracts relevant visitors, or supports internal linking
- Low: has little traffic, weak relevance, or no clear audience purpose
Avoid treating traffic thresholds as universal rules. A niche article may be successful with modest traffic, while a broad article may receive many visits but generate no meaningful action. Evaluate the page against its intended purpose.
Assign an Action to Every Article
The inventory becomes useful when each row has a next action. Keep the action list short and define what each option means.
- Keep: the article is accurate, useful, and performing adequately
- Update: improve facts, examples, structure, media, links, or optimization
- Expand: add missing depth because the topic has strategic potential
- Merge: combine overlapping articles into one stronger resource
- Redirect: send an obsolete or consolidated URL to the most relevant replacement
- Remove: delete content with no useful audience, traffic, links, or business value
- Review: gather more evidence before deciding
Do not automatically delete old articles. First check whether they have backlinks, rankings, conversions, valuable comments, or historical importance. If a page is outdated but still useful, updating it may be safer than starting from scratch.
For merge candidates, choose a primary URL, preserve the strongest sections, update internal links, and create a redirect from the secondary URL when appropriate. Confirm that the replacement genuinely satisfies the visitor’s intent; a poorly matched redirect can create a worse experience than leaving the original page available.
Turn the Inventory into a Work Plan
Sort the sheet by opportunity rather than publication date alone. A practical priority formula considers potential benefit, effort, and risk.
Start with pages that have one or more of these characteristics:
- They already rank near the first page and could improve with a focused update
- They receive impressions but few clicks, suggesting a title or description opportunity
- They generate relevant traffic but have weak calls to action
- They contain outdated information that could mislead readers
- They overlap with another article and create internal competition
- They support an important product, service, or email signup
Add an “Owner,” “Target date,” and “Completed date” column if the inventory will manage ongoing work. Create a separate editorial calendar for detailed briefs and deadlines; the inventory should remain the master record of content, not become an unwieldy project-management system.
A simple monthly workflow might include reviewing newly published URLs, checking pages marked for update, recording performance for the previous period, and adding newly discovered redirects or orphaned pages. Assign one person responsibility for maintaining definitions and preventing duplicate rows.
Troubleshooting Common Problems
If your URL totals do not match, compare the source definitions first. A CMS export may include drafts, while a sitemap may exclude noindex pages. Analytics may contain URL parameters or pages that no longer exist. Save the original exports and document how you filtered them.
If the same article appears several times, compare the canonical URL, not only the title. Parameterized URLs, mobile variants, and redirected addresses can create duplicates. Keep one canonical record and note alternate addresses separately.
If traffic data looks incorrect, confirm the selected date range, property, timezone, filters, and metric. A page with zero recorded traffic may have tracking problems rather than zero visitors.
If editors disagree about a status, use “Review” and write the reason in Notes. For example, record “Low traffic but 12 referring domains; check link value before removal.” A transparent unresolved decision is better than an unsupported guess.
If the spreadsheet becomes too large, archive completed rows only when you can still retrieve them. Use filters, frozen headers, separate tabs, and a stable naming convention. For larger sites, consider a database or content-management platform, but preserve the same core fields so the inventory remains understandable.
Know the Inventory’s Limitations
A content inventory describes your content; it does not automatically tell you whether an article is accurate, persuasive, accessible, or technically optimized. Those questions require a deeper audit, user feedback, analytics analysis, and sometimes manual review.
Performance metrics also reflect external factors such as seasonality, algorithm changes, brand demand, competitors, and tracking quality. Avoid making major deletion decisions from one unusually strong or weak month.
Finally, keep the inventory current. An accurate sheet with fewer fields is better than a detailed sheet that becomes obsolete after one audit. Schedule a lightweight review whenever you publish, substantially update, merge, redirect, or remove an article so the document continues to reflect the real state of your blog.