Event Stream Data Sets

The following data sets are available through Sailthru Connect:

Email Events

Campaign Sends

Target Location s3://[bucket_name]/campaign_send/dt=[dt]/client_id=[id]/[filename].csv
Field Name Data Type Example Description
client_id int 3386 Sailthru client identifier. Foreign key to the Client lookup data. If the client has multiple Sailthru accounts, this will be the child account which can be linked to the parent account through the lookup data.
event_time string 2018-01-02 09:24:25 Email send time represented in the following format YYYY-MM-DD HR:MI:SS
send_time string 2018-01-02 09:24:25 This is the send time of the message. The campaign start time can be found in the campaign lookup table.
message_id string 15273725.1064 Unique identifier for the message unique to the campaign and recipient. In the case of campaign emails this is a combination of the campaign_id and email_num.
profile_id string 597fa1d224c17c309b02400 Unique identifier for the Sailthru user profile of the message recipient.
email_sha256 string fbc1acf72184b83374e1920a6ee754e030e3c45defd2ce1ac75146c95f491bf3 SHA-256 hash of the recipient’s email address.
email_md5 string 81a1ffc0947e2ca9efadd006c10685ca MD5 hash of the recipient’s email address.
engagement string passive User status at the time of send.
signup_time string 2018-03-29 15:33:09 Time that the user originally signed up.  Can be used for cohort analysis. 
campaign_id int 15273725 Unique identifier for the campaign send. All messages sent as part of the campaign on a particular date will share the same campaign_id. Foreign key to the Campaign lookup data.
list_name string Mon-To-Fri-Daily-Sends(Smart List) The name of the list to which the campaign was sent.
list_id string 5abd071f2e9bba1a861570cc The unique identifier that corresponds with the list name.
template_id int 5259685 Unique identifier for the template used in the send if applicable. Foreign key to the template lookup data.
subject string October Monthly Deliverability Newsletter Subject line of the sent message.

Campaign Opens

Location s3://[bucket_name]/campaign_open/dt=[dt]/client_id=[id]/[filename].csv
Field Name Data Type Example Description
client_id int 3386 Sailthru client identifier. Foreign key to the Client lookup data. If the client has multiple Sailthru accounts, this will be the child account which can be linked to the parent account through the lookup data.
event_time string 2018-01-02 09:24:25 Email open time represented in the following format YYYY-MM-DD HR:MI:SS
send_time string 2018-01-02 09:24:25 This is the send time of the message. The campaign start time can be found in the campaign lookup table.
message_id string 15273725.1064 Unique identifier for the message unique to the campaign and recipient. In the case of campaign emails this is a combination of the campaign_id and email_num.
profile_id string 597fa1d224c17c309b02400 Unique identifier for the Sailthru user profile of the message recipient.
email_sha256 string fbc1acf72184b83374e1920a6ee754e030e3c45defd2ce1ac75146c95f491bf3 SHA-256 hash of the recipient’s email address.
email_md5 string 81a1ffc0947e2ca9efadd006c10685ca MD5 hash of the recipient’s email address.
engagement string passive User status at the time of send.  See doc for definitions and configuration options.
signup_time string 2018-01-02 09:24:25 Time that the user originally signed up.  Can be used for cohort analysis. 
campaign_id int 15273725 Unique identifier for the campaign send. All messages sent as part of the campaign on a particular date will share the same campaign_id. Foreign key to the Campaign lookup data.
list_id string 5abd071f2e9bba1a861570cc The unique identifier that corresponds with the list name.
browser string iPhone Device/browser used by the recipient.
count int 2 The open count for the user on that message at the time of the event.  If there are multiple opens this will increment each time. 

 

Campaign Clicks

