SeoTools v6: Faster, more stable and no ads!

by Niels Bosma

TL;DR We've been working on SeoTools 6.0 for quite a while and there's a lot of new updates. This is probably the largest update we've ever released! Dowload the latest version of SeoTools! Async and Caching MAJOR UPDATE: Most functions incl. Connectors are now asynchronous meaning that they can be stopped and can run in parallell (if the external data source permits it) and won't make it seem like Excel freezes. This translates into a HUGE boost in...

SeoTools 5.1: Installer, Google Search Console, Sistrix and PhantomJs Cloud

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