Marketing Engineering for Excel Software

Free Trial

University Instructors: Please download the academic version of software from our academic support site.

Customer Lifetime Value Model
What you put in... What you get out...
  • Observed churn rates
  • Customer acquisition cost
  • Number of customers/segments
  • Gross margins by segment
  • Customer transition probabilities across segments
  • Value of current customer base
  • Time required to recoup customer investments
  • ROI on customer/segment investments
  • Size and profitability of customer segments over time; sensitivity to marketing investment plan

Customer Lifetime Value (CLV) is a metric of a customer's value to the organization over the entire history of the relationship.  Short-term sales are a factor, but so are overall customer satisfaction, the churn rate in the segment, and the costs to acquire a new customer and retain an existing customer.

customer lifetime value

The model uses the following input:

Segment Description

Transition Matrix