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.

Name	Type	Description
`channel`	string	The platform used to send email/SMS. Example values: `klaviyo`
`channel_type`	string	The type of communication channel used. Example values: `email`, `sms`
`report_type`	string	The type of report generated. Example values: `flow`, `campaign`
`campaign_id`	string	The unique ID of the email/SMS campaign, assigned by the email/SMS platform. Example value: `01G2MRY5AF2A4QFJMS5EF8X2MW`
`campaign_name`	string	The name of the email/SMS campaign. Example value: `Fall Colors Launch`
`campaign_status`	string	The current status of the campaign associated with the email/SMS. Example value: `Sent`, `Cancelled`
`flow_id`	string	The unique ID for the automation flow. Assigned by the email/SMS platform. `YuNWdc`
`flow_name`	string	The name of the automation flow. `Joined Membership`
`flow_status`	string	The current status of the automation flow. Example values: `draft`, `live`, `manual`
`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`	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`	string	The current status of a specific action within an automation flow. Example values: `draft`, `live`, `manual`
`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`	string	The name of the individual message sent. Example value: `Welcome Series: Email 2`
`campaign_created_at`	date	The date and time when the campaign was created.
`campaign_updated_at`	date	The date and time when the campaign was last updated.
`campaign_send_time`	date	The date and time when the campaign was actually sent to recipients.
`campaign_scheduled_at`	date	The scheduled date and time for the campaign to be sent.
`flow_created_at`	date	The date and time when the automation flow was created.
`flow_updated_at`	date	The date and time when the automation flow was last updated.
`flow_action_updated_at`	date	The date and time when a specific action within a flow was updated.
`campaign_archived`	boolean	True if the campaign has been archived.
`flow_archived`	boolean	True if the automation flow has been archived.
`flow_action_archived`	boolean	True if the specific action within an automation flow has been archived.

Measures

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

Name	Type	Description
`delivered`	numeric	The total number of email/SMS messages that were successfully delivered to recipients' phones.
`opens_unique`	numeric	The total number of unique opens of the email in the last 365 days.
`clicks_unique`	numeric	The total number of unique clicks on links within the email/SMS in the last 365 days.
`recipients`	numeric	The total number of intended recipients for the email/SMS campaign.