How to Conduct a Content Audit on Your Site

SMS Text
How to Conduct a Content Audit on Your Site

“Content audit” sounds a bit intimidating like something that involves ghastly amounts of time, endless spreadsheets, and dozens of unpaid interns. The word “audit” is so tied up with other unpleasant life experiences that I totally understand if it doesn’t inspire you. But hang on for a second because a “content audit” might be what your site needs to get to the next level.

So, what is a content audit? A content audit is a careful look at your website’s existing content in order to make sure that it’s doing what you want it to do — driving the right kind of traffic, containing the right kind of keywords, and improving conversions.

The reason this is important is because the content of your website is the most important factor in your website’s existence. To be blunt, your content is your website.

That’s why a content audit matters. It’s about improving the very soul of your website – its content.

With crappy content, you have a crappy website. Now and then, it deserves a little audit action so you can find out what’s right about it, what’s wrong with it, and what might need to change.

But before we get into how you can audit your content, here is what you need before you can start:

What do I Need to do an Audit?

  • Time: typically one to two hours.
  • Tools: Google Drive Spreadsheet and Google Analytics.
  • Personnel: you. If the task is huge, get a few people with a moderate level of skill and language facility to help you.
  • Technical skill level: medium to low. If you have low technical ability, don’t worry. Once you do the first few pages, you’ll get the hang of it pretty quickly.
  • Writing skill level: average ability in the target language.
  • Amount of boring and mind-numbing work: medium.

Create a Spreadsheet

Now that you have the necessary tools, let’s get started by going to Google Drive and creating a spreadsheet.

How to Conduct a Content Audit on Your Site

Create the following columns in your spreadsheet: URL, Date Audited, Title, Description, Content, Keyword, Alt Tags, Last Updated, and Internal Links.

How to Conduct a Content Audit on Your Site

Each row will contain data for a separate page on your website, starting with its url.

The purpose of this spreadsheet is:

  1. To allow you to come back and work on your audit at any time.
  2. To provide an easily accessible place for navigating to the pages you need to audit.
  3. To track exactly what you’re doing and when you’re doing it.
  4. To allow collaboration with other users. You can provide shared edit access to other team members so they can help you with the audit. Because it’s cloud-based and updated in real time, you shouldn’t have any work overlap.

Go to Google Analytics to Create a List of All the Pages on Your Site

Go to Google Analytics. Navigate to the “All Pages” section.

Behavior > Site Content > All Pages

How to Conduct a Content Audit on Your Site

In this step, you’re going to get a list of the most-visited pages on your website. The reason why I recommend doing it this way is because this will help you audit your most important pages first. I’m all about low hanging fruit. This will give you results as soon as possible.

How to Conduct a Content Audit on Your Site

In the “Page” column, click on the link pop out button next to the page title.

How to Conduct a Content Audit on Your Site

Copy the URL in the page that opens and paste it into the first column of your spreadsheet.

Continue the process for every page on your website.

Warning:  If you have a huge site with thousands of pages, this could take a while.

To display all the pages on your site in a single screen (or to decrease the number of screens for bigger sites), expand the “show rows” menu at the bottom of the display chart and choose an appropriate option.

How to Conduct a Content Audit on Your Site

Alternatively, if you are a WordPress user, you may wish to create this list by pasting the edit URL for each page rather than the actual page URL. This way, you can click on the link and start editing the page.

Here’s how to do it: login to WordPress, go to “Posts” > “All Posts.”

How to Conduct a Content Audit on Your Site

Click on “Published” at the top.

How to Conduct a Content Audit on Your Site

Mouse over the first entry, then mouse over the “edit” option.

How to Conduct a Content Audit on Your Site

Right-click to bring up the menu and click “Copy Link Address.”

How to Conduct a Content Audit on Your Site

Paste this into your Drive spreadsheet.

Go to “Pages” > “Published” and repeat the process.

How to Conduct a Content Audit on Your Site

