Skip to main content

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.