Information for: DEVELOPERS   PARTNERS   SUPPORT

customersummary

Attribute Name Data Type
MasterCustomerID string
FirstTransactionDate timestamp
PreviousTransactionDate timestamp
LastTransactionDate timestamp
FirstTransactionRevenue decimal
TotalRevenue decimal
TotalRevenue_Last12Months decimal
TotalRevenue_Last13_24Months decimal
TotalRevenuedecile_Last12Months int
TotalRevenuedecile_Last13_24Months int
TotalTransactionCount int
TotalTransactionCount_Last12Months int
TotalTransactionCount_Last13_24Months int
TotalTransactionCountWithDiscount int
TotalListPrice decimal
TotalDiscount decimal
TotalProductcategoryCount int
TotalProductCount int
LastOpenDate timestamp
LastSendDate timestamp
LastClickDate timestamp
FirstVisitDate timestamp
LastVisitDate timestamp
TotalVisitCountLast30Days int
TotalVisitCount31_60Days int
TotalClickCountLast30Days int
TotalClickCount31_60Days int
TotalOpenCount31_60Days int
TotalOpenCountLast30Days int
TotalSendCount31_60Days int
TotalSendCountLast30Days int
PrimaryBrand string
PrimaryOrganization string
Country string
State string
City string
ZipCode string
Gender string
FirstPromoID string
FirstPromoCategoryID string
aovgroup string
averagediscountrate string
categorymixgroup string
daysincefirstweblogin int
daysincefirstweblogingroup string
daysincelastweblogin int
daysincelastweblogingroup string
firsttransactionrevenuegroup string
lasttransactioninterval int
recencydaysgroup string
recencymonth string
frequency double
tenuredays int
tenuredaysgroup string
totalclickcount31_60daysgroup string
totalclickcountlast30daysgroup string
totalopencount31_60daysgroup string
totalopencountlast30daysgroup string
totalsendcount31_60daysgroup string
totalsendcountlast30daysgroup string
totalproductcountgroup string
totalrevenue_last13_24monthsgroup string
totalrevenue_last12monthsgroup string
totalrevenuegroup string
totalrevenuesegment_13_24months string
totalrevenuesegment_last12months string
totaltransactioncount_13_24monthsgroup string
totaltransactioncount_last12monthsgroup string
totaltransactioncountgroup string
totalvisitcount31_60daysgroup string
totalvisitcountlast30daysgroup string
zipconcat string
age int
birthmonth string
birthyear string
frequencygroup string
totalrevenuesegment_segmentationstatus string
lasttransactionintervalgroup string
emaildomain string
closeststore string
closeststoredistance int
closeststoredistancegroup string
totalorganizationcount int
firsttransactionorganization string
lasttransactionorganization string
primarystore string
email string
customerstatus string
Preferences string
BuyerIdentification string
FirstName string
MiddleName string
LastName string
Title string
Sal string
PrimaryPhone string
SecondaryPhone string
MobilePhone string
Address1 string
Address2 string
TotalCost decimal
TotalCost_Last12Months decimal
TotalCost_Last13_24Months decimal
PrimaryDeviceType string
recencydays int
PropensityToBuyDecile string
PropensityToEngageDecile string
PropensityToConvertDecile string
BehaviorBasedClusterID string
PurchaseClusterID string
BrowseClusterID string
ProductClusterID string
BrandClusterID string
EmailStatus string
AddressCertified string
Suite string
DpvConfirm string
FirstOfflinePromoID string
DoNotEmail string
DoNotCall string
DoNotText string
DoNotMail string
BirthDate timestamp
ZipExt string
NCOADateUpdate string
MoveType string
MoveDate string
NCOADateUpdateBigInt timestamp
PrimaryPhoneValidity string
SecondaryPhoneValidity string
MobilePhoneValidity string
PropensityToBuyDecile_L1M string
PropensityToBuyDecile_L2M string
BehaviorBasedClusterID_L1M string
BehaviorBasedClusterID_L2M string
PropensityToBuyDecile_ThisMonth string
BehaviorBasedClusterID_ThisMonth string
emailHash string
RBDI string
AddressType string
ProductClusterID_L1M string
ProductClusterID_L2M string
ProductClusterID_ThisMonth string
ClosestStoreID string
PrimaryStoreID string
ChannelMix string
ChannelMix_Last12Months string
ChannelMix_Last13_24Months string