Information for: DEVELOPERS   PARTNERS   SUPPORT

List of available Attributes

Attribute-naming Convention

  1. All “ID” attributes on each entity are unique identifiers for records that are assigned by Customer Data Platform (CDP)’s platform. Examples include attributes such as MasterCustomerID, ProductID, ProductCategoryID.
  2. All “SourceXNumber” attributes on each entity are unique identifiers for records provided by the client. Examples include attributes such as SourceCustomerNumber, SourceProductNumber, SourceProductCategoryNumber.

customersummary

  1. MasterCustomerID (PK)
  2. FirstTransactionDate
  3. PreviousTransactionDate
  4. LastTransactionDate
  5. FirstTransactionRevenue
  6. TotalRevenue
  7. TotalRevenue_Last12Months
  8. TotalRevenue_Last13_24Months
  9. TotalRevenuedecile_Last12Months
  10. TotalRevenuedecile_Last13_24Months
  11. TotalTransactionCount
  12. TotalTransactionCount_Last12Months
  13. TotalTransactionCount_Last13_24Months
  14. TotalTransactionCountWithDiscount
  15. TotalListPrice
  16. TotalDiscount
  17. TotalProductcategoryCount
  18. TotalProductCount
  19. LastOpenDate
  20. LastSendDate
  21. LastClickDate
  22. FirstVisitDate
  23. LastVisitDate
  24. TotalVisitCountLast30Days
  25. TotalVisitCount31_60Days
  26. TotalClickCountLast30Days
  27. TotalClickCount31_60Days
  28. TotalOpenCount31_60Days
  29. TotalOpenCountLast30Days
  30. TotalSendCount31_60Days
  31. TotalSendCountLast30Days
  32. PrimaryBrand
  33. PrimaryOrganization
  34. Country
  35. State
  36. City
  37. ZipCode
  38. Gender
  39. FirstPromoID
  40. FirstPromoCategoryID
  41. aovgroup
  42. averagediscountrate
  43. categorymixgroup
  44. daysincefirstweblogin
  45. daysincefirstweblogingroup
  46. daysincelastweblogin
  47. daysincelastweblogingroup
  48. firsttransactionrevenuegroup
  49. lasttransactioninterval
  50. recencydaysgroup
  51. recencymonth
  52. frequency
  53. tenuredays
  54. tenuredaysgroup
  55. totalclickcount31_60daysgroup
  56. totalclickcountlast30daysgroup
  57. totalopencount31_60daysgroup
  58. totalopencountlast30daysgroup
  59. totalsendcount31_60daysgroup
  60. totalsendcountlast30daysgroup
  61. totalproductcountgroup
  62. totalrevenue_last13_24monthsgroup
  63. totalrevenue_last12monthsgroup
  64. totalrevenuegroup
  65. totalrevenuesegment_13_24months
  66. totalrevenuesegment_last12months
  67. totaltransactioncount_13_24monthsgroup
  68. totaltransactioncount_last12monthsgroup
  69. totaltransactioncountgroup
  70. totalvisitcount31_60daysgroup
  71. totalvisitcountlast30daysgroup
  72. zipconcat
  73. age
  74. birthmonth
  75. birthyear
  76. frequencygroup
  77. totalrevenuesegment_segmentationstatus
  78. lasttransactionintervalgroup
  79. emaildomain
  80. closeststore
  81. closeststoredistance
  82. closeststoredistancegroup
  83. totalorganizationcount
  84. firsttransactionorganization
  85. lasttransactionorganization
  86. primarystore
  87. email
  88. customerstatus
  89. Preferences
  90. BuyerIdentification
  91. FirstName
  92. MiddleName
  93. LastName
  94. Title
  95. Sal
  96. PrimaryPhone
  97. SecondaryPhone
  98. MobilePhone
  99. Address1
  100. Address2
  101. TotalCost
  102. TotalCost_Last12Months
  103. TotalCost_Last13_24Months
  104. PrimaryDeviceType
  105. recencydays
  106. PropensityToBuyDecile
  107. PropensityToEngageDecile
  108. PropensityToConvertDecile
  109. BehaviorBasedClusterID
  110. PurchaseClusterID
  111. BrowseClusterID
  112. ProductClusterID
  113. BrandClusterID
  114. EmailStatus
  115. AddressCertified
  116. Suite
  117. DpvConfirm
  118. DoNotEmail
  119. DoNotCall
  120. DoNotText
  121. DoNotMail
  122. BirthDate
  123. ZipExt
  124. NCOADateUpdate
  125. MoveType
  126. MoveDate
  127. ChannelMix
  128. ChannelMix_Last12Months
  129. ChannelMix_Last13_24Months

