Skip to main content

Raw events

Export Swrve raw event data to your own cloud storage, then load it into Amazon Redshift and query it.

Setting up raw data export​

Set up Swrve raw event data export to an Amazon S3 bucket or Google Cloud Storage, grant Swrve write access, and download the exported log files.


Raw event data schema​

Reference for the Swrve raw event export schema, including event types, user and time fields, payloads, parameters, and generic and custom campaign events.


Redshift sample event queries​

Run sample Amazon Redshift queries on Swrve raw event data to extract JSON custom properties, create custom views, and join events to user state tables.


Redshift event import​

Import Swrve raw event data from Amazon S3 into Amazon Redshift by creating the database and events table, loading data with COPY, and validating it.


Calculating time to first IAP​

Use Swrve raw event data in Amazon Redshift to calculate how long users take to make their first in-app purchase and chart the results as a histogram.