15 Excel tips every SEO professional must know

by Victor Sandberg

Whether its basketball, pubic speaking, or SEO, mastering the fundamentals is key. Sure, you may be able to alter a data set manually or copy a strange looking formula, but if you want to be prepared for the challenges of tomorrow, this article will get you a long way. Mikkel Sciegienny at Spreadsheeto has been involved with SEO for five years and in this blog post he will share 15 important tips for mastering Excel. 15 Excel tips every SEO...

SeoTools 5.1

by Niels Bosma

Time for a new release! SeoTools now ships with an installer making installation and upgrades a lot easier! Download SeoTools 5.1 Google Search Console Google actually released a really good API for retrieving search data! Now you can access this directly in Excel with SeoTools. Read more Use Google’s Search Console API & Pivot Tables To Supercharge Your Long-Tail SEO Sistrix First connector created by William! Implemented most of the Sistrix API. If you're a Sistrix customer, this...

Pull social metrics for multiple accounts

by Niels Bosma

We often get this question: How can I pull social metrics for multiple twitter/facebook/linkedin accounts at a time? Instead of having to input the url manually for each pull. This is actually quite easy: In the wizard of a connector or integration generate the query as a formula and then replace the literal url with a reference to the first cell in the column of urls. Then use Excel's autofill feature to populate the rest of the cells....

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