• User DB schema and sample queries

    • Tutorial objective: Get comfortable working with the data exposed by the Swrve User DBs. This tutorial assumes you’ve already loaded some User DB data into a MySQL or Redshift database. The following are examples of useful queries you can run on the user database to get comfortable working with the User DB data. Understanding the user DB Read More


  • 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. SELECT Read More


  • Monetization queries

    • Tutorial objective: Building on the LTV tutorial to get more comfortable with the monetization and user data exposed by the Swrve User DBs. This article explores a typical app’s monetization and how it can reveal user behavior. How many session starts occur per IAP? Now that we’ve learned about how users get to their first Read More


  • Top five user lifecycle queries

    • Tutorial objective: Get comfortable using the User DB data to understand user lifecycle. Study the lifecycle of your users with the User Properties Database. Advanced users may also wish to import event data in addition to user property data. This article explores how you can determine user lifecycle for a typical app. What is my average user lifetime? Read More