Identify 24-Hour Activated Asana Users | Dataford Interview Questions

Asana’s growth team wants to measure how many new users activate quickly after signup. Write a SQL query to identify users who activated within 24 hours of signup.

Requirements

Return each user_id whose activated_at timestamp is within 24 hours after signup_at.
Exclude users who never activated or whose activation happened before signup.
Include signup_at, activated_at, and the activation lag in hours.
Order the result by user_id.

Schema

asana_user_lifecycle

Column	Type	Description
user_idPK	INT	Unique user identifier
email	VARCHAR(255)	User email address
signup_at	TIMESTAMP	Timestamp when the user signed up for Asana
activated_at	TIMESTAMP	Timestamp when the user completed the activation event
signup_surface	VARCHAR(100)	Surface where the signup originated

Your question is Identify 24-Hour Activated Asana Users. Start with the requirements and the one table in the Question tab.

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 measure how many new users activate quickly after signup. Write a SQL query to identify users who activated within 24 hours of signup.

Requirements

Return each user_id whose activated_at timestamp is within 24 hours after signup_at.
Exclude users who never activated or whose activation happened before signup.
Include signup_at, activated_at, and the activation lag in hours.
Order the result by user_id.

Schema

asana_user_lifecycle

Column	Type	Description
user_idPK	INT	Unique user identifier
email	VARCHAR(255)	User email address
signup_at	TIMESTAMP	Timestamp when the user signed up for Asana
activated_at	TIMESTAMP	Timestamp when the user completed the activation event
signup_surface	VARCHAR(100)	Surface where the signup originated

Your question is Identify 24-Hour Activated Asana Users. Start with the requirements and the one table in the Question tab.

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