• Email Summary Transition
    Transition Plans
  • Standard Reporting
    Standard Reporting Overview Standard Reporting Glossary Realtime Dashboard Weekly Performance Report
  • Usage Dashboard
    Send Volume Usage
  • Message Summary
    Email Summary Campaign Reports Triggered Send Reports SMS Summary
  • User Reports
    User Reports Overview User Lookup Lists Report List Growth Report Source Signup Report Snapshots List List Performance Report Jobs List Postback Log
  • Purchase Reports
    Use the Purchase Log to View/Export Purchase Data
  • Sailthru System
    System Status and Alerts
  • Sailthru Connect

    • 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