Firebase Analytics: BigQuery - Merging IOS and ANDROID Datasets via Supermetrics

Hi there,

I've recently connected Firebase Analytics to BigQuery. I'm fairly new to BigQuery and am struggling to find a way to merge/combine the datasets I get by Google's default export.

Default export is:
Dataset for ANDROID
daily data tables
Dataset for IOS

daily data tables

Am now wondering, if I can get the result by simply querying the 2 datasets seperately and combining via Supermetrics and than integrating with Google Data Studio, but getting the following error message:

The Query is using the Standard SQL syntax and is working in the bigquery console, but Supermetrics is giving an error?

Any advise, help ideas are much appreciated
Many Thanks

3 people have this problem
Login to post a comment