I have a subscription based web app, and would like an accurate way to track lifetime value for each member. This would help figure out what is reasonable to pay for AdWords, for example.
Our app goes back to 2005, but we still have hundreds of members still paying from back then. So, the "good" customers skew any results based on customer cancellations. Is there some kind of formula for this? Without a solid number, for those of you that advertise your app, how do you set a budget?
Fraction that convert to paying * How much they per on average per month * Average months before cancellation * Some sort of Discounting for value of future money (unless you plan to increase price) = value per member
For avg months before cancellation count all those that are yet to cancel as 2x there lifetime (seems reasonable). Would give you a fairly reasonable guess. Then you just have to make sure that the value of a paid member is the same.
discounting: http://en.wikipedia.org/wiki/Discount