-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Implementing funnel and retention queries #1241
Copy link
Copy link
Closed
Description
Hello,
There is any functionality that allows implementing funnels and retention queries in clickhouse ?
For example, a funnel could include these steps:
- Step1: Count the number of unique users who registered in timeframe X.
- Step2: Of the users who were counted in step 1, count the number of them who created content in that timeframe
- Step3: Of the users who were counted in step 2, count the number of them who shared content in that timeframe
Supposing that the information is available in 3 different tables (registration, created_content, shared_content) and the common key is user_id what's the optimal way to implement this?
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels