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.

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 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`
Channel Type	`channel_type`	string	The type of communication channel used. Example values: `email`, `sms`
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 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 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`
Report Type	`report_type`	string	The type of report generated. Example values: `flow`, `campaign`

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.
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.