Skip to content

Blog Content Audit Tool

Before you write more blog posts, it helps to know which existing posts may still deserve attention. This free blog content audit tool combines WordPress, crawl and search data to help you find posts that may need refreshing, improving, merging, pruning or checking more carefully.

The tool runs in your browser. Your files are not uploaded to this website, sent to me or stored by the plugin. Detailed instructions on getting the right exports are provided below the tool.

Free tool

Blog Content Audit Tool

Create a practical blog review workbook by combining your WordPress blog export with optional crawl and search data. The tool helps you find posts that may need refreshing, merging, improving or checking before you create more content.

Your files are processed in your browser. They are not uploaded to this website, sent to Ben Locker or stored by this plugin.

Use Tools → Export in WordPress and export Posts. This helps the tool identify blog posts, dates, categories and Yoast focus keywords.

Use the Internal tab, filter to HTML, then export as CSV. This adds crawl depth, inlinks, indexability and metadata checks.

In Search Console, open Performance or Performance → Search results, set your date range, choose the Pages tab, then export as CSV.

What the tool helps you find

The workbook gives you a practical blog review shortlist.

It can help identify:

  • Posts with search visibility that may be worth improving
  • Older posts that still attract impressions
  • Posts with weak clicks compared with impressions
  • Posts that may overlap with other posts
  • Posts that may have little internal support
  • WordPress posts not found in a crawl
  • Search Console URLs not found in the crawl

It does not replace a content audit. Rather, it helps you see which posts are worth reviewing first.

What you need

The tool works best with a WordPress export XML.

You can also add:

  • a Screaming Frog Internal HTML CSV
  • a Google Search Console Pages CSV

You do not need all three files to use the tool. However, the more useful data you provide, the more useful the workbook becomes.

How to get your WordPress export

  1. Log in to WordPress.
  2. Go to Tools → Export.
  3. Choose Posts.
  4. Click Download Export File.
  5. Upload the XML file into the WordPress field above.

The WordPress export helps the tool understand which URLs are blog posts. It also gives the tool useful information such as titles, dates, categories, slugs and post content.

How to get your Screaming Frog export

This step is optional, but useful.

  1. Download and open Screaming Frog SEO Spider.
  2. Make sure it is in Spider mode.
  3. Enter your website homepage URL, using the correct https:// version.
  4. Click Start.
  5. Wait for the crawl to finish.
  6. Click the Internal tab.
  7. Use the filter dropdown and choose HTML.
  8. Click Export.
  9. Save the file as a CSV.

Upload that file into the Screaming Frog field above.

The crawl export helps the tool check whether posts are indexable, how deep they are in the site, how many internal links point to them, and whether basic page elements are missing or weak.

How to get your Google Search Console export

This step is optional, but useful.

  1. Open Google Search Console.
  2. Choose the correct property for your site.
  3. Find the main performance report. Depending on your account, this may appear as:
    • Performance in the left-hand menu, or
    • Performance → Search results.
  4. Set the date range.
  5. For a recent blog review, 3 months is often useful. For a fuller view of older posts, use 16 months.
  6. Click the Pages tab below the chart.
  7. Click Export in the top-right corner.
  8. Choose CSV.
  9. If Google gives you a ZIP file, unzip it.
  10. Upload the Pages CSV into the Search Console field above.

Search Console helps the tool see which posts Google has shown in search results, which posts have earned clicks, and which old URLs may still have search visibility.

What the workbook gives you

The exported workbook includes:

  • A review shortlist
  • Possible refresh candidates
  • Possible overlap between posts
  • Low-support posts from crawl data, if supplied
  • Possible low blog-link support from WordPress content
  • Posts with search visibility
  • WordPress posts not found in the crawl
  • Search Console URLs not found in the crawl
  • Raw source-data sheets
  • Notes on how to use the findings

The most useful sheet is the review shortlist. Start there.

A note on possible overlap

The tool can flag posts that may overlap. It does not prove keyword cannibalisation.

Two posts can look similar because they cover the same broad subject. That does not always mean one should be deleted or merged.

Treat the overlap sheet as a prompt for review, not a verdict.

What to do next

Once you have the workbook, look for patterns.

  • Do you have old posts that still get impressions?
  • Do you have useful posts buried too deep in the site?
  • Do several posts cover the same subject without a clear reason?
  • Are there posts with search visibility but weak clicks?
  • Are important posts missing internal links?

Those are the places to start.

Need help interpreting the workbook?

If the tool gives you a long review list, that is not a failure. It means your blog has history.

The harder part is deciding what to do next: refresh, merge, redirect, remove, rewrite or leave alone.

A content audit can help turn the workbook into practical decisions.

Talk to me about a content audit