Start with Screaming Frog
Let’s get started with Screaming Frog to crawl or scrap our website and export it to Excel where we’ll do some conditional formatting. With the conditional formatting, the report will tell us where we need to make our adjustments for SEO optimizations. It will help us prioritize.
Depending on your website goals, you can add other details to keep track of as well.
In my case, I’ll have an additional tab for page layout updates, keyword mapping and other things as they come up.
What is Screaming Frog?
First and foremost, don’t let the strange name make you scratch your head. It’s simply a website crawler that gathers meta data or details about a website.
I used the free version because it suits my purposes for this website audit.
There is a paid version which allows you to crawl a website that has more than 500 pages. This is good for an eCommerce site or one that has many pages and articles.
If you need to download it, visit the makers of the software. https://www.screamingfrog.co.uk/seo-spider/ It’s available for Mac and PC.
Let Screaming Frog Start Collecting From Your Site
Enter your site and hit start. The time it takes to crawl your site depends on your internet speed and the size of your site.
It isn’t like waiting for water to bowl, watch it or grab a cup of coffee then come back.
Once it is complete, export the file.
In my example, I selected All from the drop down menu, but you can filter down if you would like.
For this website audit, this is all that we’ll be using Screaming Frog for. There are so many other things that it can be used for, but right now, it’s about getting prioritizing and setting up a list with what needs to be done.
Finishing Off with Microsoft Excel
In the first and original video, I used Microsoft Excel 2007. In the second video, I used the version of Excel that is connected with my hotmail account. It’s completely online, so the screenshots might be a different from the version that you may using. However it still works in the same way. The styling is the ony thing that will be different. (The Microsoft Office on my computer has been acting goofy today. I quite honestly haven’t had enough coffee today to correct the problem.)