Sailthru Connect: Code-free, Automation To Data Lakes or Cloud Warehouses
Sailthru delivers personalized customers’ experiences across email, web, and mobile. Data resident in your Sailthru account contains rich insights into interactions users are having with these customized experiences.
Your Sailthru data is part of a puzzle that allows you the ability to understand the customer journey. The better you can understand this journey, the greater your opportunities to unlock insights to deepen customer engagement.
What is Sailthru Connect?
The Sailthru Connect service provides the data needed to fuel the insights backbone to the customer journey. If you are a Sailthru customer looking for data insights automation, Sailthru Connect is key to accomplishing that goal.
The Sailthru Connect product has two components:
- Data Exporter — JSON-based daily export that provides aggregated data about email events and profile information.
- Event Stream — A CSV-formatted export, sent hourly, provides granular event data across critical message categories (e.g., sends, opens, clicks…)
One of the primary benefits of getting your Sailthru data to your data lake (or data warehouse Redshift or Google BigQuery) is the ability to leverage your favorite tools for analysis, visualization, reporting, and analysis like Tableau Software, Power BI, Looker, AWS QuickSight, standard SQL and other BI tools.
Who should use Sailthru Connect?
If you are looking at Sailthru integrations, access to your raw data is the way to go. Connect is perfect for;
- teams that want to fuel sales and BI efforts using Sailthru event data in tools like Tableau, Looker, Periscope Data, Mode Analytics, and many others
- teams that want to “own” their Sailthru data and store in systems like BigQuery, AWS Athena, Azure Data Lake, AWS Redshift, or Redshift Spectrum, and Snowflake
Given the incredible volume of event-level data, using connect is a practical choice when replicating the same outcomes as the Sailthru API.
Sailthru Event Streams
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.
- Campaign Sends
- Campaign Opens
- Campaign Clicks
- Campaign Bounces
- Campaign Unsubscribes
- Triggered Sends
- Triggered Opens
- Triggered Clicks
- Triggered Bounces
- Triggered Unsubscribes
You can find the details for each of the event categories here.
Lookup Data
- Client
- Campaign
- Template
- LO Flow
Mobile Event Data
- Notifications
- Device Events
- Sessions
- Custom Events
- Impressions
Code-free, fully automated Sailthru Connect Data Pipelines
You and your team are maxed out and do not have the time to hire a developer or build your Sailthru integration. Using a pre-built, fully-managed Sailthru data pipeline, you can increase efficiency, reduce labor requirements, and improve customer response time.
The Openbridge integrations provide a code-free, fully automated connector.
- The data pipeline will route and load data into your private, secure data lake or cloud data warehouse like BigQuery, AWS Athena, Azure Data Lake, AWS Redshift, or Redshift Spectrum, and Snowflake.
- The data pipeline delivers code-free, analytics-ready data feeds that fuel sales and BI tools like; Looker, Tableau, Power BI, Amazon Quicksight, etc.
Using an automated Sailthru Connect data pipeline process avoids manual and messy processing. Automated activities like de-duplication, error handling, data partitioning, automatic table versioning, view creation…can go a long way in ensuring your Sailthru data is clean, well organized, and ready-to-go analytics.
