Event Stream Overview

Export granular data for independent analysis with Sailthru Connect. Gain insights about your audience and how users respond to marketing messaging sent via Sailthru.

Available Data Sets

The following Sailthru Connect data sets documentation show all the information provided by each data set. Each bullet point in the following lists are linked to the full table.

Email Event Data

The following schema reflects the events that can occur when a marketer sends an email through the Sailthru platform, and the end user’s interaction with that message.

Lookup Data

The following schema reflects the associated metadata that a marketer may wish to enrich event data for the purposes of segmentation in their reporting.

Mobile Event Data

The following schema reflects the events that can occur when a marketer sends a mobile message or push through the Sailthru platform, and the end user’s interaction with the message or the app itself.

Forward Compatibility

Sailthru will continue to iterate on its Event Stream offering in an additive manner (sometimes referred to as “forward compatibility”). New fields that appear in the file outputs will not necessarily match older schemas, and will generally be forward compatible. Sailthru advises that customer teams refer to a field by column name, and not by position. We recommend that customers avoid expecting or validating against a fixed number of fields, or fields in certain positions, which would cause errors if additional columns are provided or if field ordering changes. Sailthru will look to give advance warning in the case of any changes, and will work to minimize breaking changes to the schema at any time (i.e. field name changes, field removals).

Bucket Structure

Your bucket structure will look different depending on the type of event/lookup data. Data exported into your bucket will adhere to the following pattern for event data tables:

s3://[bucketname]/[table_name]/dt=[yyyymmdd]/client_id=[client_id]/[exportfilename].csv

For example:

s3://example-bucket/campaign_click/dt=20190926/client_id=0000/part-1ae5f73f.csv

Data exported into your bucket will adhere to the following pattern for lookup data tables:

s3://[bucketname]/[table_name]/dt=[yyyymmdd]/hr=[hh]client_id=[client_id]/[exportfilename].csv

For example:

s3://example-bucket/campaign/dt=20191001/hr=00/client_id=0000/part-1ae5f73f.csv

Note: Sailthru recommends that you avoid adding your own objects into this bucket. The intention is to avoid unexpected issues with the export process or inadvertently giving Sailthru access to non-Sailthru data.

Bucket Policy

To set up your bucket policy, see S3 Bucket Policy Information. This page contains information on setting up an Event Stream bucket policy, a joint policy for both Event Stream and Data Exporter, or a Data Exporter connection.

Top