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

CheckBacklink() in practice

by William Dahlstrom

There's plenty of reasons you might want to check whether a page is linking back to your website or not, and if they're doing so without the nofollow attribute. SeoTools naturally provides a handy implementation of this through the CheckBacklink() function. Why backlinks? While no one can say for certain, backlinks are believed to be one of the key factors in Google's algorithm. As with all SEO related topics, there's a lot of dubious information floating around - so let's...

JSON APIs + SeoTools = True

by William Dahlstrom

JSON, short for JavaScript Object Notation is a syntax for fetching, exchanging and storing data. It's considered an easier alternative to XML and its use is widespread on the web. There's an implementation or library in just about any language to deal with JSON style data, and it sees prevalent use in APIs all over the internet. SeoTools interacts with structured JSON data through the JsonPathOnUrl function. It allows you to both GET and POST data to a JSON compatible...

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

XPath, scraping the web & Chrome DevTools

by William Dahlstrom

XPath is an incredibly powerful language for finding, navigating and selecting data in XML style documents. With HTML being a derivative of XML, it means that most of the content on the web is selectable, and in turn, scrapeable with the help of XPath. That's pretty damn cool. Since XPath is just a way of selecting parts of a document (or in our case, the DOM) it needs to be combined with some kind of tool in order to leverage...