Attribute | Advantage Blueshift Field | Blueshift Advantage Field | Logic/Rules | |
|---|---|---|---|---|
List Code | list_cdecode | list_codecde | ||
List Status | email_status | eml_staemail_status | CASE WHEN lsteml_m.eml_sta IN ('A','') THEN 'Active' ELSE 'Inactive' END AS list_status | |
Source Code | source_code | lst_src | source_code | |
adr_eml | email_address (or email?) | adr_eml | ||
Date Joined | date_joined | dte_add | date_joined | |
Weekly Delivery Flag | dmo_dat | 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 | ||
campaignacquisition_codemethod | acquisition_method | pmo_acqacquisition_method | ||
list_last_click | list_last_click | |||
list_last_open | list_last_open |
...