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
|