Designing KPI Dashboard for Launch | Dataford Interview Questions

Walk me through how you would design a KPI dashboard for a new product launch.

Write a PostgreSQL query using the provided launch and event data to produce a 30-day KPI view for every launch.

Output

One row per product launch with product_id, product_name, launch_date, page_views, signups, activated_users, paying_users, revenue, and signup_rate.
Include launches with no qualifying events, using zero values for their metrics.
Include only events from the launch date through the following 30 days, excluding events on the thirtieth day after launch.
Order by launch_date ascending, then product_id ascending.

product_launches

Column	Type	Description
product_idPK	INT	Unique product launch identifier
product_name	VARCHAR(100)	Product name
launch_date	DATE	Product launch date

launch_events

Column	Type	Description
event_idPK	INT	Unique event identifier
launch_id	INT	Product launch associated with the event
event_date	DATE	Date on which the event occurred
user_id	INT	User associated with the event
event_type	VARCHAR(50)	Event category such as page_view, signup, activation, or purchase
revenue	NUMERIC(12,2)	Revenue attributed to a purchase event

Your question is Designing KPI Dashboard for Launch. 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.