Sailthru Business Intelligence Data Sources

The following tables define the fields found in each of the Sailthru Business Intelligence data sources.

Client Config

Field Name Description
Client ID Select one or more of your Sailthru Client IDs to view the most relevant data
Is Active Slice data by user engagement level. 
Name Slice data by the account name that appears in the Sailthru UI
Rollup The name of your Sailthru account
Timezone The time zone that is set in your Sailthru account

Email and List Stats

email_stats_by_day_list_template

Field Name Description
Client ID Select one or more of your Sailthru Client IDs to view the most relevant data
Email Type Select the type of email data you wish to view: campaign, triggered, or both
Event Date Select date ranges
List Name Slice data by the list name that appears in the UI
Template Name Slice data by the template name that appears in the UI
Beacon Click Count The total # of clicks that occurred with a campaign’s beacon image firing. This is part of the larger definition for “total number of people that opened my email”
Beacon Noclick Count The total # of beacons that fired without any clicks. This is part of Sailthru’s calculation for Opens in an email.
Delivered Count The count of emails sent minus bounces (which include softbounces and hardbounces).
Hardbounce Count The number of hard bounced users.
Nobeacon Click Count The total # of clicks that occurred without a campaign’s beacon image firing. This is part of the larger definition for “total number of people that opened my email”
Optout Count The number of opted out users
Pageview Count The number of pageviews. 
Purchase Count The number of purchases
Revenue Monetary value of all purchases
Send Count The number of users to whom a message was sent
Softbounce Count The count of messages with a report of a delivery problem or failed delivery. Messages may soft bounce at the server level, because of a resource exhaustion such as a full disc, or because of spam filters. A softbounced message may eventually be delivered and Sailthru makes redelivery attempts of softbounced messages.
Spam Count The number of users who reported your email as spam and were automatically opted out
Total Click Count Total number of email clicks (campaign, triggered)
Total Open Count Total number of open emails (campaign, triggered)

list_stats

Field Name Description
Client ID Select one or more of your Sailthru Client IDs to view the most relevant data
Event Date Select date ranges
List Name Slice data by the list name that appears in the UI
Active Count The count of active users on the list
Disengaged Count The count of disengaged users on the list
Dormant Count The count of dormant users on the list
Email Count The total # of users on a given day
Engaged Count The count of engaged users on the list
Hardbounce Count  Total number of hard bounced users on the list.
Lists Remove Count The number of users removed from the list
Lists Signup Count The number of users who signed up to the list
New Count The number of new users
Optout Count  The number of opted out users
Optout Loss Count The total number of users lost to optouts in the (relative) last 24 hours
Passive Count The number of passive users on the list
Spam Count  The number of users who reported your email as spam and were automatically opted out
Valid Count Total number of users on the list who have any engagement status other than Hardbounce or Optout.

Campaign Stats by Domain and Engagement

campaign_stats_by_domain

Field Name Description
Blast ID Select which message data to view by Blast ID
campaign_name Select which message data to view by campaign name
Client ID Select one or more of your Sailthru Client IDs to view the most relevant data
Domain Select the data to view by domain
Event Date Select date ranges
List Name Slice data by the list name that appears in the UI
Beacon Click Count The total # of clicks that occurred with a campaign’s beacon image firing. This is part of the larger definition for “total number of people that opened my email”
Beacon Noclick Count The total # of beacons that fired without any clicks. This is part of Sailthru’s calculation for Opens in an email.
Hardbounce Count Total number of hard bounced users on the list.
Nobeacon Click Count The total # of clicks that occurred without a campaign’s beacon image firing. This is part of the larger definition for “total number of people that opened my email”
Optout Count The number of opted out users
Pageview Count The number of pageviews
Purchase Count The number of purchases
Revenue Monetary value of all purchases
Send Count The number of users to whom a message was sent
Softbounce Count The count of messages with a report of a delivery problem or failed delivery. Messages may soft bounce at the server level, because of resource exhaustion such as a full disc, or because of spam filters. A softbounced message may eventually be delivered and Sailthru makes redelivery attempts of softbounced messages.
Spam Count The number of users who reported your email as spam and were automatically opted out
Total Click Count Total number of email clicks (campaign, triggered)
Total Open Count Total number of open emails (campaign, triggered)

campaign_stats_by_engagement