Location s3://[bucket_name]/campaign_click/dt=[dt]/client_id=[id]/[filename].csv
Field Name Data Type Example Description
client_id int 3386 Sailthru client identifier. Foreign key to the Client lookup data. If the client has multiple Sailthru accounts, this will be the child account which can be linked to the parent account through the lookup data.
event_time string 2018-01-02 09:24:25 Email click time represented in the following format YYYY-MM-DD HR:MI:SS
send_time bigint 2018-01-02 09:24:25 This is the send time of the message. The campaign start time can be found in the campaign lookup table.
message_id string 15273725.1064 Unique identifier for the message unique to the campaign and recipient. In the case of campaign emails this is a combination of the campaign_id and email_num.
profile_id string 597fa1d224c17c309b02400 Unique identifier for the Sailthru user profile of the message recipient.
email_sha256 string fbc1acf72184b83374e1920a6ee754e030e3c45defd2ce1ac75146c95f491bf3 SHA-256 hash of the recipient’s email address.  Can be used as a unique identifier to the email, and can be used to join other events by the same user.
email_md5 string 81a1ffc0947e2ca9efadd006c10685ca MD5 hash of the recipient’s email address. Can be used as a unique identifier to the email, and can be used to join other events by the same user.
engagement string passive User status at the time of send.  See doc for definitions and configuration options.
signup_time string 2018-01-02 09:24:25 Time that the user originally signed up.  Can be used for cohort analysis. 
campaign_id int 15273725 Unique identifier for the campaign send. All messages sent as part of the campaign on a particular date will share the same campaign_id. Foreign key to the campaign lookup data.
list_id string 5abd071f2e9bba1a861570cc The unique identifier that corresponds with the list name.
browser string iPhone Device/browser used by the recipient.
url string https://www.sailthru.com/marketing-blog/luxury-brands-embracing-ecommerce/ The url of the clicked link.
index int 2 The order of the link out of all links in the email.
count int 2 The click count for the user on that message at the time of the event.  If there are multiple clicks this will increment each time. 
url_count int 1 If the user clicks multiple URLs within the message, this counts unique URLs.

Campaign Bounces

Location s3://[bucket_name]/campaign_bounce/dt=[dt]/client_id=[id]/[filename].csv
Field Name Data Type Example Description
client_id int 3386 Sailthru client identifier. Foreign key to the Client lookup data. If the client has multiple Sailthru accounts, this will be the child account which can be linked to the parent account through the lookup data.
event_time string 2018-01-02 09:24:25 Email bounce time represented in the following format YYYY-MM-DD HR:MI:SS
send_time bigint 2018-01-02 09:24:25 This is the send time of the message. The campaign start time can be found in the campaign lookup table.
message_id string 15273725.1064 Unique identifier for the message unique to the campaign and recipient. In the case of campaign emails this is a combination of the campaign_id and email_num.
profile_id string 597fa1d224c17c309b02400 Unique identifier for the Sailthru user profile of the message recipient.
email_sha256 string fbc1acf72184b83374e1920a6ee754e030e3c45defd2ce1ac75146c95f491bf3 SHA-256 hash of the recipient’s email address.
email_md5 string 81a1ffc0947e2ca9efadd006c10685ca MD5 hash of the recipient’s email address.
engagement string passive User status at the time of send.  See doc for definitions and configuration options.
signup_time string 2018-01-02 09:24:25 Time that the user originally signed up.  Can be used for cohort analysis.
campaign_id int 15273725 Unique identifier for the campaign. This is a foreign key to the campaign lookup table.
list_id string 5abd071f2e9bba1a861570cc The unique identifier that corresponds with the list name.
reason_log string 4.2.2 (mailbox full) smtp;450 4.2.2 <sampleuser@icloud.com>: user is overquota Explains the reason for the bounce.
message_type string hardbounce Type includes softbounce or hardbounce.

 

Campaign Unsubscribes

