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...
By installing the SeoTools for Excel add-in your get access to a set of functions that are useful when working with online marketing. For on-page SEO analysis you have functions like HtmlH1, HtmlTitle and HtmlMetaDescription which you can use to verify that your pages are correctly setup.
SeoTools also comes in handy when looking at off-page SEO factors. Using CheckBacklink you can verify that your backlinks are still available and with GooglePageRank you can fetch PageRanks for multiple urls at ease.
By building your own Scraper using our XML format you can extend SeoTools to integrate with an external API or fetch a particular part of any webpage. SeoTools includes with over 25 open-source scrapers such as Facebook.Likes, Google.Results and Youtube.
With the Spider you can combine all the features in SeoTools into a powerful webpage crawler. Either supply the Spider with a list of urls or start with a root url.
SEOTools for Excel enables rapid tool prototyping and SEO diagnosis - it's in our consulting toolset at Builtvisible and remains invaluable in our day to day SEO activities.
If you use Excel on Windows, SEOTools for Excel has no equal. Comprehensive and incredibly powerful, bring all your favourite SEO data straight into your spreadsheet can save hours or even days of legwork. A real life saver, built by one of the most talented programmers in the industry.
I've been using the SeoTools plugin for Excel since its inception, and I'd be lost without it. I use it for so many marketing-related tasks and know that I'm still only using it at a tiny fraction of its full potential. The SeoTools plugin should definitely be a part of every marketer's toolbox.
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/18.104.22.168 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...
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...
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...
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...