Cart Analysis

By understanding which products are bought together most frequently, you can optimize your upsells, cross-sales, and product promotions.

Triple Whale avatar
Written by Triple Whale
Updated over a week ago

Overview

The cart analysis report provides insights into the shopping behavior of customers. By analyzing shopping cart data, we identify what products are being bought together and reveal trends, patterns, and opportunities for improving the customer experience and optimizing conversions.

Understanding which products are often bought together will help you make important decisions such as:

  • Improve Product-Targeted Ad Strategy: Target other frequently purchased products with ads so that consumers can easily view and purchase them.

  • Launch New Product Bundles: Consider launching new bundling offers based on the groups of products most frequently bought together. Filter the report by product when interested in bundling of specific product/type.

  • Create a Bundled Promotion: Incentivize the consumer to add two or more of your products to their cart in order to earn a compelling discount.

  • Product Recommendations: Add recommendations to frequently bought products to get consumers to consider your product in affiliation with other items relevant to their purchase journey.

Getting Started

In this feature, we identify the combination of products that make up your highest volume of orders & revenue. The report will automatically calculate the combination of products, variants, or SKUs most frequently purchased together. These are combinations that share a cart non-exclusively (meaning to say, there may be other products in the order as well).

The report will display the top 10 combinations per the selected filters (sorted by # of Orders) and provide the following insights on each combination:

  • Orders: Number of orders which included these products (per filters)

  • Total sales: Total sales of these orders (per filters)
    Gross Sales - Discounts + Tax collected + Shipping collected
    (orders might include other products - we take the value of the whole order)

  • %Orders: The percentage of orders that included these products (per filters)

  • AOV: Total sales of all orders including these products / number of all orders including these products (per filters)

  • New orders: Number of new orders which include these products (per filters)

  • New sales: Sales of new orders which include these products (per filters)

  • Returning orders: Number of returning orders which include these products (per filters)

  • Returning sales: Sales of returning orders which include these products (per filters)

Further Options

You can click on any product combination and see the full list of products. For each product you can see the:

  • Image of the product

  • Name of the product

  • Carts - the % of all multiple-product carts (per filters) that include this product

  • Product orders -the % of this product’s orders (per filters) which include this combination

Customization

There are numerous options for how to slice and segment the data included within your Cart Analysis report.

  1. Time: First, select the date range you'd like to analyze. We will then look at all the orders that were made in the selected period.

  2. Product, SKU, or Variant: Determine what sort of cart groupings you'd like to analyze.

  3. Minimum Products: Set the minimum number of products to consider for the combinations. For example: if you set the minimum number of products to 4, we will display all combinations of at least 4 products that shared a cart.

  4. Free Products: Select whether you'd like to include or exclude $0 products from the Cart Analysis.

  5. Segments: By default, the analysis will be done on all customers who made a purchase in the selected time period. Selecting a specific customer segment enables you to analyze products frequently purchased together by that specific segment.

NOTE: New customer segments can be created in the SCDP.

Filters

You can also add filters to derive insights on how specific products, locations, or order forms are impacting the type of products that are bought together.

To create a filter, click on the filter icon and select Add/View Custom Filter.

For each category -- Orders, Products, and Customers -- you can add multiple filters. Here is a quick breakdown of the variables available per category:

  1. Orders

    1. source name

    2. order tag

    3. order price

    4. discount code

    5. order destination

    6. number of items

  2. Products

    1. product name

    2. product ID

    3. SKU

    4. variant

    5. variant ID

    6. product type

    7. product tag

    8. vendor

  3. Customers

    1. State

Once complete, click Apply. Your custom filter will be applied to the dataset, and saved for later use. Applied filters affect only the Cart Analysis page and will be reset at the end of the user session.

Excluded Orders

The report ignores the following types of orders:

  • Orders that contain more than 8 unique products

  • Deleted orders

  • Test orders

  • Orders with financial_status = voided

  • Orders that contain only a gift card

Save and Share Data

Once you have the data you want, you can simply export the table as a CSV or directly to a Google Sheet, so you can review the learnings with your team and keep a record of these reports.


Did this answer your question?