Location s3://[bucket_name]/campaign_unsubscribe/dt=[dt]/client_id=[id]/[filename].csv
Field Name Data Type Example Description
client_id int 3386 Sailthru client identifier. Foreign key to the Client lookup data. If the client has multiple Sailthru accounts, this will be the child account which can be linked to the parent account through the lookup data.
event_time string 2018-01-02 09:24:25 Email unsubscribe time represented in the following format YYYY-MM-DD HR:MI:SS
send_time string 2018-01-02 09:24:25 This is the send time of the message. The campaign start time can be found in the campaign lookup table.
message_id string 15273725.1064 Unique identifier for the message unique to the campaign and recipient. In the case of campaign emails this is a combination of the campaign_id and email_num.
profile_id string 597fa1d224c17c309b02400 Unique identifier for the Sailthru user profile of the message recipient.
email_sha256 string fbc1acf72184b83374e1920a6ee754e030e3c45defd2
ce1ac75146c95f491bf3
SHA-256 hash of the recipient’s email address.
email_md5 string 81a1ffc0947e2ca9efadd006c10685ca MD5 hash of the recipient’s email address.
engagement string passive User status at the time of send.
signup_time string 2018-01-02 09:24:25 Time that the user originally signed up.  Can be used for cohort analysis.
campaign_id int 15273725 Unique identifier for the campaign. This is a foreign key to the campaign lookup table.
list_id string 5abd071f2e9bba1a861570cc The unique identifier that corresponds with the list name.
message_type string unsubscribe_hostedpage Type describes how a user unsubscribed: unsubscribe_hostedpage– user directly requested to unsubscribe through a page hosted by Sailthru

unsubscribe– user requested to unsubscribe through their email provider

spam- user marked the email as spam

Triggered Sends

Location s3://[bucket_name]/triggered_send/dt=[dt]/client_id=[id]/[filename].csv
Field Name Data Type Example Description
client_id int 3386 Sailthru client identifier. Foreign key to the Client lookup data. If the client has multiple Sailthru accounts, this will be the child account which can be linked to the parent account through the lookup data.
event_time string (yyyy-MM-dd HH:mm:ss) 2018-01-02 09:24:25 Email send time represented in the following format YYYY-MM-DD HR:MI:SS
send_time string (yyyy-MM-dd HH:mm:ss) 2018-01-02 09:24:25 Email send time represented in the following format YYYY-MM-DD HR:MI:SS
message_id string 5db2165b9c625f28504758d3 Unique identifier for the message. 
profile_id string 597fa1d224c17c309b02400 Unique identifier for the Sailthru user profile of the message recipient.
email_sha256 string 6b3918d4492bcb86d2e81b126ca466888c7e40e0f5acc
1c88277bf7c59757349
SHA-256 hash of the recipient’s email address.
email_md5 string fa2ae4e9af4986e483d006a036783691 MD5 hash of the recipient’s email address.
engagement string active User status at the time of send.
signup_time string (yyyy-MM-dd HH:mm:ss) 2018-01-02 09:24:25 Time that the user originally signed up in UTC.  Can be used for cohort analysis. 
template_id int 5259685 Unique identifier for the template used in the send if applicable. Foreign key to the template lookup data.
is_basic boolean True Whether the template is classified as a basic / transactional template.  
flow_id string 79c15585-ee58-4ca2-8f3f-7ec4d1a2d831 Unique identifier for the LO flow that triggered this send. Foreign key to the lifecycle_optimizer_flow lookup data.

Triggered Opens

