Shopping Basket Analysis

Customers tend to buy a number of items together or separately. Analyzing customer sales information can reveal valuable marketing information. Basket analysis is to determine what products customers are buying at the same time or at different times. It provides opportunities for cross-selling through relevant product recommendations. Product link analysis is to;

... find other products purchased most often along with a particular product?     

Product Purchasing Pattern Analysis

Customers tend to variety of products from the same businesses. Analyzing such information can reveal valuable business opportunities in various way. For example, the following is a summary table containing customer purchasing information. (Notice that this is not the same technique as "shopping basket analysis", also known as "association rules".)

customers Bag Books CDs Desktops Disks
customer 1 0 3 1 5 5
customer 2 0 2 1 0 5
customer 3 1 0 1 0 3
customer 4 4 2 0 1 0
customer 5 1 2 1 1 1
customer 6 1 0 2 0 4
customer 7 1 3 0 2 0
... ... ... ... ... ...

CMSR product association analysis tools can be used to extract buying patterns;

  • People buying "Books" tends to buy "CDs" products with 0.75 correlation and 67% buying.
  • People buying "Handbags" tends to buy "Purse" products with 0.15 correlation and 10% buying.
  • and so on!

Product Purchasing Pattern Analysis.

Cells in red color indicate that there is positive relationship between two products. That is, when customers buy one product, they tend to buy the other product as well. Cells in blue color indicate the opposite. When customers buy one product, they tend to not buy the other product. Brightness of cells indicates the relative strength of relationships.

* Basket analysis is a feature of CMSR Data Miner. Download is available from CMSR Data Mining Software.