Write SMS Treatment content to DB using DB Template
Hey guys,
i have configured an Offer Flow with two Send Generic Shapes, both of them are using Same DB Template (SenOutboundSMS) storing data to DB table for sending the actual SMS.
We use external system for the SMS sending which is picking up the records from the DB table and processing it to send the SMS.
First Send Generic should store the data for the SMS and Second is for the reminder SMS, requirement is to have different msg text for both SMSes
The question that is bugging me is can we use the SMS Treatment (or any treatment) text to be stored using the DB Template which we define in the Send Generic shape?
I have attached few files to demonstrate the settings that we have.
Any suggestions are welcome.
Thanks a lot :)
***Edited by Moderator Marije to add Capability tags***
Vodafone
CZ
Hello Marije,
thanks for the post you sent.
It kind of tells me that it is not possible to achieve this the way i outlined in my post.
So unfortunatelly the question remains. How to save the data for SMS body (multiple different texts within one offer flow) to DB using DB Template?
Pegasystems Inc.
US
Hi @MartinN1
I'd like to ask a few more questions before concluding we can't make this work.
Are you using Next-Best-Action Designer?
For your Actions, does each have its own flow configuration or are you using the Dynamic template option?
Finally, will the SMS messages you want to send be personalized with reference to customer or action data?
Thanks,
Amy
Vodafone
CZ
Hello Amy,
thank you for reacting here. :)
for your questions:
1. We are not using NBA Designer.
2. We are not using Dynamic template in this case.
3. I think both options are acceptable for us - personalized / non personalized
best regards
Martin
Vodafone
CZ
It seems like nobody really knows the answer to this. :(
I am thinking now maybe the solution will be to save only the treatment name to our DB and then while processing the SMS we can open the treatment in activity, load any required data, build the request to ext SMS system and send it.
DCS
GB
I would recommend NOT to use Action-Flow for this. Use DB-Template to store the Customer/Offer data needed to personalize the SMS message.
Thanks,
Nanjundan Chinnasamy
Pega Lead decisioning Architect | Decision Consultant Solutions
Vodafone
CZ
Hello, thanks for the reply.
The main idea behind using the Action Flow was to use its waiting capability and send reminders after some time. (or do more actions)
But i will have a look into the DB Template as Campaign results to check the possibilities.
thank you
M.
DCS
GB
Most recent versions of pega CDH solution (Always-ON) are not recommended to have waiting capability. Pega-CDH AlwaysON solution would determine the best Action & treatment to a specific channel for the context.
If there is a genuine need to use waiting capability, you can use Action flow using DB Template. Use SMS TemplateID (defined as custom property for each SMS treatment) along with xCAR attributes and Action attributes if there is a personalisation requirement.
Thanks,
Nanjundan Chinnasamy
Vodafone
CZ
Yes that is what I have designed, Action flow with wait shapes, my question was if there is a way to save the SMS treatment content into DB with already customized data. (The whole SMS text )
However as you suggested the way to achive this is probalbly only to save the treatment name to DB with the DB Template. And once the SMS is loaded from the DB to be send we will load the treatment and populate it with data to customize it.
Thanks and best regards
Martin
DCS
GB
Yes the other way is to keep the entire SMS treatment in a Custom property using tokens and personalize tokens with values using the Strategy framework and store the personalized SMS Treatment directly to the DB Template to send the SMS. We have done that already & works fine.
Thanks,
Nanjundan Chinnasamy | Lead Decision Architect | Decision Consultant Solutions
Vodafone
CZ
Yes we have done this as well, however this solution does not work for dynamic reminder SMS that is implemented within Action flow - you would have to have multiple properties/DB Columnts for each reminder text.
I think we can close this thread as the solution would be:
1. Create multiple properties that holds each reminder/sms text which will be handled inside strategy and then saved to DB via DB template.
2. Save only a SMS treatment name to DB and handle all the message personalization within the activity that is processing sending the SMS.