6 Replies Latest reply on Feb 6, 2018 12:20 PM by Travis Hall

    How to see customers lifetime value from source.

    Travis Hall

      I have run into a rookie problem. I am trying to see what the lifetime value (sum of subtotal) of a customer is based on their first source (source being, what channel they came in from).

      I have run the report to see what each order value is from the source, but not a running total of orders/subtotal after they come in from a channel.

       

      Here is the information that I collect:

      Table 1  

      Order_Id, user_id, ordered_at, Marketingsource, subtotal

       

      Table 2

      user_idfirst_namelast_nameorder_countphoneemail

       

       

      Any direction is greatly appreciated.  My end goal is to be able to say from the Google source a customers lifetime value to date is X.