Last modified November 22, 2014 by Gordon Glauser

Computing Lifetime Value

Tutorial objective: Get comfortable with the monetization and user data exposed by the Swrve User DBs and generate initial LTV estimates.

Run Install Date Cohorted Query

The following is an example query that computes interesting lifetime value (LTV) related metrics for each of your users. It groups users by install date for cohort analysis.

Redshift

MySQL

If you are using the Swrve Insights hosted solution, in the SQL query above, the table name is called app_01234_swrve_properties instead of swrve_properties.

Screen_Shot_2014-07-31_at_1.26.37_PM.png


Run Channel Cohorted Query

Another way to look at this data is to group by referrer channel.

Redshift

MySQL

This will give you LTV-related metrics by referrer.Screen_Shot_2014-07-31_at_1.27.00_PM.pngIf you want to slice this data further, you can include device information (which is also in the swrve_properties table).


Need a hosted solution?
Most Swrve customers can self-host this pipeline; all you have to do is follow the steps in these tutorials. However, if you prefer a turn-key hosted solution, we do offer one as a professional service. There is an additional fee associated with this service. For more information, contact your Customer Success Manager at support@swrve.com.

Need help with Queries?
Swrve support can help you with basic setup and configuration of the pipeline described above. If you need help with your queries, contact our Data Services team at support@swrve.com. They will help you get the most out of your data with dedicated support, pre-built and custom reports, and dedicated data science hours.