Skip to main content

User database

Download Swrve user databases (User DBs), automate importing them, and query them for analysis.

Intro to user databases​

Learn what the Swrve User DB contains, which user property data sets are available, and how to download them as CSV files for ad hoc analysis.


Manually downloading user DBs​

Download Swrve User DB data sets from the User DB Downloads screen, compare the User Sample and All Users formats, and get campaign metadata files.


Automating user DB imports​

Automate Swrve User DB downloads with the Export API and scripts that create database tables and import the CSV data sets into Amazon Redshift or MySQL.


Schema and sample queries​

Learn the Swrve User DB schema and run sample SQL queries for lifetime value, monetization, and user lifecycle analysis on your imported user data.


User acquisition analysis​

Use Swrve User DB data to recalculate return per install from the User Acquisition report and break results down by device for deeper analysis.