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
-
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 -
Overly Dynamic URLS
I should be able to set URL Parameters in my Google Webmasters Tool that allows be to stop my overly dynamic page URL problem. Please help me on how to do this.
Moz Pro | | pinksgreens0 -
Data Missing In Pro Account
Hi All, I've been using Pro for a couple of years with nothing more than the occasional glitch, however, almost every day there is some kind of data missing from a campaign or two within my account recently. It's got to the point that I send a support ticket most days, no matter how insignificant the problem. Often I just need to disconnect and reconnect Analytics, but it's becoming very frustrating. Is it just me who's having these issues or do other people have the same problem recently? Thanks, Steve
Moz Pro | | Stevie-G0 -
Can I setup SEOmoz PRO's 3 organic traffic metrics within Google Analytics (as custom reports)?
I like the 3 organic traffic metrics in SEOmoz PRO: 1) Organic Search Visits
Moz Pro | | AndreVanKets
2) URLs Receiving Entrances Via Search
3) Non-Paid Keywords Sending Search Visits They rock - especially for a high-level view of SEO / Organic performance. Is it possible to setup these metrics as custom reports directly in Analytics? Does anyone have these reports setup? Or maybe there are similar custom reports that give a similar high-level view?0 -
Issue with Data Updates on Campaign
I'm reviewing a campaign I am running for a client, the Keywords data has not updated yet even though it's supposed to update every monday. The competitive analysis shows a date of August 14, which is odd becuase I'm on a trial account?
Moz Pro | | amerihope0 -
Issue with Data Updates on Campaign
I'm reviewing a campaign I am running for a client, the Keywords data has not updated yet even though it's supposed to update every monday. The competitive analysis shows a date of August 14, which is odd becuase I'm on a trial account?
Moz Pro | | amerihope0 -
OSE Latest Update?
As of yesterday's OSE update alot of sites that I'm tracking saw their PA & DA drop significantly. This was for multiple sites, whereas last month's index saw those stats increase significantly. Has anybody else seen this happen to them and perhaps drawn any conclusions?
Moz Pro | | MichaelWeisbaum1 -
When using Wordpress, why does it show up so many meta data errors on here and on google webmaster? A list of do's would be good?
Using wordpress is a good CMS, yet there sre so many meta data errors occuring, is there a list of what to look out for and good practices when using wordpress?
Moz Pro | | CosmikCarrot0