• Setting up raw data export

  • This article describes how to get raw event data from Swrve. Swrve supports export of your raw data to both Amazon Web Services (AWS) and Google Cloud Storage. Data is available from the date on which access is set up—historical data is not provided. Export data to Amazon Web Services Swrve logs data for your apps Read More


  • Redshift sample event queries

  • This article describes some sample queries you can run on the raw event data imported from Swrve to Redshift. Custom properties with JSON_EXTRACT_PATH_TEXT Use the json_extract_path_text command to extract custom attributes and payload data. SELECT json_extract_path_text(parameters, 'attributes', '<custom_user_property>') FROM events LIMIT 50; For example, to query information about your users’ timezones: SELECT json_extract_path_text(parameters, 'attributes', 'swrve.timezone_name'), Read More


  • Raw event data schema

  • Swrve logs the raw data for your apps to either Amazon S3 or Google Cloud Storage. This article covers the data schema for those raw events. For more information on setting up raw data export to an Amazon S3 or Google Cloud Storage bucket, see our setup guide. Data schema The schema the raw event Read More


  • Redshift event import

  • This article describes how to import raw event data from Swrve into Redshift. Prerequisites Before you can import raw event data, complete the following: Raw event export – before you can import data from Swrve into Redshift, you need to configure the raw events export. For more information, see Setting up raw data export. Download Redshift query tools – Read More


  • Calculating time to first IAP

  • The Swrve dashboard provides powerful, actionable insights into your users’ behavior. In particular, the dashboard includes large quantities of data about virtual economy usage. Having this huge amount of data about user purchase and monetization behavior is a great start for deeper analysis. This article describes how to use the Swrve raw event data loaded into an AWS Read More