TawSernTan Member since 2015 40 posts
M1 Ltd
Posted: 4 years ago
Last activity: 4 years 6 months ago

execute SQL after completion of campaign?


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.


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

Decision Management
Moderation Team has archived post
Share this page LinkedIn