Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Bookbinders Book Club Introduction About 50,000 new titles, including new editions, are published in the United States each year, giving rise to a $20+ billion

Bookbinders Book Club

Introduction About 50,000 new titles, including new editions, are published in the United States each year, giving rise to a $20+ billion book publishing industry. About 10 percent of the books are sold through mail order. Book retailing in the 1970s was characterized by the growth of chain bookstore operations in concert with the development of shopping malls. Traffic in bookstores in the 1980s was enhanced by the spread of discounting. In the 1990s, the superstore concept of book retailing was responsible for the double-digit growth of the book industry. Generally situated near large shopping centers, superstores maintain large inventories of anywhere from 30,000 to 80,000 titles. Superstores are putting intense competitive pressure on book clubs, mail-order firms and retail outlets. Recently, online superstores, such as www.amazon.com, have emerged, carrying 1-2.5 million titles and further intensifying the pressure on book clubs and mail-order firms. In response to these pressures, book clubs are starting to look at alternative business models that will make them more responsive to their customers' preferences. Historically, book clubs offered their readers continuity and negative option programs that were based on an extended contractual relationship between the club and its subscribers. In a continuity program, popular in such genres as children's books, a reader signs up for an offer of several books for a few dollars each (plus shipping and handling on each book) and agrees to receive a shipment of one or two books each month thereafter. In a negative option program, subscribers get to choose which and how many additional books they will receive, but the default option is that the club's selection will be delivered to them each month. The club informs them of the monthly selection and they must mark "no" on their order forms if they do not want to receive it. Some firms are now beginning to offer books on a positive-option basis, but only to selected segments of their customer lists that they deem receptive to specific offers. Book clubs are also beginning to use database marketing techniques to work smarter rather than expand the coverage of their mailings. According to Doubleday president Marcus Willhelm, "The database is the key to what we are doing.... We have to understand what our customers want and be more flexible. I doubt book clubs can survive if they offer the same 16 offers, the same fulfillment to everybody."2 Doubleday uses modeling techniques to look at more than 80 variables, including geography and the types of books customers purchase, and selects three to five variables that are the most influential predictors. The Bookbinders Book Club The BBB Club was established in 1986 for the purpose of selling specialty books through direct marketing. BBBC is strictly a distributor and does not publish any of the books it sells. In anticipation of using database marketing, BBBC made a strategic decision right from the start to build and maintain a detailed database about its members containing all the relevant information about them. Readers fill out an insert and return it to BBBC which then enters the data into the database. The company currently has a database of 500,000 readers and sends out a mailing about once a month. BBBC is exploring whether to use predictive modeling approaches to improve the efficacy of its direct mail program. For a recent mailing, the company selected 20,000 customers in Pennsylvania, New York and Ohio from its database and included with their regular mailing a specially produced brochure for the book The Art History of Florence. This resulted in a 9.03 percent response rate (1806 orders) for the purchase of the book. BBBC then developed a database to calibrate a response model to identify the factors that influencedthese purchases.

For this case analysis, we will use a subset of the database available to BBBC. It consists of data for 400 customers who purchased the book, and 1,200 customers who did not, thereby over-representing the response group. The dependent variable for the analysis is Choice -- purchase or no purchase of The Art History of Florence. BBBC also selected several independent variables that it thought might explain the observed choice behavior. Below is a description of the variables used for the analysis: Choice: Whether the customer purchased the The Art History of Florence. 1 corresponds to a purchase and 0 corresponds to a non purchase. Gender: 0 = Female and 1 = Male. Amount purchased: Total money spent on BBBC books. Frequency: Total number of purchases in the chosen period (used as a proxy for frequency.) Last purchase (recency of purchase): Months since last purchase. First purchase: Months since first purchase. P_Child: Number of children's books purchased. P_Youth: Number of youth books purchased. P_Cook: Number of cookbooks purchased. P_DIY: Number of do-it-yourself books purchased. P_Art: Number of art books purchased. To assess the performance of the model, the data set includes a second sheet with 2300customers--a holdout sample representative of the entire target market. The use of such a validation sample is an appropriate way to compare alternative models.

Case study questions

