LTV Import
This article explains how to import the Lifetime Value (LTV) of your customers.
Visit the Customers Page in the Loyalty Program
You will see the below view. Now click on the Import button, a dropdown will open select Import LTV, post that a popup will open
![](https://storage.crisp.chat/users/helpdesk/website/d9947dc4cf2ed000/image_1j8guiu.png)
The popup will allow you to Select Format and Upload File file
![](https://storage.crisp.chat/users/helpdesk/website/d9947dc4cf2ed000/image_1snb7mn.png)
We are currently supporting only Nector Custom format
Download the sample CSV file. Now arrange your data as per the CSV file before importing them.
Nector Custom Format - This can be used to import LTV from anywhere. All you have to do is arrange the data as per the CSV format and upload them.
Refer the below screenshot for sample CSV content. Please do not change the column names, they needs to in lowercase letters only.
![](https://storage.crisp.chat/users/helpdesk/website/d9947dc4cf2ed000/image_1peesfu.png)
One of email or mobile is required.
The transaction_amount - refers to the customer’s LTV
To import the LTV of a customer successfully, please make sure transaction_amount column is present. If any one of them is missing then it will be completely skipped.
Now upload the CSV file, and click on Preview button, You will see preview of what will be imported. Only first 50 rows will be shown in the preview. Please check the preview properly before clicking on the Start Import button
![](https://storage.crisp.chat/users/helpdesk/website/d9947dc4cf2ed000/image_1ym4nio.png)
It is recommend you first try and import CSV with 2-3 rows only and if everything works fine, import all of them in one go.
Max CSV file size should not be above 2MB in size
You will see the below when the import starts, and will receive an email once the import has finished.
![](https://storage.crisp.chat/users/helpdesk/website/d9947dc4cf2ed000/image_eotogz.png)
Once you get the import finish email, come to this page to check the imported LTV.
Visit the Customers Page in the Loyalty Program
You will see the below view. Now click on the Import button, a dropdown will open select Import LTV, post that a popup will open
![](https://storage.crisp.chat/users/helpdesk/website/d9947dc4cf2ed000/image_1j8guiu.png)
The popup will allow you to Select Format and Upload File file
![](https://storage.crisp.chat/users/helpdesk/website/d9947dc4cf2ed000/image_1snb7mn.png)
We are currently supporting only Nector Custom format
Download the sample CSV file. Now arrange your data as per the CSV file before importing them.
Nector Custom Format - This can be used to import LTV from anywhere. All you have to do is arrange the data as per the CSV format and upload them.
Refer the below screenshot for sample CSV content. Please do not change the column names, they needs to in lowercase letters only.
![](https://storage.crisp.chat/users/helpdesk/website/d9947dc4cf2ed000/image_1peesfu.png)
One of email or mobile is required.
The transaction_amount - refers to the customer’s LTV
To import the LTV of a customer successfully, please make sure transaction_amount column is present. If any one of them is missing then it will be completely skipped.
Now upload the CSV file, and click on Preview button, You will see preview of what will be imported. Only first 50 rows will be shown in the preview. Please check the preview properly before clicking on the Start Import button
![](https://storage.crisp.chat/users/helpdesk/website/d9947dc4cf2ed000/image_1ym4nio.png)
It is recommend you first try and import CSV with 2-3 rows only and if everything works fine, import all of them in one go.
Max CSV file size should not be above 2MB in size
You will see the below when the import starts, and will receive an email once the import has finished.
![](https://storage.crisp.chat/users/helpdesk/website/d9947dc4cf2ed000/image_eotogz.png)
Once you get the import finish email, come to this page to check the imported LTV.
Updated on: 14/06/2024