FirstTransactionDate

The date of the first transaction of the customer.

timestamp

FirstTransactionDatePhysical

The date of the first transaction that the customer made in the physical sales channel.

timestamp

LastTransactionDate

The date of the last transaction of the customer.

timestamp

LastTransactionDatePhysical

The date of the last transaction that the customer made in the physical sales channel.

timestamp

TotalRevenue

The total revenue generated from the transactions that the customer made in their lifetime.

decimal

TotalRevenue_Last13_24Months

The total revenue generated from the transactions that the customer made between the last 13 and 24 months.

decimal

TotalRevenuedecile_Last13_24Months

The total revenue generated from the transactions that the customer made between the last 13 and 24 months, grouped by deciles. Decile 1 being the highest spenders and decile 10 being the lowest spenders.

int

TotalTransactionCount_Last12Months

The total number of transactions that the customer made in the last 12 months.

int

TotalTransactionCountWithDiscount

The total number of transactions that the customer made in their lifetime, with a discount amount greater than $0.

int

TotalDiscount

The total amount of the discount that the customer used in their lifetime.

decimal

TotalProductCount

The total number of distinct products that the customer purchased in their lifetime.

int

LastSendDate

The date of the last email that you sent to the customer.

timestamp

FirstVisitDate

The date when the customer first visited your website.

timestamp

TotalVisitCountLast30Days

The total number of times the customer visited the website in the last 30 days.

int

TotalClickCountLast30Days

The total number of times the customer clicked the links of an email campaign in the last 30 days.

int

TotalOpenCount31_60Days

The total number of emails that the customer opened between the last 31 and 60 days.

int

TotalSendCount31_60Days

The total number of emails sent to the customer between the last 31 and 60 days.

int

PrimaryBrand

The brand that the customer purchased the most in their lifetime based on the total transaction count. The default value is Unknown.

string

Country

The country of the winning address of the customer. The default value is Unknown. By default, CDP promotes addresses that are DPV, certified, recent, opted-in to receive mails, and complete.

string

State

The state of the winning address of the customer. The default value is Unknown. By default, CDP promotes addresses that are DPV, certified, recent, opted-in to receive mails, and complete.

string

ZipCode

The 5-digit zip code of the winning address of the customer. The default value is Unknown. By default, CDP promotes addresses that are DPV, certified, recent, opted-in to receive mail, and complete.

string

FirstPromoID

The marketing campaign through which you acquired the customer, as provided by your analytics data. For example, Google Analytics or Adobe Analytics. This is the most granular level of your marketing campaign categorization, typically the keyword level. The default value is Unknown.

string

AovGroup

The average value of the transactions that the customer made in their lifetime, grouped into buckets for easier use.

string

CategoryMixGroup

The total number of distinct product categories that the customer purchased in their lifetime, grouped into buckets for easier use.

string

DaySinceFirstWebLoginGroup

The number of days since the customer first visited your website, grouped into buckets for easier use.

string

DaySinceLastWebLoginGroup

The number of days since the customer last visited your website, grouped into buckets for easier use.

string

LastTransactionInterval

The number of days between the last and penultimate (second to last) transactions that the customer made.

int

RecencyMonth

The number of months since the last transaction that the customer made.

string

TenureDays

The number of days since the first transaction that the customer made.

int

TotalClickCount31_60DaysGroup

The total number of times the customer clicked the links of an email campaign between the last 31 and 60 days, grouped into buckets for easier use.

string

TotalOpenCount31_60DaysGroup

The total number of emails that the customer opened between the last 31 and 60 days, grouped into buckets for easier use.

string

TotalSendCount31_60DaysGroup

The total number of emails sent to the customer between the last 31 and 60 days, grouped into buckets for easier use.

string

TotalProductCountGroup

The total number of distinct products that the customer purchased in their lifetime, grouped into buckets for easier use.

string

TotalRevenue_Last12MonthsGroup

The total revenue generated from the transactions that the customer made in the last 12 months, grouped into buckets for easier use.

string

TotalRevenueSegment_13_24Months

An easier way to use the “Revenue decile”:

• “1 - High Value” represents your top 10% customers in terms of revenue on this period

• “2 - Medium Value” represents your 80% average customers, that is, not in the top/bottom 10% in terms of revenue in this period

• “3 - Low Value” represents your bottom 10% customers in terms of revenue in this period

string

TotalTransactionCount_13_24MonthsGroup

The total number of transactions that the customer made between the last 13 and 24 months, grouped into buckets for easier use.

string

TotalTransactionCountGroup

The total number of transactions that the customer made in their lifetime, grouped into buckets for easier use.

string

TotalVisitCountLast30DaysGroup

The total number of times the customer visited the website in the last 30 days, grouped into buckets for easier use.

string

Age

The age of the customer. This comes from your standard customer feed.

int

BirthYear

The birth year of the customer. This comes from your standard customer feed.

string

TotalRevenueSegment_SegmentationStatus

