FinDaS AI

Market basket analysis

Which products sell together, and what are they worth?

Market basket analysis of an online coffee shop’s orders: which products sell together more often than chance, whether each pair holds in later months, and what offering it is worth.

What sells together, and what offering it is worth

Offers worth a month

€3,495

Extra margin from one offer per product, each picked for margin among the 38 offers that held in the test months. Picked for lift instead: €2,619.

Strongest pair

12.1 times

An order with an espresso machine holds a milk jug 12.1 times as often as the average order: 903 of the 109,172 orders of October 2025 to June 2026.

Pairs above chance

102 of 190

Pairs of the 20 products in at least 546 orders that share an order more often than chance.

Offers that held

38 of 204

Offers whose buyers went on to buy the second product in July to September 2026 more often than other customers, by more than chance explains.

The strongest pairs, and what offering them is worth a month

Ranked by lift, October 2025 to June 2026; bars on one scale, the longest €1,365. Each figure is the better of the pair’s two offers, at a take-up of a shown offer of 20% of the pair’s take-up above chance.

Slice it, filter it, drill into any pair

20% of the pair’s take-up above chance
546 orders (0.5% of the 109,172)
No minimum
1.0: no more often than chance

Margin a sale, as a share of the price: coffee 45%, brewing 40%, espresso 30%, tea 55%, cups and care 50%.

Orders
109,172
Pairs that pass
102 of 190
Offers that held
38 of 204
Offers worth a month
€3,495

How the products connect

Circle: the product’s salesLink: the higher the lift, the thickerThe product picked
102 links, the pairs that pass the filters. Pick a name or a circle to drill into it; for a pair, pick its cell in the heat map.

Lift for every pair

above 1 to 1.251.25 to 1.51.5 to 22 to 4above 4Filtered outHeld in the test months
Row: the product in the order. Column: the product offered. Pick a cell for its pair.

What sells with a pour-over dripper

Strongest partner

Paper filters (pack of 100)

Lift 4.2, €71 a month

Most margin a month

Gooseneck kettle

€339 a month, lift 3.9

Take-up of each partner, the 6 strongest

Orders holding the productAll orders
Paper filters (pack of 100)53.3% against 12.6%, lift 4.2
Gooseneck kettle16.2% against 4.2%, lift 3.9
Travel mug7.6% against 5.4%, lift 1.4
Mugs, set of two6.7% against 5.3%, lift 1.3
French press8.3% against 6.7%, lift 1.2
Decaf beans, 250 g12.6% against 10.5%, lift 1.2
12 partners pass the filters; 6 more go with it above chance and are filtered out.

Pour-over dripper → Paper filters (pack of 100)

Orders together
4,476 of 109,172
Support
4.1%
Take-up
53.3% of the orders holding a pour-over dripper
Take-up the other way
32.6% of the orders holding paper filters
Lift
4.2: 53.3% ÷ 12.6%
New and returning
1,339 + 3,137 = 4,476
Mined and test months
4,476 and 1,523

Same order, test months. In the test months, July to September 2026, 1,523 orders hold both, where chance predicts 343: a lift of 4.4, 68.0 standard deviations above chance. The pair holds.

Bought later. Of the customers who ordered in both periods without paper filters by June, those who had bought a pour-over dripper went on to buy paper filters at 25.6%, against 17.5% of all of them: 7.3 standard deviations above what chance predicts. The offer holds.

Worth. 436 orders a month hold a pour-over dripper without paper filters. Take-up is 53.3% against 12.6% of all orders, 40.7 points above chance; at 20% of that, 8.1% take a shown offer, at €2.00 margin each: €16 per 100 offers, €71 a month.

A sample of the orders holding both, order numbers invented
OrderMonthCustomerBasketTotal
2510-13335Oct 2025New, first orderPour-over dripper €22, Paper filters (pack of 100) €5€27
2512-50906Dec 2025New, first orderEspresso beans, 1 kg €24, Pour-over dripper €22, Paper filters (pack of 100) €5, French press €29€80
2512-69419Dec 2025New, first orderPour-over dripper €22, Paper filters (pack of 100) €5€27
2602-39862Feb 2026ReturningPour-over dripper €22, Paper filters (pack of 100) €5€27
2606-55966Jun 2026ReturningPour-over dripper €22, Paper filters (pack of 100) €5€27
2606-27312Jun 2026ReturningPour-over dripper €22, Paper filters (pack of 100) €5, Cleaning brushes €7€34

