November 16, 2026
|
7
minute read

12 questions to get more from your restaurant data across every venue

Written by:
Kat Ellison
Last updated:
November 19, 2026
Thank you! You have successfully subscribed!
Oops! Something went wrong while submitting the form.
Summarise this article with AI
OpenAI logoPerplexity icon
Claude icon

Restaurant data analytics means using your reservations, POS, online ordering and loyalty data to see who your guests are, how often they come back and what they're worth. For a multi-venue group, the most useful questions are about people. How many guests are active? How many visit more than one venue? How many first-timers return? Which regulars are drifting, and do your offers build visits or give away margin? Here are 12 questions to answer, and the data each one needs.

Most venue groups can tell you last Saturday's takings to the dollar. Far fewer can tell you how many of last Saturday's guests were there for the first time, or how many of them will ever come back.

That gap costs money. Analytics vendor Bloom Intelligence looked at its own restaurant clients' data and found that 78.8% of repeat guests acquired before 2025 had no visit at all in 2025. It's one vendor's platform data, but anyone who has watched a strong summer fade into a quiet winter will recognise the pattern.

The cause is usually structural. Bookings sit in the reservation system, spend sits in the POS, members sit in the loyalty platform and online orders sit somewhere else again. Each system knows part of the guest, and none of them knows the whole person. So the questions that matter most go unanswered.

1. How many active guests do you have, and what counts as active?

Every other number on this list depends on this one, and many groups don't have an agreed answer. Is an active guest someone who visited in the last 6 months, or the last 12? Does a booking under a partner's name count? Does a takeaway order?

Pick a definition that suits your visit cycle. A neighbourhood pub with weekly regulars might use 90 days. A restaurant people choose for birthdays and anniversaries might need 12 months. Count unique guests rather than transactions or bookings, because one regular can generate dozens of each.

Write the definition down and get finance and marketing to agree on it before anyone builds a report. A shared active guest count definition stops the finance number and the marketing number drifting apart. Once it's settled, an active guest base forecast tells you whether the base is growing into summer or shrinking into winter.

2. How many of your guests visit more than one of your venues?

This is the question that sets a group apart from a single-site operator. Guests who move between your venues are often your most valuable, and they're the easiest to lose track of, because each venue sees them as a different person.

The answer tells you how much of your guest base belongs to the group as a whole, and how much cross-venue opportunity is still on the table. If, say, 8% of guests visit two or more venues and they spend three times as much a year, every guest you introduce to a second venue is worth chasing.

You can't answer it until guests are matched across venues, which the data section below covers. Once they are, the question is easy to put to Lexi in plain words: "How many guests visited two or more of our venues in the last 12 months, and what did they spend compared with single-venue guests?" The multi-venue guests and annual spend use case shows the shape of the answer.

3. How much of your revenue comes from regulars, and how much from first-timers?

This split tells you what kind of business each venue runs. A venue that relies on first-timers needs a steady flow of new guests and feels it fast when foot traffic drops. A venue built on regulars is steadier, but it still needs a plan to replace the regulars it loses each year.

Look at it by venue and by season. A CBD venue during spring racing will skew towards first-timers. A suburban bistro in the middle of winter should lean on its regulars. When the mix shifts and you didn't plan for it, treat that as an early warning.

Report the split every month for each venue. With returning vs first-time guest revenue next to revenue from regulars by venue, a venue manager can see straight away whether last month's growth came from new faces or from the regulars they already know.

4. What share of first-time guests come back, and does it depend on how they found you?

Your first-visit return rate is the most useful single number in hospitality marketing, because it tells you whether the first visit did its job. Measure it over a fixed window, such as a second visit within 90 days, so you can compare venues and months fairly.

Then split it by source. Guests who booked direct, came through a booking platform, walked in or redeemed a voucher can return at very different rates. If voucher guests rarely come back, you're paying for one-off visits. If guests from one channel return twice as often as the rest, that's where your acquisition budget should go.

Start small. Take the last three months of first-timers at your busiest venue, count how many came back within 90 days, and split them by how they first booked. The first-visit return rate by source use case walks through the calculation, and turning occasional diners into regulars helps you find the venues already doing it well, so the rest of the group can copy what works.

5. Which regulars are going quiet, and what are they worth?

Regulars rarely announce they're leaving. They come fortnightly, then monthly, then not at all. By the time a venue manager notices, the guest has found a new local.

Measure each regular against their own rhythm. A guest who visits every week and hasn't been in for a month is at risk. A guest who comes four times a year and hasn't been in for a month is on schedule. A simple rule is to flag anyone whose gap since their last visit is more than double their usual gap between visits, then rank that group by what they spent over the past year.

A weekly list of regulars going quiet, ranked by value gives each venue team a short list of guests to contact first. Rolled up across the group, the same data shows which venues have regulars at risk well before it shows up in the takings.

6. What's your average spend per visit by venue and time of day?

A group-wide average spend per visit hides more than it shows. Lunch, dinner, late night and weekend brunch behave like different businesses, and each venue has its own mix.

Break it down by venue and by daypart and the decisions get clearer. If Thursday lunch spend per visit is half of Thursday dinner, a lunch push has to lift spend as well as fill seats. If one venue's weekend spend sits well below its sister venues, look at the menu, pricing and upselling there before you spend more on marketing.

Strip out staff meals and comps first (excluding staff and comps), so the number reflects paying guests. Then put average spend by venue and daypart side by side across the group. The gaps between sister venues show you where to look first.

7. Are visits going up while spend per visit goes down?

A busy venue can still be losing ground. A promotion that lifts covers by 15% while spend per visit falls by 20% leaves you with more work and less revenue.

Watch covers and spend per visit together, by venue, every month. When they move in opposite directions, find out which guests drove the change. Often it's a new group of offer-led guests pulling the average down while regulars spend as they always have. Sometimes it's regulars trading down, which is the bigger worry, because it points to price or menu fatigue among the guests you can least afford to lose.

This is a good monthly question to ask Lexi: "Which venues had more covers but lower average spend per visit last month, and which guest groups drove the change?" The covers up, average spend down use case shows how the answer breaks down.

8. How reliant are you on offers and happy hours?

Offers are useful for filling quiet periods and bringing in first-timers. They turn into a problem when the same guests only ever visit on a deal, or when full-price regulars start waiting for one.

Two numbers settle most debates about discounting. The first is the share of visits and revenue that came through an offer, happy hour or voucher. The second is how many offer-only guests ever came back and paid full price. Measure your reliance on offers and happy hours to get the first, then compare guests who mostly pay full price with those who mostly visit on an offer.

The offers that gave away margin use case adds the cost side: discounts handed to regulars who would have come anyway. If a happy hour mostly discounts guests who were already coming, you can trim it and keep the trade.

9. Could your weekend regulars fill your midweek tables?

Most venues share the same shape: full on Friday and Saturday, quiet from Monday to Wednesday. The usual response is a midweek discount, which costs margin and mostly attracts guests who already chase deals.

Your weekend regulars are a better place to start. They already like the venue, and some of them live or work nearby and simply haven't thought of it on a Tuesday. A midweek invitation built around something they already order, such as a set menu, a wine night or trivia at the pub, can move some of that demand without a blanket discount.

Size the opportunity before you plan the campaign. Weekend regulars and midweek revenue shows how much midweek trade those guests could add, and Friday and Saturday revenue exposure shows how much of your week rides on two nights. If a wet Saturday can sink a venue's week, that venue goes first.

10. Which guests live near one of your venues but have never been?

Your cheapest new guests are people who already like one of your venues. A guest who dines at your CBD restaurant and lives two streets from your suburban pub is a warm introduction waiting to happen.

To find them, you need a home suburb or postcode for each guest (from bookings, loyalty sign-ups or online orders) and a record of which venues each guest has visited. Map one against the other and you have an audience for a personal invitation from the venue they haven't tried yet.

This pays off most in the months before a new venue opens. Finding existing guests near a new venue gives the launch a guest list on day one, and city diners near your suburban venues does the same for the venues you already run.

11. Do your events and private dining guests ever come back to dine?

Christmas parties, birthdays, weddings and corporate dinners bring dozens of new guests through the door at once, many of them in November and December. Many groups only capture the booker's details and never hear from the rest of the table again.

Ask how many people who attended an event later came back for a regular visit, and how many corporate bookers have booked at more than one of your venues. If both numbers are low, you've found an easy place to start.

