How to do a website audit using Screaming Frog SEO Spider

How to do a website audit using Screaming Frog SEO Spider
H, this is Dr. Susan Riegg from And in this video I wanted to demonstrate how I do a website audit. There are a lot of reasons to do a website audit. I do SEO work for clients, so I do like to scan sites and get a feel for how many pages there are on the site. Also, what do the title tags look like? The meta descriptions? Just kind of get a feel for what all the pages look like.

But this morning I was doing something a little different, I may actually be planning to do some affiliate work for a product made by Link Assistant at SEO PowerSuite, and what I’m doing is creating a spreadsheet of all of their pages so that when I go about marketing the different products, I have an organized spreadsheet of all of their different products and their materials, articles and resources. So I just want to show you how to do a site audit.

Our starting point is a piece of free software called Screaming Frog SEO Spider. You can download this from the Internet, so if you Google “Screaming Frog SEO
Spider” and the download is free. You can get a version for MAC or for your PC.

So you download that, the little icon looks like this here. And then at the top you enter the URL to spider. The website that I’m working on right now is called, and then you click on start.

So what this does: the software will scan the site and produce the data. We’re eventually going to print this out on an Excel spreadsheet. Up here you can see the bar that’s showing the completion, so now it’s at hundred percent completed. And here are all of the components of the spreadsheet.
So we have internal, external… I’m not going to go through what each of these are, that’s not the point of this video.

Page titles…this is really important for SEO clients. We are looking at their page title, meta descriptions, meta keywords, H1 headers, H2 headers and so on.

In order to create a spreadsheet, I’m going to go back here and click on internal and on “Filtered” I want to go to this drop down and click on HTML, because I just want the HTML pages, I’m not interested in images and PDFs and everything else that’s here.

So under HTML, the total down in the lower right-hand corners it says 113 pages, and I’m going to export. This is going to export… you have some choices and I have already chosen to export to an Excel workbook to my desktop. I’m going to rename this as “SEO PowerSuite” and click save.

So this will write the report and save it to the desktop. Now I’ve already done that, I’ve been working on that. I am going to open up the spreadsheet that I’m already working on, actually I take that back because I’m going to show you what the spreadsheet looks like coming right out of the box.

Okay so this is what the spreadsheet looks like coming right out of Screaming Frog SEO Spider. It is a bit medded up; so I go up in the upper left-hand corner, and click here to outline all of my borders, makes it a little bit easier to read.

The other thing I can do is to do here to wrap text; click here for a dropdown and then the text is wrapped and it’s easier to read everything. So in this first column, I have a list of all of my pages and I’m going to start deleting columns. So column B, I do not need… actually for my purposes, I’m going to delete status code. I’ll probably keep the title tags. and when I’m doing a site audit, I want to keep the title tag and the title tag length. Pixel width, I don’t need. Meta description… Meta description, pixel length I will delete, and here we have for every single page the meta keywords.

To read the rest of the transcript, click here:

Leave a Reply

Your email address will not be published. Required fields are marked *