Email/SMS Settings Table

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.