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
-
How can I limit the impact of Google's mobile friendly updates on keyword rankings?
Hi everyone, I have a client on a monthly SEO package that is taking a hard hit in the rankings as their website is not mobile friendly. We are currently building a new website for them that will be fully responsive, but face the predicament of how to keep the current site performing relatively well in the rankings in the meantime. The site is generally well optimised and we always follow SEO best practices, so we've hit a bit of a stumbling block as to how to limit any negative impact the mobile friendly updates have on the site. Does anyone have any suggestions for damage limitation? Any help will be greatly appreciated. Thanks.
Moz Pro | | keyzo0 -
Just how accurate is anyone's appraisal on this forum?
When people are discussing what affects their search engine rankings on this particular forum, which has got to be one of the most read on the Internet just how much guesswork is really going on? It seems like God almighty Google works from its own criteria and the rest of us all scrap to guess! I myself in the last week of posted various topics on here and are conflicting reports by so-called experts not that I am being critical for the sake of it. If you to one website and said to all the people on this forum just exactly why is it ranking to a degree for this particular key phrase or not as the case may be would there be any truly accurate knowledgeable answers that will come through and explained the difference? If you have a top 10 of most important things that would influence your rankings that are not guesswork would that be possible to say based on knowledge and expertise? And if so spill the beans what are ? What are the movers and shakers in their particular keyword phrases doing ongoing that's getting them the great results we all want ? Or is the entire subject of how well you rank ultimately not totally understood and only the realms of guesswork based on observation. When I was young I trained as electrician which dealt in facts, it seems like this is not possible with the world of business and search engine rankings?
Moz Pro | | WhitbyHolidayCottages1 -
I'm New To Moz What To Focus On First
Hello, Recently signed up to MOZ for the sites we operate in the UK. I wondered what folks would recommend I focus on first when starting to use MOZ for the first time for sites SEO? Cheers Stuart
Moz Pro | | Urban331 -
Since July 1, we've had a HUGE jump in errors on our weekly crawl. We don't think anything has changed on our website. Has MOZ changed something that would account for a large leap in duplicate content and duplicate title errors?
Our error report went from 1,900 to 18,000 in one swoop, starting right around the first of July. The errors are duplicate content and duplicate title, as if it does not see our 301 redirects. Any insights?
Moz Pro | | KristyFord0 -
Why don't i see a domain mozrank or moztrust?
Why don't i see a domain mozrank or moztrust? The compeitor's numbers work, but not my own site. Thanks a lot!
Moz Pro | | ivordg0 -
How can I find out why my Domain authority has gone down?
I need to find out why the domain authority has dropped 6 points in the last 6 months - any ideas where to start looking?
Moz Pro | | RedC0 -
Domain.com and domain.com/index.html duplicate content in reports even with rewrite on
I have a site that was recently hit by the Google penguin update and dropped a page back. When running the site through seomoz tools, I keep getting duplicate content in the reports for domain.com and domain.com/index.html, even though I have a 301 rewrite condition. When I test the site, domain.com/index.html redirects to domain.com for all directories and root. I don't understand how my index page can still get flagged as duplicate content. I also have a redirect from domain.com to www.domain.com. Is there anything else I need to do or add to my htaccess file? Appreciate any clarification on this.
Moz Pro | | anthonytjm0 -
Where do these URL's come from?! (Indexation issues)
We have an international webshop with languages in the URLs. Our URLs are now set up as follows: http://thermalunderwear.eu/eng/category/product Now, we know that there's some kind of strange redirect problem causing problems with our indexation, this is a technical issue that should be fixed soon. But whether this is the cause of some other strange problems, I do not know. I'd be happy with any help/advice/tips. 1. The SEOmoz site crawler starts at http://thermalunderwear.eu. This currently does not yet redirect to http://thermalunderwear.eu/eng like we want it to, but all the links on the page do include the default language code. So all links on the page are http://thermalunderwear.eu/eng/category etc. However, apart from those URLs, the site crawler finds many URLs in the form http://thermalunderwear.eu/category/product etc., so not including the language variable. Where it gets these I do not know, and since these URLs dont exist and the webshop simply shows the homepage, these URLs all have 50+ duplicate titles/content. Why oh why? 2. If I do a Google search for indexed URL's with English as language, I get many results formatted like this: Coldpruf Enthusiast mens thermal shirt - Thermal wear for men ...
Moz Pro | | DocdataCommerce
thermalunderwear.eu/eng/men/coldpruf-enthusiast-mens-thermal-shirt 170+ items – Fine-ribbed longsleeve thermal shirt men from Enthusiast ... {$SCRIPT_NAME} eng/men/coldpruf-enthusiast-mens-the {$ajax_url} http://thermalunderwear.eu/ajax What are those variables doing there? It looks like it's taking something from our Smarty debug console, which is hidden but still active in the source code, but also the ajax URL which is in a completely different location. What is Google trying to show here?0