I have a query written in MySQL. Not sure if I am doing this correctly.
I want to achieve the following:
I need to find out the the average amount of months that a group of users use a product for.
See 'AS MEMBERSHIP_LTV' in query.
I have attempted to use datediff for this but am not sure if this is correct. Im not sure if I am going at this in the totally incorrect way and need some help please.
How does one calculate what the average subscription time in months per product across multiple users?
How long does the product user group stay subscribed for on average?
The columns that manage the state date and end date are:
How doe we use these multiple dates to work out a group average because the indiviuals subscribe at different dates
I am wanting to know grouped by
I want to look at these numbers by year to establish if the changes we make to our products we offer are improving the time the customers stay subscribed for looking back over the years.
Any suggestions or advice will be appreciated