Build a customer dimension: one row per customer (every customer, even those who never ordered), enriched with lifetime measures derived from orders. Count only paid orders.
Columns: - customer_id, segment, country - lifetime_orders — count of paid orders (0 if none) - lifetime_revenue — sum of paid amount_usd (0 if none) - first_order_date — date of their earliest paid order as YYYY-MM-DD (NULL if none) - is_active — boolean, true iff they have ≥1 paid order
Sort by customer_id.