DinMo Documentation
  • 📙Core Concepts
  • Guides
    • ⚡Get started with DinMo
      • Initial Configuration of DinMo
        • Connect a Source
        • Create your Models
        • Create a Destination
      • Create and Activate Segments on DinMo
        • Create your first Segment
        • Activate your first Segment
    • 🌐Workspaces & Organizations
    • 💭Need Help?
  • Integrations
    • Data Sources
      • AWS Redshift
      • Databricks
      • Google BigQuery
      • PostgreSQL
      • Snowflake
    • Destination Platforms
      • Actito
        • Synchronize users attributes
        • Export contact lists
      • All My SMS
      • Batch
        • Synchronize contacts (MEP)
        • Synchronize profiles (CEP)
        • Send events (CEP)
      • Braze
        • Synchronize users attributes
        • Send track events
        • Synchronize subscription statuses
        • Export user lists
      • Brevo
        • Synchronize contacts
        • Export contact lists
      • Criteo
        • Export contact lists
      • Dialog Insight
        • Synchronise Contacts
      • Emarsys
        • Export contact lists
        • Synchronize contacts data
        • Synchronize custom table's data (RDS)
      • Firestore
        • Create and update Collection Documents
        • Export Audiences
      • Google Ads
        • Export audiences
        • Enhanced Conversions for Web
        • Upload click or offline conversions
          • Prerequisites and walkthrough
        • Adjust conversion events
        • Retract conversion events
      • Google Display & Video 360
        • Export audiences
      • Google Search Ads 360
      • Hubspot
        • Synchronize objects
      • Intercom
        • Export segments
        • Synchronize contacts
        • Synchronize companies
      • Iterable
        • Synchronize user attributes
        • Export contact lists
      • June Email Marketing
        • Export Contact Lists
      • Klaviyo
        • Export contact lists
        • Synchronise contacts
        • Create subscription list
      • LinkedIn Ads
        • Export user audiences
        • Export company audiences
      • Mailchimp
        • Export segments
      • Meta Ads
        • Export audiences
        • Send conversion events
      • Microsoft Ads (Bing)
        • Export audiences
      • Pinterest Ads
        • Export audiences
        • Send conversions
      • Reddit Ads
        • Export Audiences
      • Salesforce Marketing Cloud
        • Synchronize data extensions
      • SendGrid
        • Synchronize contacts
        • Export contact lists
      • Selligent
      • Snapchat Ads
        • Export Audiences
      • Splio
        • Synchronize contacts
      • TikTok Ads
        • Export Audiences
        • Send Offline Conversions
        • Send Web Conversions
      • X (Twitter)
        • Export audiences
      • Zendesk
        • Synchronize users
        • Synchronize custom objects' data
  • Models
    • Overview
    • Primary Keys
      • Detect duplicate primary keys
    • Calculated Fields
  • Identity resolution
    • Overview
  • Segments
    • Visual Builder
    • Breakdowns
    • Overlap Analysis
  • Activations
    • Overview
    • Sync Scheduling
    • Troubleshooting Syncs
      • Automatic pause or resume Activations
      • Sync warnings
  • AI PREDICTIONS
    • Overview
    • LTV and Churn
    • Product Recommendations
  • WORKSPACE MANAGEMENT
    • Set Up
    • Managing Users & Roles
    • Audit Logs
    • Enterprise Single Sign-On (SSO)
  • Security & Privacy
    • Overview
    • Networking
    • Privacy
    • Data Processing
Powered by GitBook
On this page
  • Introduction
  • LTV and churn prediction configuration
  • How to use Churn/LTV prediction
  1. AI PREDICTIONS

LTV and Churn

PreviousOverviewNextProduct Recommendations

Last updated 2 months ago

Introduction

Learn how to use the predicted Customer Lifetime Value (LTV) and churn attributes to understand and predict each of your customers’ purchasing behaviours over time.

Understanding predicted LTV and churn can offer valuable insights into customer buying habits. This information can help identify potential future purchases and opportunities for cross-selling and up-selling. You can also utilise these attributes to personalise the customer buying journey, especially during important times of the year or events that are significant to specific customer segments.

This feature predicts 2 different attributes:

  • Future Customer Lifetime Value (LTV): this indicator computes the expected revenue that a customer will generate in a given future period (1, 3, 6, 9, 12 months). It allows you to segment a customer base, based on their future monetary value. It unlocks several use cases, such as targeting expected high revenue customers.

  • Churn likelihood: this indicator gives the probability that a customer will leave (not buy anymore or in a few months in the future). This allows you to target customers that are likely to leave at the right time and keep them engaged with actions that are revenue driving, in turn, increasing LTV.

Each time a consumer makes a new purchase, the predictions are adjusted accordingly.

