Customer Retention

How to use till data plus email cadence to recover 40% of lapsed customers within 90 days

How to use till data plus email cadence to recover 40% of lapsed customers within 90 days

When I first started testing till (POS) data combined with targeted email cadences for recovering lapsed customers, I was skeptical. It sounded simple—maybe too simple. But within a few months I was surprised to see recoveries consistently hitting around 35–45% of lapsed shoppers within 90 days for several small retailers I worked with. The trick isn’t magic; it’s making the data actionable, building empathy into your messaging, and executing a tight, measurable cadence.

Why till data matters more than you think

Till data (transaction-level POS records) gives you the single most accurate view of behaviour for many SMEs. Unlike CRM activity or clickstream, till data tells you what a customer actually bought, when they bought it, and how frequently they return. That makes it ideal for defining lapsed status and creating relevant reactivation prompts.

Key fields I use from the till export:

  • Customer identifier (email/phone/loyalty ID)
  • Transaction date and time
  • Basket total and item-level SKUs
  • Store or channel (if omnichannel)
  • Payment type (for segmentation like subscription vs one-off)
  • With these fields, you can build precise segments: those who bought high-margin items last, customers who used a first-time discount, occasional shoppers who used to buy monthly, and so on. Each segment deserves a tailored reactivation approach.

    How I define “lapsed” for quick wins

    There’s no one-size-fits-all definition, but for a practical 90-day recovery test I typically define lapsed customers as:

  • Previously active customers who haven’t transacted in 30–90 days, and
  • Customers with at least two prior purchases (so we’re not chasing one-off buyers), and
  • Excluding those explicitly unsubscribed or flagged as churned in CRM.
  • This window balances the urgency to recover recent defectors while excluding long-term churn that needs a different approach (e.g., win-back offers or product changes).

    Segmentation that lifts open & conversion rates

    Segmentation is where the lift happens. I split lapsed customers into three starter groups for testing:

  • High-frequency lapsed: Used to buy monthly or more. These respond to urgency and replenishment cues.
  • High-value lapsed: Larger basket totals or premium SKUs. These need personalised offers and service-level triggers.
  • Occasional lapsed: Bought seasonally or sporadically. These respond to inspiration and timely product reminders.
  • For each segment, pull the last basket details from the till. If someone bought soap and shampoo last time, messaging about a new refill pack works better than a blanket 10% off.

    Email cadence I recommend (designed to recover ~40% within 90 days)

    This is the cadence I’ve repeatedly used. Run it for 90 days post-lapse and measure. Placeholders like [PRODUCT], [LAST_VISIT], [AMOUNT_SPENT] should be dynamically populated from till data.

    DayTypePurposeExample subject
    0–3ReminderGentle nudge referencing last purchase“We miss you — did you run out of [LAST_PRODUCT]?”
    7Value addProvide tips or replenishment suggestions related to last basket“How to make [LAST_PRODUCT] last twice as long”
    14OfferSmall incentive tied to real value (free shipping / £5 off on £25)“A little thank-you: £5 off your next order”
    30Social proofShow reviews/new arrivals of items they bought“Customers love this refill — 4.8★”
    60Stronger offer / FOMOLimited-time discount or bonus points“48 hours: extra 10% just for you”
    80Last chanceOne final reactivation with clear CTA“Last call: your £5 reward expires in 10 days”

    Timing matters: run sends in the customer’s local time, and avoid weekends if your sales historically dip then. For omnichannel retailers, coordinate SMS reminders for the 14-day or 60-day touchpoint if the customer permitted texts—SMS tends to boost conversion when combined with an email reminder.

    Message craft: empathy + evidence beats price slashes

    Customers respond more to relevance and helpfulness than to blanket discounts. That doesn’t mean you don’t use incentives—just be strategic:

  • Reference the last purchase: “We noticed you last bought [SKU]. If you liked that, try…”.
  • Use scarcity aligned with behaviour: “Only a few left in your nearest store”, if supported by inventory.
  • Offer convenience over discount: free click-and-collect, express delivery or a curated bundle that's clearly a time-saver.
  • Example email body framework I use:

  • Opening: short, warm line referencing last visit.
  • Value: quick tip, product use-case, or social proof.
  • Offer: clear, simple incentive (expiry date visible).
  • CTA: single, prominent CTA that takes them to a pre-filtered basket including their previous items.
  • Measurement & KPIs — track what matters

    To claim a 40% recovery rate you need consistent measurement. My preferred KPIs:

  • Recovery rate: % of lapsed segment who transact within 90 days of cadence start.
  • Time-to-first-order after reactivation email.
  • Average order value (AOV) of recovered customers vs baseline.
  • Retention cohort: repeat purchase rate 90–180 days later.
  • Unsubscribe and spam complaints — keep these under 0.1% for healthy programmes.
  • Run an A/B test on the offer (no-offer vs £5 vs free shipping), and another on subject lines. For robust results, aim for 1,000+ lapsed customers per test or run for at least 4–6 weeks if smaller.

    Operational tips: how to turn till exports into email triggers

    You don’t need an exotic tech stack. Here’s a lightweight process I implement with many SMEs:

  • Daily/weekly till export (CSV) from POS.
  • Append to a simple database or Google BigQuery / Redshift if volume grows.
  • Match transactions to email IDs via loyalty ID or phone-to-email hashing.
  • Flag lapsed customers and write code (or use tools like Klaviyo, Customer.io) to create dynamic segments and automate the cadence.
  • Push last-basket items into product recommendations so the email links to a pre-filled cart.
  • For stores using Square, Lightspeed or Shopify POS, there are native or third-party connectors (e.g., Zapier, Stitch, Talend) to automate data flow. I prefer Klaviyo for SMEs because of its good ecommerce integrations and reasonable learning curve.

    Common pitfalls and how to avoid them

  • Chasing one-off purchasers: filter to customers with at least two previous transactions.
  • Over-reliance on discounts: use convenience and relevance first; use discount as a final nudge.
  • Poor data matching: ensure your till-to-email matching rate is high; if not, consider asking for an email at POS with an incentive.
  • Ignoring frequency signals: a “monthly” buyer lapsed for 35 days needs a different nudge than a “quarterly” buyer at 90 days.
  • Real-world squeeze: what to expect

    In practice, a well-executed till-driven cadence will typically recover:

  • High-frequency segment: 45–60% within 90 days (they simply needed a reminder or small nudge).
  • High-value segment: 30–50% (personalised outreach works—sometimes a call or VIP email helps).
  • Occasional segment: 20–35% (these need inspiration or product discovery).
  • Those numbers vary by industry, ticket size and product lifecycle, but the underlying principle is consistent: the more relevant and timely your message (using till insights), the higher the recovery.

    You should also check the following news:

    A step-by-step test to prove open-banking–powered cashback lifts basket size for independent retailers
    Case Studies

    A step-by-step test to prove open-banking–powered cashback lifts basket size for independent retailers

    I recently ran a pragmatic, repeatable test to answer a question I hear a lot from independent...

    Aug 06 Read more...