--- title: "Available attributes for Data Export" date: "2024-02-14T06:18:38+00:00" summary: "Explore the comprehensive list of attributes available for data export in Customer Data Platform (CDP). Learn about customer, product, transaction, and address data fields to enhance your marketing analytics and personalization efforts." image: type: "page" url: "/customer-data-platform/available-attributes-data-export" id: "7e8e8498-a9dd-4b97-8a54-b17812d7e1c4" --- 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. Some of the examples are MasterCustomerID, ProductID, and ProductCategoryID. 2. 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 --------------- 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