SQL Funnel Drop-Off Analysis

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

1. Restrict events to February 2025 and the airbnb_app surface, joining valid users from users.
2. Report each funnel stage in order: search, listing view, reservation request, and booking confirmation.
3. 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.
4. Include stages with no users, preserve funnel order, and calculate conversion as a decimal rounded to three places.

Output details

• Return columns in this order: stage, reached_users, qualified_event_count, previous_stage_users, conversion_rate, dropoff_users.
• Order rows as search, listing_view, reservation_request, booking_confirmed.
• Treat February 2025 as timestamps from 2025-02-01 00:00:00 inclusive through 2025-03-01 00:00:00 exclusive.
• Count every qualifying event for qualified_event_count, including repeated events by the same user.
• Use NULL for the first stage's previous_stage_users, conversion_rate, and dropoff_users, and return NULL conversion when the previous-stage count is zero.