Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Example making "cohorts" for product analytics #89

Open
danthegoodman1 opened this issue Aug 14, 2023 · 0 comments
Open

Example making "cohorts" for product analytics #89

danthegoodman1 opened this issue Aug 14, 2023 · 0 comments
Labels
example How to do something with IceDB

Comments

@danthegoodman1
Copy link
Owner

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:

  1. Some user creates a completed_onboarding cohort
  2. We create a materialized view called that
  3. 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.
@danthegoodman1 danthegoodman1 added the example How to do something with IceDB label Aug 14, 2023
@danthegoodman1 danthegoodman1 changed the title Example making "cohorts" Example making "cohorts" for product analytics Aug 14, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
example How to do something with IceDB
Projects
None yet
Development

No branches or pull requests

1 participant