API: Queries

Searches combinations of candidate event, repetition threshold and early window after the anchor event that are statistically associated with a later return. Discovery picks the window and threshold, validation checks the already selected combination once on an independent deterministic split of actors. The result reports an association, never a causal effect. Cohort maturity is evaluated against a single as_of captured at the start of the request: actors whose outcome window has not closed are excluded instead of being counted as churn. Every behaviour window must end before outcome.from_day; overlapping windows are rejected with 422.

Returns DAU, WAU, MAU, usage-frequency and repeat-activity metrics for one activity event. date_to is the last fully completed local calendar day. The server derives the trailing 7- and 30-calendar-day windows in the project's timezone and counts exact actor_id unions in one bounded query; daily uniques are never summed to produce WAU or MAU.

Basic funnel counts are available on every plan. Supplying dropped_at_step requests exact actor membership and requires the Growth or Scale actor_drilldown entitlement in cloud or actor_drilldown in the current verified on-prem signed-license subset; direct API calls are enforced.

Returns deterministic top routes and a Sankey graph before or after the selected event. Session mode requires actor_drilldown; actor mode does not. Saved segment filters additionally require saved_segments. The result cache includes the project timezone and URL-normalization revision.

Recompiles the same start cohort, return event, timezone, date range, filters and period semantics as the parent retention report. Period 0 is the complete start cohort; later periods contain actors with a matching return bucket. Results are ordered by actor_id and cursor paginated. Server-side actor_drilldown and saved_segments entitlements are enforced for direct API calls through the cloud EffectivePlan or current verified on-prem signed-license feature subset.

Revenue is the signed sum of props.revenue in RUB. ARPU divides it by unique active actors in the entire range, so an actor active on several days is counted once. The query is project/date bounded and uses the shared report timeout, cache and saved-segment resolution.