A task at the level of Product Analytics. **Condition:** Build a cohort retention table: for each registration month, show the % of customers who made a repeat purchase in the following 1, 2, 3 months. **Tables:** - customers (customer_id, registration_date, ...) - ecommerce_orders (customer_id, order_date, ...) **Requirements:** 1. Cohort = client's registration month 2. For each cohort, calculate: cohort_size, month_1_retention %, month_2_retention %, month_3_retention % 3. Retention = % of clients
Sign in to solve
Start Solving