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 |