Salesforce Decode
Salesforcedecode
Back to questions
Data CloudAdvancedcalculated-insightsclvmetricsanalytics

Implement calculated insights for customer lifetime value

Real World Scenario

Leadership wants CLV available on unified profiles for service prioritization and media spend optimization. Source data spans 5 years of orders across brands.

Expected Answer

• Define CLV formula aligned with finance: historical revenue, margin, retention curve, or predictive model • Use calculated insights with appropriate aggregation windows and currency normalization • Handle returns and refunds in net revenue calculations • Segment CLV by brand vs enterprise total—document which is canonical • Refresh cadence: nightly for operational use vs weekly for strategic planning • Validate against finance reports with tolerance thresholds and exception reporting • Expose CLV to Service Cloud via Data Cloud related lists or activation—not duplicated formulas in CRM

Follow-Up Questions & Answers

Click to expand — each follow-up includes a direct, interview-ready answer

Main difference: use case and scale. Define CLV formula aligned with finance: historical revenue, margin, retention curve, or predictive model. Use calculated insights with appropriate aggregation windows and currency normalization. Pick based on your integration pattern and team capability. One definition of CLV enterprise-wide—multiple conflicting calculated insights destroy trust. Optimize for scale and operational observability.

Architect Perspective

One definition of CLV enterprise-wide—multiple conflicting calculated insights destroy trust. Partner with finance on formula before building.