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
-
MozBar Chrome - Can I turn it back on?
I'm using Chrome 27.0.1453.110. I installed the Moz toolbar and lost the send button in gmail. Didn't matter how I sized the window it was out of view. So I closed the Moz toolbar while I did my mail. But now I don't know how to bring it back up. Does anyone know how to turn it on again? It is still installed.
Moz Pro | | rcullet0 -
Is www.domain.com/page the same url as www.domain.com/page/ for Google? (extra slash at end of url)
Dear all, in open site explorer there is a difference the url's 'www.domain.com/page' and 'www.domain.com/page/' (extra slash at end). There can be different values in pageauthority etc. in the open site explorer tool, but is this also the case for Google? Thanks for replying, Regards, Ben
Moz Pro | | HMK-NL0 -
How many competitors can you track?
Hi All, How many competitors can you track in a campaign? It appears to only allow 3 competitors. Thanks,
Moz Pro | | toby-02
Toby1 -
Need to find all pages that link to list of pages/pdf's
I know I can do this in OSE page by page, but is there a way I can do this in a large batch? There are 200+ PDF's that I need to figure out what pages (if any) link to the PDF. I'd rather not do this page by page, but rather copy-paste the entire list of pages I'm looking for. Any tools you know of that can do this?
Moz Pro | | ryanwats0 -
Why does it take so long for SeoMoz to update data?
I changed the Anchor Text of 4 40/100 MozRank sites 2 months ago, yet SeoMoz still shows the old Anchor text in the reports. Why is this taking so long? I also notice my inbound domains hasn't increased nor has my MozRank in 3-4 weeks. What's the turnaround?
Moz Pro | | sanchez19600 -
Does the Moz Toolset offer anything like Raven's Backlink Explorer from fresh index
It seems like a useful feature where I can see what backlinks look like right now vs. the last monthly Moz dataset update. That is mostly because my site is new, but wondered if I was missing something. Thanks, Steven
Moz Pro | | sfmatthews0 -
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