Updates for Schema 13 in the UDM for SAS Customer Intelligence 360

[Will_F_SAS]

Starting with the release for November 8, SAS Customer Intelligence 360 includes updates to the Unified Data Model (UDM) for schema 13. Schema 13 contains enhancements to support these features:

• Support for A/B testing of email tasks
• Display the optout method for emails
• Update the usage details to include how many rows of audience data were processed.

 

These are updates to the existing tables in the UDM:

Table	Updates
CONVERSION_MILESTONE	The following columns are added: test_flg – specifies whether an email task is part of a test subject_line_txt – the text of the email’s subject line
DAILY_USAGE MONTHLY_USAGE	The audience_usage_cnt column was added. This column displays the number of rows of audience data that were successfully processed by SAS Customer Intelligence 360.
EMAIL_BOUNCE EMAIL_CLICK EMAIL_COMPLAINT EMAIL_OPEN EMAIL_OPTOUT EMAIL_OPTOUT_DETAILS EMAIL_REPLY EMAIL_SEND EMAIL_VIEW	The following columns are added: test_flg – specifies whether an email task is part of a test subject_line_txt – the text of the email’s subject line analysis_group_id – the variant ID for the email that was sent
EMAIL_OPTOUT EMAIL_OPTOUT DETAILS	The optout_type_nm column is added to describe the type of opt out that was used by the recipient. The value can be link_unsubsribe or list_unsubscribe.
MD_AUDIENCE	The audience_duration_val column was renamed to audience_expiration_val. The audience_frequency_cd column was updated: The column name was changed to audience_schedule_flg. The data type was changed to CHAR(1).