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

[Will_F_SAS]

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

• Added additional channel metrics to the DAILY_USAGE table and MONTHLY_USAGE table.
• New columns for EMAIL_OPEN table and EMAIL_CLICK tables to include more information about how the email is accessed.
• New columns in the EMAIL_BOUNCE table to include the reason code and raw reason text from Sparkpost.

These are updates to the existing tables in the UDM:

Table	Updates
DAILY_USAGE MONTHLY_USAGE	These columns are added: mobile_push_cnt mobile_in_app_msg_cnt facebook_ads_cnt google_ads_cnt linkedin_ads_cnt outbound_api_cnt
EMAIL_BOUNCE	These columns are added: raw_reason_txt bounce_class_cd
EMAIL_CLICK EMAIL_OPEN	These columns are added: click_tracking_flg mailbox_provider_nm open_tracking_flg user_agent_nm agent_family_nm manufacturer_nm device_nm is_mobile_flg platform_desc platform_version