Getting PA & DA off of a list of links
-
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
-
It works, thanks a million! I recommend Martijn's tool for anyone having this need.
-
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!
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
How do you determine how much a link is worth?
Obviously things like Mozrank, domain authority, relevancy signals, authority signals, and other fundamentals are a great starting ground, but I was wondering how people put value on a links. How much time is a link from a page rank of x or a moz rank of y worth. How much time, money (not in terms of paid links, but in terms of manpower, copyrighting required, etc.) is a link of a certain rank worth. Obviously there is no exact answer to this question, but I'm very curious to see what people have to say in this regard.
Moz Pro | | Oren.0 -
AM I the only one getting misleading titles in OSE?
I am trying to locate directories in my competitor's links using OSE. Here is the workflow I am using: Filter all results to external sites only, group by site, linking to any page on the domain. Export results to csv. My competitor is in the web design industry. So I try to filter the titles of the pages linking to the competitor to look for titles containing directory. But when I click on the link for "Windsor Internet Web Design Hosting Ontario Canada Directory" I get a page with the title "Kitchen & Bathroom Showroom | London Ontario | Bathroom Vanity Showroom" Are the results really this misleading?? or am I doing something wrong here? Any insight or help would be greatly appreciated.
Moz Pro | | tdlabs0 -
Opensiteexlorer - Download CSV show different links
Making backlink report, got results -> Download csv Open downloaded csv in excel, it is different links set inside - copied some urls from the web interface and could not find them in excel using Ctrl+F... wtf?
Moz Pro | | Liston810 -
Do SEOmoz private questions get answered?
I submitted a question on September 30 and never received a response. I then followed up on October 6 and had an exchange with the support staff, who first told me that the question would be answered and then a couple of days later told me that they had no record of the question. By chance, I had taken a screen shot showing confirmation that the question had been sent (just something I did to remind myself to follow up if I didn't get a response!), which I sent to them along with the question again. That was four days ago, and I've heard nothing since then - not even an automated email saying that the question was received. Is it common for it to take almost a month before a response is received, and to have to follow up multiple times just to get an answer?
Moz Pro | | csmm0 -
No follow Internal Links
Hello, I am comparing my site with my competitors. According to Open Site Explorer, my site has 541 internal follow links, and a total of 1,286 total internal links, implying I have 745 no follow internal links. I tried to drill into these internal no follow links using the "Inbound Links" report in OSE. But I'm receiving an error stating that No Data is Available for this URL. Does anyone have any insight to this? I'd really like to understand where those no follow links are coming from. Thanks in advance. eh70
Moz Pro | | TheBOTWGuys0 -
What can i use instead the juicy link finder?
I need to find authority links and i used to find them with juicy link finder, i tried to find them with open site explorer and link acquisition, but there´s no solution. Please, what can i use?
Moz Pro | | AbacoDigital0 -
OpenSiteExplorer is not seeing all my inbound links
I know I have back links to my site from about 5 or 6 websites and most of them even show in my Google webmaster account but according to OSE I only have 1 inbound link. Is it normal for the OSE stats to be wrong? I really want to use it but am worried the info isn't going to be accurate.
Moz Pro | | JasonHegarty0 -
SEO Industry Contracts, Resumes, & Jobs
We're in the process of looking to hire link builders & content managers in the Chicago area. While I know it's not a "core function" of SEOmoz, the SEO Industry Jobs section has been very helpful to us. Unfortunately, it's not easily searchable/filterable by geography. I think the Moz resume & job-board could be a lot more helpful with some updates, including filter by geography. Anyone else have any suggestions?
Moz Pro | | Gyi0