Every rule that passes the filters

The first 25 of the 204 rules that pass, October 2025 to June 2026, by lift, highest first
Espresso machine9030.8%34.3%12.1€26Holds
Milk jug9030.8%29.2%12.1€561Holds
Espresso machine7300.7%27.7%11.3€14Holds
Descaling tablets7300.7%27.3%11.3€520Does not hold
Teapot1,5831.5%41.9%10.1€25Holds
Tea infuser1,5831.5%34.9%10.1€118Holds
Pour-over dripper4,4764.1%53.3%4.2€16Holds
Paper filters (pack of 100)4,4764.1%32.6%4.2€44Does not hold
Gooseneck kettle1,3601.2%30.0%3.9€39Holds
Pour-over dripper1,3601.2%16.2%3.9€43Holds
Gooseneck kettle1,1951.1%26.4%2.1€6Holds
Paper filters (pack of 100)1,1951.1%8.7%2.1€16Does not hold
Descaling tablets1,0681.0%39.9%1.6€31Holds
Espresso beans, 1 kg1,0681.0%3.9%1.6€1Holds
Coffee scale7240.7%18.8%1.5€2Holds
Paper filters (pack of 100)7240.7%5.3%1.5€4Holds
Milk jug1,1091.0%35.9%1.4€23Holds
Espresso beans, 1 kg1,1091.0%4.0%1.4€1Holds
Teapot9900.9%26.2%1.4€7Does not hold
Green tea, 100 g9900.9%4.9%1.4€5Holds
Travel mug6390.6%10.8%1.4€6Does not hold
Pour-over dripper6390.6%7.6%1.4€4Does not hold
Teapot9730.9%25.8%1.4€6Does not hold
Black tea, 100 g9730.9%4.8%1.4€5Holds
Tea infuser1,1481.1%25.3%1.4€5Holds

What the offers are worth a month

Each offer picked for margin

€3,495

A month, from one offer per product.

Each offer picked for lift

€2,619

A month, from the same offers that held.

Offers priced

38 of 204

Rules that pass the filters and held in the test months.

One offer per product, each the priced offer with the most margin a month, beside the one with the highest lift
Product in the orderOffer, most marginLiftOffers a monthTake-up of a shown offerMargin a saleA monthOffer, highest liftA month
Espresso beans, 1 kgEspresso machine1.32,9730.2%€104.70€522Descaling tablets€22
Filter beans, 500 gGooseneck kettle1.23,4800.2%€18.00€110Paper filters (pack of 100)€46
Ground coffee, 500 gNone held€0None held€0
Decaf beans, 250 gCleaning brushes1.41,1800.4%€3.50€17Cleaning brushes€17
Pour-over dripperGooseneck kettle3.97832.4%€18.00€339Paper filters (pack of 100)€71
Paper filters (pack of 100)Filter beans, 500 g1.39261.8%€5.85€98Coffee scale€63
Gooseneck kettlePour-over dripper3.93524.5%€8.80€138Pour-over dripper€138
Burr grinderFilter beans, 500 g1.32972.0%€5.85€35Filter beans, 500 g€35
French pressPour-over dripper1.27380.4%€8.80€24Pour-over dripper€24
Espresso machineMilk jug12.11926.3%€4.20€51Milk jug€51
Milk jugEspresso machine12.12435.4%€104.70€1,365Espresso machine€1,365
Descaling tabletsEspresso beans, 1 kg1.61792.9%€10.80€56Espresso beans, 1 kg€56
Green tea, 100 gTeapot1.42,1430.3%€18.70€114Teapot€114
Black tea, 100 gTeapot1.42,1310.3%€18.70€109Teapot€109
Tea infuserTeapot10.13286.3%€18.70€386Teapot€386
TeapotTea infuser10.12437.6%€3.30€61Tea infuser€61
Mugs, set of twoDecaf beans, 250 g1.25630.4%€3.60€8Decaf beans, 250 g€8
Travel mugEspresso beans, 1 kg1.14650.7%€10.80€37Espresso beans, 1 kg€37
Coffee scalePaper filters (pack of 100)1.53491.2%€2.00€9Paper filters (pack of 100)€9
Cleaning brushesBlack tea, 100 g1.25420.7%€3.85€16Paper filters (pack of 100)€7
Total€3,495€2,619

