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

beans-I-like-them

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.

SEOgadget's API Now Available in the Links API Extension for Excel, 4.2 out of 5 based on 5 ratings

Comments

  1. Yamel Mattarollo

    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.

  2. Yamel Mattarollo

    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