What is the quickest way to get OSE data for many URLs all at once?
-
I have over 400 URLs in a spreadsheet and I would like to get Open Site Explorer data (domain/page authority/trust etc) for each URL.
Would I use the Linkscape API to do this quickly (ie not manually entering every single site into OSE)? Or is there something in OSE or a tool I am overlooking?
And whatever the best process is, can you give a brief overview?
Thanks!!
-Dan
-
Thanks John!
FYI, for anyone else looking for a solution, Mike King also pointed me towards this: http://www.tomanthony.co.uk/blog/seomoz-linkscape-api-with-google-docs/
-
As I just told Dan on Twitter, I built out a spreadsheet a few months ago that is linked to in this post: http://bit.ly/mc0Q9v.
You'll have to use your own Moz free API key and hack the sheet a little bit, but it uses the Moz and Twitter APIs to pull the Moz metrics (DA, PA, etc) into a Google doc.
Good luck Dan and anyone else who reads this!
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
-
Unsolved Solve a Lost GA Connection - can't get it to work
Hi, I followed all steps on https://moz.com/help/moz-pro/getting-started/troubleshoot-google-analytics?_ga=2.15852085.2007735045.1676157945-122376721.1676157945 below Solve a Lost GA Connection multiple times but I keep getting the message "Our connection to your Google Analytics account was lost. Don't worry, you won't lose any data. Please follow the steps in our guide to reconnect.
Moz Pro | | silvansoeters
" I am on the free trial and would obviously like to connect to GA to see how everything is working. Any help would be greatly appreciated. Thanks.0 -
Is there a report that shows how many times your keywords are searched?
I see the keyword ranking report but I need a report that shows the number of searches on those keywords, Thanks!
Moz Pro | | AFSB0 -
Why is OSE so infuriatingly annoying
Damn thing tells me the www.domain im researching has 599 links internal and external. I download an advanced report for the whole root domain of external links....and its come up with 64 in a csv file.....wtf is that about? The data about root domain says i have External Followed Links 408 and
Moz Pro | | xtopher66
55,736 total links...........which is BS. this site hasnt enough internal or external to shoot from the low figure up to 55,0000 By the way, im a 79 tall but ive never meaured my height.. Sounds like SEO data!0 -
Can we add sites to the crawl queue for OSE?
Is it possible to request that Open Site Explorer crawls a new URL on its next run? This tool is the first place I go to when working on a new site, and when there is "No Data Available" this is a little frustrating. I fully appreciate that this lack of data is usually a signal that the website is either very new or of low quality, however that if often the reason that I am brought in and would very much like to benchmark and provide initial analysis using this tool. It would make sense that OSE crawls the sites that Moz members are working on wouldnt it? Scott.
Moz Pro | | eseyo0 -
Finding the source of duplicate content URL's
We have a website that displays a number of products. The product has variations (sizes) and unfortunately every size has its own URL (for now anyway). Needless to say, this causes duplicate content issues. (And of course, we are looking to change the URL's for our site as soon as possible) However, even though these duplicate URL's exist, you should not be able to land on them by navigating through the site. In theory, the site should always display the link to the smallest size. It seems that there is a flaw in our system somewhere, as these links are now found in our campaign here on SEOmoz. My question: is there any way to find the crawl path that lead to the URL's that shouldn't have been found, so we can locate the problem?
Moz Pro | | DocdataCommerce0 -
Canonical link on canonical url
This might seem a bit of an odd one, but we seem to be going around in circles on this when using the on page optimizer tool. We have an ecommerce site (magento) which by default is putting a canonical link in the header on every product page. For example; www.example.com/product1.html has the But when we run the on page optimiser tool, we're losing points on the critical section for not having canonical set correctly. If we remove the tag, we get the tick and the a grade, but then further down the report we lose a tick for not using canonical links. What are we missing here?
Moz Pro | | andyjsi0 -
My followed backlinks tab is not showing any data?
My followed backlinks tab is not showing any data for any of my campaigns. other tabs are shwoing data like top pages but nothing under followedbacklinks. Is anyone else having this problem?
Moz Pro | | Dataken0 -
OSE Advanced for specific directory only?
Pls how do I set up Open Site Explorer Advanced to look for backlinks to files in ONLY a certain directory? so if the domain is 1234.com, I don't care about links to 1234.com. OSE can find those very neatly! What I do care about is ONLY links to 1234.com/profiles and I can't seem to figure out a way to do this. the /profiles directory has thousands of profiles in it - and we think we have hundreds of thousands of backlinks - so ideally, I'd like to use regex or DOS like filtering to look at only those which start with 9 or 8 or whatever.
Moz Pro | | seo_plus0