Customer Lifetime Value

How can we calculate total completed spending for every customer?

Advanced⏱ 3 Minutes⭐ 1980 XP

🤔 THE QUESTION

How can we calculate total completed spending for every customer?

💡 WHAT IS IT?

Filtering completed orders and aggregating by customer_id measures Customer Lifetime Value (CLV).

🎯 WHAT IS IT USED FOR?

CLV reporting, marketing ROI attribution, customer cohort valuation.

💻 EXAMPLE

SELECT
customer_id,
SUM(amount) AS lifetime_value
FROM orders
WHERE status = 'Completed'
GROUP BY customer_id;

Practice typing production-grade SQL code for Customer Lifetime Value.