A segmentation representing the progression of revenue for your customers between 13-24 months ago and the last 12 months. It characterizes whether they spent less (Downward), the same (Stable), or more (Upward) in the last 12 months when compared to the 13-24 months ago period. If a customer was acquired in the last 12 months, then they are marked as “New Buyer”. “Reactivated” customers are buyers who made a purchase in the last 12 months, but did not make a purchase in the previous 13-24 months, and made a transaction before the last 24 months. “2 Period Inactive” customers are buyers who did not make a purchase in the last 24 months, but made a purchase before 24 months ago. “Lapsed” customers are buyers who made a purchase in the last 13-24 months, but did not make a transaction in the last 12 months.

string

EmailDomain

The domain of the customer’s email address. The default value is Unknown.

string

ClosestStoreDistance

The distance, in miles, between the location of the customer and the closest store. This filter can work only for US, Canada and UK addresses for both stores and customers.

int

TotalOrganizationCount

The total number of organizations or transaction channels from which the customer purchased in their lifetime.

int

LastTransactionOrganization

The organization or transaction channel from which the customer made the last purchase. The default value is Unknown.

string

Email

The winning email address of the master customer after CDP’s Identity Resolution Engine de-duplicates child customer profiles.

string

EmailOptOutDate

The date when the customer opted out of email communication.

string

Preferences

This is a deprecated field. Use DoNotEmail, DoNotMail, DoNotCall, and DoNotText instead.

string

FirstName

The winning first name of the master customer after CDP’s Identity Resolution Engine de-duplicates child customer profiles.

string

LastName

The winning last name of the master customer after CDP’s Identity Resolution Engine de-duplicates child customer profiles.

string

SAL

The salutation deduced by CDP’s Identity Resolution Engine.

string

SecondaryPhone

The winning secondary phone number of the master customer after CDP’s Identity Resolution Engine de-duplicates child customer profiles.

string

Address1

The Address1 of the winning address of the customer. The default value is Unknown. By default, CDP promotes addresses that are DPV, certified, recent, opted-in to receive mail, and complete.

string

TotalCost

The total cost of goods of all products that the customer purchased in their lifetime.

decimal

TotalCost_Last13_24Months

The total cost of goods of all products that the customer purchased between the last 13 to 24 months.

decimal

RecencyDays

The number of days since the last transaction of the customer.

int

PropensityToEngageDecile

A deprecated machine learning model that has been replaced with a new model.

string

BehaviorBasedClusterID

A deprecated machine learning model that has been replaced with a new model.

string

BrowseClusterID

A deprecated machine learning model that has been replaced with a new model.

string

BrandClusterID

A deprecated machine learning model that has been replaced with a new model.

string

AddressCertified

A flag to mark whether the address is CASS certified by the USPS.

• “True” means that the address is CASS certified

• “False” means that the address is not CASS certified and is likely invalid

• “Unknown” means that there is no address or the address is not in the US or Canada. Currently, these are the only countries that are certified.

string

DpvConfirm

The DPV confirmation results that CDP receives from USPS for US addresses. The new filter is called “DPV Confirmed”, and can take the values:

• “Y” when the address is DPV confirmed

• “N” when the address is not certified.

string

DoNotEmail

The subscription preference of the customer for email campaigns. The possible values are:

• “Y” indicates that the contacts explicitly opted-out

• “N” indicates that the contacts explicitly opted-in

• “U” indicates that the contacts have no explicit values and are usually the contacts that you can/want to contact

string

DoNotText

The subscription preference of the customer for text (SMS) campaigns. The possible values are:

• “Y” indicates that the contacts explicitly opted-out

• “N” indicates that the contacts explicitly opted-in

• “U” indicates that the contacts have no explicit values and are usually the contacts that you can/want to contact

string

BirthDate

The birth date of the customer. This comes from your standard customer feed.

timestamp

NCOADateUpdate

The date when the record last went through NCOA processing.

string

MoveType

The type of move that was registered within the USPS NCOA database. The possible values are:

• “I” for Individual Match

• “F” for Family Match

• “B” for Business Name Match

string

NCOADateUpdateBigInt

The date when the move was registered with USPS in the NCOA. database.

timestamp

SecondaryPhoneValidity

Returned by Melissa to indicate the secondary phone validity. The possible values are V, X, and Unidentified. By default, phone validation is turned off.

string

PropensityToBuyDecile_L1M

A deprecated machine learning model that has been replaced with a new model.

string

BehaviorBasedClusterID_L1M

A deprecated machine learning model that has been replaced with a new model.

string

PropensityToBuyDecile_ThisMonth

A deprecated machine learning model that has been replaced with a new model.

string

EmailHash

A SHA-256 hash of the winning email address of the master customer after CDP’s Identity Resolution Engine de-duplicates child customer profiles.

string

AddressType

Example Address Types: Firm or Company address, General Delivery address, High Rise or Business complex, PO Box address, Rural Route address, Street or Residential address

string

ProductClusterID_L2M

A deprecated machine learning model that has been replaced with a new model.

string

ClosestStoreID

The unique identifier of the store closest to the winning zip code of the customer.

string

ChannelMix

The mix of sales channels from which the customer purchased in their lifetime.

string

ChannelMix_Last13_24Months

The mix of sales channels from which the customer purchased between the last 13 and 24 months.

string