Attribute | Advantage Field | Blueshift Field | Logic/Rules |
|---|---|---|---|
List Code | list_cde | list_code | |
List Status | eml_sta | email_status | CASE WHEN lsteml_m.eml_sta IN ('A','') THEN 'Active' ELSE 'Inactive' END AS list_status |
Source Code | lst_src | source_code | |
adr_eml | email_address (or email?) | ||
Date Joined | dte_add | date_joined | |
Weekly Delivery Flag | dmo_dat | weekly_delivery_flag | CASE WHEN SUBSTRING(LST.DMO_DAT,11,1) = '1' THEN 'true' ELSE 'false' END AS weekly_delivery_flag |
Campaign Code | cpn_cde | campaign_code | |
acquisition_method | pmo_acq | acquisition_method | |
list_last_click | list_last_click | ||
list_last_open | list_last_open |
General
Content
Integrations
App links