Most owners know exactly what sold last Tuesday. Almost none of them know which of their regulars was supposed to come back three weeks ago - and hasn't. That gap, sitting silently in the timestamp column of your transaction history, is not a data problem. It is a revenue problem. And unlike a bad review or a slow weekend, it compounds invisibly until the customer is simply gone. The good news: you already have everything you need to catch it. You just haven't been taught which number to look at.
What 'The Right Column' Actually Means
Your POS system almost certainly records two things for every transaction: who bought (or at least an identifier - a loyalty card, an email, a phone number) and when. Most owners use that data to answer backward-looking questions: what was my best-selling item last month? Which day drove the most covers? Those are useful questions. But the column almost nobody reads is the gap between a customer's visits - specifically, the difference between their average return interval and how long it has actually been since they last appeared.
Call it the Return Gap. If a customer typically visits every 18 days and it has now been 35 days since their last transaction, they are not just overdue - they are, statistically, already drifting. They have not complained. They have not unsubscribed. They have simply stopped showing up. And you have a window of roughly one to two weeks before their mental model of your business shifts from 'my regular place' to 'somewhere I used to go.'
How to Find Your At-Risk Customers This Week - Without Any Special Software
You do not need a data analyst or a CRM licence to run this exercise. What you need is 90 days of transaction data exported to a spreadsheet - something virtually every POS system can produce in under five minutes. Here is the exact process:
- Export your last 90 days of transactions to a spreadsheet. Filter for customers who appear more than twice - these are your identifiable regulars.
- For each repeat customer, calculate their average number of days between visits. If someone visited on day 1, day 19, and day 38, their average return interval is roughly 18-19 days.
- Now look at today's date minus their most recent transaction date. That is their 'days since last visit' figure.
- Flag any customer where days since last visit exceeds their average return interval by 50% or more. Someone with an 18-day rhythm who hasn't been in for 28 days is already a yellow flag. Past 36 days, they are red.
- Rank your red-flag list by historical spend value - the customers who spent most per visit deserve your first call or message.
- Do this exercise on a Friday. You will have a targeted outreach list ready to act on before the weekend.
The moment a regular stops being a regular, they rarely announce it. They just quietly start choosing somewhere else. The only way to catch that is to watch the clock, not the complaint box.
What to Actually Say - Three Messages That Work
Reaching out to a lapsing customer feels awkward until you reframe it: you are not chasing them, you are acknowledging them. The highest-converting re-engagement messages do three things - they are personal (use their name and reference what they actually buy), they are low-pressure (no 'LIMITED TIME ONLY' panic), and they offer genuine value rather than a discount that trains them to wait for the next one. Here are three approaches calibrated to different business types:
- The Simple Check-In (works for any business): 'Hi [Name], it's been a while since we've seen you - we've just added [specific new item/service/product] and thought of you. Come in this week and we'll make sure it's worth the trip.' No coupon code. No urgency. Just genuine acknowledgement.
- The Value Nudge (best for retail and food): 'We saved something for you. [Product name] is back in and we know you liked it last time. Let us know if you'd like us to hold one.' Scarcity plus personalisation, without discounting your margin.
- The Loyalty Recognition Message (best for salons, spas, gyms): 'You've been one of our regulars since [month/year] and we genuinely value that. We have a quiet slot this [day] and wanted to offer it to you first before we open it up.' Exclusivity without a price cut.
Making This Automatic - So You Never Miss the Window Again
Running the spreadsheet exercise once is valuable. Running it every week is the actual strategy. The challenge is that most owners do it once, see results, get busy, and forget to repeat it for three months - by which point a fresh wave of regulars has quietly drifted. This is exactly the kind of pattern recognition that platforms like Rulrr are built to handle: connecting your transaction data to automated signals so that at-risk customers are flagged and the outreach is drafted before you even think to look. The manual version teaches you the logic. The automated version makes sure the logic actually runs.
Whether you automate it or run it manually, the core habit is the same: treat the timestamp column in your POS as a health monitor for your customer relationships. Every gap that widens beyond the normal rhythm is not a neutral data point - it is a customer raising their hand and hoping you'll notice. Most businesses never look. The ones that do consistently find that 10-20% of their 'lost' customers weren't lost at all. They just needed one well-timed, thoughtful message to walk back through the door.
The Customers Most Worth Saving Are Usually the Quietest
High-value regulars rarely complain before they leave. They are the customers who tipped well, never caused problems, and came back like clockwork - until one day they didn't. They are also the customers least likely to respond to a mass discount blast, and most likely to respond to a message that feels like it was written specifically for them. Your POS data already knows who they are. The return gap tells you exactly when to reach out. The only remaining question is whether you act on it this week or discover they've gone in six months' time when you finally notice a dip in average weekly spend.
Start small. Pull your last 90 days today. Find your top 20 regulars by visit frequency. Check every one of them against their normal return rhythm. If even three of them are past their window, you have a targeted, high-value outreach task for this afternoon - one that costs nothing to run and has a realistic chance of recovering hundreds, if not thousands, in annual revenue per customer. That is not a marketing campaign. That is just reading the right column.
