Shopping Basket Analysis

📢 Tatvic is now a global partner of Usercentrics, world’s leading consent management platform

Shopping Basket Analysis

Last Updated:


Ever since the computerization of point-of-sale systems, retailers have been collecting vast amounts of customer purchasing and behavior data. The problem is how to make sense of it all. Traditional reports don’t reveal much of the information but the challenge is to take it one step further – to identify relationships between products. This problem is equally applicable to online era as well where there is need to know how one product is behaving with respect to other product. Whether these two products are complementary in nature and are they purchased together?
Basket Analysis
We felt this need and tried to solve this problem at a very basic level out of which is simple 2 by 2 chart of top 20 products of a clothing client. We extracted the transaction data to find out the probability of two or more products being purchased simultaneously in a single transaction. We used Tatvic GA Excel Plugin and some pure excel functions to extract the data. Below are the findings of data that we analyzed:

Data Analysis and Findings
Data Analysis and Findings

Through careful analysis we realized that:

  1. In 10% transactions of product “A”, product “B” was also purchased.
  2. In 17% transactions of product “F”, product “I” was also purchased followed by 12% transactions having product “S”.
  3. In approximately 5% transactions of product “I”, products R and S were also purchased.
  4. In 11% transactions of product “P” product “Q” was also purchased.
  5. Red circles in the diagram show hot zones where maximum slot of transactions happen and should be our focus.


Above insights can be used to decide optimum promotion and pricing strategies like:

  1. Ensuring that products being purchased in combination are on same page side by side.
  2. Highlighting those products on top landing pages of site.
  3. Providing discount in form of shipping benefits to group of products giving higher average order value.
  4. Finding out single product transactions and tie those products to moving items at discounted rate.

There is a whitepaper “Product Purchase Pattern Analysis” which covers this article in comprehensive manner.
Stay tuned for second part of shopping basket analysis where you can analyze up to 50 products and their purchase data based on affinity rules.

Picture of Riddhi Mehta

Riddhi Mehta

Riddhi is an experienced User Experience Designer with a demonstrated history of working in the information technology and services industry. Skilled in Prototyping, Concept Development, Design Thinking, User Experience Design, and Web Design, she has a bachelors in Product Design and a Masters in Communication Design.

Sign up for
our monthly newsletter

This field is for validation purposes and should be left unchanged.

Other Blog

Scroll to Top

Leverage Tatvic's comprehensive approach to 

Enquire Now

This field is for validation purposes and should be left unchanged.

Leverage Tatvic's comprehensive approach to 

Contact Us

This field is for validation purposes and should be left unchanged.