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 automatically saved in the contact book.
Related Articles
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 ...
Can I download a sample Excel or CSV file for audience creation?
Yes, you can download sample files directly from the campaign creation page.
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 the system handle duplicates or incorrect phone numbers in the Excel sheet?
When you upload an audience file in MyOperator, the system runs automatic validation checks to ensure only valid contacts are imported. This prevents failed sends, saves credits, and keeps your campaign clean. ? What Gets Removed Automatically Type ...
How does automatic contact creation work after a successful campaign?
If the uploaded Excel sheet contains both "Name" and "Phone number" columns, the system will automatically save those contacts to the contact book.