BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
JM_VFAU
Obsidian | Level 7

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Dmitry_Alergant
Pyrite | Level 9

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.

-------
Dmitriy Alergant, Tier One Analytics

View solution in original post

2 REPLIES 2
Dmitry_Alergant
Pyrite | Level 9

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.

-------
Dmitriy Alergant, Tier One Analytics
JM_VFAU
Obsidian | Level 7

Thanks Dimitry.

How to improve email deliverability

SAS' Peter Ansbacher shows you how to use the dashboard in SAS Customer Intelligence 360 for better results.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1779 views
  • 2 likes
  • 2 in conversation