BookmarkSubscribeRSS Feed
Will_F_SAS
SAS Employee

 

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

 

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
  • 991 views
  • 0 likes
  • 1 in conversation