DinMo's predictive analytics are invaluable for optimising marketing budgets and tailoring customer communications. While exact predictions for individuals aren't possible, these tools shine by averaging data across a broad customer base. Some customers may surpass their predicted lifetime value (LTV), others may not reach it, yet these differences generally even out overall.

LTV and churn prediction configuration

Initial set up

Go to the Predictions section and choose Customer Lifetime Value to predict LTV and churn predictions.

Select the following fields:

  • Users Model: This user model must contain all the customer data you wish to use for training. You must have a clearly resolved customer list. Ensure there is a relationship with an events model containing all transaction data.

  • Events Model: This event model must contain all the transactions associated to the customers in the model selected above.

  • Transaction Value Field: This field must be available in the events model you've just chosen. This represents the amount a customer spends per transaction. ⚠️ This field should be in a unique currency. Don't mix euros and dollars, for example.

Once done, click on Continue.

Configure the AI attributes:

  • Select he AI attributes you wish to compute, such as churn likelihood and/or Future LTV.

  • Choose the time window for the prediction. For example, selecting a three-month window will compute the likelihood of churn within the next three months.

  • Name the prediction and give a description (optional)

  • Click on Save.

Consulting and interpreting results

Once you've created your prediction, it will be available on the page listing all your predictions. You can get more details about one specific prediction by clicking on it.

By clicking on a specific prediction, you will find several informations in the Overview tab:

  • Prediction quality: When you configure a training on DinMo, the data used as a training set is split into two data sets, one for model training and another for model evaluation. After training the models, we compute predictions on the holdout data to compare it to the ground truth we previously stored. This gives you an idea of the accuracy of the model.

  • Prediction parameters: All the set-ups you did in the previous flow. You can modify them via the “Set up” tab.

  • Attached model: For an overview of the output, click on a prediction and then "Go to model" at the bottom.

An associated predictions model is automatically created, pointing to a predictions table in your data warehouse. You are free to use the results stored in your data warehouse, particularly for BI purposes.

In this prediction model, several fields are populated and refreshed automatically:

  • primary_key: It corresponds to the primary key of your model. This field is not intended for use in segments/activations.

  • user_unique_id: This is the unique identifier (primary key) of your user model. It can be a customer_id, an email, etc.

  • last_update_date: This date corresponds to the last time a user (identified by a user_unique_id) was updated, i.e. his predictive attributes were updated. This may be the case for a number of reasons: the customer has performed an action that has an impact on predictions (e.g. a transaction), you have forced a new prediction, etc.

  • prediction_window_months: This corresponds to the attributes prediction window, which you configured during the set up. You can have several windows predictions (1, 3, 6, 9 or 12 months) in the same prediction.

  • expected_additional_ltv: This indicator computes the expected revenue that a customer will generate in the future, at a specific prediction window (1, 3, 6, 9 or 12 months)

  • churn_score: This indicator gives the probability that a customer will leave (not buy anymore or in the given time window).

  • expected_purchases_number: This indicator gives an estimate of the number of purchases (i.e. transactions) a user will make in a given time window.

Again, exact predictions for each customer are not possible. Some customers may surpass their predicted lifetime value (LTV), others may not reach it, yet these differences generally even out overall. It's exactly the same for churn, or the number of predicted purchases.

How to use Churn/LTV prediction

Using predictive attributes in segments

To apply AI attributes as filters for your segments:

  1. Create a new segment and select the user model you used for predictions.

  2. The AI attributes will appear in the additional model filters. For example, you can choose customers with a churn likelihood above 90% in the coming month.

Most common segments

The most frequently encountered customer cases are listed in the illustration below.

To set up these use cases, you'll need a few basic segments.

  • LTV-Based Segments (Time window can be adjusted)

    • Low LTV: Bottom 20%

    • Regular Customers: LTV between 20% and 80% percentile

    • Top Customers (based on future LTV): Top 20%

  • Churn-Based Segments (Recommended to use a short time window, e.g., 1 month, to identify at-risk customers)

    • Loyal Customers: Churn probability in the bottom 20% percentile

    • Moderate Risk: Churn probability between 20% and 70% percentile

    • High-Risk Customers: Churn probability between 70% and 90% percentile

    • Lost Customers: Churn probability above 90%

It is of course possible to use other segments, combining several attributes (predictive and non-predictive) to implement more advances use cases.

  • Top Customers (Advanced): Customers ranked in the top 20% based on both current LTV and predicted future LTV

  • Future Whales: New customers whose buying behavior closely resembles that of top customers

  • Priority Win-Backs: High churn probability combined with historically high LTV

  • Low Purchase Propensity: High churn probability combined with low predicted LTV and a history of infrequent purchases.

Choose your prediction from all available options
Set up your predictions
Configure your LTV/Churn prediction
All existing predictions will be listed there
All customers who have already made more than 2 transactions and who have a churn risk of over 90%.
Most common use cases based on predicted LTV/Churn