How to Conduct a Content Audit for SEO

Name: How to Conduct a Content Audit for SEO
Rating: 4.6 (25 reviews)

Grow your organic traffic by identifying the content that works, and by fixing the content that doesn't

Created byKathy Alice Brown

Last updated 3/2024

English

What you'll learn

How to conduct a Content Audit to improve your site's Organic Traffic
How to use filters with your Excel spreadsheets
How to identify your best performing pages
How to identify your underperforming pages and what to do to improve them
How to see your organic traffic charts in Google Analytics

Course content

3 sections • 28 lectures • 2h 32m total length

Introduction4:30
An overview of the course and setting up Google Search Console
Why do a content audit?5:56
Content Audits can give you valuable insight into the performance of your content so you can shape your content strategy. An audit can also improve your SEO by eliminating or improving your poor performers.
Getting started with building your list8:05
This lecture sets the stage for the following lectures which walk you step by step through the process of building your list. We cover the process and the sources of where you'll get your data.
Using Screaming Frog to crawl your site.2:32
Screaming Frog is a freemium web crawler. You can crawl 500 URLs at no charge.
If you have the paid version of Screaming Frog ...0:14
If you have the paid version of Screaming Frog you can have it pull Analytics for you.
Creating your initial of pages in Excel6:00
We export the initial list to Excel and remove the invalid pages.
Removing Non-indexable URLs3:16
Exporting Traffic data from GA49:29
Choosing a timeframe, and how to export all traffic data as well as Organic traffic data from GA4.
Choosing a timeframe and Google Analytics export limitations0:32
What to consider when choosing a timeframe in Google Analytics and a note about a Google Analytics export limitation.
Exporting Backlink data from Google Search Console (GSC)3:34
Google Search Console provides a Backlink data about your site, how to find and export it.
Putting your data together11:02
Now that we have our URL list, Google Analytics and Backlink data, we need to put it together in one sheet so we can see our page's performance all in one tab in our spreadsheet.
Vlookup() recap0:46
Getting Other Channel Data from GA43:46
How to get other Channel Data from GA4. Difference between System Defined Medium, User Defined Medium and Channel Groups
Using GA4 Explorations to Get More Rows6:19
In GA4 we are limited to 250 rows max in the Standard Reports. Explorations are more work to set up but allow you to download all your rows.

Conducting your content audit6:45
Learn about the 4 actions we will choose to take with each page that we audit.
Filter Magic: PreAnalysis of your list12:20
A long list of URLs can be daunting to review. Here's how I used metrics to make an initial decision on my URLs and segment my list.
Time saving tip and fool proofing5:28
Turning your links into clickable links and capturing the vlookup values so changes won't break your sheet.
Removing your "Deletes"4:43
How to sort and filter your list and a WordPress screen options trick so you can remove your "deletes" pages.
Bulk deleting your posts/pages - alternatives0:49
Multiple tips to help you delete page with more efficiency.
Checking your site for broken links4:47
After we have deleted pages from our website we should check for and fix broken links.
What is a Redirect?6:02
The next group of pages we will take a look at are the ones we marked as "redirect". In this lecture we will learn what a redirect is and the different ways you can implement one.
Implementing Redirects in WordPress3:38
To implement redirects we need to determine our target URLs. Then we can set up our redirects in WordPress.
Prioritizing your Improves8:36
You may not want to invest the time to improve all the "improves" on your list. Here are two ways to find the ones to focus on.
Using performance data to find opportunities10:07
We use Google Search Console data to find the pages appearing most frequently in searches and to drill down on the keywords these pages are currently ranking for.
Evaluating your Keeps4:49
Evaluating your keep pages & pages helps you determine whether your site is aligned with your goals and mission.
Course quiz

Requirements

Access to Microsoft Excel or a similar spreadsheet tool
Access to Google Analytics and Google Search Console for a website
Access to a website that has 20 or more pages

Description

Interested in ramping up the SEO performance of your content?

You need a content audit.

When you conduct a content audit for SEO you will:

Determine your winners and losers - and get clear on what action you need to take to fix your losers.
Leverage key Excel features - so you can manipulate and segment your data with ease.
Use metrics to aid your decision making
Identify your "biggest bang for your buck" content opportunities

In a content audit we review our pages to decide on action: Delete, Redirect, Improve or Keep, and then implement that action. We will walk through both in this course.

Overview:

In this course you will learn:

How to create your initial spreadsheet of URLs that you want to audit.
Where to download traffic and backlinks data and how to add it to your spreadsheet using vlookup.
How to use filters to segment and pre-analyze your data for your decision making.
How to delete and redirect URLs in WordPress.
Ideas for improving your pages.
How to prioritize your page updates by identify which page has the topic that is in most demand.

English captions available.

This course is for you if:

You are a website owner that wants to successfully market online
You are a blogger that wants to attract more organic traffic
You work on website content for a living

PLEASE NOTE!

You need historical data for a content audit. This means having access to analytics data for your site for at least the past 3 months (and longer is better especially if you have low traffic).

See you in the course!

I'm a SEO Consultant and I have really enjoyed putting this course together for you. See you on the inside!

Who this course is for:

Content Marketers
Bloggers
SEO practitioners
Site owners that want to use content to attract more visitors to their site

How to Conduct a Content Audit for SEO

What you'll learn

Explore related topics

Course content

Creating your list of pages to audit14 lectures • 1hr 6min

Auditing your URL List11 lectures • 1hr 8min

Extras and Wrapup3 lectures • 18min

Requirements

Description

Who this course is for: