The formula is as follows: 2. Specific case category email list calculation of LT If the general APP is connected to the data analysis platform, you can see the specific retention rate figures in the background. The following figure shows the specific data of a month: Copy and paste data into excel for functional analysis Use the above data [Insert - Chart - Scatter Chart], the chart is as shown above, right click [Add Trend Line] In [Trend Line Options], there are multiple options of exponential, linear, logarithmic, polynomial, power, and moving average. Everyone compares category email list their data points and chooses the one with the best fit. I usually choose [Yes] number】.
At the bottom, check [Display formula] and [Display R squared value], R² represents category email list the degree of fit, and the closer R² is to 1, the higher the degree of fit. Therefore, the function of LT is [y = -0.096ln(x) + 0.5347], which can be substituted into the function for the retention rate data that needs more than one month or longer. As can be seen from the above formula, the LT we require is actually the sum of the retention rate, that is, the area of the blue area under the figure method one: Friends who are good at mathematics can use definite integral to calculate the category email list area under the function [y = -0.096ln(x) + 0.5347]. Method Two: Because I am not familiar with definite integrals,
I use the simple summation method in excel, and simply use category email list the formula to evaluate the data I need, as shown in the following figure: The final excel sum gets the data 8.87, so the average lifetime of LT is 9.87 days in the one-month period I selected . 3. Calculation of ARPU ARPU value has a time attribute, you can talk about daily ARPU, monthly ARPU, etc. Here I still use one month's data. According to the income data provided by Finance and the monthly activity data in the background, the ARPU value is 0.5 yuan/month. Because category email list my product belongs to the tool category, and the overall value is relatively low, everyone still depends on their own data. 4. Calculation of LTV To sum up, we obtained LT=9.87 days and ARPU=0.5 yuan/month.