How to check Mozrank and/or Moztrrust in Bulk

[StephWeigert]

Hi guys,

I've been scouting the web and the SEOmoz forum to look for a way to check the Mozrank and/or Moztrust of urls in Google docs or Excel. I know Chris Le wrote a post about this but I want to check ~ 2000 links. Is there a way to do this easily in a spreadsheet?

Regards.

[LynnPatchett]

In Google Docs you can do this using the (awesome) Seer Interactive Toolbox, check it out here:

http://www.seerinteractive.com/seo-toolbox/index.html

[StephWeigert]

Hi Lynn,

I know how to add the Api credentials but how do I make a code that shows me the mozrank, DA, PA and moztrust in bulk?

[LynnPatchett]

Hi,

So if you have a list of urls in the A column and the A1 field has a title 'urls' or similar then you select the B1 field and in the formula box (fx) up top you can put something like

=getLinkscape(A2:A92)

Which will pull the data for the urls listed from the fields A2 - A92.

I have found that you have to have a multiple of 10 so you don't get a timeout error, I think the script bunches the urls into groups of 10 and it seems to have an issue if there is an odd number. So if you have 99 urls, add another one to make a round multiple of 10!

You can see some more tips here: http://www.seomoz.org/ugc/updated-tool-seomoz-api-data-for-google-docs

Hope that helps! Its a really useful tool.

[StephWeigert]

Thanks for your help. It works but somehow I can't check it for more then 50+ links. So I manually copy paste all the urls. Is this because of my pro membership level? I have a normal PRO membership. I hope there is an other way because I want to check it for around 1980 links :-).

Thanks for your patience.

[LynnPatchett]

Hi,

Yeah I seem to not be able to get past 100 now for some reason. I remember I had some luck with this excel add-on in the past. I think it limits to 1 request every 10 seconds so if you have a big list better to leave it run over night, but it does the job and gets the data into excel so worth a shot!

http://www.businesshut.com/seo/seomoz-mozscape-add-in-for-excel/

You could also check out the seogadget excel for the moz api, I have not managed to give it a good go through, but it should also be able to do the job:

http://seogadget.com/mozscape-api-extension-for-excel/

Hope one of them helps!

[StephWeigert]

Thanks for your answers It worked!

[T0BY]

Thanks guys, very helpful advice.