query_retention
Analyze user retention by measuring how many users return after an initial event. Track repeat engagement over time with configurable date ranges, events, and segmentation.
Instructions
Query retention data. Shows how many users come back after an initial event.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| from_date | Yes | Start date (YYYY-MM-DD) | |
| to_date | Yes | End date (YYYY-MM-DD) | |
| born_event | Yes | Initial event that qualifies a user (required for birth retention) | |
| event | No | Return event to measure | |
| retention_type | No | Retention type (default: birth) | |
| unit | No | Time unit | |
| on | No | Property to segment by | |
| where | No | Filter expression | |
| born_where | No | Filter for the born event | |
| limit | No | Max segments to return |