WhatsApp Tabular Report

The WhatsApp tabular report provides the details of each submitted or received WhatsApp message. For example, message content, the status of the message, the reason for message failure, and many more.

The Tabular Report contains the following details:

Column Title	Description	Example
WABA ID	WhatsApp Business Account ID.	8XXXXXXXXXXXXX1
WHATSAPP_ID	Unique ID generated on the message request.	7XXXXXX9-9XXX-4XXX-8XXX-4XXXXXXXXXX4:0
FROM	Approved WhatsApp Phone Number through which the message is sent.	United Kingdom of Great Britain and Northern Ireland
TO	The recipient number to which the message is sent.	4XXXXXXXXXX1
MESSAGE_DIRECTION	The direction of the messages. If the value is True, it indicates the incoming message. If the value is False, it indicates the outgoing message.	false
SOURCE	The source of the WhatsApp messages. It can be API, Campaign, or webhook.	api
FORMAT	The format of the WhatsApp messages. It can be one of the following: Template Text Image Media Contact Location	text
REASON_FOR_FAILURE	The reasons for the failure of the initiated WhatsApp messages.	Template params not matching.
COUNTRY	End user's country. In the case of outgoing messages, this is the destination country. In the case of incoming messages, this is the country of the end user from where a message is sent to you.	India
TEMPLATE_NAME	The name of the template used for sending the message.	contact_us
MESSAGE	The WhatsApp message that end-users receive.	Hi, This is a test message from Kaleyra.
CREATED_AT	Date and time when the message was requested in UTC.	2022-11-25T08:34:10.000Z
FAILED_AT	Date and time when the message failed in UTC.	2022-11-25T08:34:10.000Z
SENT_AT	Date and time when the message was sent to the Meta server in UTC.	2022-11-25T08:34:10.000Z
DELIVERED_AT	Date and time when the message reached the user's mobile device in UTC.	2022-11-25T08:34:10.000Z
SEEN_AT	Date and time when the message was viewed on the mobile device in UTC.	2022-11-25T08:34:10.000Z
PARENT_SERVICE_TYPE	Indicates whether a WhatsApp message is incoming (users sending a message to you), outgoing (you are sending a message to the user as free text), or template (you have sent a message to the recipient using a template).	conversation_outgoing
CONVERSATION_TYPE	The type of conversation to which the message is associated. The following are the supported types: marketing utility authentication service	marketing
CONVERSATION_ID	Unique conversation ID for WhatsApp conversation.	eXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX4
CONVERSATION_MSG_TYPE	Indicates the conversation message type. The type can be one of the following: Conversation start* - The first message to initiate the conversation. In Conversation* - All other messages except the first message within the conversation.	In Conversation
CAMPAIGN_ID	If the message is sent as part of a Campaign launched from the UI, this is the Unique ID campaign.	0xxxx210-3xx2-11xx-9x58-0xx1559xxx49
REF	The REF parameter is optional in API requests. Customers can pass the required information for this parameter that they want displayed in the report.
REF1	The REF1 is an optional parameter that can be passed in the API requests. Customers can pass the required information for this parameter that they want displayed in the report.
REF2	The REF2 parameter is optional in API requests. Customers can pass the required information for this parameter that they want displayed in the report.

Updated 6 days ago