Privacy
Policy
|
|
Market basket analysis
Significant increases in cross-sell revenues can be achieved by using knowledge of customer purchasing habits such as:
-
Which combinations are products bought in?
- When they are
purchased?
- What sequence they
are purchased in?
- Is there a variation
dependent on customer profile?
Developing this understanding enables businesses to promote their most profitable products and encourage customers to buy items that might have otherwise been overlooked or missed.
Obvious examples of this are large retailers who store huge volumes of consumer sales, each basket being tracked by individual loyalty
cards or store credit cards.
Similarly, when you place an order on Amazon, a list of potentially interesting products (based on a profile of what other "similar" customers have ordered) is presented. They too are seeking ways to encourage the purchase of additional relevant items and thereby increase average basket value.
Beer and nappies - Know the story?
Skip
The often cited (and some say apocryphal) example of what can be achieved is the case of Wal-Mart, a huge US retail chain (owners of Asda in the UK) - an observant store manager discovered a strong association for many customers between a brand of
disposable nappies (diapers) and sales of beer.
Analysis of purchases revealed that they were made by men, on Friday evenings mainly between 6pm and 7pm. After some serious thinking, the supermarket figured out the rationale was that
mothers, realising they did not have enough stock for baby over the
weekend, asked their husbands to pick some up on the way home from the
office. The husband, wanting to make the diversion to the supermarket of
value to him decides to get some beer in for the weekend.
What did the supermarket do as a consequence?
They put the premium priced beer display next to the diapers. The result was that the fathers
buying diapers and who also usually bought beer now bought the premium beer (the up-sell), as it
was so conveniently located (they would have to go off into another part
of the store to find the regular beer).
Significantly, the men that did not buy beer before began to purchase it when it was so visible and handy - just next to the nappies (the cross-sell). Beer sales skyrocketed.
How to quantify the value of market basket analysis
This type of analysis is certainly not the exclusive domain of the supermarkets. If a company can identify a customer as having purchased a product then market basket analysis can deliver cross-sale opportunities.
Identifying high volume combinations of products
For each customer, you need to compare all items in a basket with all other items in the same basket and then count the number of times each combination exists for the period under consideration e.g. 18 months.
Exclude:
-
Multiple purchase of the same product
-
Non-products e.g. postage, delivery charges, VAT, etc
Establishing the potential
The results from above can then be sorted to reveal the highest number of purchases or a specific combination.
Now identify for each high volume combination the number of customers that bought only one of the products.
Compare these two result sets to establish where there is a strong propensity to purchase a specific product combination and there is a demonstrable market for its promotion to other customers i.e. customers who purchased one product but not the other (see diagram above).
Using the results
The above provides details of the techniques involved, but you should also take into consideration:
We have helped a number of companies increase their cross-sell potential by using market basket analysis, it is a powerful technique and can generate significant increases in sales.
If you would like to understand more about how market basket analysis could be applied to your business, then
arrange for a free
consultation. |
|
Read Michael Collins's article:
Direction
for profitability from understanding your data
©Database
Marketing Counsel, 1998-2004. All rights reserved.
|