Although this does not deliver an ordered list of high traffic pages, it does give you an easily accessible list of pages to audit.

Now, your audit document is set up. You’re ready to roll.

How to Conduct a Content Audit on Your Site

Review Each of the Following Items

Here’s where we get into the nitty-gritty of your audit. Roll up your sleeves and prepare to do some work.

The process is going to vary for every single CMS. Since WordPress is the most popular CMS and the one that I use and recommend, I’ve provided tips for WordPress users.

You don’t use WordPress? No problem! Every CMS that allows code access and even most CMSs that don’t allow code access will let you edit every one of these items.

I’m also a big fan of systematized processes. Do this process for a couple of pages, and you’ll start getting the hang of it. Then, set up your screens, figure out your keyboard shortcuts, get a system going, and you’ll fly through the rest of the pages.

In your Drive spreadsheet, you already have your table set up to record and fix each content audit category. As you move through each item, mark it in your spreadsheet. You can do this with a check mark or cell background color.

How to Conduct a Content Audit on Your Site

Now, audit each of the following items:

Check Page Title and URL

This is the lead element of a WordPress post or page.

How to Conduct a Content Audit on Your Site

Make sure it meets the following parameters:

  • Up to 65 characters
  • Unique
  • Contains keywords
  • URL should be text, not numbers or gibberish. Warning: If the page is live, don’t change the URL unless you put a 301 redirect in place! You’ll have to decide if it’s worth it to go to the trouble of setting up a 301 on pages for which you want to optimize the URL.

Check Description

I recommend that you install the WordPress SEO by Yoast plugin in order to facilitate easy description editing.

If this plugin is in place, your audit process will go much faster. In fact, you can eliminate several of the columns in your spreadsheet and replace them with a Yoast column. That way, when you go to edit a page, you can make all the necessary fixes in the Yoast section, then mark it as done on the spreadsheet. It’s all about simplicity.

How to Conduct a Content Audit on Your Site

To audit your description, make sure it has these features:

  • 160 or fewer characters
  • Written for humans, not search engines

Check Content

Now, you need to comb through the content on each page. Use the “visual” view tab.

How to Conduct a Content Audit on Your Site

Check if your content is:

  • Readable, interesting, helpful
  • Grammatically impeccable
  • At least 300 words per page

Check keywords

Make sure you have a mental or written list of your target keywords. This is going to be important as you audit the keywords for each page.

  • Sufficient number of targeted long tail keywords.
  • No keyword stuffing. No long tail keyword should appear more than five times on any page. Head terms may appear as many times as is natural.

Check Alt Tags

Make sure that every image is sufficiently tagged. In WordPress, click on the image edit icon.

How to Conduct a Content Audit on Your Site

Then, add “alternative” text if it is blank.

How to Conduct a Content Audit on Your Site

  • Each image should have alt tags and title.
  • Alt tags should be descriptive and contain any relevant long tail keywords.

Check Last Updated

In the right side of WordPress, you can see when the page was last revised. Click on “Browse,” next to “Revisions.”

How to Conduct a Content Audit on Your Site

The top revision record that appears is the most recent.

How to Conduct a Content Audit on Your Site

Each page should be reviewed and/or edited at least every 24 months. If you can do it more often, that’s even better.

Check Internal Links

Each page should contain internal links within the content. This does not include navigation menus, headers, or footers. “Internal links” refers to links with anchor text within the actual written content on a page.

  • Two to three internal links is a minimum.
  • Internal links should point to other deep pages, ideally content-rich blog articles. Do not link to the Home page, About page, or Contact Us page unless absolutely necessary.


Once you’ve done all the steps above, you’ll want to rinse and repeat on a regular basis. I myself do this once every six months to keep things simple.

Content audits can really freshen up a website, improve rankings, and gain some extra traffic. That is why you should do them on your website.

After doing a content audit, even on the top ten most-visited pages, I’ve seen sites experience skyrocketing ranking and traffic. It’s amazing how many old SEO techniques and mistakes exist on old pages. Without realizing it, you may be letting your traffic be inhibited simply as a result of outdated content.

