how to Google Analytic dat through YQL or Yahoo pi

Question

I use Google analytic, i want to retrieve the last 100 search string from my Google analytic account using YQL or Yahoo pipes, how can i do it?? Please help..

Answer 1

You can't access Analythics API using Yahoo pipes or YQL because google services requires Google Account authentication using ClientLogin\AuthSub\OAuth.

With a workaround you could export your analythics data on google groups and then retrieving it using Yahoo pipes.
Check this article.

Answer 2

I just checked in some Google Analytics YQL tables. Right now they use ClientLogin for authentication. Here is the code:

http://github.com/yql/yql-tables/blob/master/google/google.analytics.xml

You need to first authenticate with Email and Passwd and extract out the Auth token from the result. Use that Auth token to call the APIs that will list your accounts and pull data from the API. You should use the Google Analytics explorer to figure out what you want to pull down:

http://code.google.com/apis/analytics/docs/gdata/gdataExplorer.html

Here is an example query that I am using to get a list of my most active pages:

use 'http://github.com/yql/yql-tables/raw/master/google/google.analytics.xml' as ga; select * from ga where auth='...' and ids='ga:2938948' and dimensions='ga:pagePath' and metrics="ga:pageviews" and sort="-ga:pageviews" and start="2010-04-04" and end="2010-04-18" and max='50'