E-commerce Revenue Attribution — Multi-Touch Funnel, Cohort LTV, and A/B Test Analysis

This query answers three questions that an e-commerce product team asks every week: "which channels drive the most valuable customers?", "how is cohort LTV trending?", and "did our latest experiment move the needle?". It draws on the Real-World dataset (customers, orders, order_items, events, ab_assignments).

Datasets used: customers, orders, order_items, events, ab_assignments, products