About a month ago, I had a penny drop moment. We’ve had the Links API Extension for Excel available for free download since July – initially launching it with Mozscape, and later Majestic SEO. We’ve had a free API that does a ton of stuff for about the same period of time. Until that penny drop moment, I hadn’t thought of putting the two together.
Get site contact details, easily!
Here’s the kind of story you can tell with this tool:
“Show me the contact URLs for my competitors most valuable links, sorted by Domain Authority (SEOmoz) or Majestic’s FlowRank metrics.”
“I’d like the twitter profile URLs featured on this list of blog posts.”
“I’d like to find a list of author names and Google+ profile URLs from this list of articles.”
“Sort by sites hosted in Germany with more than 100 linking root domains.”
“Here’s a list of sites I made that mention the Google Keyword Tool. Grab me their contact details so I can ask them to link to our keyword research post”
You get the general idea.
“How does the SEOgadget API work?”
Asked Someone on Twitter.
We’re scraping, mostly. For example, our API crawler will look for rel=”author” on a page, and, if it finds that particular Microformat in the markup, it’ll follow the link, fetch the Google+ profile URL, resolve that through the Google+ API and spit it back out via our endpoint. Similarly, we’re fetching any URL that contains “contact” – assuming that is the contact URL and playing it back, too. So all in all this makes for a great little outreach data builder, link clean-up tool, or makes for a fun platform to cobble together apps like this one.
How does the SEOgadget API extension work?
The main API wrapper function is arranged like this:
linked_URL is the URL you’d like to fetch data for
[URL] is your website, in case you’d like us to check if a link is followed, nofollowed, live, etc
[whatToReturn] is the field you’d like returned
The “what to return” fields:
You can leave the [URL] argument blank (in fact it’s marginally faster to do so) and the [whatToReturn] argument can also be left blank and combined with the _toFit and _toSheet helper functions to squeeze the data into a meaningful table or sheet.
Would return the contact URL found on SEOgadget.com’s homepage.
Easy functions available
Rather than using the wrapped API call query above, some Excel users prefer predefined single functions. Say you’d like to know who wrote an article at a URL:
The functions are very easy to find, just start typing =SEOgadget and they’ll appear in the tool tip:
The cool thing about the Extension is that it caches the requests, so once you’ve made a table, adding columns is lightning fast. Here’s an example I built to fetch the top pages on SEOgadget.com (via the SEOmoz API – there’s a top pages function from Majestic too). I grabbed author name, Google+ profile, and Google+ counts very, very quickly. Check it out:
Here’s a little example (which you can download here: excel-demo-seogadget-api). You’ll need to have installed the latest version for this to work, obviously!
The distribution zip file is available via the Links API Extension page. If you want to learn this extension, I promise I’m writing a guide to the 60 or so functions available now. In the meantime, the best thing you could do is follow the instructions on using Mozscape here and follow on to the Majestic announcement here.