Question #1 Which attributes are significant predictors of the customer purchasing from BBC (where do the model statistics show a positive stat)? Specifically, which books do we sell best? Question #2 Compare Amount purchased, Frequency, First and Last Purchase; what do you learn from those statistics? Question #3 Those "Probability 1" column show those predicted to buy from BBC. Using the excel with the cleaned up and sorted excel data, 400 accounts actually bought from BBC, but how many more accounts should we target and why? Question #4 What insights do you gain from the 400 that purchased from BBC using this predictivemodel?

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Calibration data Calibration data contains 1600 rows and 11 columns. It contains 10 predictors, to which we added an intercept. Gender Amount purchased Frequency Last purchase First purchase P_Child P_Youth P_Cook P P_DIY P_Art Average 0.6588 200.92 12.314 3.199 22.576 0.7394 0.3356 0.7600 0.3913 0.4250 Standard deviation 0.4743 95.30 7.841 3.027 16.233 1.0587 0.6241 1.0401 0.6799 0.7347 Median 1.0000 203.00 12.000 2.000 18.000 0.0000 0.0000 0.0000 0.0000 0.0000 Minimum 0.0000 15.00 2.000 1.000 2.000 0.0000 0.0000 0.0000 0.0000 0.0000 Maximum 1.0000 474.00 36.000 12.000 96.000 8.0000 4.0000 6.0000 4.0000 5.0000 Summary of predictors. These predictors have been used for model calibration. Alternative 0 Alternative 1 Count 1 200 400 Frequency 75.0% 25.0% Frequency table for observed choices. choice Gender Amount purchased Frequency Last purchase First purchase P_Child P_Youth P_Cook P_DIY P Art 1 1 113 8 8 O 2 418 6 11 66 0 N W 2 3 3 336 18 6 32 2 O 2 4 180 16 5 42 N O O 1 5 0 320 2 3 18 0 O O 2 268 4 1 4 0 O 0 0 0 7 198 2 12 62 N 3 N 2 O 280 6 2 12 O N o O 0 393 12 11 50 3 O w 0 2 10 138 10 7 38 2 0 0 0 1Model results Model statistics Model parameters reported here have been estimated on the entire calibration data. Parameters Standard deviations P-values Intercept -0.35 6885 0.2145547 0.0962 Gender -0.864347 0.1375527 0.0000 'Amount purchased' 0.001909 0.0007930 0.0161 Frequency -0.075 633 0.0166125 0.0000 'Last purchase' 0.621114 0.0940725 0.0000 'First purchase' -0.014785 0.0128135 0.2486 P_Child -0.825 05 8 0.1173410 0.0000 P_Youth -0.673193 0.1457117 0.0000 P_Cook 0929491 0.1193261 0.0000 P_DIY -0.910397 0.1435351 0.0000 P_Art 0.673635 0.1272759 0.0000 Model statistics. For indentication purpose, parameters for alternative 0 have been xed to 0. They are not reported here. P-values = probabilities that parameter estimates are different from zero only by chance. Confusion matrix and hit rate Model performance is assessed on the entire data used for model calibration. Predicted 0 Predicted 1 Total Actual 0 1121 79 1200 Actual 1 239 161 400 Total 1360 240 1600 Confusion matrix (count). The model has correctly classied 1282 of the 1600 observations. The off-diagonal elements are classication errors. Confusion matrix (count). The model has correctly classied 1282 of the 1600 observations. The o-diagonal elements are classication errors. Predicted 0 Predicted 1 Actual 0 93% 7% Actual 1 60% 40% Confusion matrix (%). The global hit rate of the model is 80%. The diagonal elements represent alternative- specic hit rates. Model predictions Prob. 0 Prob. 1 Predicted Actual Correct 1 86% 14% 0 1 no 2 26% 74% 1 1 yes 3 70% 30% 0 1 no 4 82% 18% 0 1 no 5 l 1 % 89% 1 1 yes 6 61% 39% 0 1 no 7 39% 61% 1 1 yes 8 64% 36% 0 1 no 9 3 1% 69% 1 1 yes 10 25% 75% 1 1 yes Model predictions (in-sample) (excerpt). Gain chart and lift A gain chart is a useful representation of how good a predictive model is at identifying the most likely responses. The x-axis represents the population ordered in decreasing order of choice likelihood, and the y-axis represents the actual choices. The diagonal represents A gain chart is a useful representation of how good a predictive model is at identifying the most likely responses. The x-axis represents the population ordered in decreasing order of choice likelihood, and the y-axis represents the actual choices. The diagonal represents a random selection process, and the red line the actual data. The model performance improves when the green line (representing the model) departs from random selection and approaches the truth. 100% - 75% - 50% - 25% - 0% 0% 25% 50% 75% 100' Gain chart . The gain chart represents how good the model is at recovering actual choices. Lift is defined as the improvement in selection performance at different levels. If by selecting the top 10% of individuals (ranked by their likelihood ofChoice sensitivity to predictors Elasticities Elasticity is the measurement of how responsive the choice of an alternative is to change in predictors. In other words, how would a change of 1% in one of the predcitors would impact the likelihood of chosing each alternative? When an elasticity is greater than 1, it indicates that the alternative responds more than proportionnally to changes in predictor, and the alternative is said to be 'elastic'. 0 1 Gender 0.09% -0.28% Amount purchased -0.07% 0.22% Frequency 0.14% -0.42% Last purchase -0.37% 1.11% First purchase 0.06% -0. 17% P_Child 0.10% -0.31% P_Youth 0.04% -0.12% P_Cook 0.12% -0.35% P_DIY 0.06% -0.18% P_Art -0.07% 0.20% Elasticities. Changes in the relative likelihood of chosing each alternative aer a 1% increase in the predictors. Elasticities larger than 1% are color-coded. Impact of changes in predictors Because elasticities are expressed in relative terms to a baseline, we report here the absolute changes in absolute probabilities of chasing each alternative after a 1% increase in each predictor. Impact of changes in predictors Because elasticities are expressed in relative terms to a baseline, we report here the absolute changes in absolute probabilities of chosing each alternative after a 1% increase in each predictor. Prob 0 Prob 1 Change in 0 Change in 1 Initial 0.75 0.25 N/A N/A Change in Gender 0.75 0.25 0.00069 000069 Change in Amount purchased 0.75 0.25 -0.00055 0.00055 Change in Frequency 0.75 0.25 0.00106 -0.00106 Change in Last purchase 0.75 0.25 -0.00277 0.00277 Change in First purchase 0.75 0.25 0.00042 -0.00042 Change in P_Child 0.75 0.25 0.00077 -0.00077 Change in P_Youth 0.75 0.25 0.00031 000031 Change in P_Cook 0.75 0.25 0.00087 000087 Change in P_DIY 0.75 0.25 0.00045 -0.00045 Change in P_Art 0.75 0.25 -0.00050 0.00050 Absolute changes. Changes in the absolute likelihood of chasing each alternative aer a 1% increase in the predictors

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials of Marketing Research

Authors: Barry J. Babin, William G. Zikmund

6th edition

9781305688094, 1305263472, 1305688090, 978-1305263475

More Books

Students also viewed these Marketing questions

Question

c. What were you expected to do when you grew up?

Answered: 1 week ago