Data & Analytics

How to prove a local partner rewards exchange will lift basket size by 10% using till data and three experiments

How to prove a local partner rewards exchange will lift basket size by 10% using till data and three experiments

I was recently asked by a small retail chain if a proposed rewards exchange with a local partner — a café offering a free pastry for every £10 spent in store — would actually increase basket size by 10%. The ask felt familiar: founders want a simple, defensible projection before they commit to the operational work and margin trade-offs. The good news is you can prove (or disprove) this with tills and three tightly scoped experiments. Below I walk through a pragmatic, data-first approach I use with SMEs: what to measure, how to run the tests, and how to interpret results so you can make a confident decision.

Why till data is the right source

Till (POS) data is often under-used. It records real transactions with timestamps, SKUs, prices, discounts and — crucially — basket-level detail. That makes it ideal for measuring change in average basket value (ABV) and product mix after introducing a rewards exchange. Compared to surveys or loyalty-app click data, tills tell you what customers actually bought and paid for.

Before any experiment, I always check three things in the till feed:

  • Does each transaction have a unique basket ID and timestamp?
  • Are SKUs and prices consistent (no shifting codes) so you can track product categories)?
  • Can you tag transactions by store and by channel (in-store vs. click & collect)?
  • Define the metric and the causal window

    Be precise: the primary metric is average basket value (ABV) per transaction. Secondary metrics include items per basket, incidence of higher-margin SKUs and redemption rate of the partner reward. You want to detect a 10% lift in ABV. That means if baseline ABV is £30, target ABV becomes £33.

    Decide on the causal window — the period after a customer becomes eligible for the partner reward where you expect behaviour to change. For a local partner pastry reward this is often short: same-day or next-visit behaviour, and up to 30 days. Keep the test windows consistent across experiments.

    Experiment 1 — A/B test at till: control vs. partner offer messaging

    Goal: measure the immediate impact of presenting a partner reward to customers at point-of-sale.

    Design:

  • Randomly split till terminals (or time blocks) into control and treatment for 4 weeks.
  • Control: standard receipt/loyalty message.
  • Treatment: receipt and terminal prompt stating “Spend £10 today, get a free pastry at Café X — today's purchase qualifies.”
  • Why this works: it isolates the effect of the communication and urgency (today’s purchase) without yet delivering the redemption mechanics.

    What to measure:

  • ABV per transaction in treatment vs control.
  • Proportion of transactions >= £10.
  • Items per basket and average price per item.
  • Sample size note: use power calculations or a simple rule of thumb — you’ll typically need several hundred transactions per group to detect a 10% change depending on baseline variance. If sample is small, extend test duration or expand stores.

    Experiment 2 — Redemption-enabled pilot: coupons issued at till

    Goal: measure behavioural lift when customers receive a redeemable coupon for the partner (actual incentive unlocked).

    Design:

  • At treatment tills, issue a printed or SMS coupon automatically for customers whose transaction exceeds the threshold (£10). Include unique coupon IDs so you can track redemptions back to original transactions.
  • Control still receives no coupon. Run for 6–8 weeks to capture both issuance and redemption windows.
  • What to measure:

  • Redemption rate of coupons at partner (link partner POS or a simple manual count back to coupon IDs).
  • ABV of customers who received coupons vs. those who didn't.
  • ABV on the customer’s next visit (if you can link customers via loyalty IDs or phone numbers) — this helps measure repeat visitation impact.
  • Interpretation: If ABV in treatment increases by 10% immediately, but redemption is zero, you’ve induced higher spend through messaging. If ABV doesn’t rise but redemption occurs heavily, the program may drive partner footfall without moving your basket size.

    Experiment 3 — Partner co-promotion cross-check (reciprocal tracking)

    Goal: capture the two-way effect: does the partner reward drive higher basket value at your store when redeemed, and what is the net lift across both businesses?

    Design:

  • Work with the café (or local partner) to record which of your issued coupons are redeemed and, crucially, capture whether redeemers subsequently visit your store within a set window (7–30 days).
  • Run a matched-pair analysis: compare ABV for customers who received a coupon and redeemed it vs. a matched control group (same store, same weekday, similar baseline ABV) who didn’t receive a coupon.
  • What to measure:

  • Incremental ABV for return visits tied to redemption.
  • Net promoter metrics if available (simple exit survey at partner or follow-up email).
  • Cross-shop conversion rate: proportion of partner redeemers who come back to your store and their ABV.
  • This experiment tests the full exchange lifecycle: issuance → redemption → return behaviour. It’s the most realistic test of whether the partner exchange creates sustained additional spend, not just a one-off pastry pickup.

    Practical analysis steps using your till data

    Once experiments are complete, follow this analysis flow:

  • Clean the data: remove refunds, test transactions, extreme outliers (very large orders from wholesale). Ensure timestamps and SKUs are normalized.
  • Compute baseline ABV per store and overall for the pre-test period (4–8 weeks).
  • Calculate ABV per group (control vs treatment) and ABV for cohorts (coupon issued, coupon redeemed, non-redeemed).
  • Run statistical tests: a t-test or non-parametric Mann–Whitney test on ABV between groups. For proportions (e.g. share of baskets ≥ £10) use chi-square or proportion z-test.
  • Estimate confidence intervals for lift and check whether a 10% lift is within the interval. If the 95% CI excludes +10%, you don’t have evidence of the desired lift.
  • Fast ROI modelling

    Two numbers matter: gross incremental revenue and cost of the partnership (discount cost + administration).

    MetricHow to calculate
    Incremental revenue per transaction(ABV_treatment − ABV_control)
    Incremental transactionsChange in number of qualifying baskets or repeat visits tied to coupon redemptions
    Redemption costAverage cost to you per redemption (if you're subsidising partner item) × redemption rate
    Net margin impactIncremental revenue × gross margin − redemption cost − admin

    Run scenarios: conservative (low redemption, small ABV lift), expected, and optimistic. I often model payback period in weeks — how long until the incremental margin covers set-up and promo costs.

    Pitfalls and how to avoid them

    Common mistakes I see:

  • Not randomising properly — terminals or time blocks that correlate with busier periods bias results. Randomise at the customer or terminal level when possible.
  • Short test windows — you might miss delayed effects if customers redeem after two weeks. Align windows with realistic redemption behaviour.
  • Not tracking redemption at partner — you must be able to tie return visits to coupon redemptions, otherwise attribution breaks down.
  • Ignoring product mix — a 10% ABV lift could come from more low-margin SKUs. Break down results by category.
  • Example outcome I’ve seen

    In one pilot with a regional grocer and a bakery partner, the A/B messaging test produced a 4% ABV lift. Issued coupons led to a 22% redemption rate and redeemers returned within 10 days, delivering an additional 12% ABV on their return visit. Net of the bakery subsidy (a £0.80 pastry cost) and admin, the program delivered a 6% uplift in incremental margin initially — short of the 10% target. But after adjusting the threshold and promoting higher-margin add-ons at till, the retailer hit the 10% ABV lift in a follow-up test.

    If you want, I can draft a tailored experiment plan for your till system, including sample size estimates and a reporting dashboard template you can drop into Excel or Google Sheets. That’s the fastest way to move from “it feels like it should work” to “here’s the evidence and the ROI”.

    You should also check the following news:

    Which microreward trigger lifts month-two retention most: push notifications, surprise credits or free samples
    Customer Retention

    Which microreward trigger lifts month-two retention most: push notifications, surprise credits or free samples

    I ran a small experiment last year to answer a simple question: which microreward trigger moves the...

    Sep 06 Read more...
    What parents should know about french schools
    Loyalty Programs

    What parents should know about french schools

    For many parents, sending a child to school in France can feel both exciting and unfamiliar. The...

    Aug 18 Read more...