A content audit is like a free traffic boost. Sure, it takes some time and painstaking effort, but – I assure you – the results are worth it.

What other tips do you have for doing a content audit?


This post originally appeared on Quicksprout, and is re-published with permission.

Neil Patel
Neil Patel is the co-founder of KISSmetrics, an analytics provider that helps companies make better business decisions. Neil also blogs about marketing and entrepreneurship at... Read Full Bio
Subscribe to SEJ!
Get our weekly newsletter from SEJ's Founder Loren Baker about the latest news in the industry!
  • Brian Jackson

    I will share on here, what I did on Neil’s post to hopefully save some people time.

    I recommend Screaming Frog to grab your URLs in a matter of seconds.

    If you don’t have Screaming Frog you can speed up grabbing the list of pages from Google Analytics by simply doing an quick CSV export on that page and then adding your domain URL to the beginning of each cell using this formula:


    Then to convert to active hyperlink in Excel just run: =HYPERLINK(A1)

    Only takes a few seconds to add your domain on and grab your full list of URLs.

    • Norman

      Thank you Brian. I was thinking the same thing about Screaming Frog SEO Spider. Very helpful tool for this. Thanks for the Excel tip too!

    • Heng

      recommanding screaming frog as well. it’s free within 500 pages and you can also check your competitors’ sites and see if they do a great job with their SEO. only takes about 5 mins for each website to give you the full inside.

      • Jill Kocher

        Another vote for Screaming Frog. Xenu Link Sleuth also works, is free, but has fewer features.

    • Kelsey Nupnau

      I second what Brian says! ScreamingFrog has been a HUGE time saver for us.

    • Remar Barquilla (@RemarBarquilla)

      I am also recommending screaming frog. It’s more easy to extract pages and with the extracted data you can see right away the Title and Description of the published articles / pages. By the way nice info on content auditing.

  • Jenise Uehara Henrikson

    I loved this post. So much in fact we incorporated it into our editorial review strategy at SEJ. Explains very clearly what to do and why to do it. Bravo Neil.

  • Brian Willsone

    HI Neil, I never miss to read any of your post. This is a great post on the web for content audit. I am going to do content audit myself for for my website now. Thanks a lot for explaining everything clearly.

  • Rowena Jauod

    Just in time. Thanks for the detailed post on how to make content auditing Neil. Have to do the auditing on our blog.

  • Kamlesh

    This is really a great tutorial without any paid tool. just need analytic and spreadsheet.. Really awesome. I never thought content audit would become so much easy..

  • Alfonso Moure

    You don’t need to copy each URL from Analytics by hand. You can export the report and use CONCATENATE or the operator & create the final URL directly in Google Spreadsheet.

    In Google Spreadsheet you can load TITLE and DESCRIPTION automatically using IMPORTXML.

    Much easier.

    I also recommend Screamingfrog too!

  • Glenn Mark

    I almost always relate the audit process to my accounting subject back then. It seems tedious but thanks Neil for the “Google Analytic” suggestion above. I am sure there are many admins like me who just knew this.

  • Igor Mateski

    That’s a useful tip, doing content audit. BUT, (and all due respect to Neil), posting such a text where you’d go in GA and extract URLs by hand (ermmm, Sitemap page, anyone?) and then manually checking metatags seems like a very bad advice for a site such as SEJ. I’d expect this on a beginners site, but not here. Advice of doing a basic step manually without using Xenu or ScreamingFrog should not be allowed on SEJ….even if it comes from Neil.
    Again, all due respect to Neil, but cmon folks… don’t post advice of spending days on checking all the URLs manually for metaelements. Xenu/Frog does this in a matter of minutes. And don’t call it a content audit if there’s no mention of sifting through the text length, word count, readability score, formatting (h-tags, bullet lists), keyword maps (bubble map or word-cloud) etc. Checking for metaelements is basic on-site SEO audit, not content audit.