解释Google BigQuery“行” - Firebase事件 [英] Interpreting Google BigQuery "rows" - Firebase Events

问题描述

我使用Firebase Analytics在我的应用中记录用户事件。获得了相当多的不同用户的数据后，我很难理解每个行在 app_events 表中各自的日期。 row 从活动 onStart（）到activity onStop（）的用户事件会话？对于同一个userId，我得到了不同事件的多行。

另外，在用户维度中定义的用户属性是可变的还是不可变的，例如一次设置值，并且不能进一步重写？

所有帮助表示赞赏。

解决方案

BigQuery导出架构可以可在帮助中心中找到，其中规定：

表格中的每行对应于由
上传的Firebase Analytics SDK上传的一批活动。

用户属性是可变的。但是，我们通常建议您使用用户属性来设置静态或缓慢更改的属性，以便在报告过滤中最大化其值。

I have used Firebase Analytics for logging user events in my app. Having got data of quite a lot of distinct users, I'm having a hard time understanding what an individual row means in the app_events table for a respective day.Is this row a session of user-events from activity onStart() to activity onStop() ? For a same userId, I'm getting multiple rows with different events in them.

Also, are the user-properties defined in the user-dimensions mutable or immutable i.e. as in, set values once, and can't over-write any further?

All help is appreciated.

解决方案

The BigQuery Export Schema can be found in Help Center, and it states that :

Each row within a table corresponds to a bundle of events uploaded by the Firebase Analytics SDK.

User Properties are mutable. However, we generally recommend that you use User Properties for static or slow-changing attributes to maximize their value in report-filtering.

这篇关于解释Google BigQuery“行” - Firebase事件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！