2 Replies Latest reply on Jul 30, 2018 7:20 AM by Yuriy Fal

    Lifetime Value

    Megha Chhabra

      Hi,

       

      How can I calculate LTV of a driver over the entire lifetime of a driver using the attached data.

        • 1. Re: Lifetime Value
          Deepak Rai

          Hi Megha,

          May be you need this?

          Thanks

          Deepak

          • 2. Re: Lifetime Value
            Yuriy Fal

            Hi Megha,

             

            Deepak is right about using FIXED LOD at the level of [Driver ID].

            It is how the Lifetime would be defined that makes a difference.

             

            Having the [Driver ID] in the data would allow calculating their lifetimes directly.

            The AVG Lifetime per Driver is a simple aggregation of the values for each Driver.

             

            The fine point is to define a proper Recent Date Period (as a filter)

            to exclude the latest / newest Drivers that have Rides in the Recent Period.

             

            One couldn't count those Drivers as Churned,

            so their Lifetimes couldn't be taken into account.

             

            Please find the attached as an example illustrated the above logic.

             

            Yours,

            Yuri