SQL Funnel Drop-Off Analysis | Dataford Interview Questions

Your question is SQL Funnel Drop-Off Analysis. Start with the requirements and the two tables on the right.

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

Problem

Airbnb wants to understand where users drop out of the Airbnb Homes booking funnel in the mobile app. Write a PostgreSQL query for February 2025 that measures sequential funnel engagement.

Requirements

Restrict events to February 2025 and the airbnb_app surface, joining valid users from users.
Report each funnel stage in order: search, listing view, reservation request, and booking confirmation.
Return distinct users reaching each stage, total events from qualified users at that stage, conversion from the previous stage, and user drop-off from the previous stage. A user qualifies for a stage only if they reached every preceding stage.
Include stages with no users, preserve funnel order, and calculate conversion as a decimal rounded to three places.

Schema

users

Column	Type	Description
user_idPK	INT	Unique Airbnb user identifier
signup_date	DATE	Date the user signed up
country_code	VARCHAR(2)	Two-letter user country code

funnel_events

Column	Type	Description
event_idPK	INT	Unique funnel event identifier
user_id	INT	References users.user_id
event_type	VARCHAR(30)	Airbnb Homes funnel action
event_timestamp	TIMESTAMP	Timestamp when the event occurred
surface	VARCHAR(20)	Product surface generating the event