Guests who have no-showed more than twice in six months
What the answer looks like
Illustrative output on sample data
Illustrative example: how Lexi answers this for an omakase sushi counter group with three venues. It uses reservation records for the past six months, matched to each guest by email and phone.
- Includes guests with three or more no-shows in six months.
- Excludes no-shows the venue marked as excused, such as a reported emergency.
- Shows each guest's completed visits alongside their no-shows.
What the data shows
46 guests qualify, accounting for 31% of all no-show seats. 12 of them have also completed four or more visits.
What it means
Most repeat no-shows rarely complete a booking. The 12 with completed visits are regulars who often double-book.
What to do
Require a deposit for the 34 who rarely show up, and call the 12 regulars to confirm the day before.
Want me to list the 46 guests with their completed visits?
Why it matters
A small group of repeat no-shows often accounts for a large share of empty reserved tables. Finding them by name lets you treat them differently, with a deposit, a confirmation call or a reminder, without adding friction for the guests who always turn up.
Frequently asked questions
How should restaurants handle repeat no-show guests?
Treat them differently from everyone else. Ask repeat no-shows for a deposit or card on their next booking, and call regulars who sometimes forget to confirm. This targets the problem without adding friction for reliable guests.
How many no-shows make a guest a repeat no-show?
Set a simple rule, such as three or more in six months, and exclude excused cancellations. Review the rule against your data, since a venue with long booking windows may see more honest no-shows than one taking same-day bookings.
Should restaurants block guests who repeatedly no-show?
Blocking is a last resort. A deposit or card hold usually changes behavior while keeping the guest. Check their completed visits first, since some repeat no-shows are also valuable regulars who simply need a reminder.