Update: Version 2.0 of the Excel Interface to the seoMoz API

by Jason Green on September 22, 2011 · 16 comments

I’m very happy to announce an updated version of our Excel Interface to the seoMoz LinkScape / Mozscape API. Your suggestions have been heeded and the new version is a great improvement over the first.

What’s new?

  • Run On-Demand: No more auto-updating. Now, just press Alt+F8 to run when YOU want.
  • Rate Limiter: Helps to keep us out of the seoMoz doghouse. Allows 2 URLs to be processed per second. As of early 2012, the rate limit has been changed to 1 URL per 10 seconds. (for free accounts)
  • Cleaner Spreadsheet: Removed the “raw” seoMoz response and handles all parsing within the macro.
  • Conditional Formatting: Automatically compares scores against all others on the sheet. Highlighting opportunities FTW!
  • Stand-Alone Macro: Save the macro to your personal workbook and you can run it against any list of URLs. No need to use *this* spreadsheet every time. (minor tweaks required)

BusinessHut seoMoz LinkScape API Excel Spreadsheet

Please visit this page to download the latest version of the Excel spreadsheet: Excel Interface to the seoMoz API

— Make it more awesome with this post by John Doherty
— And for even more info, check out John’s post on SEOmoz

********* UPDATE 12/13/2011 **********
Rolling out December, 16th, 2011, the SEOmoz Free API will be severely limited.
The new rate limit for the Free API is 1 request every 10 seconds.
(Compared to 2 or 3 per second that we’ve been running.)
And batch requests for the URL Metrics Call has been limited to 10 URLs for every POST request.
You can read the official SEOmoz API update here.
**************************************

********* UPDATE 9/5/2012 **********
Version 3.0 is now in beta testing.
Rather than a vba macro, this new version is an installable Excel Add-in.
Check it out here: http://www.businesshut.com/seo/seomoz-mozscape-add-in-for-excel/
**************************************

Suggestions and support are welcome. Thank you to everyone who has given feedback thus far.

{ 14 comments… read them below or add one }

Dan September 23, 2011 at 4:50 am

Thanks for this great sheet, is there anyway to speed up how the text is parsed? the responce from the seomoz API doesnt seem to take long but a lot of time seems to spent parcing the responce… do you know any other way of doing this to speed things up? I removed conditional formatting but this only speeds up a fraction.

Great work again!

Reply

Jason Green September 23, 2011 at 7:10 am

Thanks Dan. There’s a pause built into the code for rate limiting. So, if the parsing takes .3 seconds or more, we could remove the pause. Just delete or adjust the line that says Sleep 500.

I’ll also do some testing to see if the code can be optimized.

Thanks for your input!

Reply

J September 23, 2011 at 11:35 am

I just dwnloaded the files, but not sure what to do next.
help

Reply

Jason Green September 23, 2011 at 2:04 pm

John,
First, enter your api credentials from the seomoz api page. http://www.seomoz.org/api
Then, put a bunch of urls in column A.
Press Alt+F8 and run the macro.

It’ll take about 1 second for each url, but you’ll soon have useful data to help you decide which sites to target for links.

Or…you could populate your current list of backlinks to learn more about your link profile.

I was reading on John Doherty’s blog about visualizing your link profile with Open Site Explorer. If I can automate the OSE (or similar) data, this could get pretty useful.

Reply

Alex @SEO (Search Engine Optimisation) July 19, 2012 at 2:57 am

Any news on trying to automate the OSE? I am trying the same but finding it a bit tricky!

Reply

Tom September 26, 2011 at 8:17 am

You should include a couple of images from the spreadsheet in the article to give people an idea of what to expect. Would probably drive a higher download %. Its a nice sheet!

Reply

jant February 28, 2012 at 3:34 pm

Thank you
There’s a pause built into the code for rate limiting. So, if the parsing takes .3 seconds or more

Reply

Joshua March 12, 2012 at 4:31 pm

Does this sheet this only work with Excel for Windows?

Reply

Jason Green May 15, 2012 at 10:44 pm

It appears that way. We haven’t found anyone who’s able to get it working on a Mac.

Reply

Alex @SEO (Search Engine Optimisation) July 18, 2012 at 12:21 pm

Hi

Really trying to get this to work but struggling a bit.

Where do I find the signature and timestamp info for moz api?

I only have secret key and member ID on my page?

Alex

Reply

Alex @SEO (Search Engine Optimisation) July 18, 2012 at 12:57 pm

I have used the sample signature and timestamp but it’s still not working.

Reply

Jason Green July 20, 2012 at 11:14 am

Sorry everyone! Version 2 doesn’t seem to be working anymore. I’m troubleshooting and will post a new version soon. Until then, I’ve verified that the original version still works. Please give that a try in the meantime.

Reply

Tony August 12, 2012 at 9:59 am

Just hoping this sends me an auto update when your done updating the code so i dont have to keep checking back or figure it out myself…..

Reply

riley August 14, 2013 at 4:15 pm

Holy crap! This is awesome. I was literally using python script to do all this work and this is so much easier! Thanks!

Reply

Leave a Comment

{ 2 trackbacks }

Previous post:

Next post: