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
-
A competitor's SEO firm is building spammy links to my website.
A competitor's SEO firm is building spammy links to my website. I know the disavow link process, but even this can be time consuming. Is there a better way to protect my website? Any and all ideas appreciated.... Are there any cool Moz tools that can help me manage this assault? Sorry, just a follow up from me... It appears that many of the spammy links (referrals) I see in Google Analytics are not present in Google WebMaster Tools. Does this mean that the spammy ones that I'm concerned about have already been discounted by Google, or are the spammy links no-follow? Any input on this would also be appreciated.
Moz Pro | | BVREID0 -
Good job! This URL received an grade A ?
What does this mean ? This page still ranks very bad at Google. So what does it mean that it recives a grade A ?Also, if this URL recives Grade A. It should clearly be optmizied very good on the Keyword. Stil its on page 9 in google. That is very very low on this keyword. Alot of bad blogs, foreign pages, pages without the keyword in heading, pages without any good content etc. rank better.Does this score have anything to do with ranking on google ?Something is clearly wrong with this page. The on-grade tool wont tell me what that it is. And probably dont understand either, since it gives A. Is there anywhere I can check this page on what is wrong with it ?http://www.butikksiden.no/archives/5-toffe-canada-goose-jakker and Canada Goose jakker Re-Grade Pa Good Job! This URL received an A grade
Moz Pro | | butikksiden0 -
What's my best strategy for Duplicate Content if only www pages are indexed?
The MOZ crawl report for my site shows duplicate content with both www and non-www pages on the site. (Only the www are indexed by Google, however.) Do I still need to use a 301 redirect - even if the non-www are not indexed? Is rel=canonical less preferable, as usual? Facts: the site is built using asp.net the homepage has multiple versions which use 'meta refresh' tags to point to 'default.asp'. most links already point to www Current Strategy: set the preferred domain to 'www' in Google's Webmaster Tools. set the Wordpress blog (which sits in a /blog subdirectory) with rel="canonical" to point to the www version. Ask programmer to add 301 redirects from the non-www pages to the www pages. Ask programmer to use 301 redirects as opposed to meta refresh tags & point all homepage versions to www.site.org. Does this strategy make the most sense? (Especially considering the non-indexed but existent non-www pages.) Thanks!!
Moz Pro | | kimmiedawn0 -
My followed backlinks tab is not showing any data?
My followed backlinks tab is not showing any data for any of my campaigns. other tabs are shwoing data like top pages but nothing under followedbacklinks. Is anyone else having this problem?
Moz Pro | | Dataken0 -
How come I cannot ask one question a month to the pro's ?
I just got a major increase of errors on my website on the last crawl. I haven't touched my web site ( other than adding content ) for the past 3 months. It's like more than 500 errors I got on the last crawl, How can I call SeoMoz tech support ? I cannot use my 'One question a month to the pro's a option', cannot select the option pretending I have used my question this month where it is not true. Need help. Thanks
Moz Pro | | processia0 -
Can Open Site Explorer Do This?
Is there any way to set up Open Site Explorer to show these things for competitor external backlinks: Google Page Rank of the page the backlink is on Google Page Rank of the domain the backlink is on Whether the backlink is a follow or no follow Is this possible in OSE? If not, are there any other SEOMOZ Tools that will do this? Thanks.
Moz Pro | | N5c0 -
Where can I view all of the Questions that I have Subscribed to?
I recently asked a question about viewing the questions I have answered already: http://www.seomoz.org/q/where-can-i-view-all-of-the-questions-that-i-have-answered It turns out the link was right under my nose (but it appears a lot of people were having this issue). I'm now having the problem of not being able to see where I can view all the Q&As that I have subscribed to. Again, I may just be missing a link that's right in front of me but it certainly isn't obvious. Any help much appreciated!
Moz Pro | | NickPateman810