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;

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.

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.

Interested in learning how to automate your Sailthru Connect data pipelines? Contact Us

Sailthru Connect: Code-free, Automation To Data Lakes or Cloud Warehouses was originally published in Openbridge on Medium, where people are continuing the conversation by highlighting and responding to this story.



source https://blog.openbridge.com/sailthru-connect-code-free-automation-to-data-lakes-or-cloud-warehouses-d5d752c632c8?source=rss----4c5221789b3---4

Popular posts from this blog

Data Lake Icon: Visual Reference

Image
Data Lake Icon If you were looking for some data lake icons or data lake logos, our creative team created a few for Openbridge. Data Lake Icons In terms of consistent visual representations of a data lake, we were not happy with what was available. Rather than create a unique AWS data lake icon or an Azure data lake icon, we wanted these to apply generally across all platforms. As a result, we created a set of icons that reflect a data lake conceptually. We included a modified icon that reflects our data lake formation process: data lake logo Data Lake Icons Use Cases The following are some examples of how the icons are used Openbridge : Using the icon in animation in a data lake introduction visual block Using the icon in the “ what is a data lake ” page header Using the icon in the “ why data lake ?” graphic Using the task icon to describe formation & architecting data lakes Looking for data lake providers or a data lake roadmap? If you are looking for icons
Read more

Snowflake CREATE Warehouse

Image
How to script a consistent and automated “create warehouse snowflake” environment Prior to undertaking data loading, Snowflake should be configured with some baselines. In this post, we undertake some “lite” Snowflake data warehouse training using the WORKSHEET feature. This is an easy-to-understand starting point in anyone’s journey to better learn Snowflake data warehouse setup and operations. If you are wondering why use Snowflake data warehouse , check out that link for the benefits of the platform. For now, we are assuming you are sold and are ready to give it a try. Let's get started! Step 1: Create a Snowflake account If you do not already have an account, Snowflake offers a free trial . Sign up for an account. If you have an account already, log into it. Step 2: Locate the WORKSHEET Feature In Your Snowflake Account If you log in via a web browser, click the WORKSHEET icon at the top of the page. Important: Ensure that the role for the session is set to ACCOUNTAD
Read more

PrestoDB vs PrestoSQL & the new Presto Foundation

Image
PrestoDB Last year we posted an introduction article on Presto . So what is new in the Presto world since then? A ton! PrestoDB moves to the Linux Foundation In September 2019, the official PrestoDB Foundation was started by Facebook, Uber, Twitter, and Alibaba. A formal, official foundation is what was needed for the Presto ecosystem to prosper. The formation and transition to a formal foundation under the Linux Foundation’s auspices was a significant first step to deal with confusion in the community. Kudos to Facebook, Uber, Twitter, and others in making this a reality. Having open, shared, and community-driven organization is critical to future success Presto. You can read more about these principles and roadmaps  here . Revisiting PrestoDB vs. PrestoSQL Why is a formal, independent foundation necessary? Presto Foundation established a set of much-needed guiding principles for the community. In the post last year, we highlighted some confusion about the two principle Pr
Read more