Customer Lifetime Value calculation

Question & Answer
,
1

Hi, I want to calculate CLV but I really don’t know if my calculations are correct or not. I consider a publisher having orders to be a customer

CLV = Customer value * Average Customer Lifespan
= (Average purchase value * Average frequently rate) * Average Customer Lifespan
=> Average purchase value = {sum_app_sales_amount}/{sum_app_quantity}

  Average frequently rate = sum({sum_app_quantity})/ {num_of_pub_having_order}

Average Customer Lifespan = Average of years a customer stays active/total of customers
= avg(avgOver(dateDiff({customer_acquisition_date}, {customer_final_date}, “MM”), [{publisher_username}], PRE_AGG))/ {num_of_pub_having_order}

And this is the result

image
image1414×462 43.7 KB

2

Hello @thecuon119 !

Are you trying to display the Customer Lifetime Value over time with this visual?

My recommendation, if you are trying to double check your work, is to create a table visualization with your calculated field and the component fields you used to create your calculation. That way you can compare your math with the output of your calculated field to make sure you are getting the expected outcome.

3

@thecuon119 here is another community post about customer life time value you want to review - Calculating lifetime value