Search code examples
firebasegoogle-bigqueryfirebase-analytics

Interpreting Google BigQuery "rows" - Firebase Events


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.


Solution

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