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

Available attributes for Data Export