Google Analytics, Dataform, Bigquery, Google Cloud Platform, Sql.
lot of cases, but if you run a lot of queries, the constant unnesting is computationally more expensive as well as a bit tedious. The most obvious optimization step is the sessionization of the event-level data, which I wrote an extensive article about. Or you can create other event-level