If you run a small blog or handle marketing solo, you’ve probably been told to do a content audit. Then you check the recommended tools and see monthly subscriptions costing more than your hosting bill. Frustrating, right?
Here’s the good news: you don’t need expensive software to run a proper content audit. With Google Analytics 4 (GA4), Google Search Console (GSC), and a simple spreadsheet, you can uncover exactly which posts are earning their keep and which ones are dragging your site down.
This guide walks you through a practical 9-step process built specifically for small teams and solo bloggers. Let’s get into it.
What Is a Content Audit (And Why Small Blogs Need One)
A content audit is the process of inventorying every piece of content on your site, measuring how each piece performs, and deciding what to keep, update, merge, or delete. It’s part inventory, part performance review.
For small blogs, audits matter even more than for big brands. Why?
- Google rewards sites with a high ratio of quality content to total content
- Outdated posts can hurt your topical authority
- Thin or duplicate content wastes crawl budget
- Consolidating weak posts often boosts rankings faster than writing new ones
What You Need Before Starting
Grab these free tools before you begin:
- Google Analytics 4 (traffic and engagement data)
- Google Search Console (clicks, impressions, keyword data)
- Google Sheets or Excel (your audit spreadsheet)
- A free sitemap crawler like Screaming Frog (free up to 500 URLs, perfect for small sites)
That’s it. No paid subscriptions required.
How to Do a Content Audit: The 9-Step Process
Step 1: Define Your Goal
Before pulling any data, decide what you want the audit to achieve. A vague goal like “improve the blog” won’t help. Pick one primary objective:
- Increase organic traffic
- Improve conversion rate on existing posts
- Consolidate topical clusters for better rankings
- Clean up outdated or off-brand content
Your goal shapes every decision you’ll make later. If you’re focused on SEO, you’ll weight Search Console data heavily. If you’re focused on conversions, GA4 events matter more. The team at shopify.com reached a similar conclusion.
Step 2: Build Your Content Inventory
Time to list every URL on your site. Use one of these free methods:
- Screaming Frog SEO Spider (free version handles up to 500 URLs)
- Your XML sitemap (usually at yoursite.com/sitemap.xml, copy URLs into a spreadsheet)
- Search Console’s Pages report for indexed URLs
Create a Google Sheet with these columns:
| URL | Title | Publish Date | Word Count | Category | Author |
|---|---|---|---|---|---|
| /blog/example-post | Example Post | 2024-03-12 | 1,850 | SEO | Jane |
Step 3: Pull Performance Data From GA4
In GA4, navigate to Reports > Engagement > Pages and screens. Set your date range to the last 12 months (so from August 2025 to August 2026 if you’re following along right now). kwasi.com goes into the numbers.
Export these metrics for every URL:
- Views
- Active users
- Average engagement time
- Engagement rate
- Conversions (if you have events set up)
Use VLOOKUP or INDEX-MATCH to merge this data into your master inventory sheet.
Step 4: Pull SEO Data From Search Console
In Search Console, go to Performance > Search results. Set the date range to 12 months, then export the Pages tab.
Add these columns to your sheet:
- Clicks
- Impressions
- Average CTR
- Average position
Pro tip: also grab the Queries tab so you know which keywords each page actually ranks for. This is gold when deciding whether to update or merge posts.
Step 5: Score Each Post
Add a Performance Score column. Keep it simple with a 1 to 5 scale, or use tiers:
| Tier | Criteria | Typical Action |
|---|---|---|
| A – Winners | High traffic, high engagement, ranks page 1 | Keep and protect |
| B – Potential | Decent impressions but low CTR or ranks position 5 to 20 | Update and optimize |
| C – Overlapping | Multiple posts targeting similar keywords | Merge |
| D – Dead weight | No traffic, no impressions, no backlinks, outdated | Delete or redirect |
Step 6: Decide the Action for Each Post
Now the fun part. For every URL, pick one action:
Keep
The post ranks well, brings traffic, and still reflects your brand. Leave it alone. Just add a reminder to review it in 6 months.
Update
The post has potential but is underperforming. Common fixes:
- Refresh outdated stats and examples
- Improve the title and meta description for better CTR
- Add missing subtopics based on what’s ranking now
- Add internal links from your Tier A posts
- Update the published date after significant changes
Merge
You have 2 to 4 posts targeting essentially the same keyword. Pick the strongest URL, combine the best content from the others into it, then 301 redirect the weaker URLs to the winner.
Delete
The post gets no traffic, has no backlinks, isn’t relevant anymore, and can’t be salvaged. Delete it and either 301 redirect to a related post or return a proper 410 status if nothing is relevant.
Step 7: Prioritize by Impact
You can’t fix everything at once. Sort your action list by potential impact:
- Quick wins first: posts ranking positions 5 to 15 with good impressions. A refresh can push them to page 1 fast.
- Then merges: consolidating cannibalizing posts often gives large ranking boosts.
- Then deletes: cleaning up dead weight improves overall site quality signals.
- Then deep updates: rewriting older cornerstone posts.
Step 8: Execute and Track Changes
Add a Status column and a Date Actioned column to your sheet. This becomes your workflow tracker.
When you update a post, note what you changed. When you delete or merge, log the redirect. This documentation matters when you’re trying to figure out later why traffic went up or down.
Step 9: Measure Results After 60 to 90 Days
SEO changes take time. Wait at least 2 months, then compare:
- Clicks and impressions in Search Console (page-level)
- Average position for target keywords
- Organic sessions in GA4
- Engagement rate on updated posts
Use what you learn to refine your next audit. Because yes, this should be a recurring process, not a one-off project. For most small blogs, once or twice a year is enough.
Common Content Audit Mistakes to Avoid
- Deleting posts with backlinks. Always check backlinks first. If a page has quality links, redirect it, don’t just delete.
- Refreshing without changing much. Bumping the date without meaningful updates won’t fool Google.
- Auditing too frequently. Give your changes time to breathe before evaluating.
- Ignoring user intent. A post might rank well but attract the wrong audience. Check the queries.
- Auditing everything at once. Start with one category or your top 50 posts.
A Simple Audit Template You Can Copy
Here’s the minimal spreadsheet structure that works for most small blogs:
| Column | Source |
|---|---|
| URL | Sitemap / crawler |
| Title | Crawler |
| Publish Date | CMS |
| Word Count | Crawler |
| Views (12mo) | GA4 |
| Engagement Rate | GA4 |
| Clicks (12mo) | GSC |
| Impressions | GSC |
| Avg Position | GSC |
| Top Query | GSC |
| Tier (A/B/C/D) | You |
| Action | You |
| Notes | You |
| Date Actioned | You |
Final Thoughts
A content audit isn’t glamorous, but it’s one of the highest ROI activities a small blog can do. You already have the content. You already have the data (GA4 and Search Console are free). All you need is a structured process and a few focused hours.
Start with your top 50 posts. Follow the 9 steps. Take action on the quick wins first. In 90 days, you’ll almost certainly see your traffic curve bending in the right direction.
Frequently Asked Questions
How long does a content audit take for a small blog?
For a blog with under 100 posts, expect 6 to 10 hours spread over a week. Larger blogs (500+ posts) may need 20+ hours, so tackle it in batches by category.
How often should I do a content audit?
Once or twice a year for most small blogs. If you publish very frequently (3+ posts per week), consider a light quarterly audit focused only on recent content.
Should I delete old blog posts?
Only if they have zero traffic, zero backlinks, and can’t be improved or merged. When in doubt, redirect to a related post rather than deleting outright. Never delete a post that has valuable backlinks.
Can I do a content audit without paid tools?
Yes. GA4, Search Console, Screaming Frog’s free version, and Google Sheets are all you need for a thorough audit on a small site.
What’s the difference between a content inventory and a content audit?
The inventory is just the list of all your content with basic metadata. The audit is the analysis: reviewing performance and deciding what to do with each piece. The team at yale.edu reached a similar conclusion.
Does updating old posts really work in 2026?
Yes, and arguably better than ever. Google increasingly rewards freshness and topical depth. A well-updated post often outperforms a brand new one because it already has age, authority, and possibly backlinks.
