Attribute | Blueshift Field | Advantage Field | Logic/Rules |
|---|---|---|---|
List Code | list_code | list_cde | |
Email Active | email_active | eml_sta | CASE WHEN lsteml_m.eml_sta IN ('A','') THEN 'true' ELSE 'false' END AS list_status |
SMS Active | sms_active | When a user opts in for marketing SMS then this field will be set to true | |
Source Code | source_code | lst_src | |
Date Joined | date_joined | dte_add | |
Weekly Delivery Flag | weekly_delivery_flag | dmo_dat | CASE WHEN SUBSTRING(LST.DMO_DAT,11,1) = '1' THEN 'true' ELSE 'false' END AS weekly_delivery_flag |
Campaign Code | campaign_code | cpn_cde | |
acquisition_method | acquisition_method | pmo_acq | |
list_last_click | list_last_click | ||
list_last_open | list_last_open | ||
is_deleted | is_deleted | A snapshot of the list object is taken from Advantage data from the past hour and it differentiates against the current snapshot to produce the delta and send to Blueshift. If what’s in the current snapshot does not exist in the snapshot from an hour ago, this flag is set to true. This usually happens when records are hard deleted from Advantage. |
Only lists that are active in Advantage will have data sent to Blueshift.
Another important attribute to include is the is_deleted = False as this flag would be flipped to True if the email address is removed or replaced with another email address in Advantage. Unless this flag is set to False the email address that is no longer under the list record would still be eligible to get picked up by the segment.