Write a SQL query to calculate the retention rate of users who completed the onboarding flow versus those who did not at Superhuman.
Use the signup date as the cohort start. Define a retained user as someone with at least one activity between 30 and 59 days after signup, inclusive. Treat users without a completion event as not completed.
Output
- One row per onboarding status, with
onboarding_status, eligible_users, retained_users, and retention_rate.
- Include both completed and not-completed statuses, with retention rate expressed as a percentage rounded to two decimal places.
- Order completed users before users who did not complete onboarding.
