Skip to main content

​
Creating a customer lifetime value model

​
Overview

You can find the total monetary worth of a customer to your business over a period of designated time with the help of Customer Lifetime Value (CLV) model. Moreover, the valuable customers can be retained by comparing CLV to marketing costs.

​
To create CLV model

Follow the below steps to start creating a customer lifetime model:
  1. Go to Activate > Models.
The Models page appears. Alt text
  1. Select Master Data from the dropdown list. When you select the master data, the system validates the selected master data type and filters the predictions based on the selection.
  2. Click Use this model on Customer lifetime value.
The Customer lifetime value form appears. Alt text
  1. Click Get Started.
The Model name page appears. Alt text

​
To name your CLV model

Follow the below steps to name your CLV model:
  1. In the Model name page, type a name in the Name this model text area.
  2. Type a name in the Output table name text area.
  3. Click Save & Proceed.
The Model preferences page appears. Alt text

​
To create model preferences

Follow the below steps to create your model preferences:
  1. In the Model preferences page, select a value from the Predict customer value over the next drop-down list.
ToDo
Select the time in months to predict customer valueSelect Month (s).
Select the time in years to predict customer valueSelect Year (s).
  1. In the Active customers section, perform one of the following actions to check the time that a customer has spent amount of money on your products or services.
ToDo
Let the model calculate the time spanSelect Let model calculate purchase interval from drop-down list.
Set the time span manuallySelect Set interval manually from the drop-down list.
  • In case, you select Set interval manually from the drop-down list, perform one of the below actions:
    ToDo
    Select the time in months to predict customer valueSelect Month (s).
    Select the time in years to predict customer valueSelect Year (s).
  1. In the High-value customer section, select one of the below options to determine high-value customers:
ToDo
Indicate the percentile of high-value customer manuallySelect Percent of top active customers from the drop-down list.
Let the model calculate the percentile of high-value customer based on your dataSelect Model calculation from the drop-down list.
  • In case, you select the Percent of top active customers from the drop-down list, enter % of active customers in the High-value customers are the top section.
  1. Enter a value in the Discount text area.
  2. Click Save & Proceed.
The Required data page appears. Alt text

​
To add required data

Follow the below steps to add required data to your CLV model:
  1. In the Required data page, click Add new.
The Add Customer Data form appears. Alt text
  1. Select Customer transaction from the drop-down list.
  2. Select Transaction ID from the drop-down list.
  3. Select Transaction date from the drop-down list.
  4. Select Value of transaction from the drop-down list.
  5. Select Label assigned to returns (if any) from the drop-down list.
  6. Select Product ID from the drop-down list.
  7. Click Save.
The table gets created. Alt text

​
To edit the created table

In the Required data page, you can click the three horizontal ellipses under the Action column to edit the created table.
  • If required, you can perform one of the below actions:
If you want toThen
Edit the created tableSelect Edit.
Delete the created tableSelect Delete.
  • Once done, click Save & Proceed in the Required data page.
The Additional data page appears. Alt text

​
To add additional data

Follow the below steps to add additional data for the model to sharpen the accuracy of the model’s CLV prediction:
  1. On the Additional data page, click Add New.
The Add Customer Data form appears. Alt text
  1. Select a Customer activity table from the drop-down list.
  2. Select a Primary key from the drop-down list.
  3. Select a Timestamp from the drop-down list.
  4. Select an Event from the drop-down list.
  5. Select Details from the drop-down list.
  6. In Activity type, perform one of the below actions:
ToDo
Select an Activity Type from the drop-down listClick Select from existing.
Type a new activity type in the Activity Type text areaClick Create new.
  1. Click Save.
:::note In case, you do not have any additional data to add, you can skip this step. ::: The Additional data gets created. Alt text
  1. Click Save & Proceed.
The Data update schedule page appears. Alt text

​
To add the Data update schedule

Follow the below steps to schedule your data update:
  1. In the Data updates page, perform one of the following actions:
ToDo
Import your data automatically every weekSelect Weekly.
Import your data automatically every monthSelect Monthly.
Import your data automatically every three monthsSelect Quarterly.
Choose not to import your data automaticallySelect Never.
:::note Although there is an option of choosing not to schedule your data imports, you are still not recommended to select that option. :::
  1. Click Save & Proceed.
The Review and run page appears. Alt text

​
To review and run your model

Follow the below steps to save your customer lifetime value model or run it:
  1. In the Review your model details page, click the Edit icon to edit the details.
  2. Once you complete your review or editing, perform one of the below actions:
ToDo
Save and run your customer lifetime value modelClick Save & Run.
Save your customer lifetime value modelClick Save & Close.

​
To view High or Low CLV customers

You can view your customers with high CLV on Skypoint AI. Follow the below steps to view the customers with High or Low CLV:
  1. Go to Lakehouse > Databases.
  2. Click your desired CLV Database.
  3. Select the Data tab to view the High/Low CLV column.