Information for: DEVELOPERS   PARTNERS   SUPPORT

Customer Feed

Feed structure

Field Name Required ? Data type Referential integrity Description
SourceCustomerNumber (key) Required String CustomerAddressXRef:SourceCustomerNumber, Transaction:SourceCustomerNumber, TransactionItem:SourceCustomerNumber, Webtag:SourceCustomerNumber The unique identifier of the customer in your data.
FirstName Recommended String   The customer’s first name. If you only have the customer’s full name, then just put the full name in this field and leave the other name fields empty.
MiddleName Recommended String   The customer’s middle name.
LastName Recommended String   The customer’s last name.
Gender Recommended String   The customer’s gender. Accepted values are : “M” for Male, “F” for Female, and “U” for any other values (neutral, unknown, etc…). If a gender is not provided, but a strongly gendered first name is provided, Customer Data Platform (CDP) will assign the gender of the first name.
Email Recommended String Webtag:Email The customer’s email address.
PrimaryPhone Optional String   The customer’s primary phone number.
MobilePhone Optional String   The customer’s mobile phone number.
SourceAddressNumber Recommended String   The unique identifier of this customer’s address. If you do not have a unique identifier for the address, and have only one address per customer in your data, you can populate this field with the same information as SourceCustomerNumber. Note : if you have multiple addresses per customer (at least for some customers), you should leave those fields empty and provide an Address and CustomerAddressXRef feed (see Address feed).
AddressName Optional String   The name of this customer’s address for easier reference, e.g. “San Francisco home”, “Work”…
AddressType Optional String   The type of address, e.g. “Primary residence”, “Work”…
Address1 Recommended String   The billing address of your customer. If you have only the shipping address, use that instead.
Address2 Recommended String   The billing address of your customer. If you have only the shipping address, use that instead.
City Recommended String   The billing address of your customer. If you have only the shipping address, use that instead.
Zip Recommended String   The billing address of your customer. If you have only the shipping address, use that instead.
ZipExt Optional String   The billing address of your customer. If you have only the shipping address, use that instead.
State Recommended String   The billing address of your customer. If you have only the shipping address, use that instead.
Country Recommended String   The billing address of your customer. If you have only the shipping address, use that instead.
CountryCode Required String   The standard ISO Alpha-2 code for the country where the organization is located (e.g. “United States” should be “US”, “France” should be “FR”, etc…). Required for address validation and distance-to-store calculations. If this is not provided, CDP will default to US. See the list of supported countries for more details
BirthMonth Optional Integer   The birth month of the customer.
BirthYear Optional Integer   The birth year of the customer.
BirthDay Optional Integer   The birth day of the customer.
Age Optional Integer   The age of the customer.
BirthDate Optional Datetime   The date of birth for that customer.
DateCreated Optional Datetime   The date as which the record was created.
MobileAdvertisingId Optional String   The unique advertising identifier for this customer’s mobile device. This can be the iOS IDFA or Android’s Google Advertising Id.
MobileDeviceId Optional String   The unique identifier for this customer’s mobile device. This can be the iOS IDFV or Android Device Id.
DoNotEmail Recommended String   The subscription preferences of the customer, for email campaigns. This is a flag that means “Do Not Email”, set to “Y” if you should not send emails to this customer (opted-out), “N” if you can send her an email (opted-in), “U” or do not provide this flag if you don’t have specific information.
DoNotCall Recommended String   The subscription preferences of the customer, for phone campaigns. This is a flag that means “Do Not Call”, set to “Y” if you should not make any calls to this customer (opted-out), “N” if you can call her (opted-in), “U” or do not provide this flag if you don’t have specific information.
DoNotText Recommended String   The subscription preferences of the customer, for text/SMS campaigns. This is a flag that means “Do Not Text”, set to “Y” if you should not send any text/SMS campaign to this customer (opted-out), “N” if you can send her a text/SMS (opted-in), “U” or do not provide this flag if you don’t have specific information.
DoNotMail Recommended String   The subscription preferences of the customer, for postal mailing campaigns. This is a flag that means “Do Not Mail”, set to “Y” if you should not send any postal campaign to this customer (opted-out), “N” if you can send her a direct mail (opted-in), “U” or do not provide this flag if you don’t have specific information.
Custom attributes Optional Any (float, datetime, string, boolean)   Custom attributes that you want to use inside the CDP application. Note that this customization is not self-service, requires you to engage with your CDP CSM, and involves some deployment effort.

Deprecated

After release 1729

Field Name Required ? Data type Referential integrity Description
Preferences Recommended String   This used to represent the subscription preferences of the customer. It used the following convention : “DNE=Y&DNC=N&DNM=U”, all in one field. DNE, DNM, DNC and DNT have each been split into their separate columns (DoNotEmail, DoNotMail, etc…), with the same conventions for their respective values. This makes the merging of preferences across records much more granular and easier to manage for complex use cases. Note : if you are already using this “Preferences” field, you can keep using it in your data feeds. You should however not use both at the same time : any information from the new colunms (DoNotEmail, etc…) will override whatever is found in the “Preferences” field from now on.