recently i did a post about a forum spamming attack that I analyzed and included some exports from my Google analytics data...to create this report I used a HTTPhelper i created that wraps the WinHTTP object in ASP that makes it really easy to make external requests and pull data from the Google Data API. Its easy to pull different segments and data if you use the data feed query explorer to create the request url (the second test.url in the code below) then just parse the xml and output as desired... unfortunately i haven't found a good asp oauth (recommend one to @cartercole)

the code is here but i also have included it below in this post...

this post contains code see it here

its easy to pull data from the other APIs but its sometimes hard to find the correct service string tp pass so heres my cheat sheet. im all for helping / suggestions so please leve your comments they are always appreciated (and so are links)

Google API	Service name
Google Analytics Data APIs	analytics
Google Apps Provisioning APIs	apps
Google Base Data API	gbase
Google Sites Data API	jotspot
Blogger Data API	blogger
Book Search Data API	print
Calendar Data API	cl
Google Code Search Data API	codesearch
Contacts Data API	cp
Documents List Data API	writely
Finance Data API	finance
Gmail Atom feed	mail
Health Data API	health weaver
Maps Data APIs	local
Picasa Web Albums Data API	lh2
Sidewiki Data API	annotateweb
Spreadsheets Data API	wise
Webmaster Tools API	sitemaps
YouTube Data API	youtube

and here is my HTTPhelper class... it does some cool stuff like build post data from a dictionary object and has all the stuff to do Authentication and setting headers for the request (much easier for me because i forget the methods and have to look them up) so if its helpfull for you please feel free to use it :) woohoo open source!


thanks for reading and i hope this helps you do more with the data APIs and get to your data more easily...