Session information missing from exported firebase data to Big Query

Question

I seem to be missing session related information to the events that gets exported from Firebase to Big Query. More specifically, a unique identifier of each session (ga_session_id) and an ordinal number of the session count specific to the user that generates the events (ga_session_number).

All though they are not part of the export schema, they can be found in the documentation elsewhere and a recent blog post showing queries where they use these missing fields.

Do I have to enable something in order for them to start showing up in the event_params of my firebase analytics events or are these things not yet implemented? If not, is there any information on when this will happen?

edit: I'm using the Firebase Unity SDK.

Thanks in advance!

Suzanne Suzanne · Accepted Answer · 2019-02-05T13:56:21

With this query I get the expected results:

SELECT event_params.value.int_value AS session_id
FROM `your table`, UNNEST (event_params) AS event_params
WHERE event_params.key = "ga_session_id"
GROUP BY 1

Note that in the blogpost query-example they use event_params.value.string_value which does not give any results

You also need to have the right SDK version (update from December)

Session information missing from exported firebase data to Big Query

1 Answers