Content audit template: what to do with every article you already have

Free content audit spreadsheet in Excel: paste in your Search Console data and know which articles to improve, merge or leave, and why.

The template's “Example” tab, filled in with a labor consultancy case study.

The template in numbers

7 possible decisions per article
1.000 pages fit, which is what Search Console exports
0 formulas you need to edit
Leave us these three details and the download will appear right here, instantly.
Name *
Business email *
Company *

What the content audit template includes

For blogs that already have articles and don't know which ones are working and which ones are getting in the way.

Fill it in by pasting

The columns follow the order of the Search Console Pages report: copy and paste.

One decision per article

Improve, rewrite the title and description, add a call to action, merge, or leave as is, with the reason next to it.

Flags cannibalization

If two articles compete for the same search query, it indicates which one to keep and which one to merge and redirect.

Rules at a glance

The thresholds for each decision are in a settings tab, so you can adapt them to your blog.

How to conduct a content audit step by step

One hour the first time; after that, a review every three or six months.

Export the pages from Search Console

Performance, “Pages” tab, the last three or six months. Paste the columns into the sheet.

Note the main search query

For each page, the query that gives it the most impressions (by filtering by page in the “Queries” tab).

Fill in two details

The publication or last updated date and whether it includes a call to action.

Review the decisions

Each article shows what to do and why. Start with “Merge” and “Improve”.

Repeat every quarter

Paste the new data again and see what has changed.

Content audit FAQs

Answers to your most common questions

What is a content audit template for?

To find out which blog articles bring in traffic and which do not, identify those close to the first page, detect those competing for the same search query, and decide what to update before writing anything new.

What is a content audit?

It means reviewing everything you have already published using Google data to decide what to do with each piece: keep it, improve it, merge it with another, or remove it. It is the most profitable thing a blog that is over a year old can do.

What Search Console data do I need?

The data from the “Pages” tab of the performance report (clicks, impressions, CTR, and position) and, for each page, its main query, which you can see by filtering by that page in the “Queries” tab.

How does it detect cannibalization?

If two articles have the same main search query, they compete for it. The template keeps the one with the most clicks as the main article and flags the other to be merged into it and redirected.

How often should you conduct a content audit?

At least once a year, and every quarter if you publish weekly. With the template, repeating it simply means pasting in the data again.

What do I need to use the template?

Excel and access to your website’s Search Console. It includes instructions and an example from an employment consultancy.