v.18.12New Feature
Added retention aggregate function
Added the retention aggregate function. Sundy LiWhy it matters
Theretention aggregate function helps analyze user retention by measuring how many users return after a specified period. This is valuable for tracking customer engagement and understanding behavior over time.How to use it
Use theretention function in an aggregate query by specifying the appropriate parameters for the retention interval and event sequences. Typically, use it in combination with GROUP BY to segment retention metrics across different cohorts.