How can I Pull OSE Data for Multiple URL's at once
-
I'm putting together a link prospecting csv (very basic/simple). I'm doing my own manual hunting for link prospects and compiling them in a list in that excel doc. Once I'm done with that, I want to pull OSE data on a larger scale (MozRank, PA, DA, etc.). I know Niel Bosma's SEO tools for Excel exists, but I have a Mac, and it's not available for that. And I can't really pay for any of the big tools right now (ie BuzzStream). Does anybody know of a good tool or way of going about pulling this data in a way that will save time? As opposed to pulling data for each URL one by one. ANY tips would be GREATLY appreciated.
-
Thanks to both of you. Cyrus, I took a look at those tools over the weekend and they're definitely going to help and exactly what I was looking for.
-
Sounds like your looking for the Site Intelligence API, although it might require a bit of a learning curve, depending on your experience. That said, it's really the only way to do what you are looking for. Once you get the hang of it it's really quite easy, and it's how a lot of SEO agencies like Distilled get their information.
There's a free or paid version of the API. The instructions for getting a key can be found on the site.
Aside from the resources Brian mentioned, you might find the following helpful.
Easy API (paid, haven't tried it so I can't vouch for it, but might be interesting)
Beginners Guide to SEOmoz's API
Linkscape and Google Spreadsheets
Agile Tools using Google Spreadsheets
Hope this helps.
-
Hi Michael,
Tom Anthony wrote a great introduction on the SEOmoz Blog here on how to use Google Docs to help automate this kind of work. Check out his post here: http://www.seomoz.org/blog/competitive-analysis-in-under-60-seconds-using-google-docs-12649
There's still some work to do to set it up and configure it the way that you want, but it'll help get you closer to what you're looking for with automating OSE reports.
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
-
Spam score very high but it's not clear in MOZ, it looks like a bucle
Hey there, I've a problem with this domain www.cornerjob.com In OSE just saw a spam score very high and so, I tried to see backlinks' profile in order to find suspicious backlinks. But in OSE there's a bucle, I mean: I know my domain has a high spam score but I cannot see any bad backlinks, actually the only one I see it's the same www.cornerjob.com...for that, It's a bucle. I tried to use other tools but I wasn't able to see backlinks, actually we don't have many. What Should I do in order to fix it? What does spam score mean? Thanks in advance Francesca
Moz Pro | | Nuvolaa0 -
Can we disavow all spammy looking sites in OSE with a spam score of 5 or above?
Hello, We'd like to use OSE to make a disavow list. Can we just go through everything with a spam score of 5 or higher that looks like spam when we visit the site and disavow all of them? I'll be using Moz pro, are there any other free tools that I can utilize? What do I keep in mind? Thanks!
Moz Pro | | BobGW0 -
Where has the old seomoz crawl tool gone? I can't seem to find it
I'm looking for the (SEO)moz crawl tool - but can't find it. Where has it gone?
Moz Pro | | SearchMotion0 -
Can not start a SEO MOZ campaign?
I keep getting this message, I have a 301 from my domain to my domain with the www prefix. What's the deal? We have detected that the domain www.photosbykristopher.com and the domain photosbykristopher.com both respond to web requests and do not redirect. Having two "twin" domains that both resolve forces them to battle for SERP positions, making your SEO efforts less effective. We suggest redirecting one, then entering the other here.
Moz Pro | | KrisPhoto0 -
Urgent: Campaign set up 'Select Competitors' errors
Hi. Im setting up my first campaign and Im having issues with step 3: 'Select your competitors to track'. I only want to track 1 competitor: http://en.wikipedia.org/wiki/Ryan_Murphy_(writer) When I enter this and the competitor name into the form provided and click 'continue to next step' it throws an error at me: Darn, there are errors in your form! Don’t worry, Roger can’t feel pain. Competitors domain http://en.wikipedia.org/wiki/ryan_murphy_(writer) may not have a /path after the host Domain http://en.wikipedia.org/wiki/ryan_murphy_(writer) may not have a /path after the host Can anyone help me as this is urgent.
Moz Pro | | RyanSMurphy1 -
OSE doesn't report backlinks from groupon.ca or tuango.ca. Is that possible?
Hi there, Open Site Explorer doesn't report backlinks from groupon.ca or tuango.ca. Is that possible? Thanks, Adrien
Moz Pro | | AdrienOLeary0 -
Can I see search volumes against my keywords?
I love the keyword tracker tool on SEO Moz. However I can't work out how to see search volumes for each keyword. So while I know how I am ranking for each keyword.....I have to open a separate spreadsheet to see the local Google Monthly search volumes and then cross-refer the two, which is clumsy and time-consuming. Is there a way to amalgamate the two? It seems like such a major flaw that i'm sure its there, I can't work it out. Thanks all, Dan
Moz Pro | | danfk0