Skip to main content

Peliqan

Try for free
Request a demo

Mixpanel

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’)

Try this query now in Mixpanel

Mixpanel data model

Mixpanel
Engage

Mixpanel
Annotations

Mixpanel
Export Events

Mixpanel
Cohorts

Mixpanel
Funnels

Mixpanel
Service Accounts

Mixpanel
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.

  • 14-day free trial
  • No credit card needed