Updates in Schema 11 for SAS Customer Intelligence 360

[Will_F_SAS]

In March 2023, SAS Customer Intelligence 360 includes updates to the Unified Data Model (UDM) for the schema 11 data model. Schema 11 contains enhancements to support these features:

• Facebook tasks and Google tasks
• Internal changes to support conversions and impressions

Updates to the UDM

These are updates to the existing tables in the UDM:

Table	Updates
CONVERSION_MILESTONE	The reserved_1_txt column now contains a string representation of an impression's control_group_flg attribute. For more information, see CONVERSION_MILESTONE (Partitioned).
IMPRESSION_SPOT_VIEWABLE	The reserved_2_txt column now contains a string representation of an impression's control_group_flg attribute. For more information, see IMPRESSION_SPOT_VIEWABLE (Partitioned).

These are the new tables in the UDM:

Table	Updates
ADVERTISING_CONTACT	This table captures data for tasks that integrate audience data with Facebook and Google. For more information, see Advertising Detail Tables.