CSV Template File for WhatsApp Broadcast Messages

When you submit WhatsApp Broadcast Templates, you can create templates that contain:

• Header (optional):
  • Text with 1 variable
  • Media (Image/Video/Document) variable
• Body:
  • Text with up to 15 variable
• Footer (optional):
  • Text
• Buttons (optional):
  • Call To Action
    • Call Phone Number
    • Visit Website
      • Static
      • Dynamic with 1 variable
  • Quick Reply
    
    • Up to 3 text buttons

Omnichannel Dashboard provides a downloadable CSV template for the broadcast messages feature. The CSV template will customize the message template you choose. See Tutorial

Information:

• phone_number : indicates the telephone number to which the broadcast message will be sent with the format: country code without + (e.g. 62xxxx)
• customer_name : indicates the name of the telephone number’s owner and used as the chatroom’s name
• header_variable : contains variable values in the header of the message template, variable values can contain text or media links needed. You must fill in this field if your message template has a header, but if it doesn’t has a header then you can clear this field. How to Get Direct Media Link From Omnichannel? 
  
  If you want to use the default media header uploaded to the template:
  1. Copy the default media URL from the approved template
     Open Outbound Menu > WhatsApp Broadcast Templates > choose the desired template > Copy Media Link
  2. Or, just remove the header_variable column. Note: make sure you have uploaded the media when submitting the template.

• body_variable : contains variable values on the body of the message template, the maximum variable that can be added is 15 variables. To define variable numbers please add a number in the behind body_variable by format body_variable{ordinal number of variable}. Example : body_variable1, body_variable2
• button_type : contains button types supported by WhatsApp, namely Quick Reply and Call to Action (CTA), see Using Call-to-Action (CTA) button on WhatsApp Message Template. If you don't have a button then you can empty this field. If you use CTA Button Dynamic, the button_type must be filled in with "url"
• button_variable : If your template does not have a variable then you can clear this field, this is only for CTA Button Dynamic. 

Please note the following points:

• Phone_number format must be written according to the country code, for Indonesia, you can use 62
• Make sure the media header size How Big The File That I Can Attach to a WABA Template?
• The maximum number of variables that can be used is 15 variables
• The maximum number of contacts sent is 10.000 phone_number per CSV
• The maximum template content including variables:
  • Header 60 characters
  • Body 1024 characters
• File format must be in CSV
• Make sure there is no unknown character like

  �, â, €, ¬, â, œ, “, etc.

Sample CSV content:

If your CSV file format is in accordance with the CSV template provided, the upload will be successful. After a successful upload, you can pass the broadcast message to the intended contacts. The following is the log status for each contact's broadcast message:

• Sending : Message is being sent
• Queue : Message is still in the queue to be sent
• Sent : Message has been sent but not yet received by the intended contact
• Delivered : Message has been successfully sent and received by the intended contact
• Read : Message has been read by the intended contact
• Failed : Message failed to be sent because the destination contact is invalid or does not activate WhatsApp, or there is another problem. See Failed WhatsApp Broadcast Message with CSV or API