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
-
How would I create this type of report in Google Analytics?
I work for an e-commerce site. I would like to run a weekly report to see what every category pages increase and decrease for pageviews would be. How would I do that?
Reporting & Analytics | | EcommerceSite0 -
Google traffic plummeted on Sunday - what can I do?
On Sunday, my google traffic plummeted. I was getting 320 hits a day from Google on my best days - my site is just about to turn 3 months old so I was thrilled with that. On Sunday it was 110 and I think it is getting worse. Edit: Yep, yesterday was 65. Google Webmasters shows the drop today. One day, my impressions were 5,500 and the next just 1,000. Yikes. My traffic is so depressing now after so much hard work. Is this Google Panda? What can I do? I have no idea why this happened. I am getting several quality backlinks a week, sometimes a day.
Reporting & Analytics | | 2bloggers0 -
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 -
2 questions on avoiding issues with Google and while being right in it.
Hi SEOmoz community In fact I have two questions I would like to ask (with future SEO in mind). Do you consider a WordPress Multisite or various Single installs 'safer' for SEO? Theoretically, having various sites packed into one Multisite network seems like an ideal solution. However, is there a chance that once a site in the network encounters a little 'negative turbulence', that your other sites in the network might get impacted too due to the cross-referencing, linked account i.e. Webmaster Tools etc.? It would seem outrageous, but then again I wouldn't rule it out. Do I even have to go as far as setting up new Gmail, Google Analytics and Webmaster Tools accounts, so they (the sites) are technically not linked? You can see, I don't trust search engines one bit... Is there still a point posting articles once Google is having a hissy fit with your site? Basically I am currently going through a 'rankings and traffic drops storm'. It's not as bad as being de-indexed, but it's still having enough of an impact. In addition, Google does not seem to treat my new articles (unique content) with the same attention anymore i.e. does not seem to index them 'fully' or not at all (i.e. posting the headline in Google should return the article, but it doesn't). Is there even a point spending time now and posting new material or may it pick it up again once I am through this low phase? Does Google still index what it considers worth or is it a waste of time right now to keep posting, posting and posting more? Thanks for your help. I really appreciate it.
Reporting & Analytics | | Hermski0 -
Google Analytics & AdWords Conversion Tracking
I have Google Analytics implemented on my site and have goals/funnels set up to track the conversion process. I have just started an AdWords campaign but can't see/track conversions from it. Do I need to implement both Google Analytics AND AdWords scripits on the page?
Reporting & Analytics | | mj7750 -
Transferring Google analytics accounts
Hi, Does anyone know if you can transfer an Google Analytics account. We are looking to take over a new clients existing website and the analytics account is registered to their current web designers. Is it possible to transfer it to the client so that their existing web company no longer has access and they keep all their historical data, or do we have to start from scratch. Thanks Fraser
Reporting & Analytics | | fraserhannah0 -
AW Stats vs Google Analytics
Hey Moz Community, I am looking to get opinions on the best practice for analytics/traffic analysis. From experience I know that AW Stats reads high and Google Analytics reads low for traffic for reason in this article http://www.smartz.com/blog/2009/01/23/analytic-confusion-%E2%80%93-awstats-vs-google-analytics/ It drives me a little nuts how far off both are for some pages. I have one article that shows 100 views (GA) and AW stats shows 5 times that number of views. Any suggestions or systems you recommend? Thanks
Reporting & Analytics | | johnshearer0