Timing helps here. Pull last year's Christmas party bookings, match the attendees you have details for, check who came back to dine, and invite the rest before summer trade peaks. Event guests who never returned as diners covers the attendee side, and corporate bookers across venues covers the people who choose where next year's party goes.

12. Are your loyalty members worth more than everyone else?

A loyalty programme should change behaviour. Members should visit more often, spend more or try more of your venues than similar guests who aren't members. If they don't, the programme is a discount with extra admin.

Compare members and non-members on visit frequency, spend per visit and venues visited over the same 12 months, using loyalty members vs non-members as the template. Then check the cost side, including what rewards cost by tier and how long a new member takes to pay back.

Look closely at new members who never visited again. If, say, a third of last year's sign-ups claimed a welcome reward and never came back, you know exactly where the programme leaks, and a second-visit offer for new members becomes an easy first fix.

What data do you need to answer these questions?

Almost every question above needs the same foundation: one record per guest, with every visit, booking, order and reward attached to it. In practice that means bringing together:

  • Reservations and walk-in records
  • POS transactions, including table and bar spend
  • Online and at-table ordering
  • Loyalty and voucher data
  • Wi-Fi sign-ins and guest surveys
  • Events and ticketing
  • Your property management system (PMS), if you run accommodation

The hard part is matching. The same guest books under a work email, orders online with a personal one and pays by card at the bar. Unless those records are linked, one regular looks like three occasional guests and every number on this list is off. Start with guest matching across systems, matching POS transactions to guests and getting your restaurant data in one place.

Lexi, the agentic customer data platform, matches guests across reservations, POS, ordering and loyalty into one profile per guest. Your marketing and venue teams can then ask questions like these in plain language and turn each answer into an audience for email, SMS or ad platforms, in the same conversation.

Which questions should you answer first?

You don't need all 12 at once. If you're starting from scratch, begin with three: how many active guests you have (question 1), how many first-timers come back (question 4) and which regulars are going quiet (question 5). Together they tell you whether your guest base is growing or shrinking, and they give your venue teams a list to act on this week.

Then add the group-level questions, multi-venue guests and cross-venue introductions, because that's where a group has an edge no single venue can match. For more examples by role, browse the hospitality use cases, see multi-location restaurant analytics in practice, or read how Solotel uses guest data across its venues. To see how this works for venue groups, visit Lexi for hospitality.

Book a demo to see what Lexi can do with your guest data.

‍

FAQs

What is restaurant data analytics?

Restaurant data analytics is the practice of using data from your reservations, POS, online ordering, loyalty and other systems to understand guest behaviour and venue performance. For multi-venue groups, the most valuable analysis centres on guests: how many are active, how often they return, how much they spend per visit and which venues they visit. That guest view sits alongside the takings and covers you already report.

What data does a multi-venue restaurant group need for guest analytics?

At a minimum, you need reservations, POS transactions and loyalty data, matched to individual guests. Online and at-table ordering, Wi-Fi sign-ins, surveys, events and ticketing add more detail. Hotels and resorts should include their property management system. The matching step matters most, because one guest often appears under several emails, names or cards across your systems.

What is a good first-visit return rate for a restaurant?

It depends on the venue type and how you measure it, so your own baseline is the most useful benchmark. A neighbourhood venue should expect more first-timers to return than a destination restaurant in a tourist precinct. Pick a fixed window, such as a second visit within 90 days, measure it by venue and by acquisition source, and track whether it improves month on month.

How is a guest data platform different from a reservation system's guest CRM?

A reservation system's guest CRM knows about bookings: who booked, when, for how many and any notes. A guest data platform brings bookings together with POS spend, online orders, loyalty activity and other sources, then matches records so each guest has one profile across every venue. That's what lets you answer questions about spend, visit frequency and cross-venue behaviour.

Get more from your customer data today
Find out more
Kat Ellison
Marketing Manager
Kat is Lexer's resident Marketing Manager, obsessed with helping retail and e-commerce brands across AUS and the US hit their biggest growth goals. She's all about explaining how to turn messy customer data into clean, measurable strategies that actually move the needle. You'll find her writing on everything from using AI to grow your business to boosting LTV without breaking the bank. In her spare time, Kat is reading, gardening, and listening to as much music as she possibly can.