Attribute-naming Convention

• All “ID” attributes on each entity are unique identifiers for records that are assigned by Customer Data Platform (CDP)’s platform. Some of the examples are MasterCustomerID, ProductID, and ProductCategoryID.

• All “SourceXNumber” attributes on each entity are unique identifiers for records provided by the client. Some of the examples are SourceCustomerNumber, SourceProductNumber, and SourceProductCategoryNumber.

customersummary

• MasterCustomerID (PK)

• FirstTransactionDate

• PreviousTransactionDate

• LastTransactionDate

• FirstTransactionRevenue

• TotalRevenue

• TotalRevenue_Last12Months

• TotalRevenue_Last13_24Months

• TotalRevenuedecile_Last12Months

• TotalRevenuedecile_Last13_24Months

• TotalTransactionCount

• TotalTransactionCount_Last12Months

• TotalTransactionCount_Last13_24Months

• TotalTransactionCountWithDiscount

• TotalListPrice

• TotalDiscount

• TotalProductcategoryCount

• TotalProductCount

• LastOpenDate

• LastSendDate

• LastClickDate

• FirstVisitDate

• LastVisitDate

• TotalVisitCountLast30Days

• TotalVisitCount31_60Days

• TotalClickCountLast30Days

• TotalClickCount31_60Days

• TotalOpenCount31_60Days

• TotalOpenCountLast30Days

• TotalSendCount31_60Days

• TotalSendCountLast30Days

• PrimaryBrand

• PrimaryOrganization

• Country

• State

• City

• ZipCode

• Gender

• FirstPromoID

• FirstPromoCategoryID

• aovgroup

• averagediscountrate

• categorymixgroup

• daysincefirstweblogin

• daysincefirstweblogingroup

• daysincelastweblogin

• daysincelastweblogingroup

• firsttransactionrevenuegroup

• lasttransactioninterval

• recencydaysgroup

• recencymonth

• frequency

• tenuredays

• tenuredaysgroup

• totalclickcount31_60daysgroup

• totalclickcountlast30daysgroup

• totalopencount31_60daysgroup

• totalopencountlast30daysgroup

• totalsendcount31_60daysgroup

• totalsendcountlast30daysgroup

• totalproductcountgroup

• totalrevenue_last13_24monthsgroup

• totalrevenue_last12monthsgroup

• totalrevenuegroup

• totalrevenuesegment_13_24months

• totalrevenuesegment_last12months

• totaltransactioncount_13_24monthsgroup

• totaltransactioncount_last12monthsgroup

• totaltransactioncountgroup

• totalvisitcount31_60daysgroup

• totalvisitcountlast30daysgroup

• zipconcat

• age

• birthmonth

• birthyear

• frequencygroup

• totalrevenuesegment_segmentationstatus

• lasttransactionintervalgroup

• emaildomain

• closeststore

• closeststoredistance

• closeststoredistancegroup

• totalorganizationcount

• firsttransactionorganization

• lasttransactionorganization

• primarystore

• email

• customerstatus

• Preferences

• BuyerIdentification

• FirstName

• MiddleName

• LastName

• Title

• Sal

• PrimaryPhone

• SecondaryPhone

• MobilePhone

• Address1

• Address2

• TotalCost

• TotalCost_Last12Months

• TotalCost_Last13_24Months

• PrimaryDeviceType

• recencydays

• PropensityToBuyDecile

• PropensityToEngageDecile

• PropensityToConvertDecile

• BehaviorBasedClusterID

• PurchaseClusterID

• BrowseClusterID

• ProductClusterID

• BrandClusterID

• EmailStatus

• AddressCertified

• Suite

• DpvConfirm

• DoNotEmail

• DoNotCall

• DoNotText

• DoNotMail

• BirthDate

• ZipExt

• NCOADateUpdate

• MoveType

• MoveDate

• ChannelMix

• ChannelMix_Last12Months

• ChannelMix_Last13_24Months

mastercustomer

• ID (PK)

• MasterCustomerID

• CustomerID

customer

• ID (PK)

• SourceCustomerNumber

• UUID

• SourceAccountNumber

• AccountID

• FirstName

• MiddleName

• LastName

• Title

• Sal

• Company

• Email

• PrimaryPhone

• SecondaryPhone

• Cookie

• State

• Preferences

• BirthYear

• BirthMonth

• BirthDay

• BirthDate

• Age

• DateCreated

• DateModified

• RowCreated

• RowModified

• EmailStatus

• Gender

• MobilePhone

• MobileAdvertisingId

• MobileDeviceId

• NameCodes

• DoNotEmail

• DoNotCall

• DoNotText

• DoNotMail

address

• ID (PK)

• SourceAddressNumber

• Address1

• Address2

• City

• Zip

• ZipExt

• State

• Country

• CountryCode

• Certified

• DpvConfirm

• DeliveryPointCode

• DateCertified

• Suite

• CarrierRoute

• CMRA

• DeliveryPointCheckDigit

• ErrorCode

• ErrorString

• LACS

• RBDI

• Latitude

• Longitude

• NCOADateModified

• NCOADateUpdate

• MoveType

• MoveDate

• MatchFlag

• RowCreated

• RowModified

• Name

• Type

customeraddressxref

• ID (PK)

• SourceAddressNumber

• AddressID

• SourceCustomerNumber

• CustomerID

• RowCreated

• RowModified

product

• ID (PK)

• SourceProductNumber

• Name

• Description

• ProductURL

• ImageURL

• ParentProductID

• ParentProductNumber

• Status

• BundleNumber

• BrandName

• SourceBrandNumber

• MSRP

• ListPrice

• SalePrice

• SaleCondition

• Availability

• AvailableQty

• Size

• Color

• Weight

• DateCreated

• DateModified

• RowCreated

• RowModified

• RecoStatus

productcategory

• ID (PK)

• SourceCategoryNumber

• Name

• ParentCategoryID

• SourceParentCategoryNumber

• LevelName

• URL

• ImageURL

• RowCreated

• RowModified

productcategoryxref

• ID (PK)

• SourceProductNumber

• ProductID

• SourceProductCategoryNumber

• ProductCategoryID

• RowCreated

• RowModified

transaction

• ID (PK)

• SourceTransactionNumber

• SourceTransactionNumberAlt

• SourceCustomerNumber

• CustomerID

• SourceAccountNumber

• AccountID

• SourceOrganizationNumber

• OrganizationID

• Total

• Currency

• TransactionTimeStamp

• Type

• SourceEmployeeNumber

• EmployeeID

• Discount

• Tax

• DateCreated

• DateModified

• RowCreated

• RowModified

• ShippingRevenue

transactionitem

• ID (PK)

• SourceTransactionItemNumber

• TransactionID

• SourceTransactionNumber

• SourceOrganizationNumber

• OrganizationID

• SourceProductNumber

• ProductID

• Type

• Subtype

• ShipDate

• InvoiceDate

• Quantity

• Weight

• Volume

• ListPrice

• SaleRevenue

• Discount

• CostBasis

• Tax

• ShippingRevenue

• ShippingCost

• ShippingDiscount

• OtherRevenue

• OtherCost

• Currency

• UserClient

• BundleNumber

• SourceSubscriptionNumber

• SubscriptionID

• Gift

• DateCreated

• DateModified

• DeleteFlag

• RowCreated

• RowModified

Available attributes for Data Export