如何通过YQL或Yahoo管道访问Google Analytic dat？ [英] how to Google Analytic dat through YQL or Yahoo pipes?

问题描述

我使用Google分析，我想使用YQL或Yahoo管道从Google分析帐户中检索最后100个搜索字符串，我该怎么做？请帮助..

解决方案

我刚刚检查了一些Google Analytics YQL表格。现在他们使用ClientLogin进行身份验证。以下是代码：

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

<您需要先使用电子邮件和密码进行身份验证，然后从结果中提取出身份验证令牌。使用该身份验证令牌调用将列出您的帐户并从API中提取数据的API。您应该使用Google Analytics资源管理器来确定要删除的内容：

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

下面是一个查询示例，用于获取我最活跃的页面列表：

使用' 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：pageviewsand sort = - ga：pageviewsand start =2010 -04-04和结束=2010-04-18和最大= '50'

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..

解决方案

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'

这篇关于如何通过YQL或Yahoo管道访问Google Analytic dat？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！