Batch lookup domain authority on list of URL's?
-
I found this site the describes how to use excel to batch lookup url's using seomoz api.
The only problem is the seomoz api times out and returns 1 if I try dragging the formula down the cells which leaves me copying, waiting 5 seconds and copying again.
This is basically as slow as manually looking up each url. Does anyone know a workaround?
-
You'll have to do this in Google docs and not in Excel, but try this solution:
http://www.seomoz.org/ugc/updated-tool-seomoz-api-data-for-google-docs
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
-
Moz Domain Authority 27
Hi there, I have been reading up about Domain Authority being important to rank though I have a question about it. When trying a few google searches and using a tool to see the Moz Domain Authority i notice the following. I won't mention sites or keywords, happy to send them via private message if required. A site ranks 1st position for most keywords including the main keyword that related to their industry, a highly competitive keyword. Their Moz Domain Authority 27, Est. Visits: 265,000, Pinterest shares 72, Facebook shares 191 and unique domains that point to it are 55. Yet when I look at another site, optimising for the same keyword, Moz Domain Authority 50, Est. Visits: 60,000, Pinterest shares 35000, Facebook shares 20000 and unique domains that point to it are 521. I would have thought that the second site ranks 1st for the keyword and the first one mentioned which is in 1st position I would have expected to be on page two or three. as I scroll down the first page for the term, all sites except for one have higher DA, visits, shares and so on. If a high PA is required can someone help me to understand the above example? Whn a low PA site ranks much better for a primary keyword than all other sites that have a higher PA than it?
Moz Pro | | IvanaDaulay1 -
What tools/software provide the most comprehensive list of backlinks to your domain?
We're currently looking for a product that has the capability of providing a comprehensive list of backlinks pointing to our domain, which currently has 400+ URLs. We've tried SEOMoz Pro, Google Webmaster Tools, and Majestic SEO. Does anyone have any recommendations or tips on getting the best report of backlinks?
Moz Pro | | Collegis_Education0 -
Your opinion on this opportunity's difficulty?
I'm building a tool for mechanical engineers, and I'm trying to find 10 low-competition keywords to target in my first few content marketing efforts. I've got a lot of maneuvering room, so (with a bit of expert advice) I bet I'll be able to find some low-hanging fruit. Here's what I've found: Most keywords are seem to have about 40% difficulty. What's the highest level of SEOmoz "keyword difficulty" that a new website should reasonably try for? Some ranking high-authority pages are don't appear to be targeted at the term Is it fair to say that I could beat any page with less than a 'C' ranking for on-page optimization? (Assuming I target the term with general best practices)* Thanks! If you're interested, here is my current process: Go on engineering blogs for keywords Use Wordstream's Keyword Suggestion Tool for ideas around it Use Google Keyword Tools for keywords above 50 searches in direct match Use SEOmoz Keyword difficulty report, looking more deeply at keywords under <50% If I can find a top 10 page that's less than 30PA and less than 40DA, or has less than 'C' ranking for on-page optimization, I consider the keyword achievable within 3mo, using general best practices. *Except for YouTube/Wikipedia/etc
Moz Pro | | 49wetnoodles0 -
How to handle 2 domains pointing to the same server.
My client has 2 domains which point to the same sever. eg a.com and b.com both point to the same place. For now a.com has better seo but the client wants to switch to using b.com more. Im guessing 301 redirects will not work in this case. How would I handle this? If i'm forced to manage both domains, what is the best practice for monitoring in seomoz pro. Should i set up a.com as a competitor?
Moz Pro | | eztrans0 -
Competitive Domain Analysis Question
When looking at the Competitive Domain Analysis I noticed that I am the only one amongst my competitors that does not have a link from DMOZ. The problem is, I do have a link from them. When you search for my site on dmoz.org you can find my site and it has been that way for quite a while. Anyone know any possible reasons it may be doing this?
Moz Pro | | ClaytonKendall0 -
How do I get the Page Authority of individual URLs in my exported (CSV) crawl reports?
I need to prioritize fixes somehow. It seems the best way to do this would be to filter my exported crawl report by the Page Authority of each URL with an error/issue. However, Page Authority doesn't seem to be included in the crawl report's CSV file. Am I missing something?
Moz Pro | | Twilio0 -
Has SEOMoz Domain Authority calc been updated recently
As ever, my apologies if this question's been asked before -- I searched for it, and didn't find it. But, our SEOMoz 'Domain Authority' has recently really jumped (from 67, where it was for many months, to 77). And, our number of Linking Root Domains increased as well, from 1,986 to 3,349) Of course, none of this has translated into Google goodness, but if any of it's true, maybe it WILL in the future? Any thoughts/ideas? Thanks, Dave (www.TeachStreet.com)
Moz Pro | | daveschappell0 -
What's name of SEOmoz and Open Site Explorer robots?!
I would like to exclude in robots.txt SEOmoz and Open Site Explorer bots to don't let them index my sites… what's their names?
Moz Pro | | cezarylech0