Attribute | Blueshift Field | Advantage Field | Logic/Rules |
|---|---|---|---|
List Code | list_code | list_cde | |
customer_id | customer_id | This is the profile key which is comprised of the affiliate id and email address which is MD5 hashed. | |
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 customer opts in for to receive marketing SMS then this field this flag will be switched to True. If a customer opts out this flag will be set to trueFalse | |
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. |
...