Retention rate of new users - Mixpanel SQL Query - Peliqan

Retention rate of new users

SQL query for Mixpanel

Calculate the retention rate of new users.

SELECT COUNT(DISTINCT user_id) * 100.0 / (SELECT COUNT(DISTINCT user_id) FROM table_name WHERE DATE(user_signup_date) = ‘2023-01-01’) AS retention_rate FROM table_name WHERE DATE(event_date) = ‘2023-01-08’ AND user_id IN (SELECT user_id FROM table_name WHERE DATE(user_signup_date) = ‘2023-01-01’)

Mixpanel data model

Export

Annotations

Revenue

Cohorts

Engage

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.