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
-
Google Analytics unexplainable traffic spike
Viewing this report **Behaviour > Site content > All pages **with primary dimensions of **Page ** and **Page title **are showing different results for one specific page on our site. We noticed a huge spike in pageviews and entrances to that specific page on our site. The user flow report shows traffic going through and from the page (in high volume) from other pages on the site which suggests that it's not the usual case of spam referrals. When I view the report above by page, I get unrealistic data. Over 600% increase in pageviews and over 900% increase in entrances. When I view by page title however, I get realistic results. Can anyone help shed some light on why these two reports will be different? Anyone else seeing similar issues?
Reporting & Analytics | | OptiBacUK0 -
Google Analytics for User Experience
Hi In terms of looking at the overall User Experience of a website is there any particular areas of Google analytics that you believe to be particularly useful to identify areas of worry or opportunity?
Reporting & Analytics | | TheZenAgency1 -
How long does Google Analytics store data?
Hello All, How long analytics keep the data for one website? at least two years at least 25 months other I guess that they guarantee at least 25 months, but it might be more.
Reporting & Analytics | | CommercePundit
Anyone has any other suggestion? Thanks,0 -
Using advance segments or primary dimensions?
Hi guys, I haven't played around with advance segments enough to know the answer to this, so looking for some help. What I want to track is a keyword through the whole analytics, so I created an advance segment for "KEYWORD". This segment is Include - Keyword - "KEYWORD". Now when I remove the advance segment and do the following: Traffic Sources - Organic - Primary Dimension - Keyword - "KEYWORD" The amounts of visits differ a lot. I'm guessing this has to do with sessions? Looking for a clarification on this.
Reporting & Analytics | | William.Lau0 -
Google Analytics and DNS change
Our new alumni application is going be tested at domain uva.imodules.com . We are going to collect traffic data with a Google analytics account number UA-884652-XX. So going to uva.imodules.com/myPage.html would send its data to Google Analytics with that account number. Then when it is ready for production we are going to just change the domain name of the application and switch the DNS over to dardencommunity.darden.virginia.edu . So going to dardencommunity.darden.virginia.edu /myPage.html would send its data to Google Analtics with that SAME account number. Aside from having the testing domain data in the same profile are there any other issues/problems we may run into?
Reporting & Analytics | | Darden0 -
Un-link Google Analytics
I have set the wrong account/password details for one of my campaigns. How do I 'step back' and choose the correct settings please? Thanks Ian
Reporting & Analytics | | driansmith0 -
Track image searches on google analytics
How can i track image searches on google analytics? To filter the refferers by image.google or /imgres does not work in new google analytics (and brings an impossibly small number on old GA). also, this would not cover local google image refferers, that don't come from image.google.com. anyone knows how to find image search sources? i haven't found anything helpful in google's documentation or forums. thanks!
Reporting & Analytics | | zeepartner0 -
Google Analytics' Goals and Cold Fusion
We are having an issue tracking goal completions in GA with a cold fusion site. I would like to know if anyone as had similar issues and found a solution.
Reporting & Analytics | | JamesBarry0