BookmarkSubscribeRSS Feed
Will_F_SAS
SAS Employee

In the 22.03 release of SAS Customer Intelligence 360, the Unified Data Model (UDM) and the Common Data Model (CDM) will be updated to use the data model for schema 8. Schema 8 introduces new enhancements to improve cross-table compatibility and to add columns for new features.

 

Updates to the Unified Data Model

 

These are the updates to the UDM tables:

 

Table Name

Updates

EXTERNAL_EVENT

The table is now available for more licenses. The categories for this table are now DISCOVER, ENGAGEEMAIL, ENGAGEDIGITAL, and ENGAGEDIRECT.

DAILY_USAGE

This table is new and will contain data for future reports. Currently this table is listed in schema 8 but cannot be downloaded.

MONTHLY_USAGE

This table is new and will contain data for future reports. Currently this table is listed in schema 8 but cannot be downloaded.

IMPRESSION_DELIVERED

Three columns are added:

  • product_id
  • control_group_flg
  • rec_group_id

This update makes the table consistent with the IMPRESSION_SPOT_VIEWABLE table.

SPOT_CLICKED

Two columns are added:

  • control_group_flg
  • rec_group_id

This update makes the table consistent with the IMPRESSION_SPOT_VIEWABLE table.

MD_TARGET_ASSIST

This is a new table that will support future enhancements to analytics.

MD_TASK

Two columns are added:

  • use_modeling_flg
  • model_start_dttm

These columns are added to support future enhancements to analytics.

 

Updates to the Common Data Model

 

Columns were added to the CDM tables to ensure that full CDM details are captured and that the integrity between tables is maintained.

 

These are the updates to the CDM tables:

 

Table Name

Updates

CDM_ACTIVITY_CUSTOM_ATTR

One column is added: activity_id

CDM_ACTIVITY_X_TASK

Two columns are added:

  • activity_id
  • task_id

CDM_DYN_CONTENT_CUSTOM_ATTR

One column is added: content_id

CDM_RTC_DETAIL

Two columns are added:

  • segment_id
  • task_id

CDM_RTC_X_CONTENT

One column is added: content_id

CDM_SEGMENT_CUSTOM_ATTR

One column is added: segment_id

CDM_SEGMENT_DETAIL

One column is added: segment_map_id

CDM_SEGMENT_MAP_CUSTOM_ATTR

One column is added: segment_map_id

CDM_TASK_CUSTOM_ATTR

One column is added: task_id

CDM_TASK_DETAIL

One column is added: recurring_schedule_flg

 

 

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
  • 0 replies
  • 4855 views
  • 1 like
  • 1 in conversation