Using dynamic treatments in SAS CI

[JM_VFAU]

Hi,

Is it possible to to use create a treatment in SAS CI which is combinations of fixed text and Dynamic value obtained from database?

For e.g:,

If you are from [Suburb] please call us.

To use this text as one of the columns in the Treatment. The variable [Suburb] is read from the databases based on the customer included in the campaign.

Is it posisble to create a treatment which is combination of Dynamic and static values in a treatment object?

Regards,

John

[Dmitry_Alergant · Accepted solution]

How many different suburbs do you have?

If the number is reasonable, you can split the diagram by suburb into multiple cells (one cell per suburb) and then manually assign a different treatment attribute value for each cell.

But if you need truly dynamic (personalized) treatment attribute values coming from the database or a formula, this is not possible in SAS MA out-of-the-box, unfortunately.  In SAS RTDM, treatments can have truly dynamic attributes (assigned with a variable or a formula), but in SAS MA this is not yet supported. Treatment attributes in SAS MA can only have constant values - either assigned on a Treatment level ("static" attributes"), or at the Cell level while the treatment is assigned in the campaign (this is what is called "dynamic" in UI, but not very dynamic in fact).

So, to answer you precisely:

• Can SAS MA produce a dynamically personalized message text and export it to the channel? Sure it can, you create a calculated item and add it to the Export tab, that's it.
  
  
• Can this dynamically personalized message text then be stored in your campaign history database, for historical, reporting and audit purposes? Yes, it can but you will need to work on it to make it happen, one way or another. Use whatever export output you produce to add the information in your campaign history database - either to an extension columns to SAS CDM tables or some custom history table.
  
  
• Can this dynamically personalized message text be produced and then stored as a treatment attribute - no it can not (in all current releases of SAS MA). There is always hope this may change in the future releases.
  

 Hope it helps.

[JM_VFAU]

Thanks Dimitry.