Field Name Description
Blast ID Select which message data to view by Blast ID
campaign_name Select which message data to view by campaign name
Client ID Select one or more of your Sailthru Client IDs to view the most relevant data
Engagement Select the data you wish to view based on the user engagement level. 
Event Date Select date ranges
List Name Slice data by the list name that appears in the UI
Beacon Click Count The total # of clicks that occurred with a campaign’s beacon image firing. This is part of the larger definition for “total number of people that opened my email”
Beacon Noclick Count The total # of beacons that fired without any clicks. This is part of Sailthru’s calculation for Opens in an email.
Hardbounce Count Total number of hard bounced users on the list.
Nobeacon Click Count The total # of clicks that occurred without a campaign’s beacon image firing. This is part of the larger definition for “total number of people that opened my email”
Optout Count The number of opted out users
Pageview Count The number of pageviews.
Purchase Count The number of purchases
Revenue Monetary value of all purchases
Send Count The number of users to whom a message was sent
Softbounce Count The count of messages with a report of a delivery problem or failed delivery. Messages may soft bounce at the server level, because of a resource exhaustion such as a full disc, or because of spam filters. A softbounced message may eventually be delivered and Sailthru makes redelivery attempts of softbounced messages.
Spam Count The number of users who reported your email as spam and were automatically opted out
Total Click Count Total number of email clicks (campaign, triggered)
Total Open Count Total number of open emails (campaign, triggered)

Campaign Stats by Signup Month

Field Name Description
campaign_name Select which message data to view by campaign name
Client ID Select one or more of your Sailthru Client IDs to view the most relevant data
Event Date Select date ranges
List Name Slice data by the list name that appears in the UI
Signup Month Select the signup months you wish to view
Beacon Click Count The total # of clicks that occurred with a campaign’s beacon image firing. This is part of the larger definition for “total number of people that opened my email”
Beacon Noclick Count The total # of beacons that fired without any clicks. This is part of Sailthru’s calculation for Opens in an email.
Hardbounce Count Count of hard bounced users
Nobeacon Click Count The total # of clicks that occurred without a campaign’s beacon image firing. This is part of the larger definition for “total number of people that opened my email”
Optout Count The number of opted out users
Pageview Count The number of pageviews
Purchase Count The number of purchases
Revenue Monetary value of all purchases
Send Count The number of users to whom a message was sent
Softbounce Count The count of messages with a report of a delivery problem or failed delivery. Messages may soft bounce at the server level, because of a resource exhaustion such as a full disc, or because of spam filters. A softbounced message may eventually be delivered and Sailthru makes redelivery attempts of softbounced messages.
Spam Count The number of users who reported your email as spam and were automatically opted out
Total Click Count Total number of email clicks (campaign, triggered)
Total Open Count Total number of open emails (campaign, triggered)

Campaign Stats by Device

Field Name Description
Blast ID Select which message data to view by Blast ID
campaign_name Select which message data to view by campaign name
Client ID Select one or more of your Sailthru Client IDs to view the most relevant data
Device Slice data by device type
Event Date Select date ranges
List Name Slice data by the list name that appears in the UI
Refresh Time Displays a timestamp of the last time the data was updated/refreshed.
Beacon Click Count The total # of clicks that occurred with a campaign’s beacon image firing. This is part of the larger definition for “total number of people that opened my email”
Beacon Noclick Count The total # of beacons that fired without any clicks. This is part of Sailthru’s calculation for Opens in an email.
Hardbounce Count Total number of hard bounced users.
Nobeacon Click Count The total # of clicks that occurred without a campaign’s beacon image firing. This is part of the larger definition for “total number of people that opened my email”
Optout Count The number of opted out users
Pageview Count The number of pageviews.
Purchase Count The number of purchases
Revenue Monetary value of all purchases
Send Count The number of users to whom a message was sent
Softbounce Count The count of messages with a report of a delivery problem or failed delivery. Messages may soft bounce at the server level, because of a resource exhaustion such as a full disc, or because of spam filters. A softbounced message may eventually be delivered and Sailthru makes redelivery attempts of softbounced messages.
Spam Count The number of users who reported your email as spam and were automatically opted out
Total Click Count Total number of email clicks (campaign, triggered)
Total Open Count Total number of open emails (campaign, triggered)

Campaign Stats

