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
-
Do you get link equity from a redirect service?
When using a redirect service, do you get link equity from the redirect service or only from the linking website? Using opensite explorer in Moz, always shows me directory and redirect services as most important contribution for the domain authority. But I'm questioning if this is true. P.S. I'm not asking if link equity is passed from the linking website. That question has been answered many many many times. (hint: the answer is yes). H58xHAl.png pGH7e48.png
Moz Pro | | jasny0 -
Why am I getting all these duplicate pages?
This is going for basically all my pages, but my website has 3 'duplicates' as the rest just have 2 (no index) Why are these 3 variations counting as duplicate pages? http://www.homepage.com http://homepage.com http://www.hompage.com/index.php
Moz Pro | | W2GITeam0 -
Is there a way to get SEOMOZ to not throw an error if i'm using the rel=canonical tag?
There are so many errors (~1500) that I can't find the pages with duplicate content among the ones that are correctly tagged
Moz Pro | | seospeedwagon0 -
Blog Post Not Picked up by OSE
How come this blog post of mine which got lots of links has not been picked up by Open Site Explorer: http://infographicdirectory.wordpress.com/2012/08/22/the-internet-a-decade-later/
Moz Pro | | Eavesy0 -
Help with URL parameters in the SEOmoz crawl diagnostics Error report
The crawl diagnostics error report is showing tons of duplicate page titles for my pages that have filtering parameters. These parameters are blocked inside Google and Bing webmaster tools. I do I block them within the SEOmoz crawl diagnostics report?
Moz Pro | | SunshineNYC0 -
How often does Organic Traffic Data update?
The latest traffic I see is from week ending 2nd Jan 2011, this seems an overally long time to wait for a traffic update, given that tools such as Raven can provide live stats.
Moz Pro | | Grumpy_Carl0 -
How to get seomoz to re-crawl a site?
I had a lot of duplicate content issues and have fixed all the other warnings. I want to check the site again.
Moz Pro | | adamzski0 -
Filtering OSE Results
Issue: When I export OSE Linking Pages results to .CSV, I'd like to filter only unique domains. It seems to me that there should be a way to do this with Excel, perhaps pivot table. Anyone have a quick solution for this? Alternatively, I can use Linking Domains, which gives all unique roots, but then i lose follow/nofollow filter. Thoughts?
Moz Pro | | Gyi0