Question

3
Replies
210
Views
Taw Sern Tan (TawSernTan)
M1 Ltd

M1 Ltd
SG
TawSernTan Member since 2015 40 posts
M1 Ltd
Posted: March 16, 2016
Last activity: April 10, 2017
Posted: 16 Mar 2016 5:12 EDT
Last activity: 10 Apr 2017 9:23 EDT
Closed

execute SQL after completion of campaign?

Hi,

We are using the Cordiant Marketing Director. We are exploring to use the software to blast out SMS alerts to our customer whenever some locations of the our Fibre network is down. The information is not readily available in the database and hence we need to load the data and execute the campaign.

Just wondering,

1) If we will to load data into the table while the campaign is execution, what is the impact to the campaign?

2) Is it possible to execute a SQL to update certain field in the table after the campaign execution has completed, so that the next run will not pick up the old record? It is not possible to remove stop the duplication at campaign setting, as the same customer need to be contacted twice if the main backbone is cut off twice.

Please advise what is the best way to build the campaign.

Regards.

***Updated by moderator: Lochan to add Categories***

Decision Management
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.