Welcome to the SQL screen.
The question is on your right: Analyze Asana Onboarding Funnel Dropoff. Read through the requirements and the three tables first.
Run and submit your code as often as you need. You also have five interviewer messages this session - want to talk through your approach, or are you ready to start coding?
Asana's growth team wants to understand where newly signed-up users are dropping off during onboarding. Write a SQL query to measure conversion through a 7-day onboarding funnel for each signup date.
signup workspace_created project_created task_completed.signup_date with:
signup_ts is NULL.Use the tables below.
| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Unique user identifier |
| signup_ts | TIMESTAMP | Timestamp when the user signed up |
| acquisition_channel | VARCHAR(50) | Marketing channel that acquired the user |
| country_code | VARCHAR(2) | User country code |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique event identifier |
| user_id | INT | User who triggered the event |
| event_name | VARCHAR(50) | Name of the Asana event |
| event_ts | TIMESTAMP | Timestamp when the event occurred |
| surface | VARCHAR(50) | Asana surface where the event occurred |
| Column | Type | Description |
|---|---|---|
| membership_idPK | INT | Unique membership record |
| user_id | INT | User identifier |
| workspace_id | INT | Workspace identifier |
| role_name | VARCHAR(30) | Role in the workspace |
| joined_ts | TIMESTAMP | Timestamp when the user joined the workspace |