Seven-day activation by channel
Problem
For March 2024 signups, calculate each channel activation rate. Activated means the user created their first project within seven days of signup.
Tables
Example rows — the live problem includes the full dataset.
signups
| user_id | signup_date | channel |
|---|---|---|
| 1 | 2024-03-01 | search |
| 3 | 2024-03-05 | paid |
| 5 | 2024-03-10 | referral |
events
| event_id | user_id | event_date | event_name |
|---|---|---|---|
| 1 | 1 | 2024-03-03 | first_project_created |
| 3 | 3 | 2024-03-06 | first_project_created |
| 8 | 8 | 2024-03-26 | dashboard_view |
Expected output
Your answer should return 3 rows with the columns channel, signups, activated_users, activation_rate.
Starter code (SQL)
SELECT *
FROM signups;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