Sailthru

Sailthru provides services for email management. Sailthru services include scheduling and sending campaigns and transactional emails to each user's interest. Campaigns are email messages scheduled for group of users based on a specific template. It can contain news update or promotional messages. Transactional emails are sent to a particular user in response to a specific action.

Features

Setup guide

Follow our step-by-step Sailthru setup guide to connect Sailthru with your destination using Fivetran connectors.

Schema information

This schema applies to all Sailthru connectors.

Schema notes

_fivetran_purchase_id is a calculated hash that is added as the primary key in purchase and purchase_item table.

_fivetran_campaign_query_id is a calculated hash that is added as the primary key in campaign_query and campaign_click table.

Sailthru does not provide email addresses in user report. email_hash column in user table contains MD5 hash values of email addresses.

Sync strategy

We fetch data from the Sailthru API. If you opt to sync Sailthru Connect, we fetch Event Stream data.

We cannot query most of the Sailthru API endpoints using date ranges. Consequently, we need to fetch all historical data during incremental syncs. We can then discard the older data that we already have synced to the destination.

As an exception, the campaign endpoint allows us to use time ranges in our API calls. We can therefore incrementally sync the campaign table that uses this endpoint. For campaign, we fetch all historical data during the initial sync and sync incrementally during the subsequent syncs. We do not need to discard the older records in campaign.

For campaign_query and tables based on it (tables whose names start with campaign_), we fetch the last 18 months' worth of data during the initial sync. During the subsequent incremental syncs, we still fetch the last 18 months' worth of data and discard records older than 60 days.

For the following tables, we sync 30 days' worth of data during both the initial sync and subsequent incremental syncs:

• purchase and tables based on it (tables whose names start with purchase_)
• user and tables based on it (tables whose names start with user_). We sync these tables based on the send_time parameter value returned by the corresponding list endpoint. We retrieve the data for a list only if it has a valid send_time value and if this value is within the last 30 days.

For the following tables, we sync all historical data during both the initial sync and subsequent incremental syncs:

• ad_plan and tables based on it (tables whose names start with ad_plan_)
• template and tables based on it (tables whose names start with template_)
• list

We support fetching older data on request.

Historical sync time frame

You can set the historical sync time frame for the following tables during connector configuration:

• CAMPAIGN_QUERY
• PURCHASE
• PURCHASE_ITEM

Pack modes

Pack modes determine the form in which Fivetran delivers your data to your destination. We provide you the option to choose the pack mode for the custom fields of the LIST_STAT and USER tables.

In the connector setup form, you can choose one of the following packing modes for your custom fields:

• UNPACKED: If you choose this option, we will upsert all the custom fields into separate columns in the LIST_STAT and USER tables. If you select this mode and if the final number of columns exceeds the column limit of your destination tables, some columns may be missing from your destination even though the sync is marked as successful. By default, we use this pack mode.
• PACKED: If you choose this option, we will pack all the custom fields into a single JSON file and upsert it into a single column. We recommend that you choose this option if the number of custom fields exceeds the column limit of your destination tables.

IMPORTANT: The packing mode options apply only to the LIST_STAT and USER tables. As we are setting a hard limit of 10,000 columns for these tables this feature is useful. If Unpacked Mode is selected and the number of columns of your table exceeds 10,000 then we will truncate the columns to 10,000. To avoid this, switch to Packed Mode.

Switching pack modes

You can switch pack modes at any time in your Fivetran dashboard. When you change the pack mode, we automatically perform a full table re-sync of the LIST_STAT and USER tables.

To change the pack mode for a table, do the following:

1. In the connector details page, go to the Setup tab.
2. Click Edit connection details.
3. In the connector setup form, select the Pack Mode of your choice.
4. Click Save & Test.