Mon, 05/13/2013 - 08:13 - Mark Klein
As more marketers become aware that successful cross-sell requires knowing what products to offer to each individual customer, the question everyone now wants answered is “How do you do that?” If you send out individualized marketing campaigns emphasizing cross-sell, how do you determine what products to offer to each customer that they have not previously purchased?
A key part of the answer, the secret to cross-sell, is to build an affinities table similar to the one shown below.
|Predictor||Affinity||Score||Lift||Bought Both||Bought Predictor Only||Expected Buyers|
|Cell Phone & Accessories||Portable Audio||25.0%||1.609||2,316||1.737||434|
|Other Electronics||Portable Audio||24.0%||1.542||1,081||822||197|
|Kitchen & Dining Room||Small Kitchen Appliances||20.0%||3.04||6,000||4,799||960|
|Small Kitchen Appliances||Kitchen & Dining Room||8.1%||3.04||14,805||13,604||1,102|
An affinities table lists every product in your product set, and many are listed multiple times. For each targeted product (we call it the ‘affinity product’), there are ‘predictor products’: other products in the set whose purchase is an indicator of a future purchase of the affinity product.
Most affinity products have several predictor products, and the most accurate affinities tables consider baskets of predictor products. The simpler table shown here only considers two product combinations, not higher order affinities showing propensities for an affinity product when multiple predictor products are purchased. For each combination of affinity product and predictor product there is a metric (the ‘lift’) showing the relative effectiveness of the predictor product in inducing a sale of the affinity product.
Having an affinities table doesn’t completely solve the cross-sell problem. You still have to match the affinity products to what each customer has already purchased (these now become the predictor products) as part of the process of calculating a cross-sell score for a particular product for a particular customer, but having an affinities table makes that task much easier.
An affinities table also can make your website stronger. When a visitor clicks on a product, consider it the predictor product and use the table to find the corresponding affinity products to present next to the site visitor.
At Loyalty Builders, we consider affinities tables so essential that creating one is an important early step in our customer analytics program for every one of our customers. Don’t handicap your marketing program by not having an affinities table for your product set.