Example making "cohorts" for product analytics
Opened this issue · 0 comments
danthegoodman1 commented
If we have a set of pre-known cohorts (give us a name and a query) that we can turn into a materialized view then we can inject that where found into future queries.
For example the flow can look like:
- Some user creates a
completed_onboarding
cohort - We create a materialized view called that
- They run a query where
_completed_onboarding
(indicates using a pre-defined table, maybe we do$completed_onboarding
so it's clear there will be injection as otherwise that's improper sql) where they check for folks who completed onboarding in different regions.