rpt_outbound_message_performance_daily - SourceMedium

Daily messaging performance across email/SMS/push for campaigns, flows, and transactional sends.

Grain: One row per (date x message/campaign context).
Date field: date.
Filters to start with: sm_message_channel (email, sms, push); message_type (campaign, flow, transactional).
Joins: none; drill down to message-detail models using (date, message context) filters.

Query examples

Messaging

Columns

Column	Type	Description
`sm_store_id`	STRING	SourceMedium’s unique store identifier. For Shopify stores, derived from the myshopify.com domain; for other platforms (Amazon, TikTok Shop, Walmart.com), uses platform-specific identifiers.
`campaign_id`	STRING	Messaging campaign identifier (if message_type is campaign).
`campaign_name`	STRING	Messaging campaign name (if message_type is campaign).
`date`	DATE	Calendar date for daily aggregation.
`dimension_value`	STRING	Dimension grouping value (e.g., campaign or flow identifier) depending on report mode.
`list_subscribes`	NUMERIC	Count of list subscription events attributed to the message.
`list_unsubscribes`	NUMERIC	Count of list unsubscribe events attributed to the message.
`message_id`	STRING	Platform message identifier for the send.
`message_name`	STRING	The name/title of the message as configured in the messaging platform. Used to identify specific email templates, SMS messages, or push notifications.
`message_subject`	STRING	The subject line of the message (primarily for email campaigns). NULL for SMS/push messages that don’t have subject lines.
`message_type`	STRING	Whether the message originated from a campaign, flow/automation, or transactional send.
`message_unique_bounces`	NUMERIC	Count of unique bounces.
`message_unique_clicks`	NUMERIC	Count of unique clicks.
`message_unique_drops`	NUMERIC	Count of unique drops/suppressed sends.
`message_unique_opens`	NUMERIC	Count of unique opens.
`message_unique_receives`	NUMERIC	Count of unique receives/deliveries.
`platform_reported_begin_checkout_revenue`	FLOAT64	Platform-attributed revenue from begin checkout events.
`platform_reported_begin_checkouts`	NUMERIC	Platform-attributed begin checkout events from the message/day.
`platform_reported_order_line_quantity`	NUMERIC	Platform-attributed order line item quantity from the message/day.
`platform_reported_order_line_revenue`	FLOAT64	Platform-attributed order line revenue from the message/day.
`platform_reported_order_revenue`	FLOAT64	Platform-attributed order revenue from the message/day.
`platform_reported_orders`	NUMERIC	Platform-attributed order conversions from the message/day.
`sm_channel`	STRING	Sales channel for the message performance (always ‘Online DTC’ for email/SMS/push campaigns). Provides consistency with order-level channel attribution in multi-channel reporting.
`sm_message_channel`	STRING	Normalized message channel (email, sms, push).
`sms_unique_sends`	NUMERIC	Count of unique SMS sends for the message/day.
`source_system`	STRING	The messaging platform that sent the message (e.g., Klaviyo, Postscript, Attentive). Used to segment performance by messaging service provider.