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
-
Strange 404 Pages Appearing in Google Analytics
Hi, My client has some strange urls appearing in GA which lead to error pages. Please see the following image: https://imgur.com/a/6TPO8yL e.g URLs like /h/6445738.html I've used screaming frog to see if these pages exist on the website and I can't find them, anywhere. Therefore how are they coming up in GA? If anyone could please help I'd really appreciate it.
Reporting & Analytics | | SolveWebMedia0 -
Google News Bug
During today and yesterday we are getting a lot of visits (Over 400) from http://news.google.com the visits are all at the same time and to different pages, the visits are very brief so much so that it pushes our bounce rate up to 69% in GA. Is there anything we can do to stop this? Thank you in advance?
Reporting & Analytics | | Palmbourne0 -
Google Analytics Custom Alert For Goal Completions?
Hi currently setting up custom alerts for a website. I want to do a custom alerts for when goal completions decrease or increase by a certain % e.g. 20% as shown in the third example from this Moz Article back in 2012 - http://moz.com/blog/7-essential-google-intelligence-custom-alerts-that-keep-me-sane However when i go into my GA account the only options seem to be for when the goal completion conversion rate % drops. I could use this, but i rather do just based on completions rather than %. Any ideas on how i can do this? Thanks.
Reporting & Analytics | | MBASydney0 -
Google Webmasters DNS error
Hi, In my webmaster tools I have a yellow triangle stating that there is a DNS error that is preventing Google crawling my sites. The site is indexed and I have checked fetch as Google and that seems ok but the triangle is still there every time I check it. The whois sites all have the correct information and point to Hostgator who I am using. I have contacted them and they said everything seems ok. Should I just carry on as normal with my link building as the site is indexed or investigate even further? Cheers, Stuart
Reporting & Analytics | | stuart420 -
Google Analytics: Multi channel funnel
Hi 🙂 I have a little problem. In Multi-channel Funnel Overview I see 50 conversions from Paid Search (screenshot 1). But when I click on Assisted Conversion and then choose Paid Search, I see 31 Assisted Conversions and 32 Last Interaction Conversion. (screenshot 2) So my question is - why the number of converstions in overview (50) is different than number in Assisted Conversions (assisted or last interaction conversion, or both together)? Probably, the answer is so simply, but I can found out it! 🙂 thanks a lot. X6UihL7.png lCNsw4T.png
Reporting & Analytics | | visibilitysk0 -
Google Analytics "Undetermined" Keyword
Google analytics is suddenly showing a new keyword "undetermined". Traffic Sources > Sources > All Traffic with the primary dimension set to Keyword. It's currently our 13th keyword and it is displayed without parentheses around that you see with (not provided) or (not set). Anyone have any idea what this is? Thanks!
Reporting & Analytics | | Morris770 -
Looking for a Google Analytics expert
Looking to hire a Google Analytics expert for a project. Dealing with trying to track traffic across multiple domains and then work with the Ecommerce options. Contact Jeff Logan @ Avelient with costs and time frame for work. [personal information removed by editors. please contact via private message system to exchange information]
Reporting & Analytics | | Avelient0 -
Does Google Analytics use your data against you?
I couldn't find this question answered anywhere in Q&A, so I apologize if it's a duplicate of another post. I heard, about a year ago on either Web Pro World, or Warrior Forum that Google uses your visitor data in your Google Analytic account to rank your site. Someone said that when they took out the Google code, their site went from the third to the first page within 48 hours. That was then verified over the next couple of weeks by others. Their thought was that regardless of the optimized page and incoming link, if the site wasn't getting visitors, then it would be penalized. Since Google has the data, they would be able to use it. I then started using another, paid, solution - getclicky.com. While I like clicky, there is some info Google has that clicky doesn't, everyone integrates with Google analytics - like SEOmoz, and I'm paying a monthly fee. Now that I'm a part of a community of experts, what do you think? Have you noticed Google ranking you based on your analytics data? Has anyone experienced this, or heard about it before? Because I'd like to go back to using Google analytics. Thanks!
Reporting & Analytics | | DallasBonsai0