Master-level task for FAANG Product Analytics. **Condition:** Build a full cohort analysis of customers with LTV (Lifetime Value) calculation. **Tables:** customers, ecommerce_orders, order_items **Requirements:** 1. Cohort = month of first purchase (not registration!) 2. For each cohort, calculate: - cohort_size (number of customers) - retention_month_1, retention_month_2, ... retention_month_6 (% active) - avg_orders_per_customer (average number of orders) - avg_ltv (average total amount)
Sign in to solve
Start Solving