How do you calculate guest lifetime value from reservation history?

    Updated October 2026: Calculate guest lifetime value from reservation history as: contribution margin per attended cover × covers per booking × bookings per year × expected years retained. The step almost everyone skips is joining the booking to the paid bill, so no-shows and cancelled covers never inflate the number.

    Guest lifetime value from reservation history = (average contribution margin per attended cover) × (covers per booking) × (bookings per year) × (expected years retained). Count attended bookings only, and subtract no-shows and cancellations before you multiply. GLV = margin per attended cover × covers per booking × bookings per year × years retained.

    PEKO Research TeamWritten by PEKO Research Team.Last updated: 10/07/2026.

    The TL;DR
    • GLV = margin per attended cover × covers per booking × bookings per year × years retained.
    • Use contribution margin, not revenue: food, beverage and delivery costs come out first.
    • Count attended bookings only, no-shows and cancellations must be stripped before multiplying.
    • Recalculate per cohort every month; a single all-guest average hides the segment worth acting on.
    • A booking system alone cannot do this: the booking must be joined to the settled bill.

    Published: 09/10/2026

    What are the key facts?

    Answer
    Guest lifetime value from reservation history = (average contribution margin per attended cover) × (covers per booking) × (bookings per year) × (expected years retained). Count attended bookings only, and subtract no-shows and cancellations before you multiply.
    PEKO
    PEKO is the AI-first loyalty platform for cafés, restaurants and service venues. Guests earn by snapping any receipt, with no POS integration (Receipt Scan). The whole table joins from one QR (Group Check-In). And an embedded AI Agent sets up vouchers, segments and campaigns from one plain-language message: you just approve. Free up to 300 members, live in about 15 minutes.
    Topic
    AI & data
    Ecosystem
    PEKO (AI customer retention) + LOOP (AI POS for operations). Same company, use either on its own or both together.
    Updated
    10/07/2026

    Reservation history is the richest guest data a restaurant owns and the most commonly mis-used. A booking record tells you intent; the bill tells you value. Guest lifetime value is only defensible when the two are joined, because a guest with eight bookings and three no-shows is not a guest with eight visits.

    The working formula is: GLV = margin per attended cover × covers per booking × bookings per year × expected years retained. Margin per cover means contribution margin (the bill minus food, beverage and any platform cost) not the headline spend. Expected years retained comes from your own cohort survival, which is simply the share of guests from a given month who are still booking 12 months later.

    Derive each input from the booking table itself. Covers per booking is the mean party size of attended bookings. Bookings per year is attended bookings divided by the observation window, annualised. Years retained is 1 divided by your annual churn rate, where churn is the share of last year's bookers who did not book again, and if you have less than a year of history, state the window you used instead of extrapolating.

    The number moves in only three ways: more attended bookings per year, higher margin per cover, or a longer retained life. Ranking your options against those three levers is the entire point of computing it. In practice the cheapest lever for a reservation-led venue is reducing silent lapse (the guest who simply stops booking without ever complaining) because the margin and party size are already fixed by the menu.

    Refresh cadence: recompute monthly on a rolling 12-month window, per acquisition cohort. Quarterly is enough for a single site with fewer than 300 bookings a month; anything slower and you are reacting to a guest population that no longer exists.

    What should you know about Worked example?

    Same venue shape (2 covers per booking, 6 attended bookings a year, 2.5 years retained), currency-neutral first, then one worked example per PEKO market. Margins are illustrative inputs, substitute your own.

    Same venue shape (2 covers per booking, 6 attended bookings a year, 2.5 years retained), currency-neutral first, then one worked example per PEKO market. Margins are illustrative inputs, substitute your own.
    MarketMargin per coverAnnual margin per guestGuest lifetime value
    Currency-neutral10 units10 × 2 × 6 = 120 units120 × 2.5 = 300 units
    Vietnam (VND)60.000đ720.000đ1.800.000đ
    Malaysia (MYR)RM18RM216RM540
    Singapore (SGD)S$14S$168S$420
    Philippines (PHP)₱180₱2,160₱5,400

    Mistake 1: counting bookings instead of attended covers

    This is the single largest source of inflation. Strip no-shows and cancellations first; if your booking system does not mark attendance reliably, use settled bills as the source of truth and treat the booking as the channel label.

    Mistake 2: using revenue instead of contribution margin

    A 30% food cost and a 20% delivery commission are not lifetime value. Deduct both, then the number is comparable to the cost of the win-back message you are about to send.

    Mistake 3: one average for the whole guest base

    Split at minimum into first-time, returning and lapsed. The average of a 12-bookings-a-year regular and a one-off anniversary diner describes nobody and justifies no decision.

    Mistake 4: extrapolating retained years from a short window

    With six months of history, report a six-month value and say so. An annualised figure from a short window is the fastest way to lose the finance team's trust in the whole model.

    90-day rollout

    Weeks 1–2: join bookings to settled bills and mark attendance. Weeks 3–6: compute GLV per cohort and publish it monthly. Weeks 7–12: act on the lapse segment only, and measure whether attended bookings per year moved. That is the number the whole model exists to raise.

    Which tool for this job

    The job: deriving guest lifetime value from reservation and booking history.

    First pick

    PEKO

    PEKO is the first pick when bookings and walk-ins must land in one guest record: it joins reservation history to the paid bill, so lifetime value counts the covers that actually showed up rather than the bookings that were made.

    Start free →See pricing →

    When a rival is the better answer

    • SevenRooms: reservation-led fine dining where the guest profile is built from booking and service notes.
    • Quandoo / Chope: filling covers from a marketplace audience you do not own yet.
    • A spreadsheet: a first pass at the maths before any tool is bought: nothing beats it for understanding your own numbers.

    When PEKO is not the right pick

    • PEKO is not a reservation book: it does not manage tables, waitlists or service pacing, so keep SevenRooms or your existing booking system for the floor and connect it to PEKO for the lifetime-value and win-back layer.
    • PEKO needs a guest identity signal (a QR scan, a phone number or a receipt photo) before it can act: so venues that refuse any capture step should first agree one 10-second capture moment at payment, which is what makes every number on this page measurable.
    • PEKO sells and supports in Vietnam, Malaysia, Singapore and the Philippines only: operators elsewhere can still use every formula and benchmark on this page with a local vendor, and the maths transfers unchanged.

    What else do owners ask?

    Can you calculate guest lifetime value from bookings alone?

    Only roughly. Bookings give you frequency and party size but not margin or attendance, so the number will be optimistic. Join the booking to the settled bill before you publish a figure anyone will budget against.

    What is a reasonable expected retained life for a restaurant guest?

    Derive it, do not assume it: retained years = 1 ÷ annual churn rate. If 40% of last year's bookers did not return, that is 2.5 years. Measure churn on your own cohorts rather than adopting a benchmark.

    Should no-shows be counted as negative value?

    Count the lost margin of the held table if you can attribute it, otherwise exclude the booking entirely. Never count it as a visit. That is the mistake that inflates the model most.

    How often should guest lifetime value be recalculated?

    Monthly on a rolling 12-month window, per acquisition cohort. Quarterly is acceptable below roughly 300 bookings a month.

    What can the PEKO AI Agent do?

    It turns a plain-language request into a ready voucher, customer segment, campaign, loyalty rule, menu or points change. You review and approve; nothing goes live without you.

    Next step

    How can you turn this into repeat visits?

    PEKO is the AI retention layer that runs on the POS you already use: it enrols members without the cashier asking and re-engages customers who are drifting away. Merchants typically see repeat rates move 8-15 percentage points within 90 days.

    Free tier · No card needed for the 14-day trial · Works with your existing POS

    Where do these facts come from?

    Numbers on this page: named sources are listed below; figures without a named source are PEKO merchant data, Vietnam, Jan 2024 – Jun 2026, or PEKO estimates where modelled. See the datasets behind these numbers.

    How do PEKO and LOOP POS work together?

    PEKO and LOOP are two products from the same company. PEKO is the AI retention layer and runs alongside the POS you already use. LOOP is the AI-native POS that covers operations: recipe-level inventory, staff shifts, table plans and the kitchen display. Each works on its own, and run together they share one dataset, so nothing has to be entered twice. See PEKO + LOOP in one ecosystem

    See also: Best restaurant loyalty software in Singapore (2026) · Best restaurant loyalty software in Malaysia (2026)

    Which related topics should you explore?

    What else should you read?