How to get User's table from Firebase events in BigQuery?

Question

I am trying to look at old events based on user's current values. Events from Firebase Analytics are exported in single table together with User data(user data is part of event record). How can I join old event to current user? Is it possible to export User table separately? Thanks!

Answer 1

You can identify a user with either user_dim.app_info.app_instance_id, user_dim.device_info.resettable_device_id or user_dim.user_id. You can read more about these fields in this help center article.