SEOgadget’s API Now Available in the Links API Extension for Excel

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.

Until now.

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:

=SEOGadgetAPI(linked_URL,[URL],[whatToReturn])

Where:

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:

google_domain_pagerank google_pagerank whois.email links.contact_links links.linkedin_links links.twitter_links links.emails url ip seomoz.root_domains_to_domain seomoz.page_authority seomoz.domain_authority seomoz.root_domains_to_url sharedcount.linkedin_shares sharedcount.facebook_likes sharedcount.google_plusones sharedcount.facebook_shares sharedcount.pinterest_pins sharedcount.tweet_count location http_status_code

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.

Example query:

=SEOGadgetAPI("http://seogadget.com",,"links.contact_links")

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:

=SEOGadget_gplus_display_name([@Column1])

The functions are very easy to find, just start typing =SEOgadget and they’ll appear in the tool tip:

queries

 

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:

fetch-authors

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!

Download now!

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.



Stay Updated: Sign Up for Webinar & New Blog Alerts

4 thoughts on “SEOgadget’s API Now Available in the Links API Extension for Excel

  1. Jason says:

    I assume this only works on Excel for PC?

  2. Hey Jason,

    Yes – I’m afraid so. If you’re running a MAC you’re going to have a bad time :D

  3. Yamel Mattarollo says:

    Hi Richard, I installed the Moscape api extensions for excel and added my seomoz api credentials, and I can use formulas like =SEOMOZ_URLMetrics_toFit(). I want also to use the seogadget api, but where in excel should I enter the api key to make it work? I followed this http://seogadget.com/how-to-use-our-api/ and I can make it work, but not with seogadget formulas.

  4. Yamel Mattarollo says:

    Hi Richard, I installed the Moscape api extensions for excel and added my seomoz api credentials, and I can use formulas like =SEOMOZ_URLMetrics_toFit(). I want also to use the seogadget api, but where in excel should I enter the api key to make it work? I followed this http://seogadget.com/how-to-use-our-api/ and I can make it work, but not with seogadget formulas. Thanks

Comments are closed.