SalesMetrics.Customer Lifetime Value measure

Finding and your answer

SalesMetrics.Customer Lifetime Value measure

Not found in this gold boundary 99%

How the model read it

No Customer Lifetime Value measure or supporting customer/order structure was observed. The current model's four finance measures are differently named and have unknown exact DAX. The workbook prototype's 3.2 frequency multiplier is illustrative and does not establish a production definition.

Workbook evidence

Target Fields!A8:J8 Sales KPI Prototype!A5:C5 Sales KPI Prototype!B5

Cited current gold

fde-finance.current-model

Open questions

What forecast horizon and expected-order-frequency method should production CLV use?

Should CLV use gross order value, net revenue, gross margin or contribution margin?

How should churn, returns, discounts and customer tenure affect the calculation?

Your answer Confirmed match Current estate already satisfies this. Confirmed partial Partly satisfied — the remainder becomes phase-two work. Confirmed gap Not satisfied — becomes phase-two work. Excluded from scope Stays visible for traceability, but is not proposed work. Needs more evidence Blocks scope until resolved. Enters the research queue.

Why Decided by

Confirmed partial and gap answers enter the scope queue. “Needs more evidence” enters the research queue and blocks the scope document until it is resolved.