Document toolboxDocument toolbox

Blueshift Conferences

The Conferences data object was created to allow Blueshift users to target customers based on specific Conferences attributes.


Attribute

Advantage Field

Blueshift Field

Logic/Rules

Attribute

Advantage Field

Blueshift Field

Logic/Rules

Attendee Customer

CTM_NBR

customer_id



Billing Customer

BIL_CTM

bill_to_customer_id



Owning Org

OWN_ORG

owning_org



Conference Location

CONF_LOC

conference_location



Promotion Code

PMO_CDE

promotion_code



Outlet Code

PMO_CDE

outlet_code

Substring promotion_code(1,1)

Registration Status

REG_STA

registration_status

If 'A' then 'Active’

'B' then 'Bill Suspended'

'C' then 'Cancelled'

'N' then 'Non-pay Cancelled'

'R' then 'Reversed'

'W' then 'Wait Listed'

else 'UNKNOWN'

Registration Status

REG_STA

registration_status_detail



Conference Id

CONF_ID

conference_id



Conference Session

CONF_SES

conference_session



Attendee Status

ATN_DED

event_attended

If 'Y' then 'True’ else 'False'

Registration Date

REG_DTE

registration_date



Registration Sequence

CONF_RSQ

registration_sequence



Conference Registration Id

CONF_REG

conference_registration



Campaign Code

CPN_CDE

campaign_code



Acquisition Method

PMO_ACQ

acquisition_method



Creative Code

CTV_CDE

creative_code



Offer Code

OFR_CDE

offer_code



Email Id

EMAL_ID

email _id



Owning Org

OWN_ORG

owning_org



Email Status

EML_STA

email_status

If ('A',' ') then 'Active', 
if 'I' then 'OptOut',  
if 'B' then 'Bounce'  
if 'X' then CsSPAM 
If 'S' then 'Spam'  
else 'UNKNOWN' 

Email Address

ADR_EML

email_address



com.atlassian.confluence.content.render.xhtml.migration.exceptions.UnknownMacroMigrationException: The macro 'html-macro' is unknown.