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
-
Couple of Moz's bugs
There are still some bugs in a new Moz: I can still find a lot of mentions of "SEOMoz", for example: in a footer, in a Q/A form (SEOMoz Resources), in a new question form (SEOmoz PRO Application, SEOmoz Tools, etc.) On a main form (http://moz.com/pro/home) sometimes my full name is not visible at all, sometimes my MozPoints are hidden (on a left top corner); There is not direct link from http://devblog.moz.com/ to a main website; Regards.
Moz Pro | | ditoroin0 -
What Are Roger's Super Powers?
I ended up with a box of SEOMOZ swag. (Thanks! As to how this came to pass...I shall draw a veil, as they used to say in Victorian novels.) My upstairs neighbour Max, age 5, enjoys a rich fantasy life and is very much into superheroes and costumes. Naturally, he ended up with a lot of the Roger stickers. Alas, I was unable to answer all of Max's questions. When he asked: "What does Roger do?" I replied: "Roger makes your computer work." Pretty good, I thought. But then Max asked: "What does the antenae do?" I was kind of stumped. Then it got worse. Max asked what Roger's superpowers are and if he could beat Spiderman. I tried to change the subject. Max wasn't impressed. What are the answers? Enquiring five year old minds want to know!
Moz Pro | | DanielFreedman6 -
Can't log into Firefox MozBar
I just downloaded and installed the MozBar for Firefox, but it will not let me login to my account. The Log In button is gray and none of the buttons do anything when I click on them. Please help! Thank you,
Moz Pro | | Instabill
Meghan0 -
Mozcape API Batching URLs LIMIT
Guys, there's an example to batching URLs using PHP: http://apiwiki.seomoz.org/php Which is the maximum number of URLs I can add to that batch?
Moz Pro | | Srvwiz0 -
What's Your Thought About Market Samurai as An SEO Tool Compared to SEOMoz?
What is your opinion about Market Samurai tool as a SEO Tool? I have used it and found it good for analyzing the top 10 competition, getting anchor text profiles and so on. SEOMoz is cool, but has a lot more features. However it lacks keyword research tool. We really cant compare the two tools in terms of pricing because the cost of the MS tool for a lifetime is what will cost SEOMoz membership for a month. What;s your take on this?
Moz Pro | | ConversionChamp0 -
Using the 'Organic Traffic Data ' feature.
I don't have access to the clients Google Analytics Password. Can you set it up without being redirected to Google webmasters? Is there a way to insert a simple code into the website and then have SEOmoz double check the code? Thanks so much
Moz Pro | | Robin_Jennings0 -
How do data feeds work in product selection
Hi – I don't know if this is an SEO matter or not, but I have data feeds to Google, Bing and thefind.com for all of my products. I have no idea if these feeds help. My guess is that they do not generate much business. For example if I type in "Brass Bookends" our products usually don't show up until the late pages. Using this as an example does anyone know how these sites select the order in which they display products? Another way to phrase this is what makes thefind.com show a competitor's brass bookends several pages before ours? FYI we have been doing these data feeds for a year on a consistent basis so being new shouldn't be a factor. Any insights will be most appreciated. Thanks. Don. www.uniquegiftsanddecor.com
Moz Pro | | uniquegifts-2778790 -
What's with the new Q&A set up?
In the old Q&A set up your response was automatically given a thumbs up by you so that you got a mozpoint for every response you gave. Now you have to manually thumb up your responses. Why was this change made? Can we get it back to the way it was?
Moz Pro | | DanDeceuster1