In the Outputs tab, choose the results to display. The customers being charged at the beginning of the month, we choose the option Start of period in the Payment section. In the Options tab, we can take certain parameters, such as the discount rate or fixed operating costs, into account in the CLV computation. Our data set contains segments variable, so check the case Segments and select the corresponding data to allow XLSTAT to produce results by segments.Īs the subscriptions are monthly, select monthly in the subscription period field. Then select in order the two columns related to the acquisition date and churn date in the field Time(acquisition/churn). In the General tab, select the column corresponding to the subscription price in the ARPA (Average Revenue Per Account) field. The Customer Long-term Value dialog box appears: Once XLSTAT is launched, select the Advanced Functions / Marketing Tools / CLTV feature. Setting up a Customer Long-term Value dialog box The goal of this tutorial is to calculate the CLTV (customer long-term value) of customers and to obtain a detailed overview of the customers life cycle. Three groups of users from a value-based segmentation are represented: Young, Classic and Premium. The dataset represents a sample of monthly subscription data from a phone service provider. Dataset and goal of this tutorial on Customer Long-term Value (CLTV)
Xlstat customer service how to#
This tutorial shows how to compute and interpret a Customer Long-term Value analysis in Excel using the XLSTAT software.
0 kommentar(er)
