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
-
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 -
403s: Are There Instances Where 403's Are Common & Acceptable?
Hey All, Both MOZ & Webmaster tools have identified 403 errors on an editorial site I work with (using Drupal CMS). I looked into the errors and the pages triggering the 403 are all articles in draft status that are not being indexed. If I am not logged into our drupal and I try to access an article in draft status I get the 403 forbidden error. Are these 403's typical for an editorial site where editors may be trying to access an article in draft status while they are not logged in? Webmaster tools is showing roughly 350 pages with the 'Access Denied' 403 status. Are these harmful to rank? Thanks!
Moz Pro | | JJLWeber1 -
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 -
Why Even Publish Dates for the Next OSE Data Set?
I just noticed on the Linkscape calendar the update that was supposed to happen yesterday is pushed back to the 6th. It would be better not knowing. Is this a possibility? Or use the calendar internally, I don't care. Credibility in any announcement or claim looses muster once you do not do what you say you are going to do over and over again. Just a thought..
Moz Pro | | Mr.Rangen1 -
Batch lookup domain authority on list of URL's?
I found this site the describes how to use excel to batch lookup url's using seomoz api. The only problem is the seomoz api times out and returns 1 if I try dragging the formula down the cells which leaves me copying, waiting 5 seconds and copying again. This is basically as slow as manually looking up each url. Does anyone know a workaround?
Moz Pro | | SirSud1 -
Can export be sped up?
Good tool guys. Basically, when I used to work at a software development company, we used to have a huge hosted app that had to import/export 10's of 1,000's of records, and at batch of 10,000 could be done in a few seconds. When exporting from OSE, it can take several minutes. Thanks and keep up the good work. Look forward to when your database can catch up to Yahoo's old SiteExplorer (yes, I know they were a full on search engine 🙂 but your one of the only decent alternatives, so guessing you're getting quite popular now 🙂
Moz Pro | | onlinefun0 -
How can I create multiple private labeled website SEO analysis reports?
How can I create multiple white-labeled website SEO analysis reports using the SEOMoz software? I'm speaking at a workshop and want to provide this as a giveaway to attendees to start the discussion on improving their SEO. I'm looking mostly for an overview summary of a site's key SEO data points including inbound links, on-page SEO details including page titles, and basic recommendations for improving. Websitegrader.com offers this but not white-labeled. I'm not sure about how SEOMoz handles this. Thanks
Moz Pro | | bshanahan0 -
Site is penalized yet Google WTC and SEOMOZ says it's ok!
My first question on this community.. A high traffic site of mine has been severely hit for over two months. I took a look at GWTC and noticed a lot of suggestions on the HTML suggestions tab, where I believed that one or a combination of these errors/notices might been causing the penalty. At the moment of typing GWTC shows no HTML suggestions and minor meaningless crawl errors. Checking on SEOMOZ reported issues, I see zero errors except for a high number of duplicate page titles resulting from tag pages being accessible in the same tag title in paginations (tag.html?page=x) which can be fixed easily by using rel=canonical but I just know it can't cause such penalty. For reported warnings, site has a decent amount of title element being too long and missing meta tag description tags. I have been very active in the past with 301 inner pages of the site to make pages URLs as unique as possible and results were great, but that was long time ago before taking the hit. The penalty the site suffers from is zero rankings for newly added contents and old contents as well. It has also lost all rankings for its money terms. Site is not banned and still ranking top for its name which is a good thing. I am not sure where else I should be looking and will appreciate any good advices. Thanks!
Moz Pro | | HossamHossny0