What is a returning guest worth? Guest lifetime value from your own records

A guest's lifetime value is the margin a hotel keeps from all of that person's stays, not the revenue they generate. Calculate it from your own records: net spend per stay after distribution and variable costs, multiplied by stays over a stated horizon.

Two guests pay the same rate for the same room. One booked on your own site and came back twice; the other arrived once through a booking site and never returned. Your reservation list shows two reservations and says nothing about the difference. After reading this, you will be able to turn that reservation list into a defensible figure per guest, and use it for one decision: how much keeping a guest is allowed to cost.

What is guest lifetime value for a hotel?#

Guest lifetime value is the margin one guest leaves across every stay, measured over a fixed horizon. It answers a spending question: how much a hotel can afford to keep that guest.

The unit is one person, identified by a merged profile, not one reservation and not one market segment. It is margin, not revenue: the bill minus the cost of the channel that brought the booking, minus the cost that appears only because the room was sold.

The horizon is a decision, not a discovery. Pick a number of years, write it down, and keep it fixed; a two-year figure and a five-year figure cannot be compared. Lifetime value is not a loyalty score, not a prediction and not a forecast. It is arithmetic on records the hotel already holds, and its value is that it replaces a feeling about repeat guests with a number a manager can defend in a budget meeting.

Produce one figure per guest group, not one figure for the whole hotel, and use it for one decision at a time.

Which records do you need, and where do they come from?#

You need four things per guest: every stay, the bill for each stay, the channel each booking came through, and one profile that joins them. Three usually exist already; the fourth is the work.

Stays come from reservation history attached to a profile. Keep cancellations and no-shows in a separate list, because they cost money without producing revenue. Spend comes from the closed guest bill, not the room rate: restaurant, minibar and spa lines belong in the figure, since they carry their own margin. Channel must be recorded at the moment of booking, so a reservation that arrived through an agency, a booking site or your own website is still distinguishable a year later.

Profiles are where the calculation usually fails. Duplicates split one person into several, so a guest who stayed four times looks like four first-timers. For guidance on the profile itself, see what to record on a guest profile, and what never to record.

Merging profiles without guessing#

Merge on a rule you can explain, such as the same email address plus the same surname. Write the rule down before you start, apply it mechanically, and check a sample of the results by hand. A merge that depends on judgment cannot be repeated next season, so the figures will not be comparable.

What never goes on the profile#

Keep the marketing profile narrow: preferences, stay history and consent status. Identity records kept for the statutory guest notification are a separate record, held for its own purpose and period. A monthly export to a spreadsheet is enough to start. The calculation does not require a new system, only a consistent one.

Why margin, not revenue: what to subtract before you multiply#

Revenue counts money that passes through the hotel; margin counts money the hotel keeps. A lifetime value built on revenue overstates every guest who books through a costly channel.

Channel cost is whatever the hotel pays for that booking: a commission, a fixed fee, or the running cost of its own website and the staff time spent answering enquiries. Use your own contract figure, never an industry average. Variable cost per stay covers what appears only because the room was sold: housekeeping time, laundry, breakfast, utilities, amenities, card fees. Fixed costs stay out. Rent, permanent salaries and building costs do not change because one guest returns, so they belong in neither the per-stay margin nor the comparison.

Extras carry different margins. A spa treatment and a minibar sale do not cost the same as a room night, so keep them as separate lines where the records allow. Corrections must be voided and reversed, not deleted, or a corrected bill quietly doubles a guest's recorded spend.

Sanity check: a margin per stay that comes out above the room rate means a cost line is missing. For the channel side of this subtraction, see comparing channels by what the hotel keeps; for the cost lines under the room, cost per occupied room, line by line.

A worked example, with numbers that are invented#

The arithmetic is short; the discipline is in labeling every number as an assumption. The hotel and the figures below are fictional and are not a benchmark.

State the assumptions first: average bill, channel cost, variable cost, stays per guest, horizon. If one of them is a guess, say so.

For example: a guest whose bill averages 4,000 lira per stay, with 600 going to the channel and 900 of variable cost, leaves 2,500 lira of margin per stay. Three stays inside a five-year horizon give 7,500 lira of margin from that one guest.

A comparable new guest won through a booking site produces the same 2,500 lira once, and replacing the returning guest means finding and paying for three separate new guests. Compare the two lines; do not add them. Adding replacement cost to lifetime value produces a number that means nothing.

Change one assumption at a time to see which one moves the answer. If the answer swings wildly between two plausible assumptions, the sample is too small to act on.

Direct guest or booking-site guest: which one leaves more behind?#

The one who comes back. The channel decides how much of each stay the hotel keeps, but the number of stays decides how much there is to keep.

Compare margin over the same horizon, never the rate on the first booking. A direct guest with one stay can be worth less than a booking-site guest with four. The direct guest usually leaves more per stay because no channel cost applies, but the hotel paid to attract them: advertising, website content, and hours at the desk answering questions. The booking-site guest was found by someone else at a cost per booking. If that guest returns directly next time, the first booking bought a relationship rather than a transaction.

What the hotel controls is permission to contact. Capture consent at check-out and the second stay can be direct; without it, the guest is a stranger again on the next trip. What the hotel cannot see is a guest who books through several sites and looks like several new guests. Profile merging is what turns that into a repeat.

Decision rule: if the margin difference over the horizon is larger than the cost of the retention action, do the retention action; if it is smaller, a corrected bill and an apology are the honest response.

How much should a return offer or a recovery cost?#

Up to the margin the guest is expected to leave, and no more. Lifetime value sets a ceiling on spending; it is not a target to reach.

After a complaint, a gesture is worth its cost only when the guest's expected future margin exceeds it. Otherwise a sincere apology and a corrected bill are the honest response. A return offer comes out of the margin of the next stay, so the offer must stay smaller than the margin it is protecting.

Set the band per guest group, not per individual: a written rule for the top group and a written rule for first-time guests. Improvised gestures at the desk cannot be reviewed later. Record the outcome: did the guest return? Without that record the ceiling is never corrected and the same mistake repeats each season.

Marketing use of a profile generally requires consent; confirm your own case with a legal adviser. Stay history may serve the contract and the stay itself; a return offer by email needs permission recorded before it is sent. Sequence matters too: thank, invoice, review request, then the offer. An offer that arrives before the thank-you reads as a transaction, not as recognition. On that order, see post-stay emails in the right order.

When the number misleads: small samples, tour operators, one-time destinations#

Lifetime value is arithmetic on your own records, so it inherits every gap in them. Three situations break it often enough to name.

Small samples: a short history or few repeat guests produces a figure that swings on a single person. Report a range, or wait for another season. Tour-operator and agency guests: the operator holds the relationship and often the contact data, so the hotel sees one stay and no repeat signal. Count them in a separate group. One-time destinations: where most visitors come once by design, lifetime value collapses to single-stay margin, and the useful question becomes acquisition cost rather than retention.

Wrong merges are quieter: a shared surname or a company booking can join two different people. Check a sample of merged profiles by hand before trusting the total. And different years are not comparable when prices move. Restate older bills or shorten the horizon so all stays sit in one price environment.

Quote the horizon, the cost lines and the sample size every time the figure appears in a meeting. An unlabeled number becomes a fact within a week.

What to do next#

Export one year of reservations with channel and bill totals, merge the profiles, and calculate margin per stay by hand for twenty guests. If the arithmetic holds on twenty, extend it to the full list; if it does not, the problem sits in the records, not in the formula, and fixing the records is the real first step.