v.18.12New Feature

Added retention aggregate function

Added the retention aggregate function. Sundy Li
Introduced the retention aggregate function in ClickHouse.

Why it matters

The retention 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 the retention 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.