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