Automatic SMS sending on a given date

Tags

, ,

One of our customers had a very good question lately: Can we schedule automatic sms sending over a date in a column of a database? The answer is yes, however you need a second task in the Campaign Manager. We created a short guideline with screenshots and I would like to share it with you.

1)
We need a sms and these two columns in the database: ‘DateX’ and ‘SendSMS’. DateX stores the custom dates.

SMS_on_spec_date01

2)
Then I prepared a filter (for a task later), it simply checks if the database column [[SensSMS]] is ‘Yes’. Save the filter.

SMS_on_spec_date02

3)
In the Campaign Manager I added a new task ‘DB-Writer’. Two things need to be set up: It should write into the column [[SendSMS]] (please see the assignment in the next step). Furthermore we have to enable the repetitive execution plan. The task needs to be repeated each day.

SMS_on_spec_date03

4)
The assignment looks like this: Write ‘No’, but if the custom date in the column [[DateX]] is equal to the current date (in the same format), then write ‘Yes’.

SMS_on_spec_date04

5)
I added the second task, send SMS. The SMS should not be send out to every record, but only to the ones which match the filter ‘SendSMS’. It is the filter we created in step 2.

SMS_on_spec_date05

6)
Last step: start both tasks!

SMS_on_spec_date06

That’s it!