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 | Source |
|---|---|---|---|
channel | string | The platform used to send email/SMS. Example values: klaviyo | Klaviyo |
channel_type | string | The type of communication channel used. Example values: email, sms | Klaviyo |
report_type | string | The type of report generated. Example values: flow, campaign | Klaviyo |
campaign_id | string | The unique ID of the email/SMS campaign, assigned by the email/SMS platform. Example value: 01G2MRY5AF2A4QFJMS5EF8X2MW | Klaviyo |
campaign_name | string | The name of the email/SMS campaign. Example value: Fall Colors Launch | Klaviyo |
campaign_status | string | The current status of the campaign associated with the email/SMS. Example value: Sent, Cancelled | Klaviyo |
flow_id | string | The unique ID for the automation flow. Assigned by the email/SMS platform.YuNWdc | Klaviyo |
flow_name | string | The name of the automation flow.Joined Membership | Klaviyo |
flow_status | string | The current status of the automation flow. Example values: draft, live, manual | Klaviyo |
flow_action_id | string | The unique ID for a specific action within an automation flow. Assigned by the email/SMS platform. Example value: 51670312 | Klaviyo |
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 | Klaviyo |
flow_action_status | string | The current status of a specific action within an automation flow. Example values: draft, live, manual | Klaviyo |
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 | Klaviyo |
message_name | string | The name of the individual message sent. Example value: Welcome Series: Email 2 | Klaviyo |
campaign_created_at | date | The date and time when the campaign was created. | Klaviyo |
campaign_updated_at | date | The date and time when the campaign was last updated. | Klaviyo |
campaign_send_time | date | The date and time when the campaign was actually sent to recipients. | Klaviyo |
campaign_scheduled_at | date | The scheduled date and time for the campaign to be sent. | Klaviyo |
flow_created_at | date | The date and time when the automation flow was created. | Klaviyo |
flow_updated_at | date | The date and time when the automation flow was last updated. | Klaviyo |
flow_action_updated_at | date | The date and time when a specific action within a flow was updated. | Klaviyo |
campaign_archived | boolean | True if the campaign has been archived. | Klaviyo |
flow_archived | boolean | True if the automation flow has been archived. | Klaviyo |
flow_action_archived | boolean | True if the specific action within an automation flow has been archived. | Klaviyo |
Measures
Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.
| Name | Type | Description | Source |
|---|---|---|---|
delivered | numeric | The total number of email/SMS messages that were successfully delivered to recipients' phones. | Klaviyo |
opens_unique | numeric | The total number of unique opens of the email in the last 365 days. | Klaviyo |
clicks_unique | numeric | The total number of unique clicks on links within the email/SMS in the last 365 days. | Klaviyo |
recipients | numeric | The total number of intended recipients for the email/SMS campaign. | Klaviyo |