How can I ensure my Excel sheet is correctly formatted for variable mapping?
Your Excel sheet must contain the exact columns needed for the variables in the template. For example, if your template includes {{customername}}, {{amount}}, and {{date}}, the Excel sheet should have columns like "customer_name", "amount", and "date".
Related Articles
How can I ensure my Excel sheet is correctly formatted for variable mapping?
When sending personalized WhatsApp campaigns, your Excel or CSV file must be formatted correctly so that template variables (e.g., , ) map seamlessly to real customer data. ⚠️ If the file is misformatted, your campaign may fail, variables will remain ...
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}}, ...
When is variable mapping required?
Variable mapping is only required if your chosen WhatsApp template includes placeholders (e.g., , ). If your template contains no variables, the mapping step is skipped automatically—you go straight to contact upload. ? Decision Flow Does your ...
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.
How does variable mapping work in WhatsApp campaigns?
Variable mapping connects template placeholders (like , ) to columns in your uploaded Excel/CSV file. This makes your WhatsApp campaign personalized at scale, ensuring each recipient sees content tailored to them. ? What Are Template Variables? In ...