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 Twitter 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 when loading stored configurations. Fixed...

Mobile webpages and SeoTools

by Niels Bosma

There's a a few different techniques for mobile web content adaption. Depending on the technique used by the page you're analyzing you way need to set a user agent so the right page is fetched. If the page in question is build using responsive design you don't need to do anything. But if the pages servers different content based on the user agent you need to change the SeoTools http settings to be able to analyze these pages. Change the...

Bulk check Google Mobile Test in Excel

by Niels Bosma

So with mobilegeddon raging around us we need a good way to bulk check all of our websites for mobile friendliness. A perfect job for Excel and SeoTools! Google has released a tool that help test whether a website is considered "mobile friendly" or not. But only for one website at a time. What if we need to bulk check lots of websites to spot the ones we need to fix? In this post I'll show you how we can...

Get date_to_release from WhoIs

by Niels Bosma

When a domain expires some WhoIs results includes a "date to release". For swedish domains this can look like: Using the functions WhoIs and RegexpFind we can get this date in Excel using SeoTools: =RegexpFind(WhoIs("0081.se");"date_to_release:\s*(\d{4}-\d{2}-\d{2})";1) Using a more generic regexp we can get any field we want: =RegexpFind(WhoIs("nielsbosma.se");"registrar:\s*([^\n]*)";1)...