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

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