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)
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.
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!
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!
I just dwnloaded the files, but not sure what to do next.
help
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.
Any news on trying to automate the OSE? I am trying the same but finding it a bit tricky!
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!
Thank you
There’s a pause built into the code for rate limiting. So, if the parsing takes .3 seconds or more
Does this sheet this only work with Excel for Windows?
It appears that way. We haven’t found anyone who’s able to get it working on a Mac.
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
I have used the sample signature and timestamp but it’s still not working.
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.
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…..
Holy crap! This is awesome. I was literally using python script to do all this work and this is so much easier! Thanks!