Plan, execute, measure and optimize customer experiences

Using dynamic treatments in SAS CI

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 15
Accepted Solution

Using dynamic treatments in SAS CI

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

 


Accepted Solutions
Highlighted
Solution
‎08-29-2017 05:43 PM
Contributor
Posts: 51

Re: Using dynamic treatments in SAS CI

[ Edited ]

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


All Replies
Highlighted
Solution
‎08-29-2017 05:43 PM
Contributor
Posts: 51

Re: Using dynamic treatments in SAS CI

[ Edited ]

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
Occasional Contributor
Posts: 15

Re: Using dynamic treatments in SAS CI

Thanks Dimitry.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

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