Retention rate by cohort - Mixpanel SQL Query - Peliqan

Retention rate by cohort

SQL query for Mixpanel

Calculate the retention rate for each cohort.

SELECT cohort_id, (COUNT(DISTINCT person_id) / COUNT(DISTINCT session_id)) * 100 AS retention_rate FROM cohorts GROUP BY cohort_id

Mixpanel data model

Engage

Annotations

Export Events

Cohorts

Funnels

Service Accounts

Schemas

Ready to get instant access to all your company data ?

Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.