Blueshift List (CF)

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

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 customer opts in to receive marketing SMS this flag will be switched to True. If a customer opts out this flag will be set to False
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.