Skip to content
Sendora Cloud
Create account
2026-05-31 · Platform

Analytics — retention heat-grid drill-down

  • `GET /orgs/:orgId/analytics/retention/drill-down` returns the user list behind any (cohortDate, period) heat-grid cell. Period 0 = cohort members; period N>0 = subset still active in that bucket.
  • Reuses the `user_first` CTE from `getRetention`, narrows to one cohort bucket via `date_trunc`, groups `user_periods` on the requested period_num. Sibling COUNT(DISTINCT uid) for pagination.
  • Profiles join surfaces email/name where externalId is on file; cross-project drift returns first match (same posture as profile timeline).
  • `audienceId` cohort scoping forwards from /retention.
  • Dashboard: heat-grid cells clickable → modal w/ paginated user list + Prev/Next paging. Cohort-size button opens at period=0. 0% cells non-clickable.