Somewhere in your transaction history right now, a customer who used to visit every ten days hasn't been in for thirty-five. Your POS recorded it. Your accounting software filed it. Nobody acted on it. That gap between a regular's normal return window and their last visit is the single most accurate churn signal you'll ever have access to - and for most local business owners, it just sits there, quietly expiring. The good news: you don't need a data analyst, a CRM consultant, or a marketing degree to act on it. You need to understand one number, set one threshold, and let the right system handle the rest.
The Number Your POS Has Always Been Hiding From You
Every repeat customer has a return interval - the average number of days between their visits. For a coffee shop regular it might be 3 days. For a hair salon client, 28. For a dental patient, 180. That rhythm is invisible until you surface it, but once you do, it becomes your most reliable predictor of who is drifting away. The calculation is straightforward: pull the last 90 days of transaction data, filter for customers with two or more visits, and calculate the average gap between visits per person. That number is their baseline. Anyone who has exceeded that baseline by 1.5x or more without a new visit is showing early churn behaviour - not confirmed churn, but the precursor to it. At 2x their baseline with no return, the risk is serious. At 3x, you've almost certainly lost them.
Why 90 Days Is the Right Starting Window
Less than 90 days of data and you're working with too few data points to establish a reliable baseline for each customer. More than 12 months and seasonal shifts distort the average. Ninety days gives you enough visits to calculate a stable interval while staying recent enough to reflect current behaviour. If your business is genuinely seasonal - a beach-town ice cream shop, a ski-resort cafe - adjust the window to your active trading season rather than a calendar year.
The Three Thresholds That Should Trigger Outreach
Not every lapsed gap needs the same response. Treating a customer who missed one visit identically to a customer who has been absent for three times their normal cycle is wasteful and can feel tone-deaf. Here is a practical three-tier framework that works across most local business types.
- 1.5x their return interval - Soft engagement. A friendly check-in, a piece of useful content, a new menu or product update. No offer yet. You're maintaining warmth without signalling desperation.
- 2x their return interval - A genuine reason to return. A time-sensitive offer tied to something real: a new service, a seasonal item, an exclusive access window. Keep it relevant to what they actually bought before.
- 3x their return interval - A direct win-back attempt. Make it personal, make it specific to their history, and give them a clear reason to act now. This is your last realistic opportunity before they mentally categorise your business as somewhere they 'used to go'.
- Beyond 3x - Re-acquisition, not retention. At this point the psychology has shifted. Treat them more like a warm new lead than a lapsed regular. The tone, the offer, and the channel all need to reflect that reset.
The best time to send a win-back message is three days before a customer decides to leave. The second-best time is the moment your data tells you they already have.
Turning a Signal Into an Automatic Campaign
Here is where most owners stall. They understand the logic, they can see the data, but manually checking which customers have hit a 1.5x gap every week - across hundreds of transactions - is a job, not a task. This is precisely the gap that platforms like Rulrr are built to close. By connecting your POS transaction history to an automated marketing layer, Rulrr can calculate each customer's return interval, monitor for threshold breaches in real time, and trigger the right message - via email, SMS, or social ad - without you building a single workflow from scratch. The campaign writes itself from what the customer actually purchased. The timing sets itself from their actual behaviour. You review the output; the system does the heavy lifting.
Building Your First Return-Interval Report in Under an Hour
If you want to start manually before automating, here is the fastest path to a working report. Pull your transaction export from the last 90 days. In a spreadsheet, sort by customer ID or email, then by transaction date. Add a column that calculates the number of days between each customer's visits. Average those gaps per customer. Add a final column that flags anyone whose days-since-last-visit exceeds 1.5x their average. Sort by that flag. That list is your immediate action queue. It takes about 45 minutes the first time and reveals a pattern most owners have never seen in three or more years of trading.
- Step 1 - Export 90 days of transaction data filtered to repeat customers (2+ visits).
- Step 2 - Calculate average days between visits per customer (their return interval).
- Step 3 - Note the date of each customer's most recent visit.
- Step 4 - Flag anyone whose days-since-last-visit is 1.5x or more above their interval.
- Step 5 - Segment into the three tiers above and assign a message type to each.
- Step 6 - Write or generate one message per tier, personalised to purchase history.
- Step 7 - Set a weekly reminder to run the same check - or connect your POS to a platform that does it automatically.
What to Actually Say in Each Message
Tier one messages should feel like a natural touchpoint, not a marketing email. Reference something specific - a menu item they ordered, a service they booked - and mention something new or relevant that connects to it. Tier two messages need a hook that feels genuinely valuable, not a panic discount: a first look at something new, a loyalty reward they've earned, a genuinely seasonal offer with a real end date. Tier three messages should be short, direct, and personal. 'We haven't seen you since March - here's something we thought you'd want' outperforms a decorated newsletter every time. The combination of specificity and brevity signals that you noticed their absence without making them feel chased.
The Metric That Changes How You See Every Sale
Once you start reading your transaction data through the lens of return intervals, you stop seeing individual sales and start seeing relationships. A customer who visits every eight days and just hit day fourteen is not a statistic - they're a conversation that's starting to go quiet. The businesses that win on retention aren't the ones with the biggest loyalty programmes or the most aggressive discount schedules. They're the ones who notice the silence early, respond with something relevant, and make it easy for a customer to come back without feeling like they need an excuse to. Your POS has been recording all of this since the day you opened. The only question is whether you're listening.
The owners who act on this data first in their category own a structural advantage that compounds over time. Every competitor chasing new customers through paid ads is spending five times more to replace someone who could have been retained with a single well-timed message. Your transaction history is already talking. Building the habit of listening to it - or connecting it to a system that listens automatically - is one of the highest-return decisions a local business can make this year.