1 Reply Latest reply on Nov 22, 2018 2:04 PM by Shinichiro Murakami

# Time to reach some cumulative value per customer

Given a raw list of transactions similar to the following (this is the raw data source):

shop_idcustomer_iddate_of_transactiontransaction_amount
12312018/07/10\$32.00
12322018/07/12\$40.00
45612018/07/14\$10.00
45632018/07/15\$21.00
12312018/07/17\$38.00

1) I want to evaluate, for each customer, the time between this customer's first transaction ever, and the moment this customer reaches \$1,000 of (so-far) lifetime value.

Hypothetical example: customer A reached \$1,000 of LTV in 62 days, while customer B reached the same LTV in 45 days.

2) Then, I want to be able to use this time-to-reach-some-LTV as a dimension/measure, that I can re-use in various charts. For instance, I'd want to plot the distribution of time-to-LTV for various customer segments, or to plot the average time-to-LTV as a function of customer's first shop he made his first transaction in. Or, I'd like to plot the average customer LTV (current) based on bins of time-to-reach-some-LTV. For instance, what's the current average LTV for customers who reached \$1,000 in 20-30 days? And what's the average LTV for customers who reached \$1,000 in 30-40 days?

Q: What would be the best way to accomplish both these things in Tableau (using Tableau Desktop)?

Thanks

• ###### 1. Re: Time to reach some cumulative value per customer

Could you prepare sufficient size of data which includes several customers which reached 1000.

and from the conclusion, that can not be done by one data source.

You need to create one table then export that data to the file as another source to use the values for another analysis.

Thanks,

Shin