100% FREE Content Audit Automation Tool
5(100%)1vote

  • Auto pull KW rankings (SEM Rush) and crosswalk with organic traffic data (Google Analytics).
  • Sync GSC for SERP impressions, clicks and KW¬†tracking.
  • Generate powerful organic traffic reports from Google Analytics with a single click.
  • Beautiful reporting layout, fully customizable to your brand using Google Data Studio.

GET THE TOOL, FREE.

We don’t charge for these tools, but we don’t like them on the open web. If you give us your email, we’ll send it to you, free of charge.

Read the detailed guide here.

When your site’s been around for a while, you accumulate pages that no longer add value to your audience. Old, aged and irrelevant content can:

  • Negatively impact your website’s indexation rate
  • Negatively impact your website’s crawl budget
  • Negatively impact your organic traffic
  • Negatively impact your audience’s perception of your brand

Periodically reviewing your website’s content performance can help to alleviate this. To clean it up, you need to undergo a content audit, where you review every page on your site.

We (David Krevitt, CIFL and Ryan Stewart, WEBRIS) put together this Google Sheets template to automate a large portion of the tedious content audit process.

By pulling traffic data from GA (using Supermetrics), and exporting your link data from Ahrefs, you’ll end up with a list of pages to:

  • Leave as is (aka 200)
  • Quality review (QR)
  • Delete (404)
  • Redirect to similar content (301)

Please watch the video to see the template in action, as well as a step by step process how to execute it.

  • Auto pull KW rankings (SEM Rush) and crosswalk with organic traffic data (Google Analytics).
  • Sync GSC for SERP impressions, clicks and KW¬†tracking.
  • Generate powerful organic traffic reports from Google Analytics with a single click.
  • Beautiful reporting layout, fully customizable to your brand using Google Data Studio.

GET THE TOOL, FREE.

We don’t charge for these tools, but we don’t like them on the open web. If you give us your email, we’ll send it to you, free of charge.