The Mining Data Mart - Data Mining Techniques in CRM: Inside Customer Segmentation - page 151

Table 4.12 A subset of the ''M_Transactions'' table recording the channel utilization for two bank customers.

Year_Month Customer_ID Account_ID Transaction_ Transaction_ Transaction_ Amount_

Code Channel Channel_Desc Transactions

200901 1001 10011 101 1 BRANCH 100

200901 1001 10011 101 2 ATM 30

200901 1001 10012 101 2 ATM 80

200901 1001 10012 104 1 BRANCH 70

200901 1001 10012 102 1 BRANCH 90

200901 1002 10021 101 3 INTERNET 120

200901 1002 10021 101 1 BRANCH 150

200901 1002 10022 103 3 INTERNET 140

200901 1002 10022 105 3 INTERNET 180

200901 1002 10022 105 4 PHONE 120