Location s3://[bucket_name]/triggered_open/dt=[dt]/client_id=[id]/[filename].csv
Field Name Data Type Example Description
client_id int 3386 Sailthru client identifier. Foreign key to the Client lookup data. If the client has multiple Sailthru accounts, this will be the child account which can be linked to the parent account through the lookup data.
event_time string (yyyy-MM-dd HH:mm:ss) 2018-01-02 09:24:25 Email open time in UTC
send_time string (yyyy-MM-dd HH:mm:ss) 2018-01-02 09:24:25 Email send time in UTC
message_id string 5db2165b9c625f28504758d3 Unique identifier for the message. 
profile_id string 597fa1d224c17c309b02400 Unique identifier for the Sailthru user profile of the message recipient.
email_sha256 string 6b3918d4492bcb86d2e81b126ca466888c7e40e0f5a
cc1c88277bf7c59757349
SHA-256 hash of the recipient’s email address.
email_md5 string fa2ae4e9af4986e483d006a036783691 MD5 hash of the recipient’s email address.
engagement string active User status at the time of send.
signup_time string (yyyy-MM-dd HH:mm:ss) 2018-01-02 09:24:25 Time that the user originally signed up in UTC.  Can be used for cohort analysis. 
template_id int 5259685 Unique identifier for the template used in the send if applicable. Foreign key to the template lookup data.
is_basic boolean True Whether the template is classified as a basic / transactional template.  
flow_id string 79c15585-ee58-4ca2-8f3f-7ec4d1a2d831 Unique identifier for the LO flow that triggered this send. Foreign key to the lifecycle_optimizer_flow lookup data.
browser string iPhone Device/browser used by the recipient.
count int 2 The open count for the user on that message at the time of the event.  If there are multiple opens this will increment each time. 

 

Triggered Clicks

Location s3://[bucket_name]/triggered_click/dt=[dt]/client_id=[id]/[filename].csv
Field Name Data Type Example Description
client_id int 3386 Sailthru client identifier. Foreign key to the Client lookup data. If the client has multiple Sailthru accounts, this will be the child account which can be linked to the parent account through the lookup data.
event_time string (yyyy-MM-dd HH:mm:ss) 2018-01-02 09:24:25 Email click time in UTC
send_time string (yyyy-MM-dd HH:mm:ss) 2018-01-02 09:24:25 Email send time in UTC
message_id string 5db2165b9c625f28504758d3 Unique identifier for the message. 
profile_id string 597fa1d224c17c309b02400 Unique identifier for the Sailthru user profile of the message recipient.
email_sha256 string 6b3918d4492bcb86d2e81b126ca466888c7e40e0f5a
cc1c88277bf7c59757349
SHA-256 hash of the recipient’s email address.
email_md5 string fa2ae4e9af4986e483d006a036783691 MD5 hash of the recipient’s email address.
engagement string active User status at the time of send.
signup_time string (yyyy-MM-dd HH:mm:ss) 2018-01-02 09:24:25 Time that the user originally signed up in UTC.  Can be used for cohort analysis. 
template_id int 5259685 Unique identifier for the template used in the send if applicable. Foreign key to the template lookup data.
is_basic boolean True Whether the template is classified as a basic / transactional template.  
flow_id string 79c15585-ee58-4ca2-8f3f-7ec4d1a2d831 Unique identifier for the LO flow that triggered this send. Foreign key to the lifecycle_optimizer_flow lookup data.
browser string iPhone Device/browser used by the recipient.
url string https://www.sailthru.com/marketing-blog/luxury-brands-embracing-ecommerce/ The url of the clicked link.
index int 2 The order of the link out of all links in the email.
count int 2 The click count for the user on that message at the time of the event.  If there are multiple clicks this will increment each time. 
url_count int 1 If the user clicks multiple URLs within the message, this counts unique URLs.

 

Triggered Bounces

