Start a new topic

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:
https://prnt.sc/iuf38h

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


1 person has this problem
Login or Signup to post a comment