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.

Attribute Name

Data Type

Description

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.

string

The customer’s email address.

PrimaryPhone

string

The customer’s primary phone number.

SecondaryPhone

string

The customer’s secondary phone number.

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.

Did not find what you were looking for?

Loading...

Acquia Help

Filter by product:

Interactive Queries common questions

Did not find what you were looking for?