Location s3://[bucket_name]/triggered_bounce/dt=[dt]/client_id=[id]/[filename].csv
Field Name Data Type Example Description
client_id int 3386 Sailthru client identifier. Foreign key to the Client lookup data. If the client has multiple Sailthru accounts, this will be the child account which can be linked to the parent account through the lookup data.
event_time string (yyyy-MM-dd HH:mm:ss) 2018-01-02 09:24:25 Email bounce time in UTC
send_time string (yyyy-MM-dd HH:mm:ss) 2018-01-02 09:24:25 Email send time in UTC
message_id string 5db2165b9c625f28504758d3 Unique identifier for the message. 
profile_id string 597fa1d224c17c309b02400 Unique identifier for the Sailthru user profile of the message recipient.
email_sha256 string 6b3918d4492bcb86d2e81b126ca466888c7e40e0f5acc1c88277bf7c59757349 SHA-256 hash of the recipient’s email address.
email_md5 string fa2ae4e9af4986e483d006a036783691 MD5 hash of the recipient’s email address.
engagement string active User status at the time of send.
signup_time string (yyyy-MM-dd HH:mm:ss) 2018-01-02 09:24:25 Time that the user originally signed up in UTC.  Can be used for cohort analysis. 
template_id int 5259685 Unique identifier for the template used in the send if applicable. Foreign key to the template lookup data.
is_basic boolean True Whether the template is classified as a basic / transactional template.  
reason_log string 4.2.2 (mailbox full) smtp;450 4.2.2 <sampleuser@icloud.com>: user is overquota Explains the reason for the bounce
message_type string hardbounce Type includes softbounce or hardbounce

 

Triggered Unsubscribes

Location s3://[bucket_name]/triggered_bounce/dt=[dt]/client_id=[id]/[filename].csv
Field Name Data Type Example Description
client_id int 3386 Sailthru client identifier. Foreign key to the Client lookup data. If the client has multiple Sailthru accounts, this will be the child account which can be linked to the parent account through the lookup data.
event_time string (yyyy-MM-dd HH:mm:ss) 2018-01-02 09:24:25 Email unsubscribe time in UTC
send_time string (yyyy-MM-dd HH:mm:ss) 2018-01-02 09:24:25 Email send time in UTC
message_id string 5db2165b9c625f28504758d3 Unique identifier for the message. 
profile_id string 597fa1d224c17c309b02400 Unique identifier for the Sailthru user profile of the message recipient.
email_sha256 string 6b3918d4492bcb86d2e81b126ca466888c7e40e0f5a
cc1c88277bf7c59757349
SHA-256 hash of the recipient’s email address.
email_md5 string fa2ae4e9af4986e483d006a036783691 MD5 hash of the recipient’s email address.
engagement string active User status at the time of send.
signup_time string (yyyy-MM-dd HH:mm:ss) 2018-01-02 09:24:25 Time that the user originally signed up in UTC.  Can be used for cohort analysis. 
template_id int 5259685 Unique identifier for the template used in the send if applicable. Foreign key to the template lookup data.
is_basic boolean True Whether the template is classified as a basic / transactional template.  
message_type string unsubscribe_hostedpage Type describes how a user unsubscribed: unsubscribe_hostedpage– user directly requested to unsubscribe through a page hosted by Sailthru

unsubscribe– user requested to unsubscribe through their email provider

spam- user marked the email as spam

 

Lookup Tables

Client

Location s3://[bucket_name]/client/dt=[dt]/hr=[hr]/client_id=[id]/[filename].csv
Field Name Data Type Example Description
client_id int 3386 Sailthru client identifier. If the client has multiple Sailthru accounts, this will be the child account which can be linked to the parent account through the account_id field.
account_id int 1 The client_id of the parent account. If this client is the parent account the account_id will be the same as the client_id.
name string Sailthru Testing The name of the Sailthru client account.

 

Campaign

