One row is
one outbound message
Delivery
Rewritten daily
Columns
32
Where it lands
snapshot_date= partition only, and check for _SUCCESS before you do, as
described in bucket layout.
Columns
Internal warehouse key. Not stable between deliveries — the send is identified by
conversation_id.Internal warehouse key for the contact. Join
cloud_chat_contacts through the conversation instead.Join key. Conversation the message opened or belongs to. Joins to
cloud_chat_conversations.Name of the WhatsApp template used in the send. For
campaign, the template configured on the campaign; for individual_proactive, the first template sent in the conversation. NULL for a free-text send.Category of the template as declared when it was sent:
MARKETING, UTILITY or AUTHENTICATION. Campaign sends do not record it, so it is usually NULL for campaign. For what Meta charged, use meta_pricing_category.billable as reported by Meta for the template message of this send. Meta is phasing this field out: read meta_pricing_type and meta_pricing_category together instead.Category Meta billed the template message of this send under:
marketing, utility, authentication, authentication_international, service or referral_conversion. Recorded since November 2026. NULL for older sends, for sends whose message was never delivered, and when the template message of the send cannot be found in the conversation.regular when Meta charges the template message of this send at the rate of meta_pricing_category; free_customer_service or free_entry_point when it costs nothing.Meta pricing model the template message of this send was billed under.
PMP, per-message pricing.What produced the send:
campaign for a bulk send, individual_proactive for one agent reaching out to one contact.When the contact opened it. Always
NULL on channels that do not report read receipts, which is not the same as unread.Whether the contact replied. The four flags give you the delivery funnel without comparing timestamps for
NULL.The error code with a plain-language explanation, for example a rate limit, a policy block or an undeliverable number.
Other error covers codes without a specific category.