With the updates just added to the Mozscape API (previously Linkscape), I decided to update the Excel Macro and turn it into a full-fledged Excel Add-In.
Select any number of cells containing URL’s.
Right-click and select “Run Mozscape on Selection”
Enter your Access ID and Secret Key (aka Private Key) from the api page.
A big improvement is that you only need to do this once.
If your credentials are accepted, a new sheet named “Mozscape” will be created and all url-metrics will be added for your chosen URL’s.
If you run this twice, or if you already have a sheet named “Mozscape” it will be deleted and replaced. Rename it before running again if you want to keep the data.
The free Mozscape API is limited to 1 request every 10 seconds.
100 URL’s would take about 17 minutes. 1,000 would take 3 hours.
Full details will be posted soon. For now, I’m just looking for a few beta testers. ***Please bear with me as this is very much a draft version. There are many features I intend to add, but since the latest release of the Mozscape API broke our previous macro, I’m releasing this untested in case anyone really needs the data. Your support and patience is very much appreciated.
[Update 9/8/2012 : If you're not seeing any data, it's because of a change to the Mozscape API code. They now require that we explicitly list which url-metrics we want to return by using bit flags. I'm expecting to release a new version today that will fix this as well as a few of the other bugs we've seen. More info here: http://apiwiki.seomoz.org/deprecated#default-metrics ]
[Update 9/10/2012 : We've updated the code to use bit flags, fixing the previous issue. Individual bit flag selection has been added as a todo item, as it's best to only retrieve the minimum amount of information you need.
Automatically trims access id and secret key to remove extra spaces.
Installs prerequisite software, such as .NET 4.0 and VSTO Runtime. ]
*** Download the latest version here. ***
[[ This version has only been verified to work with Excel 2010 on a computer running Windows 7. If you get it to work on any other setup, please let us know. ]]
Mozscape Add-in : Beta 1 (9/4/2012)
MozscapeAdd-in : Beta 2 (9/10/2012)
MozscapeAdd-in : Beta 2.2 (9/10/2012)
MozscapeAdd-in : Beta 2.3 (9/11/2012)
Please post any questions or suggestions in the comments below. To receive a notice of each release, enter your name and email in the box below. Thanks again for your support!