The Email/SMS Settings table contains email and SMS campaign and flow message setup, including message content, status, send timing, and message-level counters. One row per campaign or flow message setup.

📋
Table Guide
What You Can Answer With This Table

What subject lines and message copy belong to each campaign or flow? — use campaign_name or flow_name with message_subject, message_copy, and message_name

Which campaigns and flows are active, archived, or draft? — use campaign_status, flow_status, campaign_archived, flow_archived

How many recipients, deliveries, opens, clicks, and conversions are tied to each message setup? — use delivered, opens_unique, clicks_unique, recipients, conversions

Before You Query

This table is not time-series. No event_date filter is needed.

Key Relationships

Table Join Key Use This Join To
Email/SMS message_id Measure how each message configuration performed over time

When to Use a Different Table

Use Email/SMS table when you need daily performance trends for email/SMS campaigns or flows. The Email/SMS Settings table is for message configuration, content, and setup details.

View the full Triple Whale Data Ontology →

Table	Join Key	Use This Join To
Email/SMS	`message_id`	Measure how each message configuration performed over time

Dimensions

Dimensions are immutable properties that can be used for grouping data.

Title	ID	Type	Description
Is Campaign Archived	`campaign_archived`	boolean	True if the campaign has been archived. Possible values: `true`, `false`
Campaign Creation Date	`campaign_created_at`	date	The time the campaign was created. Formatted according to the ISO 8601 international standard. Example value: `2019-04-15 08:26:00`
Campaign ID	`campaign_id`	string	The unique ID of the email/SMS campaign, assigned by the email/SMS platform. Example value: `01G2MRY5AF2A4QFJMS5EF8X2MW`
Campaign Name	`campaign_name`	string	The name of the email/SMS campaign. Example values: `Fall Colors Launch`, `Father's Day Sale 50% Off`
Campaign Scheduled Date	`campaign_scheduled_at`	date	The time the campaign was scheduled to be sent. Formatted according to the ISO 8601 international standard. Example value: `2019-04-15 08:26:00`
	`campaign_send_date`
Campaign Sent Date	`campaign_send_time`	date	The time the campaign was sent to recipients. Formatted according to the ISO 8601 international standard. Example value: `2019-04-15 08:26:00`
Campaign Status	`campaign_status`	string	The status of the campaign associated with the email/SMS. Example values: `Sent`, `Cancelled`
Campaign Updated Date	`campaign_updated_at`	date	The time the campaign was last updated. Formatted according to the ISO 8601 international standard. Example value: `2019-04-15 08:26:00`
Channel	`channel`	string	The platform used to send email/SMS. Example values: `klaviyo`, `smsbump`
Messaging Channel Type	`channel_type`	string	The messaging channel used to deliver the communication. Example values: `email`, `sms`, `push`
Is Flow Action Archived	`flow_action_archived`	boolean	True if the specific action within an automation flow has been archived. Possible values: `true`, `false`
Flow Action ID	`flow_action_id`	string	The unique ID for a specific action within an automation flow. Assigned by the email/SMS platform. Example value: `51670312`
Flow Action Name	`flow_action_name`	string	The name of the specific action within an automation flow. Example values: `SEND_EMAIL`, `SEND_SMS`, `AB_TEST`, `TIME_DELAY`, `WEBHOOK`
Flow Action Status	`flow_action_status`	string	The status of a specific action within an automation flow. Example values: `draft`, `live`, `manual`
Flow Action Updated Date	`flow_action_updated_at`	date	The time the flow action was updated. Formatted according to the ISO 8601 international standard. Example value: `2019-04-15 08:26:00`
Is Flow Archived	`flow_archived`	boolean	True if the automation flow has been archived. Possible values: `true`, `false`
Flow Created Date	`flow_created_at`	date	The time the automation flow was created. Formatted according to the ISO 8601 international standard. Example value: `2019-04-15 08:26:00`
Flow ID	`flow_id`	string	The unique ID for the automation flow. Assigned by the email/SMS platform. Example value: `YuNWdc`
Flow Name	`flow_name`	string	The name of the automation flow. Example value: `Abandoned cart reminder: 1-3 days`, `Joined Membership`
Flow Status	`flow_status`	string	The status of the automation flow. Example values: `draft`, `live`, `manual`
Flow Trigger Is Triple Whale	`flow_trigger_is_tw`	boolean	True if the flow was triggered by a Triple Whale (Sonar) metric or event. Possible values: `true`, `false`
Flow Trigger Metric ID	`flow_trigger_metric_id`	string	The ID of the metric or event that triggered the flow. Example value: `Lm72Qs`
Flow Trigger Metric Name	`flow_trigger_metric_name`	string	The name of the metric or event that triggered the flow. Example values: `Checkout Started`, `Added to Cart`, `Abandoned Cart`, `Fulfilled Order`
Flow Trigger Organization	`flow_trigger_organization`	string	The platform where the flow trigger originated. Example values: `Shopify`, `API`, `Klaviyo`, `Triple Whale`
Flow Trigger Sonar Enabled	`flow_trigger_sonar_enabled`	boolean	True if Sonar is enabled for this flow trigger. Possible values: `true`, `false`
Flow Updated Date	`flow_updated_at`	date	The time the automation flow was last updated. Formatted according to the ISO 8601 international standard. Example value: `2019-04-15 08:26:00`
Message Copy	`message_copy`	string	The full text content of the email message body, including dynamic variables and template tags used for personalization, embedded links, images, and call-to-action buttons. Example value: `'Can't view this email? {% web_view %} Shop our latest collection! [https://example.com/new-arrivals] Get 20% off your first order with code WELCOME20. {% unsubscribe %}'`
Message ID	`message_id`	string	The unique ID for the individual message sent as part of a campaign or flow. Assigned by the email/SMS platform. Example value: `SDiqmK`
Message Name	`message_name`	string	The name of the individual message sent. Example value: `Welcome Series: Email 2`
Message Preview Text	`message_preview_text`	string	The short snippet of text shown alongside the subject line in the recipient’s inbox, offering a preview of the message content. Example value: `Get 20% off your first order – limited time only!`
Message Subject	`message_subject`	string	The subject line of the email message, as displayed in the recipient's inbox. Example value: `New Fall Collection Just Dropped`
Message Template HTML URL	`message_template_html_url`	string	The URL of the hosted HTML template for the email message, fully formatted as rendered for recipients. Example value: `https://storage.googleapis.com/email-templates/klaviyo/12345/template.html`
Report Type	`report_type`	string	The type of report generated. Example values: `flow`, `campaign`
Shop ID	`shop_id`	string	The unique ID of the shop (often corresponds to the shop domain). Can be used to group or filter data by shop in multi-store reports. Example values: `example-US.myshopify.com`, `example-EU.myshopify.com`
Shop Name	`shop_name`	string	The name of the shop. Can be used to group or filter data by shop in multi-store reports. Example values: `example-US`, `example-EU`

Measures

Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.

Title	ID	Type	Description
Clicks	`clicks_unique`	numeric	The total number of unique clicks on links within the email/SMS.
Conversion Value	`conversion_value`	numeric	The total value of conversions for the email/SMS campaign / flow.
Conversions	`conversions`	numeric	The total number of conversions for the email/SMS campaign / flow.
Delivered Messages	`delivered`	numeric	The total number of messages successfully delivered to the targeted recipient.
Opens	`opens_unique`	numeric	The total number of unique email opens.
Recipients	`recipients`	numeric	The total number of intended recipients for the email/SMS campaign.