Last modified October 11, 2018 by Gordon Glauser

Manually downloading user DBs

You can manually import User DB CSV files into a local database or reporting tool to run ad-hoc data-mining queries. Download different data sets of your user profiles on the User DB Downloads screen.

User database download screen

Data sets are updated daily to reflect the latest cumulative state of your users from all time. Swrve provides data sets in the following formats:

Format Description
User Sample This is a gzipped bundle of eight CSV data files (one for each user property type, plus an extra file called swrve_fat_dataset that contains all combined data) for a random sample of 10,000 users. This data set enables you to perform spreadsheet analysis and you can easily import the data into a spreadsheet tool for further analysis (for example, using pivot tables).The files are available in two formats, depending on the program you use:

  • Data formatted for Microsoft Excel, Google Spreadsheets or Tableau
  • Data formatted for MySQL

File names begin with sample-users*.

All Users This table provides individual data sets covering all users for all time. Each column represents one of the available user property types. You can use the data sets provided in this table to perform database analysis. Depending on your DAU and the history of your app, the data sets can be very large, so data is typically split over multiple files. File names begin with all-users*.Swrve provides the following scripts to help you to define database schemas for this format:

  • MySQL scripts – to create the corresponding tables in a MySQL database.
  • Redshift scripts – to create the corresponding tables in an Amazon Redshift database.

Please note the format of these data sets has recently changed to include a header row, so you will need to ignore the first line of these CSV files when importing them into your system.

How to download a data set

Step 1: On the Analytics menu, select User DB Downloads.

Step 2: Select the link for the data set that you want to download. The data set is automatically downloaded to your default download folder as a gzipped CSV file.

Alternatively, you can automate the download of these files using Swrve’s Export API. For more information, see Swrve Export API guide.

Next steps

  • Learn how to download data sets and import them into your database by following the user DB tutorials. For more information, see Automating user DB imports.