What the analysis found

  • Three kits make the five strongest pairs: an espresso machine with a milk jug and with descaling tablets, a teapot with a tea infuser, and a pour-over dripper with paper filters and with a gooseneck kettle.
  • The money is in a few offers. Three bring 65% of the €3,495 a month: an espresso machine offered with a milk jug, €1,365; an espresso machine offered with espresso beans, €522; a teapot offered with a tea infuser, €386.
  • Selling together is not the same as buying next. Paper filters and a dripper share an order 4.2 times as often as chance, yet customers who had bought filters went on to buy a dripper less often than other customers, 11.1% against 15.4%: most already own one. An offer goes to orders without the second product, so only offers that held this test are priced.
  • New customers buy the kit. In a new customer’s first order a dripper and paper filters go together at a lift of 5.2, against 4.1 in returning customers’ orders.

How it works

  1. 01

    Orders

    109,172 orders, October 2025 to June 2026. Each is a customer, a month and the products in it.

  2. 02

    Baskets

    Each order becomes the set of products in it. Quantities and prices drop out.

  3. 03

    Pair counts

    Count the orders holding each product and each pair: 4,476 of the 8,403 orders holding a dripper hold filters.

  4. 04

    Support, take-up, lift

    Support: share of all orders holding both
    4,476 ÷ 109,172 = 4.1%
    Take-up: share of dripper orders holding filters
    4,476 ÷ 8,403 = 53.3%
    Lift: take-up over filters’ share of all orders
    53.3% ÷ 12.6% = 4.2

    Above 1, the pair shares an order more often than chance. The filters drop pairs in too few orders, taken up too rarely, or too weak.

  5. 05

    The test months

    Rules mined on October 2025 to June 2026 are tested on July to September 2026: customers who had bought a dripper went on to buy filters more often, by 7.3 standard deviations. The rule holds.

The slices. The shop’s 45,607 customers place about 12,100 orders a month, at an average of €39.99. The rules are mined on the nine months from October 2025 to June 2026; the test months, July to September 2026, are held out. A new customer’s first order is the order in the month they first ordered; every other order is a returning customer’s, and the two add up to all orders. A category keeps the rules whose first product is in it.

Two tests on the months held out. The same-order test asks whether the pair still shares an order more often than chance in July to September 2026, by at least two standard deviations. The later test, the example analysis’s, asks whether customers who had bought the first product by June went on to buy the second more often than all customers who ordered in both periods and had not bought it yet. An offer “holds” when it passes the later test, because an offer goes to a customer who does not have the second product.

How the money is worked out. An offer goes to the orders that hold the first product and not the second: 783 orders a month hold a pour-over dripper without a gooseneck kettle. 16.2% of the orders holding a dripper hold a kettle, against 4.2% of all orders: 12.0 points above chance. The shop made no offers, so how many customers take one is an assumption, set with the slider: here 20% of those points, 2.4% of the orders shown it. At €18.00 margin a sale, that is €339 a month. Paper filters, the dripper’s strongest partner, earn €71: lift picks what belongs with a dripper, margin picks what pays beside it.

What this does not show. Which offers cause a sale. Every purchase in these orders was unprompted, so a customer who buys filters with a dripper does so without an offer, and a discount to them gives margin away. We recommend testing the priced offers with a random half of their customers left without them; the example analysis sizes that test. The prices and margins are the year’s; a new range or a price change calls for mining the rules again.

The full analysis, with the next offer for each of the shop’s main products and the test that would measure what an offer adds: which product to offer next, a market basket analysis.

Start here

Want to know what sells together in your own orders?

Up to thirty minutes on your question and your order data, then a fixed proposal.

Book a free call