SQL Metrics Definition and Querying | Dataford Interview Questions

Tell me about how you would define success metrics for a product question, then write SQL to compute them.

Use the supplied user and product event data. For this exercise, define activation as a core action within seven days of signup and retention as any event during days 7 through 13 after signup.

Output

One row per signup month, with signup_month, total_users, activated_users, activation_rate_pct, retained_users, and retention_rate_pct.
Include signups from January and February 2025 only, and order by signup_month ascending.

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
signup_at	TIMESTAMP	Timestamp when the user signed up
acquisition_channel	VARCHAR(50)	Channel that acquired the user

product_events

Column	Type	Description
event_idPK	INT	Unique event identifier
user_id	INT	User associated with the event; NULL represents an anonymous event
event_name	VARCHAR(50)	Name of the product event
event_at	TIMESTAMP	Timestamp when the event occurred

Your question is SQL Metrics Definition and Querying. Start with the requirements and the two tables 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