Collections Funnel SQL Analysis | Dataford Interview Questions

Write a SQL query to analyze a collections funnel by stage, calculating conversion rates and drop-off between steps.

Use all available funnel stages and stage events. Count each account once per stage, including stages with no matching events.

Output

One row per funnel stage with stage_name, entrants, previous_entrants, conversion_rate_pct, and dropoff_count
Include the first stage with null prior-stage metrics
Order by the defined stage sequence

funnel_stages

Column	Type	Description
stage_idPK	INT	Unique funnel stage identifier
stage_name	VARCHAR(100)	Name of the collections funnel stage
stage_order	INT	Sequential position of the stage

collection_stage_events

Column	Type	Description
event_idPK	INT	Unique stage event identifier
account_id	VARCHAR(30)	Account associated with the event
stage_id	INT	Funnel stage reached by the account
entered_at	DATE	Date the account entered the stage

Your question is Collections Funnel SQL Analysis. 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.