Industry: Retail
Product: ModelRisk
Application: Customer Behavior Analysis

The Average Shopper Spends $139 a Quarter — and Almost No One Is Average

A retailer's CRM dashboard reports an average customer spend of $139 per quarter and treats it as a planning constant: multiply by the active base, get the revenue line. But when a multinational chain rebuilt its shopper analytics in ModelRisk — modeling purchase frequency as a Poisson process and basket value as a Gamma distribution at the level of the individual shopper — the average turned out to describe almost no one. The median shopper spends $98, the top-decile shopper $339 (P90), the top-percentile shopper $653 (P99), and 22% of shoppers buy nothing at all in a given quarter. The top decile alone accounts for 34% of total spend. Planning to the $139 average over-serves the silent majority and under-invests in the few shoppers who actually carry the revenue.

This is individual-level analytics — the unit is one shopper, the question is RFM and next-purchase — distinct from any category-level demand or pricing question. It feeds two decisions: how much a given shopper is worth, and whether they are still a customer at all.

Why a point estimate fails

A single average spend collapses two very different sources of variation. Frequency is a count — a shopper makes 0, 1, 2, 3... visits in a quarter, drawn Poisson around a per-shopper rate that is itself spread across the base (Gamma heterogeneity, mean 2.4 visits), so light and heavy shoppers coexist. Basket value is a positive, right-skewed amount (Gamma, mean $58) that varies visit to visit. Multiply a skewed frequency by a skewed basket and the result is sharply skewed with a fat right tail and a 22% spike at zero. A mean cannot represent a distribution with a point mass at zero and a long tail simultaneously. To stop the customer-base total from averaging away to a deterministic point, a single shared store/season factor multiplies every shopper's rate in a given quarter — a slow quarter is slow for everyone at once, so the base total keeps a real spread.

Is the shopper even still active?

A customer who has not visited in a while may be between trips — or may have quietly churned. A buy-till-you-die model resolves the ambiguity: each quarter a shopper "drops out" with probability 10%, and the longer the silence, the more it tilts toward churn. The probability a shopper is still active given their recency depends sharply on how often they used to buy.

• After 1 quarter of silence: a light shopper is 73% likely active, a typical shopper 45%, a heavy shopper just 9%.
• After 2 quarters: light 28%, typical 3%, heavy 0%.
• After 3 quarters: light 7%, typical and heavy 0%.
• After 4 quarters: light 2%, the rest 0%.

The counter-intuitive result: a heavy shopper going quiet is a far stronger churn signal than a light shopper going quiet. A weekly regular who skips a quarter has almost certainly left; an occasional shopper skipping a quarter is business as usual. Recency means nothing without frequency context — exactly the join a single-number model cannot make.

What drives high-value spend

Retention budget targets the top shoppers, so the tornado ranks drivers by their effect on P90 spend (baseline $339) rather than the mean — the high-value tail is where the money is.

• Visit frequency mean (1.8-3.0): $148 spread — frequency, not basket size, is the dominant lever on high-value spend.
• Basket value mean ($48-$68): $116.
• Season factor sd (5%-15%): $7.
• Basket-value spread (Gamma shape 3.6-1.8): $5.

The lesson for CRM: a campaign that adds one extra visit per quarter moves the high-value tail more than one that lifts average basket size, and far more than chasing basket-mix variability. Frequency is the lever.

The recency value cliff

Combining the two halves — expected value = P(active | recency) x expected spend when engaged — gives the number a retention team can act on: what is a shopper worth right now, given how long they have been silent?

• Recency 0 quarters: 100% active, expected value $178.
• Recency 1 quarter: 45% active, expected value $80.
• Recency 2 quarters: 3% active, expected value $6.
• Recency 3-5 quarters: effectively 0% active, expected value $0.

The value does not decay gently — it falls off a cliff between quarters 1 and 2, from $80 to $6. That is the win-back window: a reactivation offer at one quarter of silence targets an $80 expected asset; the same offer at two quarters chases a $6 ghost. The model pins the deadline precisely.

What the model changed

• Revenue planning shifted off the $139 average. Forecasts now run on the full per-shopper distribution, so the base total carries an honest spread driven by the shared season factor rather than a deceptively smooth point.
• Win-back campaigns got a deadline. Because expected value collapses from $80 to $6 between one and two quarters of silence, the retention team moved reactivation offers to fire at the one-quarter mark — where the asset is still worth recovering.
• Churn scoring became frequency-aware. The active-probability model showed that a lapsed heavy shopper is a stronger churn signal than a lapsed light shopper, so the CRM stopped scoring recency in isolation and combined it with prior frequency.
• Retention spend re-pointed at frequency. The tornado showed frequency outranks basket size in driving high-value spend, redirecting promotion design toward trip-frequency incentives.

ModelRisk Functionality Used

• Poisson frequency x Gamma severity composed per shopper into a next-quarter spend distribution — the family-agnostic frequency-severity construction, with a Gamma-mixed Poisson rate to reproduce the heterogeneity of a real customer base.
• Shared store/season common factor applied across all shoppers in a simulated quarter so the customer-base total retains a genuine spread instead of collapsing to its mean.
• Buy-till-you-die active-probability model that updates P(still a customer) from recency and prior purchase rate — turning days-since-last-purchase into a churn probability.
• Sensitivity ranking on the P90 (high-value) outcome to point retention budget at the lever that moves the revenue-carrying tail, not the average.

The average shopper is a planning fiction. The decisions that matter — who to win back, when, and with what — live in the shape of the distribution and the recency cliff, and Monte Carlo is what makes that shape visible.