Lifetime Customer Value (LCV)

Lifetime Customer Value

Goal

Provide a score for each existing customer that takes into account purchase history. The score incorporates purchase data that takes into account both historical purchases and forecasted purchases. This amalgamation of historical and future value to the business enables marketing teams to focus resources on customers that have the greatest revenue potential.

Deliverables

  • Individual-level LCV labels (i.e., high, medium, low)
  • Individual level diagnostic categories (e.g., total spend, recency, average spend, number of transactions, loyalty span, etc.)

Primary Source Data

  • Transaction data (minimum with primary key)
  • Customer/Contact bio/profile/descriptions
  • Transaction data is not necessary once a model has been trained and scored using transaction data. Subsequent LCV scoring can be done with match scores and profile data (e.g., sex, age, zipcode, tel prefix, email domain, etc.)

Required Scores

  • Brand/product match scores

Steps

  1. ETL: date to integer
  2. record-level transaction arrays
  3. record-level regression
  4. extract spend summary values:
  • max spend
  • total spend
  • number of transactions
  1. extract date summary values:
  • earliest transaction date
  • most recent transaction date
  • span of transaction dates (i.e., number of days)
  • number of days between ‘today’ and most recent transaction date

Transformations for customers with <2 transactions

  • future spend
  • recency
  • spend total
  • spend maximum
Share the Post:

Related Posts

Wrench.AI partners with Ideaship to scale personalization

Lead Scores

Goal Businesses want to enhance the effectiveness of their marketing and sales resources. This means finding customers or potential customers

Read More