1 Reply Latest reply on Mar 29, 2016 11:55 AM by diego.medrano

    Payback, LTR and Lifespan Convergence View

    collin.watson

      Hi All,

       

       

      My team and I are working on an LTV analysis and need some help generating a specific graph.

       

       

      We are attempting to show when the average customer pays us back and how that relates to our Average Lifetime Revenue and Average Customer Lifespan metrics.

       

       

      What we would like to show is the curve leading up to the ratio between these two metrics.

       

       

      We have attempted to drop User Id and Segment Id on the Marks shelf to show the breakdown and then generate a trend line but the trend line does not appear to approach the final ratio.

       

       

      The attached workbook provides a sample dataset and calculations that shows the average payback reference line and the ratio we would like the curve to end at.

       

       

      Any thoughts, feedback, questions or help would be greatly appreciated!