Chapter 2: | Segmenting Customer Transactions Using a Pattern-Based Clustering Approach |
Global model (no segmentation), k-means, the RFM-based (Recency, Frequency and Monetary value) segmentation model and GLIMMIX (Generalized Mixture Regression Model). With RFM, customers can be grouped according to how recently they bought from the retailer, how frequently they bought in a given time period, and how much they spent in that same period. RFM is a popular market segmentation model in the marketing literature and practice (Shepard 1995). Using the site-centric purchasing data we have, we are able to derive values for Recency, Frequency and Monerary value. Customers with the same value for RFM were grouped together. For example, customers with {Recency = low, Frequency = high, Monetary = high} were grouped into one segment. For every possible combination of the values of Recency, Frequency and Monerary value, there is a segment. In the prediction stage, a customer is assigned to one of the segments according to the values of the customer’s R, F and M. In our experiment, we have three possible values (low, medium, high) for R, F and M. See (Hartigan 1975) for the description of k-means and see Appendix 2 for the description of GLIMMIX. Table 4 presents the results comparing the predictive accuracy of the 5 approaches on the hold-out samples.
In our experiment, RFM was not significantly different from the Global model (p = 0.3478); GLIMMIX was significantly better than
Table 4. Comparison of Root Mean Squared Errors for Experiment I
Global | RFM | GLIMMIX | k-means | GHIC | |
amazon.com | 25.07 | 24.68 | 25.24 | 24.28 | 19.36 |
bestbuy.com | 22.71 | 22.13 | 4.71 | 5.28 | 3.72 |
bmgmusic.com | 6.61 | 6.67 | 4.94 | 4.58 | 3.30 |
expedia.com | 35.43 | 36.67 | 26.92 | 27.01 | 26.02 |
hotwire.com | 24.14 | 32.65 | 11.12 | 17.10 | 13.23 |
landsend.com | 32.91 | 34.22 | 22.23 | 27.78 | 11.35 |
orbitz.com | 58.14 | 57.66 | 48.69 | 47.34 | 36.57 |
qvc.com | 165.63 | 164.31 | 73.63 | 111.10 | 65.58 |
sears.com | 26.57 | 26.47 | 15.12 | 23.46 | 13.45 |
ticketmaster.com | 76.95 | 77.46 | 31.33 | 18.90 | 12.48 |