Check final mapping set
NOTE
If you are coming from the Streaming Ingestion Lab please click the below link to proceed to the next step in that lab:
Simple mappings
NOTE
Replace the <tenant-name> with the value from your sandbox
Source Field
Target Field
account_create_date
<tenant-name>.account.createDate
account_end_date
<tenant-name>.account.endDate
customer_id
<tenant-name>.customerID
plan_name
<tenant-name>.plan.name
plan_id
<tenant-name>.plan.planID
billing_city
billingAddress.city
billing_zip_code
billingAddress.postalCode
billing_state
billingAddress.state
billing_street_address
billingAddress.street1
email_optIn
consents.marketing.email.val
mobile_phone
mobilePhone.number
firstName
person.name.firstName
lastName
person.name.lastName
email
personalEmail.address
createDate
repo.createDate
modifyDate
repo.modifyDate
shipping_city
shippingAddress.city
shipping_zip_code
shippingAddress.postalCode
shipping_state
shippingAddress.state
shipping_street_address
shippingAddress.street1
NOTE
Ensure your final mapping matches what is shown below before continuing.
Calculated mappings
Calculated fields
XDM Field
iif(sms_optIn == null or sms_optIn == “”, ‘n’, sms_optIn)
consents.marketing.sms.val
concat(date_part(“month”, date(birth_Date,“M/d/yyyy”)).toString(), “-”, date_part(“day”, date(birth_Date,“M/d/yyyy”)).toString())
person.birthDayAndMonth
date_part(“yyyy”,date(birth_Date,“M/d/yyyy”))
person.birthYear
NOTE
Ensure your final mapping matches what is shown below before continuing
recommendation-more-help
blueprints-learn-help-blueprints