Attribute | Blueshift Field | Advantage Field | Logic/Rules |
|---|---|---|---|
List Code | list_code | list_cde | |
List StatusEmail Active | email_statusactive | eml_sta | CASE WHEN lsteml_m.eml_sta IN ('A','') THEN 'Activetrue' ELSE 'Inactivefalse' 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 | |
email_address (or email?) | adr_eml | ||
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 |
...