Meta wants to measure a simple Messenger onboarding funnel: signup → first message sent → 7-day active. Write a SQL query to calculate, by signup date, how many users reached each stage.
A user counts as:
usersReturn one row per signup_date with counts for each funnel stage.
signup_datesignup_date + 7 dayssignup_date| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Unique user identifier |
| signup_ts | TIMESTAMP | Timestamp when the user signed up |
| signup_surface | VARCHAR(50) | Meta surface where signup started |
| Column | Type | Description |
|---|---|---|
| message_idPK | INT | Unique message identifier |
| sender_id | INT | User who sent the message |
| sent_ts | TIMESTAMP | Timestamp when the message was sent |
| thread_type | VARCHAR(30) | Conversation type |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique activity event identifier |
| user_id | INT | User who generated the activity event |
| event_ts | TIMESTAMP | Timestamp of the activity event |
| event_name | VARCHAR(50) | Type of activity event |