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.
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
-
Difference between urls and referring urls?
Sorry, nit new to this side of SEO We recently discovered we have over 200 critical crawler issues on our site (mainly 4xx) We exported the CSV and it shows both a URL link and a referring URL. Both lead to a 'page not found' so I have two questions? What is the difference between a URL and a referring URL? What is the best practice/how do we fix this issue? Is it one for our web developer? Appreciate the help.
Moz Pro | | ayrutd1 -
Url-delimiter vs. SEO
Hi all, Our customer is building a new homepage. Therefore, they use pages, which are generated out of a special module. Like a blog-page out of the blog-module (not only for blogs, also for lightboxes). For that, the programmer is using an url-delimiter for his url-parsing. The url-delimiter is for example a /b/ or /s/. The url would look like this: www.test.ch/de/blog/b/an-article www.test.ch/de/s/management-coaching Does the url-delimiter (/b/ or /s/ in the url) have a negative influence on SEO? Should we remove the /b/ or /s/ for a better seo-performance Thank you in advance for your feedback. Greetings. Samuel
Moz Pro | | brunoe10 -
Crawl Diagnostics saids a page is linking but I can't find the link on the page.
Hi I have just got my first Crawl Diagnostics report and I have a questions. It saids that this page: http://goo.gl/8py9wj links to http://goo.gl/Uc7qKq which is a 404. I can't recognize the URL on the page which is a 404 and when searching in the code I can't find the %7Blink%7D in the URL which gives the problems. I hope you can help me to understand what triggers it 🙂
Moz Pro | | SebastianThode0 -
Getting a URL Unaccessible on the page grader
I'm optimizing a site for a financial advisor, here is the site: http://www.mattkeenancfp.com I am getting the message "that URL is unaccessible" when I try to use the on-page grader. This is an emerald website too, I'm not sure if that has any effect on anything though.
Moz Pro | | ryanbilak0 -
Internal Links Data on OSE and poor ranking despite excellent metrics
Hi folks, I use OSE a lot for comparing where we stand against our competitors and I'm always surprised to see most of our competitors have loads more internal links than we do. For example, comparing 'www.kensyard.co.uk' with 'www.sterlingbuild.co.uk', we are better on every Root Domain Metric except for the Total Links metric and this is down to a much smaller number of internal links. They are ranking better than us in Google so I'm wondering if there is something wrong with the way our site is coded / structured that means Google and OSE are not picking up our internal link network properly? We have over nine times as many external root domains linking to our site than theirs, which is surely a far more valuable metric than internal links right? Or is there an issue with our internal link structure that is confusing Google and causing us to rank lower? Many thanks for any advice, Luke
Moz Pro | | LukeyB300 -
Can we assign multiple admins and users with different role in one PRO account?
We wish to give different login details to authorized personnel without handing out the main account ownership login.
Moz Pro | | solution.advisor0 -
Why can't we access metrics in the API that are available in the mozbar?
For example, the Chrome/Firefox mozbar uses peid (Root Domain External Links) but the api doesn't allow this. I've done a little bit of reverse engeniering and it looks like the accessID for the mozbar (when logged in as a pro member) is "pro-xxxx". Does this mean that each pro account has its own accessid/secret key? If so, when will pro members have access to that? I've created a tool that I use for deciding which expired domains to buy and it uses all of the free metrics - but I find myself having to do one extra step to get the peid (navigating to ose). It doesn't make much sense that the metric is available to me when I'm using the mozbar logged in as a pro member (which I pay for), but not apart of the API.
Moz Pro | | SeanStewart811