All tasks

Conversion Funnel Analysis

Advanced

Task level: Product Analytics / Amplitude. **Condition:** Build a conversion funnel: view → add_to_cart → checkout → purchase. Calculate the conversion between each stage. **Table:** user_events (user_id, event_type, product_id, event_time, session_id) **Requirements:** 1. Count unique users for each stage 2. Calculate conversion: % who moved to the next stage 3. Calculate overall conversion (view → purchase) 4. Output: stage, users_count, conversion_to_next %, cumulati

Category
Analytics
Estimated time
~30 min
Databases
PostgreSQLGreenplum
Tags
FAANGInterviewFunnelConversionProduct Analyticsподзапросы

Sign in to solve

Start Solving