Have Geek Brain

How does Google Analytics through YQL or Yahoo channels?

I am using google analytics, I want to get the last 100 search lines from my google analytic account using YQL or Yahoo tubes, how can I do this? Please, help..

+2


a source to share


2 answers


I just checked in some Google Analytics YQL spreadsheets. They are now using 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 the Auth token from the result. Use this Auth token to call APIs that will enumerate your accounts and retrieve data from the API. You have to use Google Analytics Explorer to figure out what you want to remove:



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

Here's an example query I'm using to get a list of the 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 '

+3


a source


You cannot access Analystics APIs using Yahoo or YQL pipes because google services require google account authentication with ClientLogin \ AuthSub \ OAuth.



With a workaround, you can export your analytics data to google groups and then retrieve it using Yahoo pipes.
Check out this article.

+1


a source






More articles:


All Articles