How can I ensure my Excel sheet is correctly formatted for variable mapping?

• Related Articles

• How does variable mapping work in WhatsApp campaigns?

  Variable mapping connects placeholders (e.g., {{customername}}) in the template to actual data (e.g., the "Name" column in your Excel sheet). It ensures personalized messages are sent. In a template with variables like {{customername}}, {{amount}}, ...

• What is a fallback value in variable mapping?

  A fallback value is a default value used when data for a variable is missing in the Excel sheet. It can also be a fixed value that applies to all customers.

• When is variable mapping required?

  Variable mapping is needed only when the selected template contains variables. If no variables are present, this step is skipped.

• What information is needed in the Excel sheet for audience creation?

  The Excel sheet must contain at least a column labeled "Phone number". It is also recommended to include the customer’s name (Column name - “Name”) for better personalization.If a name is provided alongside the phone number, the contact will be ...

• How does the system handle duplicates or incorrect phone numbers in the Excel sheet?

  The system automatically removes duplicate phone numbers and ignores rows with incorrect or non-Indian phone numbers.