After July 2021, the 2.3.x release line no longer received quality updates or user guide updates. PHP 7.3 reached end of support in December 2021, and Adobe Commerce 2.3.x reached end of support in September 2022. We strongly recommend upgrading to Adobe Commerce 2.4.x to help maintain PCI compliance.

Data Mapping

This site contains archived merchant documentation for a version of Adobe Commerce and Magento Open Source that has reached end-of-support. The documentation available here is intended for historical reference only and is not maintained. The Adobe Commerce Merchant Documentation for current releases is published on the Adobe Experience League.

Stores > Settings > Configuration > dotdigital > Data Mapping

Customer Information

Customer Information

Field Scope Description
Title Website Maps the customer Name Prefix data field from Magento to your corresponding contact data field in dotdigital.
Customer ID Website Maps the Customer ID data field from Magento to your corresponding contact data field in dotdigital.
Firstname Website Maps the First Name customer data field from Magento to the corresponding contact data field in dotdigital. Default data field: FIRSTNAME
Lastname Website Maps the Last Name customer data field from Magento to the corresponding contact data field in dotdigital. Default data field: LASTTNAME
D.O.B. Website Maps the Date of Birth customer data field from Magento to a corresponding contact data field in dotdigital.

Important: In keeping with current security and privacy best practices, be sure you are aware of any potential legal and security risks associated with the storage of customers’ full date of birth (month, day, year) along with other personal identifiers (e.g., full name) before collecting or processing such data. We recommend limiting the storage of customers’ full birth dates and instead suggest using customer year of birth as an alternative.
Gender Website Maps the Gender customer data field from Magento to the corresponding contact data field in dotdigital. Default data field: GENDER
Created At Website Maps the date the customer account was created from Magento to a corresponding contact data field in dotdigital.
Last Logged in Date Website Maps the date the customer last logged in from Magento to a corresponding contact data field in dotdigital.
Customer Group Website Maps the customer group name from Magento to a corresponding contact data field in dotdigital.
Review Count Website Maps the number of reviews written by the customer from Magento to a corresponding contact data field in dotdigital.
Last Review Date Website Maps the date of the customer’s last review from Magento to a corresponding contact data field in dotdigital.
Subscriber Status Website Maps the customer subscription status from Magento to a corresponding contact data field in dotdigital.

Address

Address

Field Scope Description
Billing Address Line 1 Website Maps the first line of the billing street address from Magento to your corresponding contact data field in dotdigital.
Billing Address Line 2 Website Maps the second line of the billing street address from Magento to your corresponding contact data field in dotdigital.
Billing State Website Maps the billing address State field from Magento to your corresponding contact data field in dotdigital.
Billing Country Website Maps the billing address Country field from Magento to your corresponding contact data field in dotdigital.
Billing Postcode Website Maps the billing address Postal Code field from Magento to your corresponding contact data field in dotdigital.
Billing Telephone Website Maps the billing address Telephone Number field from Magento to your corresponding contact data field in dotdigital.
Billing Company Website Maps the billing address Company field from Magento to your corresponding contact data field in dotdigital.
Delivery Address 1 Website Maps the first line of the shipping address from Magento to your corresponding contact data field in dotdigital.
Delivery Address 2 Website Maps the second line of the shipping address from Magento to your corresponding contact data field in dotdigital.
Delivery City Website Maps the shipping address City field from Magento to your corresponding contact data field in dotdigital.
Delivery State Website Maps the shipping address State field from Magento to your corresponding contact data field in dotdigital.
Delivery Country Website Maps the shipping address Country field from Magento to your corresponding contact data field in dotdigital.
Delivery Postcode Website Maps the shipping address Postal Code field from Magento to your corresponding contact data field in dotdigital.
Delivery Telephone Website Maps the shipping address Telephone Number field from Magento to your corresponding contact data field in dotdigital.
Delivery Company Website Maps the shipping address Company field from Magento to your corresponding contact data field in dotdigital.

Sales

Sales

