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
-
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 -
Remove geographic modifiers from keyword list
I just pulled a search term report for all of 2013 from my PPC account. What I got was 673,000 rows of terms that have garnered at least 1 impression in 2013. This is exactly what I was looking for. My issue is that the vast majority of terms are geo-modified to include the city, the city and state or the zip code. I am trying to remove the geographic information to get to a list of root words people are interested in based on their search query patterns. Does anyone know how to remove all city, state and zip codes quickly without having to do a find and replace for each geo-modifier in excel? for example, if i could get a list of all city and state combinations in the US and a list of all zip codes, and put that list on a separate tab and then have a macro find and remove from the original tab any instances of anything from the second tab, that would probably do the trick. Then I could remove duplicates and have my list of root words.
Moz Pro | | dsinger0 -
How accurate is SEOMoz's keyword analysis tool?
For the most part, SEOMoz's keyword analysis tool has been in line with other tools like Adwords keyword tool with regards to competitive level. I have just encountered a keyword though that a client may choose to compete on that seems to be far off. keyword phrase: online math games Adwords competitive level: Low SEOMoz competitive level: 80 This seems like a sizeable difference (I know the two compare all results vs first page authority's, but typically they are in line with each other). With other related keywords for the industry in question, SEOMoz and Adwords seem to be in line. This one just got me thinking. I know the SEOMoz score is a sign of the strength of the top results and that the "low" score from Adwords may be a sign of much weaker results on the following pages (with a higher number of weaker pages vs fewer high authority outliers). **Question: ** How accurate is SEOMoz keyword analysis tool and what other keyword analysis tools are you guys/gals using that you like? I have tried others but many provide duplicate insights.
Moz Pro | | mattylac0 -
How can I get a report of the top 500 national sites using Domain Authority and Page Authority? Does someone have to type sites in one by one on Site Explorer or is there another way?
I want to know what sites and blogs have the to rankings overall based on their Domain Authority and Page Authority - Top 500 - 1000 in nation - I want to know which ones are follow and no-follow too - Does anyone know? Has anyone run such a report yet? Thanks for help - BD
Moz Pro | | creativeguy0 -
Here's a hard one! Why isn't my profile picture displaying as an avatar iin forums and blogs?
My profile pic is updated and displays on my profile but I still have the default avatar beside all forum and blog posts... This is life or death... I must know the answer. 😉 Thanks guys.
Moz Pro | | Anthony_NorthSEO0 -
Twitter Page Authority Score?
I've been doing some competitive research in Open Site Explorer and many of our competitors have Twitter accounts very similar to ours. Their Twitter pages are usually one of the pages with linking to their website with the most Page Authority. The incoming links from Twitter are a "no follow" as you would guess. This has been the case for a large number of well ranking sites I have looked at. www.dremed.com also has a Twitter account at: https://twitter.com/#!/DREmed . However, Open Site Explorer does not list the Twitter link as an incoming link at all ( or if it does it has no Page Authority ). The Twitter account page seems very similar in nature to other competing Twitter pages. I'm not sure why it does not ALSO pull a high Page Authority score??? Do you know why this might be? Best, Justin
Moz Pro | | justinjeffries0 -
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 -
How do I get a list of my non-followed links
Our site has a lot of non-followed links showing up on the latest SEOMoz Competitive Link Analysis update and I would like to know how to get a list of the sites that aresettin no-follow.
Moz Pro | | oznappies0