customer

Attribute Name	Data Type	Description
ID	string	The unique identifier of the customer.
TenantID	int	The unique identifier of the client environment.
SourceSystemID	string	The unique identifier of the upstream source system.
SourceCustomerNumber	string	The unique identifier of the customer in your data.
UUID	string	Universally Unique Identifier (UUID) is a 128-bit label used for information in computer systems.
SourceAccountNumber	string	The account number of the source.
AccountID	string	The unique identifier of the account.
FirstName	string	The customer’s first name. If you have the customer’s full name, specify the full name in this field and leave the other name fields empty.
MiddleName	string	The customer’s middle name.
LastName	string	The customer’s last name.
Title	string	The customer’s title.
Sal	string	The customer’s salary.
Company	string	The customer’s company.
Email	string	The customer’s email address.
PrimaryPhone	string	The customer’s primary phone number.
SecondaryPhone	string	The customer’s secondary phone number.
Cookie	string	The unique identifier of the person triggering the event. For web or app-related events, use an actual cookieID or mobiledeviceID of the visitor, prefixed with an indication of the source system. This attribute is used only for web or app-related events.
State	string	The state or province where the customer is located.
Preferences	string	A combination of the individual preference columns, such as `DoNotCall`, `DoNotEmail`. Each value is separated by `&`. For example, `DNC=Y&DNE=N`.
BirthYear	int	The birth year of the customer.
BirthMonth	int	The birth month of the customer.
BirthDay	int	The birthday of the customer.
BirthDate	timestamp	The date of birth of the customer.
Age	int	The age of the customer.
DateCreated	timestamp	The date when the record was created.
DateModified	timestamp	The date when the record was updated.
DeleteFlag	boolean	The flag that indicates if a customer record is deleted. The possible values are: `True` when a customer record is deleted `False` or `null` when a customer record is not deleted
RowCreated	timestamp	The time when the customer record was first ingested in CDP.
RowModified	timestamp	The time when the customer record was last modified in CDP.
Batch	string	The time when the customer record was last modified in CDP. This is used for bucketing the ingestion of records in CDP.
EmailStatus	string	The validity of the email address of your customers. The possible values are: `V` stands for Verified and indicates that the syntax is valid, the domain is good or known, and the email address is not a known spam trap. `U` stands for Unverified and indicates that the syntax is valid, but the domain is unknown or bad. `X` stands for Invalid and indicates that the syntax is invalid. `Unknown` indicates that no email address was provided.
Gender	string	The customer’s gender. The possible values are: `M` for Male `F` for Female `U` for any other values If a gender is not provided, but a gendered first name is provided, Acquia CDP assigns the gender based on the first name.
MobilePhone	string	The customer’s mobile phone number.
MobileAdvertisingId	string	The unique advertising identifier for the customer’s mobile device. This can be the iOS IDFA or Android’s Google Advertising Id.
MobileDeviceId	string	The unique identifier for the customer’s mobile device. This can be the iOS IDFV or Android Device Id.
NameCodes	string	The Melissa result code system to indicate data quality when validating customers. This also indicates status and any errors. These codes are four-character codes, where two letters are followed by two numbers, and are delimited by commas. For example, `NS01,NS03`.
DoNotEmail	string	The subscription preference of the customer for email campaigns. The possible values are: `Y`: You must not send emails to the customer (opted-out). `N`: You can send emails (opted-in). `U` or empty: You do not have specific information.
DoNotCall	string	The subscription preference of the customer for phone campaigns. The possible values are: `Y`: You must not make calls to the customer (opted-out). `N`: You can call the customer (opted-in). `U` or empty: You do not have specific information.
DoNotText	string	The subscription preference of the customer for text or SMS campaigns. The possible values are: `Y`: You must not send any text or SMS to the customer (opted-out). `N`: You can send a text or SMS to the customer (opted-in). `U` or empty: You do not have specific information.
DoNotMail	string	The subscription preference of the customer for direct, postal mailing campaigns. The possible values are: `Y`: You must not send any postal campaign to the customer (opted-out). `N`: You can send a direct mail to the customer (opted-in). U` or empty: You do not have specific information.
PrimaryPhoneValidity	string	It is returned by Melissa during customer validation to indicate primary phone validity. Possible values are `V`, `X`, and `Unidentified`. By default, phone validation is turned-off.
SecondaryPhoneValidity	string	It is returned by Melissa during customer validation to indicate secondary phone validity. Possible values are `V`, `X`, and `Unidentified`. By default, phone validation is turned-off.
MobilePhoneValidity	string	It is returned by Melissa during customer validation to indicate mobile phone validity. Possible values are `V`, `X`, and `Unidentified`. By default, phone validation is turned-off.
Source	string	The last file origin that modified the customer record.
PhoneValidationResultCodes	string	The Melissa result code system that indicates phone validation quality when validating customers.
RowProcessed	timestamp	The date when the customer record was last processed by CDP.

Loading...

Did not find what you were looking for?