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
-
Youtube traffic page url referral
Hello, How can I see which videos from Youtube that has my domain inserted in their description url drive traffic to my domain? I can see in GA how many visitors are coming from Youtube to my domain, but I can't see what Youtube video pages has driven traffic. Any help?
Moz Pro | | xeonet320 -
Can using url builder for campaign tracking impact link equity?
We have used the URL builder tools for building custom links that are placed on our referrer websites mainly for campaign tracking in Google Analytics, but when you use a shortened link on another website how does that impact the the link juice or equity? Is there any negative impact on the link rankings? Or should you provide the specific landing page url to the company that will be posting a link to your site?
Moz Pro | | CSobus0 -
Title Missing or Empty - has title tag's
In seomoz pro this page shows the error - "Title Missing or Empty", but has a tag. I'm trying to figure out if it's an issue on my end or a bug in the mozpro system. Thanks!! http://www.65broadwaydental.com/Contact.aspx
Moz Pro | | MusicNerd0 -
How accurate is SEOMoz's keyword analysis tool?
For the most part, SEOMoz's keyword analysis tool has been in line with other tools like Adwords keyword tool with regards to competitive level. I have just encountered a keyword though that a client may choose to compete on that seems to be far off. keyword phrase: online math games Adwords competitive level: Low SEOMoz competitive level: 80 This seems like a sizeable difference (I know the two compare all results vs first page authority's, but typically they are in line with each other). With other related keywords for the industry in question, SEOMoz and Adwords seem to be in line. This one just got me thinking. I know the SEOMoz score is a sign of the strength of the top results and that the "low" score from Adwords may be a sign of much weaker results on the following pages (with a higher number of weaker pages vs fewer high authority outliers). **Question: ** How accurate is SEOMoz keyword analysis tool and what other keyword analysis tools are you guys/gals using that you like? I have tried others but many provide duplicate insights.
Moz Pro | | mattylac0 -
Website traffic data miles behind
Just logged into one of my profiles to review my traffic data and the last traffic is for 9th Jan. Given it is now 22 this is far far from acceptable. Given the high monthly fee charged by this service why is the traffic data so far behind. If other services (cheaper services) can update their traffic data daily or even weekly why should I continue to use SEOMOZ. The rankings, errors etc are all updated for the 21st of Jan so why not the traffic. Your's An unhappy custimer
Moz Pro | | Grumpy_Carl0 -
OSE Advanced for specific directory only?
Pls how do I set up Open Site Explorer Advanced to look for backlinks to files in ONLY a certain directory? so if the domain is 1234.com, I don't care about links to 1234.com. OSE can find those very neatly! What I do care about is ONLY links to 1234.com/profiles and I can't seem to figure out a way to do this. the /profiles directory has thousands of profiles in it - and we think we have hundreds of thousands of backlinks - so ideally, I'd like to use regex or DOS like filtering to look at only those which start with 9 or 8 or whatever.
Moz Pro | | seo_plus0 -
Filtering OSE Results
Issue: When I export OSE Linking Pages results to .CSV, I'd like to filter only unique domains. It seems to me that there should be a way to do this with Excel, perhaps pivot table. Anyone have a quick solution for this? Alternatively, I can use Linking Domains, which gives all unique roots, but then i lose follow/nofollow filter. Thoughts?
Moz Pro | | Gyi0 -
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