The Email/SMS Settings table provides detailed configurations and performance metrics for email and SMS campaigns, including delivery statistics, unique opens, and clicks. Querying this table allows you to analyze the effectiveness of your communication strategies, optimize your marketing efforts, and enhance engagement with your audience.

📋
Table Guide
What You Can Answer With This Table

Which email or SMS message content is associated with each campaign or flow? — use message_subject, message_copy, message_id

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

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

Before You Query

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

Settings rows are returned for connected Klaviyo accounts.

Key Relationships

Table Join Key What the Join Enables
Email/SMS message_id Message-level performance trends over time, including sends, clicks, revenue, purchases, and subscriber changes

When to Use a Different Table

Need daily email/SMS performance trends → Email/SMS table. Email/SMS tracks message performance by day, while Email/SMS Settings focuses on message configuration, content, and current setup details.

View the full Triple Whale Data Ontology →

Table	Join Key	What the Join Enables
Email/SMS	`message_id`	Message-level performance trends over time, including sends, clicks, revenue, purchases, and subscriber changes

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.