Table Name Campaign
Location s3://[bucket_name]/campaign/dt=[dt]/hr=[hr]/client_id=[id]/[filename].csv
Field Name Data Type Example Description
client_id int 3386 Sailthru client identifier. Foreign key to the Client lookup table. If the client has multiple Sailthru accounts, this will be the child account which can be linked to the parent account through the lookup table.
campaign_id int 15273725 Unique identifier for the campaign send. All messages sent as part of the campaign on a particular date will share the same campaign_id.
name string 12/6/18 Customer blog send User defined campaign name
from_name string Sailthru The name displayed as the sender
from_email string dglueck@sailthru.com The email address displayed as the sender
replyto_email string support@sailthru.com The email address replies are sent to
subject string Get Ready for Green Monday with These 4 Best Practices The subject line for the campaign. If Zephyr is used in the subject line this will include the unresolved Zephyr code.
list_name string sailthru_blog_updates The list to which the campaign was sent.
data_feed_url string http://feed.sailthru.com/ws/feed?id=58472bd51aa312367c8b456b URL of the data feed used to power dynamic content in the campaign (if applicable).
preheader string Marketing best practices from Sailthru The preheader text that shows up with the subject line (only available for templates created through Email Composer).
template_id int 5259685 Unique identifier for the template used in the campaign (if applicable). Foreign key to the template lookup table.
schedule_time string (yyyy-MM-dd HH:mm:ss) 2018-01-02 09:24:25 Scheduled send time represented as a unix timestamp in UTC time with milliseconds.
report_email string dglueck@sailthru.com Email address to which the confirmation report is sent once the campaign sends complete.
suppress_list string [

 “Old/Dormant Mkto Blog Users”,

 “Marketo Suppression”, “sailthru_blog_updates”

    ]

Listing of email list(s) used as suppression lists for the campaign.
email_hour_range int 6 The length in hours of the sent time range when Personalized Send Time (PST) is used.
create_time string (yyyy-MM-dd HH:mm:ss) 2018-01-02 09:24:25 Time of campaign creation represented as a unix timestamp in UTC time with milliseconds.
start_time string (yyyy-MM-dd HH:mm:ss) 2018-01-02 09:24:25 Campaign send start time represented as a unix timestamp in UTC time with milliseconds.

 

Template

Location s3://[bucket_name]/template/dt=[dt]/hr=[hr]/client_id=[id]/[filename].csv
Field Name Data Type Example Description
client_id int 3386 Sailthru client identifier. Foreign key to the Client lookup table. If the client has multiple Sailthru accounts, this will be the child account which can be linked to the parent account through the lookup table.
template_id int 5241784 Unique identifier for the template.
name string Abandoned Cart User defined name for the template.
create_time string (yyyy-MM-dd HH:mm:ss) 2018-01-02 09:24:25 The time the template was created represented as a unix timestamp in UTC time with milliseconds.
modify_time string (yyyy-MM-dd HH:mm:ss) 2018-01-02 09:24:25 The last time the template was modified represented as a unix timestamp in UTC time with milliseconds.
create_user string dglueck@sailthru.com The email address of the Sailthru user that created the template.
modify_user string dglueck@sailthru.com The email address of the last Sailthru user to modify the template.
from_name string Sailthru The name displayed as the sender
from_email string dglueck@sailthru.com The email address displayed as the sender
replyto_email string support@sailthru.com The email address replies are sent to
subject string Get Ready for Green Monday with These 4 Best Practices The subject line for the template. If Zephyr is used in the subject line this will include the unresolved Zephyr code.
preheader string Marketing best practices from Sailthru The preheader text that shows up with the subject line (only available for templates created through Email Composer).
is_basic boolean false Indicator of whether the template is a basic template. Basic templates are non-marketing transactional emails, such as password reset messages.
data_feed_url string http://feed.sailthru.com/ws/feed?id=58472bd51aa312367c8b456b URL of the data feed used to power dynamic content (if applicable).

Lifecycle Optimizer Flow

Location s3://[bucket_name]/lifecycle_optimizer_flow/dt=[dt]/hr=[hr]/client_id=[id]/[filename].csv
Field Name Data Type Example Description
flow_id string 4320f1ef-ebe4-4d65-86ba-484d26dc02a7 Unique identifier for the Lifecycle Optimizer (LO) flow within Sailthru.
name string Internal DHC Proposed Changes User defined name for the LO flow.
create_time string (yyyy-MM-dd HH:mm:ss) 2017-02-09 23:17:24 The time the LO flow was created represented in UTC.
modify_time string (yyyy-MM-dd HH:mm:ss) 2017-02-09 23:22:24 The time the LO flow was created represented in UTC.
version string 3 The most recent version of the flow.

 

Top