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

New SeoTools 5.0 with Connectors, Moz, YouTube and uClassify

by Niels Bosma

Download SeoTools 5.0 Connectors I've rebuilt Scrapers entirely. They are now called Connectors and can return table values and do all sorts of cool things. Connectors are written using my XML format and makes it super easy to integrate most HTTP APIs with Excel. The ones that I've written has been open-sourced on GitHub and I really hope some of you will be inspired and help integrate more APIs. I'll follow up with a post on how to write...

SeoTools 4.4 with SEMrush

by Niels Bosma

SEMrush integration The much wished-for SEMrush integration support is finally here! With the SEMrush integration in SeoTools you can perform powerful keyword analysis for paid and organic traffic, learn what and how much your competitors spend on Adwords and review your backlinks directly in Excel. Integrated features Anchors Backlinks Competitors in organic search Competitors in paid search Display advertisers Domain organic search keywords Domain overview Domain paid search keywords Indexed pages Keyword difficulty Keyword overview Organic results Paid results Phrase...

Find the country where a site is hosted in Excel

by Niels Bosma

Using the ip-api.com JSON API and ResolveIp we can get the country where a site is hosted: The following API request http://ip-api.com/json/91.189.43.102 returns this JSON response: So we use ResolveIp to get the ip of the site and JsonPathOnUrl on to parse the result: =JsonPathOnUrl("http://ip-api.com/json/"&ResolveIp("http://nielsbosma.se");"$.country";HttpSettings(TRUE;;;"240|240|Host")) Note the usage limits from their documentation: Our system will automatically ban...

SeoTools 4.3.5 with YouTube metrics!

by Niels Bosma

A small release this time with some new scrapers and bug fixes. New scrapers Youtube Google.AdsenseId Instagram.Followers Twitter.Followers Google.MobileFriendly Got an idea for an API that we should integrate into SeoTools as a scraper? Let me know! Fixes Added Include and Exclude url options in Spider. Defaults for AhrefsRank function. Updated Google Analytics metrics and dimensions. New "depth" option for UrlProperty Fixed formatting bug in Google Adwords/Search trends header results. Fixed issues with the Spider...