| Info |
|---|
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. |
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. |
...
. |