Filter Firebase analytics events based on user properties in Google Data Studio

Question

Using BigQuery it is possible to connect Firebase analytics to Data Studio. Data source can be either the "EVENTS" or the "USER PROPERTIES".

My problem is that I want to filter the events based on user properties, but I can't have both of them in the same data source.

Update: Here is an screenshot which shows my dashboard. As you can see when adding a data source which is a Firebase analytics report, after selecting the table, you have to select "EVENTS" or "USER PROPERTIES".

Answer 1

Assuming I understand what you're doing, it sounds like you just need to select Custom Query under BigQuery in the Connectors list from Data Studio. Then you can write whatever arbitrary query that you want instead of reading from a single table, which is what will happen if you select My Projects, Shared Projects, or Public Samples from the list instead.