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

    Time to reach some cumulative value per customer

    Jivan Roquet

      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