BookmarkSubscribeRSS Feed
Will_F_SAS
SAS Employee

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

 

  • Support for A/B testing of email tasks
  • Display the optout method for emails
  • Update the usage details to include how many rows of audience data were processed.

 

These are updates to the existing tables in the UDM:

 

Table

Updates

CONVERSION_MILESTONE

The following columns are added:

  • test_flg – specifies whether an email task is part of a test
  • subject_line_txt – the text of the email’s subject line

DAILY_USAGE

MONTHLY_USAGE

The audience_usage_cnt column was added.

 

This column displays the number of rows of audience data that were successfully processed by SAS Customer Intelligence 360.

EMAIL_BOUNCE

EMAIL_CLICK

EMAIL_COMPLAINT

EMAIL_OPEN

EMAIL_OPTOUT

EMAIL_OPTOUT_DETAILS

EMAIL_REPLY

EMAIL_SEND

EMAIL_VIEW

The following columns are added:

  • test_flg – specifies whether an email task is part of a test
  • subject_line_txt – the text of the email’s subject line
  • analysis_group_id – the variant ID for the email that was sent

EMAIL_OPTOUT

EMAIL_OPTOUT DETAILS

The optout_type_nm column is added to describe the type of opt out that was used by the recipient.

 

The value can be link_unsubsribe or list_unsubscribe.

MD_AUDIENCE

The audience_duration_val column was renamed to audience_expiration_val.

 

The audience_frequency_cd column was updated:

  • The column name was changed to audience_schedule_flg.
  • The data type was changed to CHAR(1).

 

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