In this post, we will see how to resolve Customer LTV SQL Query
Question:I m trying to figure out SQL query for calculating Customer Long term value. Here is the current table tblCustomerRevenue:
Goal is to get the customer order value for every date/every customer the following metrics: 1 Day total, 1 week, 1 month, 1 year purchase totals like below. Can someone please point me in the right direction? Thank you
Best Answer:You need to generate the dates you want to be shown. The
revenue1daycan be today or yesterday. The same for the month column.
If you have better answer, please add a comment about this, thank you!