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
-
Why are my month old links not showing in WMT or OSE?
Hey Everyone! I've been working hard on boosting my ranking after launching my new site 2 months ago. I realize that this process normally takes some time however I've come across a questions that I'm not sure I know that answer to... I had some really solid back links added about a month ago but nothing is showing up yet in WMT on them. When I run an OSE I don't see any links there (not even under newly discovered). Can someone please help with some insight on why they might now be showing. Is it just a time thing or should I be doing something different?Any insight will be very helpful. Thanks
Moz Pro | | MDesigns0 -
Page Rank Report says #6 in Google but I can't find the page anywhere
So SEOMoz says that I've consistently ranked #6 for a certain keyword. But when I search I'm no where to be found. I've done regular searches, incognito and some non-seomoz reports and all come up with nothing in Google. I noticed it a week or two ago, but didn't think it would continue. This is no bueno. I wouldn't be surprised if I got penalized (luckily my homepage relatively well for similar keywords), an old seo consultant used very spammy tactics. I recently removed them, but not before I started to notice that I fell off the map. Why would SEOMoz not recognize this, and continue to say I'm ranking well? The keyword is bpi building analyst the page is http://www.cleanedison.com/courses/bpi-building-analyst
Moz Pro | | CleanEdisonInc0 -
What's with measuring search rank?
Okay, here 6 different ways to measure search rank on Google U.S. and I get 6 different answers: Looking for search term "Lunch Bags" for the site Zappos (just a random example - no connection to me). SEOMOZ RankTracker - #49 SEOCentro - #36 http://www.seocentro.com/tools/search-engines/keyword-position.html ZendProxy.com - #21 (an anonymizer proxy) anonymouse.org - no rank (another anonymizer) Mikes Marketing Tools - no rank http://www.mikes-marketing-tools.com/ranking-reports/ RankingCheck.com - #38 Can you duplicate a similar variation? What gives? Which if any of these would you rely on? Thanks... Darcy
Moz Pro | | 945010 -
Why can't I change the domain being tracked in my campaign?
Apologies if this has already been answered a million times and/or if I'm posting this in the wrong place... I did look, but couldn't find the answer anywhere... I just realized that all this time I have been tracking www.mydomain.com in my campaign for a long time now, while I should probably have been tracking *.mydomain.com. I wanted to change this, but it looks like I can't. If I have to set up a whole new campaign, with all of the same keywords, competitive sites to track, etc., that will take forever. Why can't I just change it so that my campaign starts tracking *.mydomain.com instead of www.mydomain.com from now on? Thank you!
Moz Pro | | ScottShrum0 -
Why can't I find uipl?
Hi guys, I'm working with the API at the moment. I have most of the information I want, but I cannot find the uipl in any of the returned data using several methods. The methods I have tried are: http://lsapi.seomoz.com/linkscape/links/www.google.co.uk?Scope=page_to_domain&AccessID=xxx&Expires=xxx&Signature=xxx http://lsapi.seomoz.com/linkscape/url-metrics/www.google.co.uk?AccessID=xxx&Expires=xxx&Signature=xxx I can't seem to find how to get the uipl. Any ideas? Thanks in advance!
Moz Pro | | ClickConsult0 -
It's possible to transfer a campaign from an account to another?
Since in SeoMoz is not possible to have 2 user for account, I need to transfer to a news Pro account 2 campaign I host in my Pro account. I need to mantain the historical data too.
Moz Pro | | BMLab0 -
Use of the tilde in URLs
I just signed up for SEOMoz and sent my site through the first crawl. I use the tilde in my rewritten URLs. This threw my entire site into the Notice section 301 (permanent redirect) since each page redirects to the exact URL with the ~, not the %7e. I find conflicting information on the web - you can use the tilde in more recent coding guidelines where you couldn't in the old. It would be a huge thing to change every page in my site to use an underscore instead of a tilde int he URL. If Google is like SEOMoz and is 301 redirecting every page on the site, then I'll do it, but is it just an SEOMoz thing? I ran my site through Firebug and and all my pages show the 200 response header, not the 301 redirect. Thanks for any help you can provide.
Moz Pro | | fdb0 -
Does anyone know what the %5C at the end of a URL is?
I've just had a look at the crawl diagnostics and my site comes up with duplicate page content and duplicate titles. I noticed that the url all has %5C at the end which I've never seen before. Does anybody know what that means?
Moz Pro | | Greg800