Field Name Description
Abtest ID Slice data by the AB Test ID
Blast ID Select which message data to view by Blast ID
Client ID Select one or more of your Sailthru Client IDs to view the most relevant data
Event Date Slice data by specific dates or date ranges
List Name Slice data by the list name that appears in the UI
Name Slice data by the campaign name that appears in the Sailthru UI
Subject Slice data by the message subject 
Beacon Click Count The total # of clicks that occurred with a campaign’s beacon image firing. This is part of the larger definition for “total number of people that opened my email”
Beacon Noclick Count The total # of beacons that fired without any clicks. This is part of Sailthru’s calculation for Opens in an email.
Delivered Count The count of emails sent minus bounces (which include softbounces and hardbounces).
Hardbounce Count Total number of hard bounced users on the list.
List Active Count The total # of users on a given list that are considered “Active” on a given day
List Disengaged Count The total # of users on a given list that are considered “Disengaged” on a given day
List Dormant Count The total # of users on a given list that are considered “Dormant” on a given day
List Email Count The total # of users on a given list on a given day
List Engaged Count The total # of users on a given list that are considered “Engaged” on a given day
List Hardbounce Count The total # of users on a given list that are considered “Hardbounced” on a given day
List New Count The total # of users on a given list that are considered “New” on a given day
List Optout Count The total # of users on a given list that are considered “Optout” on a given day
List Passive Count The total # of users on a given list that are considered “Passive” on a given day
List Spam Count The number of users who reported your email as spam and were automatically opted out on a list on a given day
List Valid Count Total number of users on the list who have any engagement status other than Hardbounce or Optout on a list
Lists Remove Count The total # of users that were removed from a list in the (relative) last 24 hours
Lists Signup Count The total # of users that were signed up to a list in the (relative) last 24 hours
Nobeacon Click Count The total # of clicks that occurred without a campaign’s beacon image firing. This is part of the larger definition for “total number of people that opened my email”
Optout Count The count of opted out users
Pageview Count The number of pageviews
Purchase Count The number of purchases
Revenue Monetary value of all purchases
Send Count The number of users to whom a message was sent
Softbounce Count The count of messages with a report of a delivery problem or failed delivery. Messages may soft bounce at the server level, because of a resource exhaustion such as a full disc, or because of spam filters. A softbounced message may eventually be delivered and Sailthru makes redelivery attempts of softbounced messages.
Spam Count The number of users who reported your email as spam and were automatically opted out
Total Click Count Total number of email clicks (campaign, triggered)
Total Open Count Total number of open emails (campaign, triggered)

Campaign Stats by URL

Field Name Description
Blast ID Select which message data to view by Blast ID
campaign_name Select which message data to view by campaign name
Client ID Select one or more of your Sailthru Client IDs to view the most relevant data
Event Date Select date ranges
List Name Slice data by the list name that appears in the UI
Refresh Time Displays a timestamp of the last time the data was updated/refreshed.
URL Filter campaign performance by url/links included in campaigns 
Click Count The number of clicks per link included in campaigns
Purchase Count The number of purchases
Revenue Monetary value of all purchases
Send Count The number of users to whom a message was sent
Total Click Count Total number of email clicks (campaign, triggered)

Campaign Label Stats

campaign_stats_blast_label

Field Name Description
Abtest ID Select which message data to view by AB Test ID
Blast ID Select which message data to view by Blast ID
Client ID Select one or more of your Sailthru Client IDs to view the most relevant data
Event Date Select date ranges
Label ID The label ID
Label Name Used to segment campaign data by user-generated labels
List Name Slice data by the list name that appears in the UI
Name Slice data by the account name that appears in the Sailthru UI
Subject Slice data by message subject
Beacon Click Count The total # of clicks that occurred with a campaign’s beacon image firing. This is part of the larger definition for “total number of people that opened my email”
Beacon Noclick Count The total # of beacons that fired without any clicks. This is part of Sailthru’s calculation for Opens in an email.
Hardbounce Count Total number of hard bounced users.
Nobeacon Click Count The total # of clicks that occurred without a campaign’s beacon image firing. This is part of the larger definition for “total number of people that opened my email”
Optout Count The number of opted out users
Pageview Count The number of pageviews.
Purchase Count The number of purchases
Revenue Monetary value of all purchases
Send Count The number of users to whom a message was sent
Softbounce Count The count of messages with a report of a delivery problem or failed delivery. Messages may soft bounce at the server level, because of a resource exhaustion such as a full disc, or because of spam filters. A softbounced message may eventually be delivered and Sailthru makes redelivery attempts of softbounced messages.
Spam Count The number of users who reported your email as spam and were automatically opted out
Total Click Count Total number of email clicks (campaign, triggered)
Total Open Count Total number of open emails (campaign, triggered)

