Excel as a heatmap

by William Dahlstrom

Today's post is going to be different. While we usually walk through SeoTools functions or explain SEO concepts, I received an interesting question the other day. What's the coolest Excel hack you've seen? While technically not a hack, the easy way out would've been to reply with a SeoTools pitch - instead I asked for some time to mull it over and here's my answer. Excel heatmaps John Nelson at IDV Solutions walks us through how he uses an Excel...

Majestic: TrustFlow & CitationFlow

by William Dahlstrom

We've briefly touched on TrustFlow & CitationFlow in our post on link auditing. Since we published that post we've had some questions on what TrustFlow & CitationFlow actually is. In an agency environment there can be hundreds of links to place each month. This can lead to placing content on some sites that may look good at first glance but in reality, the website owner may have used that domain for greyhat tactics in the past and is now just...

Community spotlight: RocketMill

by William Dahlstrom

For digital marketing agency RocketMill, SEOTools for Excel has become a fundamental resource for saving valuable time logged against their clients. We spoke to them about a few of the ways the tool improves their productivity. Meet RocketMill Sussex-based RocketMill emerged into the digital marketing sphere five years ago, beginning life as a team of just three and working with small SMEs. Now, the workforce is 30 strong – with plans to expand further – and their client base has grown to...

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...