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
-
Best Keyword Strategy for Lower-Authority-Ranked Domain
Hi, What should a lower-authority-ranked blog (DA - 21) who is trying to increase general traffic focus on above all when selecting keywords: difficulty, monthly volume, opportunity, or priority? I know that all are important factors to consider, but I fear that without an already consistent following our new content will just get hidden behind more established domains if we select too difficult of keywords. I'd love to hear from someone who's built up a blog audience as to what strategy they used here. Thanks!
Moz Pro | | ascott7770 -
Pages with URL Too Long
Hello Mozzers! MOZ keeps kindly telling me the URLs are too long. However, this is largely due to the structure of E-commerce site, which has to include 'brand' 'range' and 'products' keyword. For example -
Moz Pro | | tigersohelll
https://www.choicefurnituresuperstore.co.uk/Devonshire-Rustic-Oak-Bedside-Cabinet-1-Drawer-p40668.html MOZ recommends no more than 75 characters. This means we have 25-30 characters for both the brand name and product name. Questions:
If it is an issue, how to fix it on my site?
If it's not an issue, how can we turn off this alert from MOZ?
Anyone know how big an issue URLs are as a ranking factor? I thought pretty low.0 -
Domain Authority
Hi, I've been adding links to my site on directories, article sites and relevant industry blogs. I've also been given and a budget for Google Ads, which has also increased traffic. In the last week my Keyword positions have risen. However, my domain authority has reduced. I know the most important thing is improving traffic and keywords but I'd like to know how I can improve my domain authority. What is causing it to reduce and how can I improve it? Cheers,
Moz Pro | | desktop_nev
Neville0 -
Where is the directory list now living?
Hi - I'm trying to access the directory list that used to live at this address: http://www.seomoz.org/directories But I am being redirected to: http://www.whitelistproject.com/ with no explanation. Where is the directory list now living? Thanks T.
Moz Pro | | tone4u_gmail.com0 -
Crawl Diagnostics Shows thousands of 302's from a single url. I'm confused
Hi guys I just ran my first campaign and the crawl diagnostics are showing some results I'm unfamiliar with.. In the warnings section it shows 2,838 redirects.. this is where I want to focus. When I click here it shows 5 redirects per page. When I go to click on page 2, or next page, or any other page than page 1 for that matter... this is where things get confusing. Nothing shows. Downloading the csv reveals that 2,834 of these are all showing: URL: http://www.mydomain.com/401/login.php url: http://www.mydomain.com/401/login.php referrer: http://www.mydomain.com/401/login.php location_header: http://www.mydomain.com/401/login.php I guess I'm just looking for an explanation as to why it's showing so many to the same page and what possible actions can be taken on my part to correct it (if needed). Thanks in advance
Moz Pro | | sethwb0 -
OSE Domains & Subdomains
Is there a compelling reason that OSE treats subdomains as part of a parent domain, rather than as a separate site? Or is this just a technical limitation? I ask because it's my understanding that Google treats subdomains more like separate domains than like parts of the parent domain. OSE treating them more like folders creates some frustrating situations when researching niches that are heavily filled with blospot and wordpress.com blogs. First of all, the domain authority in these situations is not at all indicative of the strength of the site. It also makes it hard to evaluate linking root domains at a glance, since all blogspot blogs count as one domain. So to see all blogspot sites linking you have to go to the full link list -- where each site may be listed hundreds of times -- and you can't group them because they're all considered the same domain. To be sure you when researching these niches you can just throw out domain authority as a metric, and export every report to excel where you can sort things in a way to make it easier to separate sites. But if there isn't a compelling SEO reason to have OSE function this way, I'd love to see those subdomains treated as separate sites so I can have access to all the easy to use SEOmoz metrics and layouts without the extra work. And of course if there is a compelling SEO reason for subdomains to be treated as domains, I'd love to be educated! : )
Moz Pro | | Ecreativeworks0 -
Does the Moz Toolset offer anything like Raven's Backlink Explorer from fresh index
It seems like a useful feature where I can see what backlinks look like right now vs. the last monthly Moz dataset update. That is mostly because my site is new, but wondered if I was missing something. Thanks, Steven
Moz Pro | | sfmatthews0