Sending Bulk SMS Appointment Reminders with Sakari

 

Data Setup

To get started let’s take a look at our data. I’ll open up our Excel file and walk through it. Now that we’ve got the file opened up let’s walk through it.

To send bulk text message appointment reminders using Sakari there are only two required fields: the first is the mobile phone number that you want to send the message to and the second is the country code for that mobile phone number.

In this example I’ve also added some additional personal attributes to be able to personalize each of these text messages.

Let’s walk through each of the columns. In column A we have our country code. Sakari recognizes the country code using either the ISO 2 or the ISO 3 country codes for the United States that would be either us or USA and it doesn’t matter if it’s capitalized or lowercase the system will recognize it.

You can also see that we can include other country codes in the file at the same time. In this example set I’ve also included a phone number for Great Britain as well as Canada.

We support over 150 country codes and you can include all of them in a single file.

Moving to the next column we have our mobile phone number. In this example I’ve intentionally setup some difficult phone numbers to try and trick the system, but in each case the Sakari system is able to trim out extra spaces, dashes and parentheses.

Now moving to the right, we have our customer appointment reminders first and last name. These will be used to personalize the message and we have their appointment date in the appointment time.

I want to highlight here the there’s no requirement that the appointment dates all be the same in the file. In this case I’ve intentionally set them up such that each row is a unique date. Each message will be personalized just to that individual with their specific date and time.

Uploading Data

So, the data looks good, now we need to save it. When you’re uploading files to Sakari they need to be an CSV be file format. To do that I’ll go to “File > Save As” select “CSV” as the file format. Give it a name and save it. Now that we have our file saved let’s move back to the Sakari system.

 

Only two of these are required the rest are optional. In my example we don’t have email so I can delete that by selecting delete to the right. The first name is mapped properly and the last name is mapped properly. Had these not been mapped properly I can select them and select from pulldown column names to be able to associate it to the expected property. In my example I’m not using tags so I can delete that as well. You can also see that the system has automatically pulled in the additional columns of the appointment date in the appointment time. If I want to look at some of the sample data I can toggle through and see each of the rows from my Excel file and how it’s mapped. This looks good so I’ll click Save and my columns have been mapped. 

So, let’s get started with our message. To add a wildcard field the structure is three open brackets, your field name let’s use “First Name” as an example, and three closing brackets. You’ll see that that text automatically turns green which indicates that it’s a wildcard field.

In my example, I want to include the customers first name, their appointment date and their appointment reminder time. Using a mix of both static as well as wildcard fields I’ve already written my message so I’ll paste that in now.

So, I’ve pasted it in my message and you can see that there’s some fields both in green as well as in black. In this case Sakari is going to personalize the text message by saying “Hi [first name] your appointment with my Mighty Movers is scheduled for their appointment date, from that Excel file with their appointment time from the Excel file, and then it’s asking them to confirm that they can make it.

This looks good, and you can see that we’re within the one segment based upon the estimated characters, so I’ll click “Save” and my template has been completed. The final step is to select if you’d like the optional reporting.

The reporting is an email report that you can be sent to yourself that will give you a total of the number of text messages that were sent after a delay of your choice. To turn it on or off, I can click on “Reporting”, and in this case, I don’t need the report so I’ll select “No” and I’ll click Save. The final step is to give your campaign a name, I’ll call this the “Daily Appointment Reminder SMS” and I’ll click Save.

Let’s look at Joe for example. Here we can see that the message has been personalized by adding his name, his specific appointment date from the Excel file, and his appointment time with a status of “Sent.” To look at some of the incoming examples I can click on the incoming tab and I can see the message responses from customer appointment reminders.

We’ve set this up with some sample data so you can see what our message response would look like as it comes in. To get more information I can look at the conversations view by closing this and selecting “Conversations” in the left navigation.