Advanced Segmentation: Turning Visit Data Into VIP Relationships

Why Basic Segmentation Isn't Enough

Lesson 3 covered splitting your list by visit frequency and timing. That alone beats sending one message to everyone. It still treats guests as static, though.

A more useful picture: each guest is at a point in a relationship with your venue, moving towards becoming a regular or drifting away. Different points call for different messages.

None of the frameworks below is complicated. What they need is consistent execution and a willingness to look at your guest list analytically rather than anecdotally.

RFM Segmentation for Physical Venues

RFM stands for Recency, Frequency and Monetary value. Direct marketers have used it for decades, and it suits any business where customers come back in person.

Recency: how recently did the guest last visit? Someone who came in yesterday is more likely to respond than someone who has not been in for six months.

Frequency: how many times have they visited over a set period, typically 90 or 180 days?

Monetary: how much do they spend per visit? WiFi data cannot tell you this. Match WiFi visits with your till data, or use visit timing as a rough stand-in (dinner guests usually spend more than morning coffee guests).

Building an RFM score

Give each dimension a score from 1 to 5, where 5 is best. Example bands for a venue with weekly regulars:

• Recency 5: visited within the last 7 days
• Recency 4: 8 to 21 days ago
• Recency 3: 22 to 45 days ago
• Recency 2: 46 to 90 days ago
• Recency 1: more than 90 days ago

• Frequency 5: 8 or more visits in the last 90 days
• Frequency 4: 5 to 7 visits
• Frequency 3: 3 to 4 visits
• Frequency 2: 2 visits
• Frequency 1: 1 visit only

Adjust the bands to your trade. A daily coffee shop needs tighter recency bands than a special-occasion restaurant.

Guests scoring 4 or 5 on both are your champions. Guests with high frequency but falling recency are the ones to watch: they used to be regulars and have recently stopped. They are your best win-back targets.

The Third Visit Question

Many operators work on the belief that the third visit is when a guest stops exploring and starts coming out of habit. It is a useful idea, but test it on your own list before relying on it.

You can check it with your WiFi data. Take guests whose first visit was at least six months ago. Group them by how many visits they made in their first 60 days (one, two, three or more) and see what share were still visiting in month six. If the jump between two visits and three is large, the third visit matters for you.

If it does, a campaign aimed at guests with exactly two visits in the last 60 days, with a specific, time-limited reason to come back, is one of the most useful things you can run. Track it against a small group of similar guests you did not email, so you can see what the campaign actually added.

Behavioural Trigger Campaigns

Calendar campaigns ("January offer", "Mother's Day menu") go to broad groups on dates you choose. Trigger campaigns fire when a specific guest does something, or stops doing something. Because the timing follows the guest, they are easier to make relevant.

The visit milestone trigger Fire: after a guest's fifth visit Message: "You're officially a regular. Here's what that means." Purpose: recognise loyalty out loud, introduce perks, and make the relationship feel personal.

The time since last visit trigger Fire: when the gap since the last login passes your chosen thresholds, for example 14, 21 and 45 days, depending on your visit pattern Message: a gentle reminder first, a warm win-back with an offer second, a final note third Purpose: catch guests before they drift away completely.

The frequency drop trigger Fire: when a guest's visits over the last 30 days fall to half of their usual rate or less Message: "We've missed you. Is everything okay?" Purpose: spot a problem early. A guest who came three times a week and now comes once may have had a bad experience. A personal note can recover the relationship.

The first visit follow-up Fire: the day after a guest's first login Message: "Thanks for coming in. Here's what to try next time." Purpose: the second visit is the first habit to build. A useful note and a light reason to return gives first-timers a nudge.

All of these depend on a visit appearing as a login. Make sure devices are authorised for less time than the gaps you are measuring (a published VoqadoWiFi portal uses 8 hours), or returns inside the window will be invisible.

Lifecycle Stage Mapping

Think of each guest on your list as being in one of five stages:

Stage 1: First visit. Has logged in once and received the welcome emails.

Stage 2: Returning. One or two return visits. The goal is the habit, which for many venues means a third visit.

Stage 3: Regular. Visits in a steady pattern. The goal is to deepen the relationship: loyalty perks, learning their preferences.

Stage 4: Champion. Frequent, recent, and (if you can match till data) high spending. The goal is recognition, and inviting them to bring friends.

Stage 5: Lapsed. No visit for longer than your lapse window. Run the win-back sequence, then stop emailing if they do not respond.

The reasoning is simple: moving a guest who already knows you from Stage 1 to Stage 3 usually costs less than finding a new guest. Many venues spend most of their effort on new guests and little on the ones they already have.

Identifying and Protecting Your Champions

Rank every guest by visits over the last 90 days and see what share of all visits the top fifth accounts for. In many venues the answer is a large share, which tells you how much depends on a small group of people.

These guests do not need discounts to visit. They respond to recognition and to feeling that their loyalty is noticed.

Ideas for champions:

• Preview evenings: invite them to taste a new menu before it launches
• A table by name: let them book their usual table directly
• A direct line: a named manager's email for feedback and requests
• Behind the scenes: kitchen videos, supplier stories, introductions to the team

Champions who feel noticed tend to bring friends and leave reviews. Keep a running list of them, review it monthly, and reach out personally when one of them goes quiet.

• 1RFM (recency, frequency, monetary) is a long-standing direct marketing model; WiFi gives you recency and frequency, your till gives you spend
• 2Many operators treat the third visit as the point a guest becomes a regular; check whether that holds in your own data before building on it
• 3Triggers based on what a guest did are easier to make relevant than calendar campaigns
• 4Rank guests by visits to see how concentrated your trade is, then look after the top of that list
• 5Set lapse windows from your venue's usual gap between visits: days for a coffee shop, weeks for a restaurant