Content Audit [Template] - created by Ahrefs
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABC
1
Instructions
2
1. Click File > Make a Copy > Save to your Drive

2. Import all pages from your Sitemap into the "Sitemap" sheet (format should be your full URL (ie. https://ahrefs.com/blog/seo-tips/).

3. Import your GA data from Behaviour > Site Content > All pages over the past year into the "GA" sheet. Make sure to add a segment for "Organic traffic" and toggle the option to show the maximum 5,000 rows before exporting.

4. Import your link data from Ahrefs (Site Explorer > enter domain > Best by Links > 200 status code filter > export) or GSC (Search console > Links > Top linked pages > Export) into the "Links" sheet.

5. Adjust your conditions in the table below to match your "thresholds" (if required)

6. View the "Master" table and see your suggestions
3
>>>> Read Blog Post <<<<
4
>>>> Watch Video <<<<
5
6
7
Conditions Table
8
Minimum backlinksMinimum "meaningful" organic trafficMinimum "meaningful" traffic (all sources)
9
1365365
10
11
12
Actions Descriptions
13
1. Delete (404) - Has no meaningful traffic and no backlinks.

2. Redirect (301) or update - Has no meaningful traffic yet meets the minimum backlinks threshold.

3. Leave as is (200) - Has meaningful traffic, a good amount of which is derived from organic search.

4. Manually review- Has meaningful traffic, little to none of which is derived from organic search. See the blog post or video to learn how to deal with this.
14
15
16
17
18
19
Questions
20
Have a question? Ask us in the comments section on our blog post or video.
Loading...
Main menu