Skip to content
  • For Marketing
    • AI Personas and Behavioral Segmentation
    • Campaign Recommendations
    • Lead Scores
    • Churn Prevention with “At Risk”
    • Lifetime Customer Value (LCV)
  • For Sales
    • AI Personas and Behavioral Segmentation
    • Lifetime Customer Value (LCV)
    • Lead Scores
    • Churn Prevention with “At Risk”
  • Products
    • AI Development
    • AI Personas and Behavioral Segmentation
    • Campaign Recommendations
    • Lead Scores
    • Lifetime Customer Value (LCV)
    • Churn Prevention with “At Risk”
  • Blog
  • Resources
    • Api Documentation
    • Glossary
    • Getting Started Wizard
    • Videos
    • Privacy Statement
    • Terms and Conditions
  • Register / Login
Menu
  • For Marketing
    • AI Personas and Behavioral Segmentation
    • Campaign Recommendations
    • Lead Scores
    • Churn Prevention with “At Risk”
    • Lifetime Customer Value (LCV)
  • For Sales
    • AI Personas and Behavioral Segmentation
    • Lifetime Customer Value (LCV)
    • Lead Scores
    • Churn Prevention with “At Risk”
  • Products
    • AI Development
    • AI Personas and Behavioral Segmentation
    • Campaign Recommendations
    • Lead Scores
    • Lifetime Customer Value (LCV)
    • Churn Prevention with “At Risk”
  • Blog
  • Resources
    • Api Documentation
    • Glossary
    • Getting Started Wizard
    • Videos
    • Privacy Statement
    • Terms and Conditions
  • Register / Login

Lifetime Customer Value (LCV)

  • Dan Baird
  • July 22, 2022

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
Previous
Next
Share the Post:

Related Posts

Get Inside Your Audience's Head: Discovering Customer Affinities with AI

Get Inside Your Audience’s Head: Discovering Customer Affinities with AI

In today’s crowded marketing landscape, simply broadcasting your message and hoping it sticks is no longer effective (and if it

Read More

Onboarding: Connecting Your Data

Once you’ve created a Wrench.ai account, it’s time to connect your data. This video will walk you through the simple steps to complete your data integration.

Read More

Want to learn more?

Wrench.ai uses predictive analytics to transform your customer data into actionable insights that provide deeper personalization and engagement to your campaigns.

The personalization platform driving acquisition, growth, and engagement.

Twitter Linkedin
Info
  • Privacy Policy
  • Terms
  • API documentation
  • Getting Started Guide
  • Videos
Quick Links
  • For Marketing
    • AI Personas and Behavioral Segmentation
    • Campaign Recommendations
    • Lead Scores
    • Churn Prevention with “At Risk”
    • Lifetime Customer Value (LCV)
  • For Sales
    • AI Personas and Behavioral Segmentation
    • Lifetime Customer Value (LCV)
    • Lead Scores
    • Churn Prevention with “At Risk”
  • Products
    • AI Development
    • AI Personas and Behavioral Segmentation
    • Campaign Recommendations
    • Lead Scores
    • Lifetime Customer Value (LCV)
    • Churn Prevention with “At Risk”
  • Blog
  • Resources
    • Api Documentation
    • Glossary
    • Getting Started Wizard
    • Videos
    • Privacy Statement
    • Terms and Conditions
  • Register / Login
Menu
  • For Marketing
    • AI Personas and Behavioral Segmentation
    • Campaign Recommendations
    • Lead Scores
    • Churn Prevention with “At Risk”
    • Lifetime Customer Value (LCV)
  • For Sales
    • AI Personas and Behavioral Segmentation
    • Lifetime Customer Value (LCV)
    • Lead Scores
    • Churn Prevention with “At Risk”
  • Products
    • AI Development
    • AI Personas and Behavioral Segmentation
    • Campaign Recommendations
    • Lead Scores
    • Lifetime Customer Value (LCV)
    • Churn Prevention with “At Risk”
  • Blog
  • Resources
    • Api Documentation
    • Glossary
    • Getting Started Wizard
    • Videos
    • Privacy Statement
    • Terms and Conditions
  • Register / Login
Get In Touch
  • Email: info@wrench.ai.com
  • Phone: 415-766-0778
  • Hours: Mon-Fri 9:00AM - 5:00PM

© All Rights Reserved.