How can I Pull OSE Data for Multiple URL's at once

[MichaelWeisbaum]

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.

[SarahGoliger]

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.

[Cyrus-Shepard]

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

SEOmoz API with Excel

Agile Tools using Google Spreadsheets

Hope this helps.

[MichaelWeisbaum]

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.