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
-
Duplicate content flagged by Moz that's not actually duplicate content at all
Hi, Moz has flagged a whole lot of pages as dupe content, but I cannot see how they qualify as such.
Moz Pro | | Caro-O
Not sure if I'm allowed to post actual URLs here....happy to if I can, but I feel certain that the pages are not 90% similar. Has anyone else had this experience? ~Caro1 -
I have double-checked the rel canonical is properly employed on our page but the On Page Grader says it's not working?
I have double-checked the rel canonical is properly employed on our page but the On Page Grader says it's not working Here is the URL - http://www.solidconcepts.com/industries/aerospace-parts-manufacturing/ What is wrong with how we are doing things?
Moz Pro | | StratasysDirectManufacturing0 -
Can you change the websites in your PRO Dashboard?
Hello, I set a client's website in one of my 5 campaigns in my Pro Dashboard. But my client changed his domain. I don't see an option to change the domain server in the Campaign settings. Is it possible?
Moz Pro | | Eblan0 -
What is the best ranking checker solution for 100's of sites
Hello, We used IBP for over 2 years and it worked great. We were able to schedule every clients site to auto run and email our clients. Now IBP is terrible due to Google's new updates. We are looking for something cost effective since we have 100's of websites we check on a weekly basis. We are either looking for a great software that uses proxies to check, or a service that offers unlimited sites and is cheap per month. We have searched for many, however there are so many that we aren't sure what is good and what isn't. We tried Jonathan Ledgers new one and it's not good, we looked into Web CEO and it's per amount of websites which is expensive. We tried cute rank tracker which is free and added proxies and it doesn't work, it lags out and doesn't even track ranks properly. It wouldn't hurt if it had a built in report analysis of the website as well. So whats a good one?
Moz Pro | | MarketingOfAmerica0 -
Do you miss SEOmoz's Term Extractor Tool?
Do you miss SEOmoz's Term Extractor Tool and want them to bring it back? If you do, please go to this link and submit a feature request form. Here is a brief description for those that are not familiar with what the SEOmoz Term Extractor Tool is;This tool analyzes the content of a given page and extracts the terms that appear to be targeted at search engines. It applies certain weights to HTML elements and other on-page factors to determine what it thinks is a targeted term.
Moz Pro | | brianhughes1 -
No data showing in SiteExplorer
For this site: www.cooperator.biz/ I see no backlinks in SEO Moz Open SiteExplorer but Majestic SEO is showing 13 unique domains linking to it. I regularly encounter zero data for sites that I know have backlinks, why is this? If it's a problem with crawling them, why would I continue to use SEO Moz when other SEO services are showing me links? Kind regards, Rich
Moz Pro | | Boogaloodoood0 -
Can I change the crawl day ?
Hi All I hope there is a simple solution to this - we have a number of campaigns setup which are all crawled, and therefore updated, on different days of the week. We review these weekly and it would be much easier if they were all crawled on the same day. Is it possible to change the crawl day for some campaigns? Thanks Roy
Moz Pro | | bluelogic0 -
Any tools for scraping blogroll URLs from sites?
This question is entirely in the whitehat realm... Let's say you've encountered a great blog - with a strong blogroll of 40 sites. The 40-site blogroll is interesting to you for any number of reasons, from link building targets to simply subscribing in your feedreader. Right now, it's tedious to extract the URLs from the site. There are some "save all links" tools, but they are also messy. Are there any good tools that will a) allow you to grab the blogroll (only) of any site into a list of URLs (yeah, ok, it might not be perfect since some sites call it "sites I like" etc.) b) same, but export as OPML so you can subscribe. Thanks! Scott
Moz Pro | | scottclark0