mastercustomer

  1. ID (PK)
  2. MasterCustomerID
  3. CustomerID

customer

  1. ID (PK)
  2. SourceCustomerNumber
  3. UUID
  4. SourceAccountNumber
  5. AccountID
  6. FirstName
  7. MiddleName
  8. LastName
  9. Title
  10. Sal
  11. Company
  12. Email
  13. PrimaryPhone
  14. SecondaryPhone
  15. Cookie
  16. State
  17. Preferences
  18. BirthYear
  19. BirthMonth
  20. BirthDay
  21. BirthDate
  22. Age
  23. DateCreated
  24. DateModified
  25. RowCreated
  26. RowModified
  27. EmailStatus
  28. Gender
  29. MobilePhone
  30. MobileAdvertisingId
  31. MobileDeviceId
  32. NameCodes
  33. DoNotEmail
  34. DoNotCall
  35. DoNotText
  36. DoNotMail

address

  1. ID (PK)
  2. SourceAddressNumber
  3. Address1
  4. Address2
  5. City
  6. Zip
  7. ZipExt
  8. State
  9. Country
  10. CountryCode
  11. Certified
  12. DpvConfirm
  13. DeliveryPointCode
  14. DateCertified
  15. Suite
  16. CarrierRoute
  17. CMRA
  18. DeliveryPointCheckDigit
  19. ErrorCode
  20. ErrorString
  21. LACS
  22. RBDI
  23. Latitude
  24. Longitude
  25. NCOADateModified
  26. NCOADateUpdate
  27. MoveType
  28. MoveDate
  29. MatchFlag
  30. RowCreated
  31. RowModified
  32. Name
  33. Type

customeraddressxref

  1. ID (PK)
  2. SourceAddressNumber
  3. AddressID
  4. SourceCustomerNumber
  5. CustomerID
  6. RowCreated
  7. RowModified

product

  1. ID (PK)
  2. SourceProductNumber
  3. Name
  4. Description
  5. ProductURL
  6. ImageURL
  7. ParentProductID
  8. ParentProductNumber
  9. Status
  10. BundleNumber
  11. BrandName
  12. SourceBrandNumber
  13. MSRP
  14. ListPrice
  15. SalePrice
  16. SaleCondition
  17. Availability
  18. AvailableQty
  19. Size
  20. Color
  21. Weight
  22. DateCreated
  23. DateModified
  24. RowCreated
  25. RowModified
  26. RecoStatus

productcategory

  1. ID (PK)
  2. SourceCategoryNumber
  3. Name
  4. ParentCategoryID
  5. SourceParentCategoryNumber
  6. LevelName
  7. URL
  8. ImageURL
  9. RowCreated
  10. RowModified

productcategoryxref

  1. ID (PK)
  2. SourceProductNumber
  3. ProductID
  4. SourceProductCategoryNumber
  5. ProductCategoryID
  6. RowCreated
  7. RowModified

transaction

  1. ID (PK)
  2. SourceTransactionNumber
  3. SourceTransactionNumberAlt
  4. SourceCustomerNumber
  5. CustomerID
  6. SourceAccountNumber
  7. AccountID
  8. SourceOrganizationNumber
  9. OrganizationID
  10. Total
  11. Currency
  12. TransactionTimeStamp
  13. Type
  14. SourceEmployeeNumber
  15. EmployeeID
  16. Discount
  17. Tax
  18. DateCreated
  19. DateModified
  20. RowCreated
  21. RowModified
  22. ShippingRevenue

transactionitem

  1. ID (PK)
  2. SourceTransactionItemNumber
  3. TransactionID
  4. SourceTransactionNumber
  5. SourceOrganizationNumber
  6. OrganizationID
  7. SourceProductNumber
  8. ProductID
  9. Type
  10. Subtype
  11. ShipDate
  12. InvoiceDate
  13. Quantity
  14. Weight
  15. Volume
  16. ListPrice
  17. SaleRevenue
  18. Discount
  19. CostBasis
  20. Tax
  21. ShippingRevenue
  22. ShippingCost
  23. ShippingDiscount
  24. OtherRevenue
  25. OtherCost
  26. Currency
  27. UserClient
  28. BundleNumber
  29. SourceSubscriptionNumber
  30. SubscriptionID
  31. Gift
  32. DateCreated
  33. DateModified
  34. DeleteFlag
  35. RowCreated
  36. RowModified