Analyze Asana Onboarding Funnel Dropoff

HardSQL · PostgreSQL

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

Tablesusersevent_logworkspace_memberships