Use SEOmoz API in Google Docs Spreadsheet
-
Hi,
Has anyone made functions to get link metrics from SEOmoz API in Google docs spreadsheet?
- Page Authority
- Domain Authority
- Linking Root Domains
- Total Links
_Thanks to Tom Critchlow I got the social metrics, now I just need the ones from SEOmoz api. _
Any help would be sweet.
-
Hey, as promised - here's Ian's post about using the SEOmoz API with Google Docs:
http://www.conversationmarketing.com/2011/04/linkscape-google-spreadsheets.htm
-
Thanks, awesome work
-
I had a play with this (having been inspired by Tom's great SEO tools with spreadsheets article) I played around with Google docs and some of the sample code to query the SEOMoz API.
(BTW I don't think all the data you're looking for is available with the free API.)
I knocked together a google docs spreadsheet that does the query, hope you find it useful as a guide till someone (Messrs. Critchlow and Lurie?) posts something more user friendly.
To use it, make your own copy of the sheet, then:
- enter your member ID and secret key in the blue cells (D1 and F1) - you can get your info from www.seomoz.org/api
- type a number into B1 for the expiry interval,
- the search query should be self-explanatory (cells A4,B4 and C4)
As you'll see from the code, I'm no Google docs expert, but hopefully you'll see how the call gets put together.
-
Cool. Looking forward to it.
-
Hey - I've been working with Ian Lurie from Portent and he has a blog post on it's way that details how to do exactly this! Look out for it in the next week or so
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
-
Does Google need Analytics installed to create metrics?
Hi Mozers, Does Google know time on site, number of page visits, bounce rate, etc. even if Google Analytics is NOT installed? Does it measure all that stuff anyway, and if you install the GA code on your site, that is so that YOU can see those metrics? OR can Google only see those metrics if you install GA on your site? Thanks! Jane
Reporting & Analytics | | CalamityJane771 -
Tracking 301 redirect traffic in Google Analytics
if I 301 redirect www.mywebsite.com to go to www.yourwebsite.com, how can I track the traffic in Google Analytics that is coming from mywebsite.com?? I don't think that's a referral traffic, is it?
Reporting & Analytics | | Armen-SEO0 -
Google Tag Manager Classes
Does anyone know of classes or people who teach Google Tag Manager and how to use it effectively?
Reporting & Analytics | | JQC0 -
Seomoz or GWMT correct?
I'm getting a few 404 errors show up in seomz, but a few thousand in gwmt. These are old site url's that may have been missed by redirects. Which one should I believe/attack first?
Reporting & Analytics | | Paul_MC0 -
Blended results in google ???
I am a little confused about my search results. My ranking on google is displayed as #42. HOWEVER, I am #1 in the LOCAL results... what does that mean? Am I really #42? or am I #1 because local is listed over the organic results?
Reporting & Analytics | | drshahprs0 -
Google Analytice for Shopping Results
We are trying to optimise for Google Shopping and therefore would like to be able to monitor traffic to site from this source? How can this be done in Google Analytics? Thanks
Reporting & Analytics | | seanmccauley0 -
Google analtyics code placement
I saw that Google suggests the analytics code be in the , will this effect the page load if it is in here? Also, is it a problem to have it in the body?
Reporting & Analytics | | Gordian0 -
What is the best Wordpress Analytics Plugin to use?
I am installing a new instance of WordPress and want to use Google Analytics. Which Plug-in is the best to use? I am finding several Plug-ins that all seem to do the same thing: Google Analyticator Google Analytics Dashboard Simple Google Analytics Ultimate Google Analytics Wordpress Google Analytics Maybe one of these are not the best? Any recommendations would be appreciated. Thanks!
Reporting & Analytics | | LBike0