Auditing content using SEO Tools for Excel Pro 4.3.4

Isaac Bullen

Asia Pacific Director

3WhiteHats have been using SEO Tools for Excel for a number of years. This piece of software is a little beauty and has come in really handy at our agency, especially seeing as many of our reports are created from Microsoft Excel documents.

The feature I’d like to explore today is Spider as we’ve been looking for a way to audit the performance of articles on the 3WhiteHats blog more quickly and accurately. Unlike other SEO spiders, SEO Tools Spider requires no migration from one piece of software to another, and it can pull in data from integrations – useful stuff from Majestic such as total referring domains and social media shares. You simply select the metrics you want from the left box and enter the URL - things like word count, titles, headings and Meta descriptions will help.

 

Spider_screenshot


The scraper integration is really, really handy!

 

Scraper_screenshot

 

Usually I’d add a cell to the right of Meta description to count the Meta description's length. With Spider you set ‘warn if length’ and it automatically highlights offending Meta descriptions that are either too long or too short.

 

Spider_screenshot_2

 

Next I’ve used XPathOnURL to extract information directly from the blog post. In our case we are going to extract the author name to help with our content audit. We’re using WordPress to host our blog, therefore the following XPath code will point the Scraper to the author name: //span[@class="author vcard"]

Other useful data you might want to extract include tags, categories, number of comments, number of images, alt text – I’d write a tutorial about this but you can learn the basics of XPath here.

 

Spider_screenshot_3

 

Using XPathOnUrl with XPath input of: //span[@class=’author vcard’] gives us the following output:

 

xpath_screenshot_1

 

Click generate and away Spider goes:

 

Spider_screenshot_4

 

Once it has done its thing, you should be presented with a spreadsheet full of useful data of which you can add a filter, prune pages you don’t want to audit, and then get cracking with your content audit!

 

Troubleshooting

  • If you are not getting enough pages, you may need to increase the ‘limit search total’ and change the ‘limit search depth’ values. However, this may have the undesired effect of taking longer for the software to crawl the website and longer for you to filter output.
  • If you are collecting cache information from Google or ‘hitting’ particular servers often, you may find they stop you from collecting data. To overcome this head to ‘http settings’ and either add some proxies or experiment with the sleep between requests function.
  • If my crawl is going to keep Excel hanging out of action, I’ll often run it on a virtual machine or remote desktop into another machine. This way, I can continue with other tasks while SEO Tools for Excel is busy.

 

Wish list

  • Integrate with Google Analytics, so we can include visitor data.
  • Path exclusions / inclusion, so we can bypass or include certain directories.
  • Conditional formatting set by warn if length is responsive to cell updates.
  • Twitter share count for the URL, not just the domain.
  • An option to exclude file types such as images from the crawl.

 

Are you using the Spider feature, SEO Tools for Excel or have a great piece of SEO software? Let us know what you think by commenting below, or talk to us on Twitter @3WhiteHats.

 

 

Related Posts

A marketer’s guide to mobile-first indexing

In Google’s ever-continuing efforts to follow user trends and make the web more mobile friendly, mobile-first indexing was rolled out. Read this guide to find out what it is and how you can use it to it’s best ability for marketing and website success.


1 month ago

The step-by-step guide on how to prepare for Google's Page Experience update

Having good user experience (UX) is something every webmaster should strive for. With Google's Page Experience update rolling out in May 2021, we’ve outlined what this is and how you can prepare for it.


1 month ago

Fine-tune your content in 2021 with these SEO tips and trends

As we take our first steps into 2021, now’s the time to identify the most effective ways to use content to connect your business with its audiences. Not only will this help you get ahead of the competition, but after a curveball year in 2020, it’ll ensure you’re on the right track if your audiences’ behaviours online have changed at all.


3 months ago

Inside Screaming Frog: Top Takeaways From The Workshop

Ensuring that your URLs can be crawled and indexed is a cornerstone of SEO. If Google can’t find that lovely content you want to get in front of your customers, what’s the point in writing it, right?


2 years ago

Our top takeaways from BrightonSEO

Here we explore the Spider feature, as we’ve been looking for a way to audit the performance of articles on the 3WhiteHats blog more quickly and accurately.


2 years ago

Google changes affecting local queries

As Google continuously updates in order to keep up with our ever-changing world of tech, we ask, what are the recent changes affecting local queries?


3 years ago

Drag