campaign_stats_by_domain_label

Field Name Description
Blast ID Select which message data to view by Blast ID
Client ID Select one or more of your Sailthru Client IDs to view the most relevant data
Domain Slice data by domain
Event Date Select date ranges
Label Name Used to segment campaign data by user-generated labels
List Name Slice data by the list name that appears in the UI
Beacon Click Count The total # of clicks that occurred with a campaign’s beacon image firing. This is part of the larger definition for “total number of people that opened my email”
Beacon Noclick Count The total # of beacons that fired without any clicks. This is part of Sailthru’s calculation for Opens in an email.
Hardbounce Count Total number of hard bounced users.
Nobeacon Click Count The total # of clicks that occurred without a campaign’s beacon image firing. This is part of the larger definition for “total number of people that opened my email”
Optout Count The number of opted out users
Pageview Count The number of pageviews
Purchase Count The number of purchases
Revenue Monetary value of all purchases
Send Count The number of users to whom a message was sent
Softbounce Count The count of messages with a report of a delivery problem or failed delivery. Messages may soft bounce at the server level, because of a resource exhaustion such as a full disc, or because of spam filters. A softbounced message may eventually be delivered and Sailthru makes redelivery attempts of softbounced messages.
Spam Count The number of users who reported your email as spam and were automatically opted out
Total Click Count Total number of email clicks (campaign, triggered)
Total Open Count Total number of open emails (campaign, triggered)

Purchase

first _purchase

Field Name Description
Campaign ID Use in reports to slice campaign data by Campaign ID
Campaign Name Select which message data to view by campaign name
Client ID Select one or more of your Sailthru Client IDs to view the most relevant data
Message ID The unique identifier for purchases that tell you if a purchase was driven from an email. If not, message ID will be (empty value). If it is, it’ll give you the unique message ID that drove that purchase. (Note that this is different than Blast ID)
Product ID Unique identifier for specific products
Product Name Unique name for specific products
Purchase Date Slice data by purchase date
Purchase ID Unique identifier for specific purchases

purchase_stats_by_hour

Field Name Description
Client ID Select one or more of your Sailthru Client IDs to view the most relevant data
Event Hour Select time ranges
Purchase Count The number of purchases
Total Items The total number of items purchased
Total Price The gross revenue generated (or – total unadjusted price) of all items in a users’ cart

purchases_per_product_day

Field Name Description
Campaign ID Use in reports to slice campaign data by Campaign ID
Product Name Unique name for specific products
Purchase Date Slice data by purchase date
average_price The average price of items purchased
items_sold The number of items sold
Purchase Count The number of purchases
total_revenue Total monetary value of all purchases

Profile Stats

Field Name Description
Client ID Select one or more of your Sailthru Client IDs to view the most relevant data
Domain Two separate uses: 1) to filter any campaign facts/metrics by domain, allowing you to segment campaign metrics by specific email domains that were sent to. 2) to filter all customer-specific reports by user domains
Is Buyer Segments Customer ID (or all user data) by whether or not users have made at least one purchase
Is Hardbounce Used to segment Customer IDs by hardbounce status
Is Optout A Yes/No value – is the profile opted out?
Is Subscriber Use to slice by whether or not a user is a subscriber
Is Valid Use to slice by whether or not users/audiences/segments are currently valid or invalid (Invalid = Optout OR Hardbounced)
Last Open Period A user’s last open was between X and Y days ago
last_click_period A user’s last click was between X and Y days ago
last_open_period_finegrained A user’s last open was between X and Y days ago
Signup Day Metric returning a user’s signup date
Time to Conversion Period Average time to users’ converting
Time to Optout Period Average time to users’ opting out
Click Count The count of email clicks
Num Profiles The total number of profiles
Num Profiles Gte 1 Purchases Total number of profiles that have made at least one purchase
Num Profiles Gtw 2 Purchases Total number of profiles that have made at least two purchases
Num Profiles Gte 3 Purchases Total number of profiles that have made at least three purchases
Num Profiles Gte 4 Profiles Total number of profiles that have made at least four purchases
Open Count The number of opened messages
Total Click Count Total number of email clicks (campaign, triggered)
Total Open Count Total number of open emails (campaign, triggered)
Total Pageview Count Total number of pageviews.
Total Purchase Count Total number of purchases
Total Purchase Revenue Total monetary value of all purchases
Total Send Count The total number of users to whom a message was sent

 

Top