Blueshift Access
- Tony Browne (Unlicensed)
The Access data object was created to allow Blueshift users to target customers based on specific Access attributes.
Attribute | Advantage Field | Blueshift Field | Logic/Rules |
|---|---|---|---|
Customer Number | CTM_NBR | customer_id | |
Agreement Id | AGR_ID | agreement_id | |
Agreement Term | AGR_TRM | agreement_term | |
Agreement Status | AGR_STS | status_detail | |
Agreement version | AGR_VER | agreement_version | |
Agreement Renewal | AGR_REN | renewal_type | If 'A' then 'Auto Renewal' 'C' then 'Auto Charge' Â 'D' then 'Auto Discontinued' 'E' then 'Promote Donee' 'N' then 'Do Not Renew' 'S' then 'Special Renewal'Â Â Â Â 'X' then 'Do Not Promote for Renewal' Â 'Y' then 'Promote for Renewal' Â 'Z' then 'Promote Limited Offers' else 'UNKNOWN' |
Agreement Renewal | AGR_REN | renewal_type_detail | |
Agreement Type | AGR_TYP | agreement_type | if 'C' then 'Complimentary', 'I' then 'Invoiceable', 'P' then 'Pro-forma', 'T' then 'Trial' else ‘UNKNOWN’ |
Choice Id | AGR_CHC | choice_id | |
Expiration Date | EXP_DTE | expiration_date | |
Final Expiration Date | AFIN_EXP | final_expire | |
Host Code | HOST_CDE | host_code | |
Item Number | ITM_NUM | item_number | |
Last Updated Date | UPD_UTC | last_updated_date | |
Outlet Code | PMO_CDE | outlet_code | Substring promotion_code(1,1) |
Order Number | ORD_NBR | order_number | |
Owning Org | OWN_ORG | owning_org | |
Promotion code | PMO_CDE | promotion _code | |
Price Code | PRIC_CDE | price_code | |
Quantity Ordered | QTY_ORD | quantity_ordered | |
Quantity Remaining | QTY_REM | quantity_remaining | |
Service Id | SRV_ID | service_id | |
Subscription Type | SUB_TYP | subscription_type | |
Version Start Date | VER_STRT | start_date | |
Unit Price | UNIT_PRC | unit_price | |
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 | |
Email Status | EML_STA | email_status | If ('A',' ') then 'Active', |
Email Address | ADR_EML | email_address | |
Customer Number | CTM_NBR | customer_id | |
Agreement Id | AGR_ID | agreement_id | |
Item Number | ITM_NUM | item_number | |
Agreement Term | AGR_TRM | agreement_term |