Introduction to Spider

by William Dahlstrom

We've previously touched on the subject of scraping the web in the context of fetching a very specific part from a single page. But what if you're looking to analyse a substantial part of, or an entire website? Enter the Spider The Spider is an intelligent crawler built right into SeoTools. It lets you run one or several SeoTools functions against an entire website, including all public sub pages and external links. In this example we're going to do some...

Link auditing with SeoTools and Majestic

by William Dahlstrom

Auditing your backlinks should be something you do regularly. It's much easier to proactively make sure Google isn't punishing you than rectifying the situation after the fact. In this article we'll use Majestic to automatically fetch backlinks for our domain and provide domain rankings, so I'm going to assume you've got that integration all set up within SeoTools. Fetch the backlinks Let's start off by pulling a list of backlinks to our domain. Then we're going to use UrlProperty to...

Securely compare customer lists from two parties

by Niels Bosma

Say you're negotiating a deal with an external party and to be able to move forward you need to know how many customers do we have in common? Neither party is at this stage interested in sending their list of customers. My solution to this problem is by using the new MdFive function in SeoTools 5.0. MD5 which stands for Message Digest algorithm 5 is a widely used cryptographic hash function that was invented by Ronald Rivest in 1991....

SqlConnectors - Connect to your data in Excel

by Niels Bosma

Let me tell you about the best secret I sneaked into SeoTools 5.0! This is a life-saving feature that I use almost every day at my day job as a growth hacker. Wouldn't it be nice to be able to access data from your database in a structured and user-friendly way directly in Excel? Say for example that you have a list of user ids (maybe from a custom dimension in GA?) and you need to quickly figure out...

CheckBacklink() in practice

by William Dahlstrom

There's plenty of reasons you might want to check whether a page is linking back to your website or not, and if they're doing so without the nofollow attribute. SeoTools naturally provides a handy implementation of this through the CheckBacklink() function. Why backlinks? While no one can say for certain, backlinks are believed to be one of the key factors in Google's algorithm. As with all SEO related topics, there's a lot of dubious information floating around - so let's...