I have a basic question regarding Google analytics and bigquery.In searching for this online I haven't seen a straight answer.
我有一个关于谷歌分析和bigquery的基本问题。在网上搜索我没有看到一个直接的答案。
If I have a blog with user id's 1,2,3...I also have google analytics running on my site picking up the utms param's etc.
如果我有一个用户ID为1,2,3的博客...我也在我的网站上运行谷歌分析,拿起utms param等。
When I log into google analytics I can see it has demographic breakdown of my users(sex, age), it also has interests, which is what I'm really interested in.
当我登录谷歌分析时,我可以看到它有我的用户的人口统计细分(性别,年龄),它也有兴趣,这是我真正感兴趣的。
I heard that I can pull all this underlying data from bigquery if I have a premium account.
我听说如果我有一个高级帐户,我可以从bigquery中提取所有这些基础数据。
If that bigquery connection is made, can I run a query like?
如果建立了bigquery连接,我可以运行一个类似的查询吗?
select blog_user_id, interest_name, sum(interest_spend) as spend, sum(interest_num_impressions) as lvl_interest from bigquery bg left join blog_user_base bl on bl.cookies=bg.cookiesgroup by 1,21 个解决方案
#1
This is the schema exported from Google Analytics to Google BigQuery:
这是从Google Analytics导出到Google BigQuery的架构:
https://support.google.com/analytics/answer/3437719?hl=en
It doesn't seem to have the 'interest' column right now - though the list of variables increase regularly by customers requests. Variables like these are trickier as they are not part of regular logs - so they might not be surfaceable on the granular level.
它现在似乎没有“兴趣”专栏 - 尽管变量列表会根据客户要求定期增加。像这些变量比较复杂,因为它们不是常规日志的一部分 - 因此它们可能在粒度级别上不可表现。
#1
This is the schema exported from Google Analytics to Google BigQuery:
这是从Google Analytics导出到Google BigQuery的架构:
https://support.google.com/analytics/answer/3437719?hl=en
It doesn't seem to have the 'interest' column right now - though the list of variables increase regularly by customers requests. Variables like these are trickier as they are not part of regular logs - so they might not be surfaceable on the granular level.
它现在似乎没有“兴趣”专栏 - 尽管变量列表会根据客户要求定期增加。像这些变量比较复杂,因为它们不是常规日志的一部分 - 因此它们可能在粒度级别上不可表现。