hero background shape
Use Case

Customer Lifetime Value

hero background gradient
 

Implementing and executing customer lifetime value (CLV) analytics can be expensive and time consuming. Through automation, companies can connect customer data with sales data, apply CLV calculations, and segment those customers into different bands according to value and lifetime, all in the same process.

Top-Line Growth

Focus initiatives on the highest value customers

Customer Experience

Directly measure ROI of CX expenditures

Risk Reduction

Target customers with highest value first in churn reduction efforts

 

Business Problem

Customer lifetime value (CLV) is a measurement of how valuable a customer is to your company over that customer’s lifetime. When properly mapped and calculated, it highlights those customers with whom the whole of your relationship is quantitatively greater than the sum of its individual transactions.

CLV is a difficult calculation for most companies. It’s made up of metrics like length of relationship (in years), website visits, coupons used, customer referrals, purchase volume, and product preferences — data points held in multiple disparate sources. It can be a costly, needle-in-haystack attempt to identify a small handful of extremely valuable customers, with little short- or medium-term return. That’s why convincing management of the benefits of understanding CLV — for the bottom line as well as the brand — is as important as the exercise itself.

Alteryx Solution

The essence of measuring CLV is to identify the transactions (visits, referrals, purchases, etc.) at which customers create value, then weave the data from those transactions into a customer journey. By adding up the revenue in each transaction and using predictors to extrapolate into the future, the company arrives at the lifetime value of that customer. The goals are to build relationships with high-value customers and to move other customers into higher-value segments through marketing.

Automation smooths the process of collecting transactions from a variety of data sources and predictive analytics extrapolates from historical data to help estimate future revenue. Alteryx Customer Lifetime Value workflow in the Customer Analytics Starter Kit enables users to combine customer data from multiple sources and to use that data to train a forest model to predict spend for current customers. This model can then be applied to new customers to understand their expected lifetime value before they ever make a purchase.

 

1 – Data Access

Combine customer sales, demographic, and psychographic data

2 – Prep & Blend

Combine current and new customer streams while removing unwanted fields

3 – Predictive Analytics

Utilize a Forest Model tool to predict spend for new customers

 

Additional Resources

 
 
Starter Kit for Marketing Analytics
Learn More
 
 
Analytics Automation for Customer Intelligence
Learn More
 
 
Starter Kit for Customer Analytics
Learn More
 

Recommended Resources

 
Webinar
PwC Gold Sponsor Session: Human-led, tech-powered
In this sponsor session at Inspire on Tour in London, hear from PwC Partner Karl Saunt to hear how PwC transformed their business by investing in the democratisation of analytics, and how they have helped their customers to improve their processes and reduce their exposure to risk.
  • Finance
  • Marketing
  • Supply Chain
Watch Now
 
Customer Story
Kurt Geiger Uses Alteryx to Improve Shopper Frequency and Drive Social Impact
Kurt Geiger, purveyor of luxury footwear, handbags and small leather goods leans into data & analytics to improve shopper frequency by 15% whilst fueling their philanthropic customer loyalty programme, Kurt Cares.
  • BI/Analytics/Data Science
  • Data Analytics
  • Marketing
Learn More
 
Webinar
Sustainable Citizen Development Through Governance and Best Practices
Learn how The LEGO Group gains better supply chain visibility with low-code, no-code analytics and process automation.
  • Live Webinar
  • Customer Success
  • Supply Chain
Watch Now