Getting PA & DA off of a list of links

[Fergclaw]

I have a list of links that I want to get PA and DA for each individual link, can this be done in some way other than one at a time? I've heard this can be done with excel and using api but I don't know the specifics of this.. Help would be appreciated

[Martijn_Scheijbeler]

Hi Fergus,

While this option is probably available as an Excel plugin I made this tool which allows you to pull the Page Authority and Domain Authority for multiple links (10 in this case, but more is possible) via the SEOMoz API.

• To get started log in to your Google Account.
• Make a copy of this spreadsheet via: File > Make a Copy.
• You need to follow the steps mentioned in the document to get it working. I experienced 1 small problem with the signature because it was not encoded the right way. Use this tool, to encode the signature if needed.
• You'll have to enter the URLs (including: http://) in column A.

To make this clear, I'm not a great developer myself and learned to build functions like this in Google Docs by following the steps in this awesome blogpost of Tom Critchlow. So you're probably going to find some lacks in the functions I used.

Hope this helps you a step further, please let me know if you have any more questions or feedback on this tool!

[Fergclaw]

It works, thanks a million!  I recommend Martijn's tool for anyone having this need.