- Tags:: Data Analysis
From https://twitter.com/teej_m/status/1494481801250705410?s=20&t=c9fjgY_Owq_6yVdkkvHq6A:. So it probably not a good idea to have crude data on BQ and build up all the analysis in there.
With a site or app, all we can do is follow the trail of breadcrumbs that users leave behind. Funnels, cohorts, A/B tests, attribution. These are all flavors of sequence analysis - stitching together events to tell the story of WHY. But it sucks to do this with SQL alone. Bad.
But can be done. From When not to use SQL:
A related repo: sf-funnels.
The easiest strategy to build a funnel is with self joins, though the performance can be poor.
Snowflake has made this easier with MATCH_RECOGNIZE: Funnel Analytics in Snowflake.