Field Scope Description
Total Number of Orders Website Maps the total number of orders made by the customer from Magento to your corresponding contact data field in dotdigital.
Average Order Value Website Maps the average order made by the customer from Magento to your corresponding contact data field in dotdigital.
Total Spend Website Maps the total amount that a customer has spent from Magento to your corresponding contact data field in dotdigital.
Last Purchase Date Website Maps the date of the last purchase made by a customer from Magento to your corresponding contact data field in dotdigital.
Last Increment ID Website Maps the Order ID of the customer’s most recent order from Magento to your corresponding contact data field in dotdigital.
Total Refund Website Maps the total amount of refunds issued to the customer from Magento to your corresponding contact data field in dotdigital.
Most Purchased Category Website Maps the category with the most product purchases made by the customer from Magento to your corresponding contact data field in dotdigital.
Most Purchased Brand Website Maps the brand that has been purchased the most by the customer from Magento to your corresponding contact data field in dotdigital.
Most Frequent Day of Purchase Website Maps the day of the week when most purchases were made by the customer from Magento to your corresponding contact data field in dotdigital.
Most Frequent Month of Purchase Website Maps the month when most purchases were made by the customer from Magento to your corresponding contact data field in dotdigital.
First Category Purchased Website Maps the category associated with the first purchase made by the customer from Magento to your corresponding contact data field in dotdigital.
Last Category Purchased Website Maps the category associated with the most recent purchase made by the customer from Magento to your corresponding contact data field in dotdigital.
First Brand Purchased Website Maps the brand of the customer’s first purchase from Magento to your corresponding contact data field in dotdigital.
Last Brand Purchased Website Maps the brand of the customer’s most recent purchase from Magento to your corresponding contact data field in dotdigital.

System Values

System Values

Field Scope Description
Website Name Website Maps the name of the website associated with the customer’s activity from Magento to your corresponding contact data field in dotdigital.
Store Name Website Maps the name of the store associated with the customer’s activity from Magento to your corresponding contact data field in dotdigital.
Last Order ID Website Maps the Order ID of the customer’s most recent order from Magento to your corresponding contact data field in dotdigital.
Last Quote ID Website Maps the Quote ID of the customer’s most recent quote from Magento to your corresponding contact data field in dotdigital.
Abandoned Product Name Website Maps the name of the customer’s most recent product abandoned in the cart from Magento to the corresponding contact data field in dotdigital.

Custom Attributes

Gives you the ability to create custom mappings to dotdigital, based on the following Magento attributes:

  • Is Confirmed
  • Create In
  • Disable Automatic Group Change Based on VAT ID
  • Middle Name/Initial
  • Name Suffix
  • Default Billing Address
  • Default Shipping Address
  • Updated At
  • Tax/VAT Number
  • Failures Number
  • First Failure Date
  • Reward Update Notification
  • Reward Warning Notification

Custom Attributes

Field Scope Description
Attribute Website Lists the selection of additional data fields that can be mapped from Magento.
Data Field Website Lists the current selection of contact data fields from dotdigital that can be mapped to a Magento attribute.
Action Website Deletes the current custom mapping.
Add New Attribute   Adds a new custom mapping.

B2B Data

B2B Data

Field Scope Description
Customer Type Website Lists the selection of customer types that can be mapped from Magento.
Company Website Lists the selection of companies that can be mapped from Magento.
Company Status Website Lists the selection of company status settings that can be mapped from Magento.
Store Credit Balance Website Lists the selection of store credit balance amounts that can be mapped from Magento.
Shared Catalog Name Website Lists the selection of shared catalogs that can be mapped from Magento.

Enterprise Data

Enterprise Data

Field Scope Description
Reward Points    
Points Website Maps the customer’s number of points earned from Magento to your corresponding contact data field in dotdigital.
Reward Amount Website Maps the value of the reward points earned by the customer from Magento to your corresponding contact data field in dotdigital.
Expiration Date Website Maps the expiration date of the customer’s reward points from Magento to your corresponding contact data field in dotdigital.
Last Used Date Website Maps the date the customer’s reward points were last used from Magento to your corresponding contact data field in dotdigital.
Customer Information    
Customer Segments Website Maps the customer segment that applies to the customer from Magento to your corresponding contact data field in dotdigital.

Create Data Field

Create Data Field

Field Scope Description
Data Field Name Website The name of the new Customer Engagement contact data field.
Data Field Type Website The type of data to be entered into the field. Options: String (text) / Numeric / Date
Default Value Website The initial value that appears in the field.
Visibility Website Determines if the field is visible to the general public, or only to logged-in users. Options: Private / Public
Create New Data Field   Creates the new data field.
© 2024 Adobe. All rights reserved.