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

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?


1 year 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?


2 years ago

Ditch the hassle: Excel secrets to master keyphrase research

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

How to respond to negative Google My Business reviews

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

Seven beginner WordPress plugins

In this article we've compiled some of the absolute best WordPress SEO plugins – and more – for making the job of optimising your website that much easier.


2 years ago

Drag