Dashboard adoption and retention cliff
Problem
For Pro users who started in January 2024, compare 30-day retention for users who viewed a dashboard in their first 14 days versus users who did not.
Tables
Example rows — the live problem includes the full dataset.
subscriptions
| user_id | plan | start_date | canceled_at |
|---|---|---|---|
| 1 | Pro | 2024-01-02 | |
| 2 | Pro | 2024-01-04 | 2024-01-18 |
| 9 | Team | 2024-01-05 |
feature_usage
| id | user_id | used_at | feature |
|---|---|---|---|
| 1 | 1 | 2024-01-04 | dashboard_view |
| 5 | 5 | 2024-02-02 | dashboard_view |
| 6 | 6 | 2024-02-05 | export_csv |
Expected output
Your answer should return 2 rows with the columns adopted_dashboard, users, retained_30d, retention_rate.
Starter code (SQL)
SELECT *
FROM subscriptions;Solve this SQL question free
Write SQL and run it instantly in your browser — even on your phone. No signup needed to try.
Solution & explanation
Create a free account to unlock the optimal solution, a step-by-step explanation, and the hidden test cases that grade your answer.
Sign up free to unlock