Hotel guest LTV: modelling four-year return gaps

September 26, 2026 · 5 min · Free, with full transcript

When a resort guest has not booked in three years, is she churned or simply between visits? The position here is that standard lifetime value math, average purchase times frequency times years, was built for weekly buyers and misreads long gaps as abandonment. A Maldives resort guest who spent $41,000 across two stays was flagged churned by the software and nearly dropped from marketing. You come away able to segment irregular high spenders from once-and-done guests, calculate the real average interval between stays, and model expected visits over a 20 year horizon. The episode covers why the same guest values at $8,000 one way and $52,000 the other, and how to read HubSpot, SEMrush and Forrester numbers.

Listen to the podcast

4 min

Chapters

Key takeaways

  • Segment irregular high spenders separately before calculating LTV, since blended averages with one-time Groupon guests produce a number that describes nobody.
  • Model expected visits over a realistic horizon such as 20 years using the segment's real return interval, not a monthly frequency average.
  • Pull your top 100 spenders, calculate the average gap between their stays, and remove anyone still inside that window from the churn list.
  • Treat HubSpot's retention cost multiples of 5 to 25 and SEMrush acquisition figures as vendor starting points and cross check against Forrester before quoting them to a board.
  • Keep contact during quiet years with birthday messages or renovation news rather than treating a non-booking guest as a rejection.
Read the full transcript

Host:This is Leader's Insights. On the table, a guest who returns once a decade is still worth modeling at full five-figure value. If a guest hasn't booked in three years, why is she still on your books as valuable and not written off as dead weight?

Expert:Picture the actual moment. It's March, I'm sitting with the revenue team at a resort group in the Maldives, and someone pulls up a guest who last stayed in 2023. The system has flagged her churned. Churned meaning the software has decided she's gone. She'd spent $41,000 across two visits, and the algorithm wanted to stop marketing to her to save the postage. And you said? I said congratulations. You've just fired your best customer because she didn't behave like she buys coffee. That's the trap, then. The math built for people who buy every week. Exactly. So let's build it from the floor up, because this is where most hotel marketers quietly get it wrong. Lifetime value. LTV. What a customer is worth to you across the whole relationship. The standard formula assumes rhythm. Average purchase. Times how often they buy. Times how many years they stick around. And for a coffee subscription, that's fine. Beautiful. Buys monthly. You can predict it. But a resort guest isn't monthly. She's a comet. She swings past every three or four years, spends a fortune, then vanishes into the dark. If you measure her by frequency, the formula sees long gaps and reads abandoned. It can't tell the difference between someone who left and someone who's simply between orbits. So the fix is what? Just be more patient? Patience isn't a model. The fix is to stop measuring frequency and start measuring the pattern of the gaps. You look at your genuinely high value guests and you ask, what's the normal interval between their stays? If your anniversary couples come back every four years like clockwork, then year three isn't churn. Year three is Tuesday. How do you actually calculate that without kidding yourself? You segment first. Separate the comets from the coffee drinkers, the irregular high spenders from the once and done crowd. For the comets, you model expected visits over a realistic horizon, say 20 years, using their real return interval, not a monthly average. Forester's work on customer valuation makes this point hard. Blended averages destroy value in businesses with lumpy purchasing. When you average a comet with a tourist who came once for a Groupon, you get a number

Host:that describes nobody. Give me the difference in dollars. Make it hurt.

Expert:Same guest, two methods. Standard frequency model saw her going quiet, projected maybe one more visit, valued her around 8,000, rebuild it on a four year interval across a 20 year relationship, and she models at 52,000. That's the swing. That's whether you send her a handwritten note from the

Host:general manager or nothing at all. You mentioned software flags. Her is churned. Who's software and should I trust the churn number it spits out? HubSpot's

Expert:tooling will happily calculate churn and l T V for you, and it's fine. But remember, they sell the customer relationship software, so their default settings assume the frequent buyer world their product was built for. HubSpot has put retention cost multiples in the 5 to 25 range depending on the study, though worth noting they're a vendor. So cross check against Forester before you quote it in a board deck. Same with SEMrush on acquisition costs for travel keywords useful, but they sell the analytics tools. So treat their numbers as a starting point, not scripture. What's the mistake even smart operators make here? They mistake silence for rejection. A guest not booking isn't a guest saying no. She's a guest whose life hasn't lined up with another trip yet marketing to her in the quiet years. A birthday message, a note when a sweet she loved is renovated. That's not waste. That's keeping the runway lit for a plane that lands

Host:every four years. So if a marketer does one thing Monday morning, what

Expert:is it? Pull your top 100 spenders. Calculate the real average gap between their stays. Anyone inside that gap window. Take them off your turn list today. You're not chasing the dead. You're just standing at the door for people who are always going to come back. What we read for this one,

Host:Forester research, SEMrush, vendor, SEO analytics tools, DigiDay, HubSpot, vendor, CRM marketing automation. We'll leave it there. The CMO self assessment at MBA dash training.com will tell you where you really stand.

Read and go deeper