Send personalised batch campaigns
The below guide will assist you with creating and sending personalised batch SMS using variable fields.
Last updated
Was this helpful?
The below guide will assist you with creating and sending personalised batch SMS using variable fields.
Last updated
Was this helpful?
Personalising your SMS messages can significantly enhance the impact of your communications. You can tailor each message to its recipient by using variable fields with MACROS. This guide will walk you through the process of setting up and sending custom SMS messages using variable fields.
Data Format: Your data should be organised in an Excel spreadsheet (.csv recommended).
Headers: The file headers of your columns must be in uppercase. For instance, use 'NUMBER', 'NAME', 'POINTS', 'MESSAGE', etc., as your column headers.
Data Entry: Enter the recipient details under these headers. Ensure that each column contains the appropriate data for its header (e.g., phone numbers under 'NUMBER', names under 'NAME').
Using Macros: In your message text, you'll use macros to insert variable fields. These are represented by the column headers enclosed in hashtags.
If your message template is:
Hello #NAME#, just a reminder that your next appointment at BrightSmile Dental is on #DATE# at #TIME#. You currently have #POINTS# loyalty points. Reply STOP to opt out of reminders.
The system will replace #NAME#, #DATE#, #TIME#, and #POINTS# with each recipient's corresponding data from your file.
From your login screen, select Compose from the top left panel of the screen.
Select Bulk SMS
You will then be navigated to the Import Batch screen as pictured below:
You will now be able to upload your batch file from the above screen. To do this, select Upload a File. From here, you can navigate to your batch file in .csv (recommended format) and select it.
Once you have selected your desired batch file, you will be navigated to the screen below. This next step requires selecting your file's first row of usable data. This row will be highlighted as per the image below. Once you have matched the row, you may proceed by selecting the Next Step.
On this page, we will ask you to let us know what data makes up each column of the .csv file you uploaded.
Be sure to select Message to correspond with your message field. Macro fields must be set to Ignore this data. If you followed the file format, the page should be set up similarly to the below screen.
Once you are satisfied with the setup, you can proceed by selecting the Next Step option.
The next step in the process would be to apply your final settings for your SMS send. Some notable options:
Campaign Name
This is the name of your batch file or campaign that you'd like to use.
From
This is a custom number that you can select as the source number for the SMS.
This number can be anything you need to it be and will be used to cross-reference incoming messages back to a campaign if you need to track this. The value can either be alpha or numeric.
Start sending campaign
This option allows you to select when the batch send will be started:
Immediately - sends the batch immediately once the steps have been completed
When I click ‘Start’ - saves the batch for a manual start.
At a scheduled date and time - Sends the batch at the date and time selected.
Advanced Options (Optional)
This allows you to view and set advanced options for the batch send such as speed (TPS), filtering options, removing duplicates (checked by default), and batch splitting options for bigger campaigns.
After you've created the batch, you'll be taken to a batch preview page where you can review your message content, settings, and total billable messages.
Enter your mobile number in the SEND TEST field and press the SEND button to send a live test to confirm that you are satisfied with your text.
If you are happy with your test results, you can continue by selecting Finish.
You will be taken to the campaign status page once the batch has been created. If you choose an immediate start, this page lets you track the campaign's progress.
For sending at a later stage, return to Campaigns to manually begin your batch send. Here you can see a list of your campaigns. Start Batch by selecting the drop-down arrow next to the desired campaign name. Your batch will now start sending.
Tips for Effective Use
Ensure your data is consistent and correctly formatted in your upload file.
Always send a test message to yourself or a colleague to ensure the variable fields work correctly.
