Market Basket & Co-Purchase Analysis Narrator
Turn pasted basket data into clear merchandising and bundling calls.
What is the Market Basket & Co-Purchase Analysis Narrator?
The Market Basket & Co-Purchase Analysis Narrator is a free AI skill that turns market basket data you already have into a plain-language read on what food and beverage shoppers buy together in the same trip. You paste in your basket or co-purchase data — a retailer extract, a loyalty-panel pull, or a rough list of item pairs — along with your product and category; it returns the strongest same-basket pairings, the shopper mission each likely reflects, and what the pattern implies for bundling, secondary placement, and promotional pairing. It is built for shopper marketing and category teams whose co-purchase data sits unread, with no time to turn it into a narrative a merchandising team can act on. Because every pairing is checked against the data you pasted, the read holds up when a buyer asks where a claim came from. It flags thin evidence as a gap. Pairing the pattern with live food and beverage demand data helps confirm whether it reflects a lasting habit or a short-term blip.
Who it's for
- Shopper marketing managers turning basket data into merchandising action
- Category insights analysts narrating co-purchase patterns for a review
- Trade marketing managers building a bundling or pairing pitch
- E-commerce merchandising leads spotting cross-sell pairs from order data
What you get
- The strongest same-trip item pairings from your pasted data
- The likely shopper mission behind each pairing
- Bundling and multi-buy ideas the pattern supports
- Secondary-placement and cross-merchandising implications
- A confidence read per pairing, tied to the data provided
- A flag on pairings that need more data before you act
How to use it
- 1Paste the prompt into ChatGPT, Claude or Gemini.
- 2Paste your basket or co-purchase data into the brackets.
- 3Answer its clarifying questions about the data's source and period.
- 4Ask it to turn the top pairing into a bundling or display pitch.
See it in action
Example input
Pasting 8 weeks of basket-level data from fictional 'Heirloom Grocer' loyalty program for our fictional 'Bramblefield' pasta sauce line. Across roughly 4,200 baskets containing our marinara, the top co-purchased items are dry pasta (61% of baskets), garlic bread (34%), parmesan (29%), and ground beef (22%). We want to know what this means for shelf and promotion.
Example output
Basket co-purchase read — Bramblefield marinara, Heirloom Grocer, 8-week loyalty data Headline: this basket is telling a "weeknight dinner build" story, not a "condiment" story. Four items appear across a huge share of your marinara baskets, and they stack into a coherent meal rather than four unrelated impulse adds — that is the strongest signal in this data. Ranked pairings 1. Dry pasta — 61% of baskets This is close to a default pairing, which is expected but still worth stating plainly: more than six in ten Bramblefield marinara trips already include pasta in the same basket. The shopper mission is straightforward meal assembly, not discovery. Because the rate is this high, the marginal upside of a chip-and-salsa-style co-display is lower than it looks — most of this pairing is already happening without your help. The bigger opportunity is basket size, not basket creation: a bundle here should aim to add a third item, not just confirm a pairing shoppers already complete on their own. 2. Garlic bread — 34% of baskets A third of marinara baskets add garlic bread, which is a strong enough rate to treat as a real pairing rather than noise, but well below the pasta rate — meaning two-thirds of your shoppers are completing a marinara-and-pasta dinner without a bread side. That gap is the opportunity: a garlic bread cross-merchandising push isn't chasing an already-saturated pairing, it's recruiting the majority of baskets that currently skip it. Treat 34% as the baseline to beat, not the ceiling. 3. Parmesan — 29% of baskets Close behind garlic bread and likely correlated with it in the same baskets — worth checking in your raw data whether parmesan and garlic bread tend to appear together or represent two distinct shopper segments (one finishing with cheese, one finishing with bread). This distinction changes whether you build one three-way bundle or two separate two-way pairings. Flagging this as a question the pasted summary can't answer on its own; it needs a basket-level cross-tab, not just individual pair rates. 4. Ground beef — 22% of baskets The smallest of the four, but the most meal-transforming — beef converts a marinara-and-pasta side dish into a full meat-sauce dinner. Lower incidence likely reflects a real behavioral split between vegetarian-leaning marinara occasions and meat-sauce occasions rather than pure under-merchandising, so treat this pairing as a distinct occasion to target on its own rather than folding it into a single generic bundle. Assumption to validate: whether the 22% is stable across weeks or concentrated in one segment of shoppers. Merchandising and bundling implications - Lead cross-merchandising investment with garlic bread, not pasta. Pasta's pairing rate is already near its ceiling; garlic bread has the largest gap between current pairing rate and plausible upside. - Consider a three-item "dinner build" secondary display — marinara, pasta, garlic bread — sized to the 34% rate as a realistic lift target, not the 61% pasta rate. - Treat ground beef as a separate "hearty dinner" occasion, potentially a distinct end-cap or shelf-talker theme rather than folded into the default bundle, since it likely reflects a different shopper intent from the start of the trip. - Hold parmesan for a follow-up cut of the data before building a display around it — its overlap with garlic bread needs to be confirmed first. What this data can't tell us Whether these pairings are incremental (the shopper wouldn't have bought pasta anyway) or simply confirm a trip that was already planned. Basket co-occurrence shows what sits in the cart together, not causality. A short in-store test — running the garlic bread cross-merchandise for four weeks and comparing the pairing rate against this baseline — would confirm whether display actually lifts the rate or just makes visible what shoppers were already doing. Want me to draft the sell-in case for the garlic bread secondary display using this data?
The prompt
Here's the start of the prompt. Download the free bundle for the full, ready-to-paste version — plus the installable Claude Skill and Custom-GPT instructions.
# Role You are a senior shopper insights analyst who specializes in market basket analysis for food and beverage brands. You work strictly from the co-purchase data provided, narrating what it shows rather than what category logic assumes it should show. # Context I'll provide - My product and category: [PRODUCT + CATEGORY] - Basket or co-purchase data, pasted as text: [PASTE BASKET DATA — item pairs, co-purchase rates, or a basket extract] - Data source and period: [SOURCE + PERIOD e.g. loyalty panel, retailer extract, 8 weeks] - Retailer or channel (optional): [RETAILER] - What I'm deciding (optional): [DECISION e.g. secondary display, bundle, promo pairing] # Your task 1. If the basket data, product, or category context is missing or too thin to analyze, ask up to 3 clarifying questions BEFORE writing anything.
Frequently asked questions
- What is market basket analysis in food and beverage retail?
- Market basket analysis looks at which items appear together in the same shopping trip — same receipt, same basket — to find real co-purchase patterns rather than assumed ones. This skill takes basket or co-purchase data you already have, ranks the strongest same-trip pairings, and narrates what each implies for bundling, secondary placement, and cross-merchandising, so the data turns into an action a merchandising or sales team can use.
- How is this different from the Cross-Merchandising Opportunity Finder skill?
- The Cross-Merchandising Opportunity Finder starts from your product and occasion and generates candidate adjacent-category pairing ideas from shopper-mission logic, even when you have no basket data yet. This skill starts from data: you paste in actual basket or co-purchase numbers, and it narrates what your shoppers are already buying together in the same trip, ranked by evidence rather than generated from category reasoning. Use the finder when you're exploring ideas; use this when you have the data and need it explained.
- Which AI models can run this prompt?
- Any capable chat model — ChatGPT, Claude, or Google Gemini. The prompt is model-agnostic and works by pasting your basket data directly into the chat; models with larger context windows handle bigger data pulls more smoothly, but the analysis structure is identical everywhere. Many teams save it as a reusable skill so every basket-data review follows the same format.
- What kind of basket data does this need?
- Anything from a full loyalty-panel extract to a rough list of item pairs and their co-purchase rates works — the more baskets behind each number, the more confident the read. If your data is thin or covers a short window, say so in your inputs; the skill will flag low-confidence pairings rather than presenting a small sample as a reliable pattern.
Related skills
Coupon & Offer Mechanic Designer
Design the right offer mechanic and the psychology behind it.
Get it freeCross-Shop & Basket Affinity Analyzer
Map which brands and categories your shoppers also buy over time.
Get it freeDigital Coupon & Rebate App Campaign Brief
Brief a cash-back rebate app offer from submission through redemption tracking.
Get it freeWant the live data behind sharper outputs?
These skills get better with real-time F&B intelligence. See what Tastewise can do for your team.