1. Acoustic Help Center
  2. Insights
  3. Channel performance

Channel performance

WhatsApp data dictionary

Avatar
Katarzyna Gajewska
  • Updated

Here you'll find all the definitions and calculations of data fields used in the WhatsApp channel dashboard.

Dimensions

Database field reference Reporting field name Type Definition
campaign_name Name string The name of the campaign.
code Code string Sender ID for WhatsApp.
consent_action Consent action string Mobile originated requested consent action: OPTED-IN, OPTED-OUT.
delivery_status Delivery status string Status of delivery: SENT, REJECTED, ERROR, FAILED, DELIVERED, PARTIALLY_DELIVERED.
event_category Event category string The channel category of the event.
event_date Event Date datetime Datetime of event.
event_details Event details string Details for this event.
event_type Event type string Type of the email event.
includes_media Includes media string Indicates whether the send includes media, like images or files.
message_date Message Date time Message Send Date UTC.
mobile_number Mobile number string Contact Identifier of a mobile device.
num_media_urls Num media URLs string The number of media URLs sent.
sent_event_date Sent datetime The first sent event of the message.
sent_event_datetime Sent date (formatted) datetime The first sent event of the massage, formatted as 'Month Date, Year'.

Measures

Database field reference Reporting field name Type Definition Calculations
count Count Count The total number of WhatsApp events by event_id. Count of event_id records.
click_count Clicked (gross) count The total number of times a recipient clicked on a link within a WhatsApp message. Count of events with event_type: 'linkClicked'.
click_count_unique Clicked (unique) count_distinct The total number of unique clicks Count of unique contact_ids by message_id with one click count.
click_rate Clicked rate (gross) number The total number of click events out of the number of delivered messages. Click count out of delivery count, by percentage.
click_rate_unique Clicked rate (unique) number The total number of unique clicks out a number of delivered events, as a percentage. Unique click count out of delivery count, by percentage.
delivery_count Delivered count The total number of times a WhatsApp message was not rejected by a server. Count of events with event_type: 'delivered'.
delivery_rate Delivery rate number The total number of delivered by the number of sent messages. Delivery count out of the sent count, by percentage.
undelivery_count Failed delivery count The total number of sent messages that were undelivered. Count of events with delivery_status: 'FAILED'
undelivery_rate Failed delivery rate number The total number of failed delivery count by the number of sent events, as a percentage. Failed delivery count out of sent count, by percentage.
interacted_count Interacted count The total number of interacted messages. Count of events with event_type: 'interacted'.
read_count Read count The total number of times a WhatsApp message is read by a recipient in a marketing campaign. Count of events with event_type: 'read'.
send_count Sent count The total number of times a WhatsApp message is sent to a recipient in a marketing campaign. Count of events with event_type: 'sent'.
opt_in_counts Opt-ins count The total number of opt-in events out of the number of delivered messages. Count of events with event_type: 'interacted' and consent_action: 'OPTED-IN-OK'.
opt_out_counts Opt-outs count The total number of times a recipient declines to receive messages from a sender. Count of events with event_type: 'interacted' and consent_action: 'OPTED-OUT-OK'.
Was this article helpful?
0 out of 0 found this helpful
Return to top

Related articles

Comments

0 comments

Please sign in to leave a comment.