Analyze Asana Onboarding Funnel Dropoff | Dataford Interview Questions

Your question is Analyze Asana Onboarding Funnel Dropoff. Start with the requirements and the three tables on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

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.

Requirements

Treat the funnel steps as: signup workspace_created project_created task_completed.
Only count events that happen within 7 days of the user's signup timestamp.
Return one row per signup_date with:
- total signed up users
- users who reached each funnel step
- conversion rate from signup to each step
- the step with the largest dropoff in user count
Exclude users whose signup_ts is NULL.

Use the tables below.

Schema

users

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

event_log

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

workspace_memberships

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