yodai Academy Analytics

Academy › Publishing › Analytics

How to find out every week who's crossed your limit

By the end, your abandonment limit turns into something that doesn't depend on your memory: a fixed check-in on your calendar to see who's crossed it and, if your tool has it, the automatic email that goes out to the customer.

By Yodai · Published September 6, 2026 · Updated October 12, 2026

4 min read

Your cutoff week is the point after which, for your business, someone who hasn't come back counts as lost. The problem is that week doesn't remind you on its own. If you don't have a set time to check it, you end up opening your customer list whenever you remember, counting back dates, and finding out three weeks too late that someone hasn't set foot in your business in six weeks.

A limit that only lives in your head doesn't do you any good. What works is that same limit turned into something that doesn't depend on your memory: a fixed check-in on your calendar so you find out, and, if your website or booking system has it, an automatic email that reaches the customer when they cross it. That's what you're building today.

What you need to find out in time

Three things: a date to start from, a limit to compare it to, and a set time to make that comparison. Nothing else.

The date you start from is each customer's last purchase or last appointment, the same one you use to figure out how often your regulars come back. The limit is your cutoff week. You set the fixed time yourself: if your orders or appointments are saved with their date, whether on your website, your calendar, or a spreadsheet, you already have each customer's date. What's missing is doing the math on the same day every time, without relying on remembering.

How to set it up from scratch
  1. 1Write the rule as a sentence
    Before you touch anything: "if a customer hasn't booked in more than 5 weeks, I want to know." Use your exact number, not just an example. That sentence is the only decision you need to make.
  2. 2Decide who finds out
    It can be an alert for you, so you're the one who calls, or an email that goes straight to the customer. Those are two different things. If your website or booking system has an automatic "we miss you" email, set it to your cutoff week converted into days. You'll set up your own alert in the next step. What you say to the customer, and who you leave out, is a separate decision.
  3. 3Put a day and time on your calendar
    A reminder that repeats every week, always on the same day. During that time, sort your customer list by their last visit date and jot down anyone who's crossed the limit. If you keep your customers in a spreadsheet, a column that subtracts the last visit date from today's date gives you everyone's count at a glance.
  4. 4Test it with a made-up case
    Before you trust your check-in, add a test customer whose last appointment falls exactly one day past the limit. If your check-in doesn't catch that one, it won't catch the real ones either.
  5. 5Let it run for a few weeks before you touch it
    At first it's going to feel like too many names, or too few. Don't change the limit yet: first see whether these are useful alerts or just noise.
Your week's list, as is
3 customers cross the 5-week mark this week Maria G., last appointment: 37 days ago Carlos R., last appointment: 36 days ago Lucia P., last appointment: 41 days ago No one's been contacted yet. Review and decide.
The costly mistake: reviewing everyone at once, on day one
If your business has been running for years, your first check-in is going to spit out two hundred names. Nobody reviews two hundred names, and that first failure becomes the perfect excuse to drop the whole thing for good. Start only with customers who cross the limit from today forward, not your entire history. Look at the history separately, just once, with no rush.

What to do if your business has several services with different rhythms

If you offer haircuts and also hair color, your cutoff week for one doesn't work for the other: someone who comes in for color might take twice as long to come back, and that's completely normal. In that case your check-in needs two rules, one per service type, not a single one for the whole business. And if your tool's automatic email only allows one timeframe for the entire business, set it to match the service that takes longest to bring customers back, and reach out yourself, from your check-in, to the others.

If you only offer one service, or your different services share roughly the same return pace, one rule is enough. Don't double up just to be safe: a rule nobody needs is a rule nobody checks.

Weekly check-in or daily check-in
Once a week
  • A fixed slot, same day, same time
  • Easy to stick with once it's on the calendar
  • Good for reviewing calmly; some customers wait a few days before you see it
A few minutes, every day
  • You find out the next day when someone crosses the limit
  • Harder for names to pile up unnoticed
  • Only worth it if you have a lot of customers and reacting fast matters to you

Which one to pick: If your customers come back every few weeks, a weekly check-in is enough. A few days' lag won't change anything. If your business depends on reacting fast, check in daily, even if it's just five minutes.

Now you know when you'll find out. Who to write to next, and in what words, depending on whether your customer decides based on trust or on price, is what you'll draft in the final lesson.

What you'll walk away with
  • You have the exact rule written down for when a customer crosses your limit
  • Your check-in is on your calendar and tested with a sample case, not just in theory
  • You're starting from today, without drowning in the full history on day one
  • You know what's on you and what an automatic email can handle on its own, if your tool has one; who to write to next is the next lesson
NextWhat you write to the one who crossed the line, and who you don't write to at all