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 about 2 months ago