Schema and sample queries
Use the User DB schema and sample SQL queries to calculate lifetime value, monetization, and user lifecycle metrics.
User DB schema and sample queries​
Learn the Swrve User DB table schema and run sample SQL queries on the swrve_properties, events_fired, items_purchased, and segment_membership tables.
Computing lifetime value​
Run sample Redshift and MySQL queries on Swrve User DB data to estimate user lifetime value, grouped by install date cohort or referrer channel.
Monetization queries​
Explore app monetization with Swrve User DB queries that compare session starts per IAP, purchase counts, and how spend and revenue vary by user lifetime.
Top five user lifecycle queries​
Use five Swrve User DB queries to analyze user lifecycle, including average lifetime, lifetime breakdown, funnels, multiple dimensions, and engagement.