Calculating guest lifetime value from WiFi data
Key takeaways: WiFi data provides two of the three inputs needed for lifetime value calculation: visit frequency and retention duration. The third input — average spend per visit — comes from the POS or the venue operator's estimate. A restaurant guest who visits twice per month, spends $35 per visit, and remains active for 24 months has an LTV of $1,680. Knowing this number changes every marketing decision: how much to spend on acquisition, how much to invest in retention, and how to prioritize different guest segments. WiFi data makes LTV calculable for venues that never had access to this metric before.
LTV calculations in this article use simplified models for clarity. Actual models may incorporate discount rates, margin adjustments, and cohort-specific retention curves.
Ask a restaurant owner what a customer is worth, and they'll say "$35" — the check average. They're off by a factor of 50.
A customer who visits twice a month and stays for two years is worth $1,680 in total revenue. A customer who visits once, spends $35, and never returns is worth $35. Both look the same on a single visit. The difference is entirely in what happens after.
WiFi data reveals what happens after. It tracks return visits, visit frequency, and retention duration — the inputs that turn a single transaction value into a lifetime value.
The LTV formula
The simplest customer lifetime value formula:
LTV = Average Spend Per Visit × Visit Frequency Per Month × Average Customer Lifespan (months)
WiFi data provides: visit frequency and customer lifespan. The venue provides: average spend per visit (from POS or estimate).
Example calculations by vertical
Restaurant:
- •Average spend: $35
- •Visit frequency: 2x/month (from WiFi visit data)
- •Customer lifespan: 18 months (from WiFi retention curve)
- •LTV = $35 × 2 × 18 = $1,260
Gym:
- •Average membership: $50/month
- •Visit frequency: 3x/week (from WiFi presence data)
- •Customer lifespan: 14 months (from WiFi + membership data)
- •LTV = $50 × 14 = $700 (membership-based, not per-visit)
Coffee shop:
- •Average spend: $6
- •Visit frequency: 4x/month
- •Customer lifespan: 24 months
- •LTV = $6 × 4 × 24 = $576
Hotel (annual return):
- •Average spend per stay: $450
- •Visit frequency: 1.5x/year
- •Customer lifespan: 4 years
- •LTV = $450 × 1.5 × 4 = $2,700
How WiFi data makes LTV calculable
Visit frequency (from WiFi connection data)
The WiFi platform tracks every connection per contact. Calculating visit frequency is straightforward:
Jane's connections: Jan 5, Jan 12, Jan 19, Jan 26, Feb 2, Feb 9, Feb 16...
Visit frequency: 1x/week = 4.3x/month
Aggregate across all contacts to get the venue's average visit frequency. Segment by visitor type to see frequency differences:
| Segment | Avg Visits/Month | % of Database |
|---|---|---|
| Weekly regulars | 4.2 | 15% |
| Biweekly visitors | 2.1 | 25% |
| Monthly visitors | 1.0 | 30% |
| Occasional (< monthly) | 0.4 | 20% |
| One-time visitors | N/A | 10% |
Customer lifespan (from WiFi retention curves)
Customer lifespan is harder to measure than frequency because you need to observe when customers stop coming. WiFi data enables this by tracking the "last visit" date for every contact.
Method: Cohort retention analysis
- •Group contacts by their first-visit month (January cohort, February cohort, etc.)
- •For each cohort, track what percentage are still active (visited at least once) in each subsequent month
- •The retention curve shows how quickly each cohort decays
Example retention curve:
| Months After First Visit | % Still Active |
|---|---|
| 1 | 45% |
| 2 | 38% |
| 3 | 33% |
| 6 | 25% |
| 12 | 18% |
| 18 | 14% |
| 24 | 11% |
Average lifespan calculation: The area under the retention curve equals the average customer lifespan. For the curve above:
Average lifespan ≈ 0.45 + 0.38 + 0.33 + 0.33 + 0.33 + 0.25 + ... ≈ 5.5 months (for the average customer, including one-time visitors)
Excluding one-timers: If you exclude contacts who visited only once (since they never became customers), the retention curve improves significantly. Average lifespan for contacts with 2+ visits: 12–18 months at most venues.
This is why the first-to-second-visit conversion is so important. Getting a one-time visitor to return doubles or triples their projected LTV because they've entered the retention curve for multi-visit customers.
Segmented LTV
Not all guests have the same LTV. Segmenting by behavior reveals where the real value concentrates.
LTV by visit frequency
| Segment | Visits/Month | Lifespan | Avg Spend | LTV |
|---|---|---|---|---|
| Weekly regulars | 4.2 | 24 months | $35 | $3,528 |
| Biweekly | 2.1 | 18 months | $35 | $1,323 |
| Monthly | 1.0 | 12 months | $35 | $420 |
| Occasional | 0.4 | 6 months | $35 | $84 |
| One-time | 1 visit | 0 months | $35 | $35 |
The top 15% of guests (weekly regulars) generate 10x–100x the value of one-time visitors. This concentration is typical across all venue types.
LTV by email engagement
Contacts who engage with email campaigns visit more frequently and stay active longer. The data usually shows:
| Engagement Level | Visits/Month | Lifespan | LTV Multiplier |
|---|---|---|---|
| High (40%+ open rate) | 3.8 | 22 months | 2.5x average |
| Medium (15–39%) | 2.4 | 16 months | 1.5x average |
| Low (<15%) | 1.2 | 10 months | 0.7x average |
| No engagement | 0.6 | 4 months | 0.3x average |
Email engagement is both a predictor of high LTV and a driver of it. Contacts who read emails are reminded to visit. Contacts who are reminded visit more. The causal arrow runs both directions.
Using LTV in marketing decisions
Acquisition budget
If a guest's LTV is $1,260, how much should you spend to acquire them?
Rule of thumb: Spend up to 10–20% of LTV on acquisition. For a $1,260 LTV guest: $126–$252 is a reasonable acquisition cost.
Most WiFi marketing platforms cost $49–$199/month. At $49/month, the platform captures 1,000+ contacts/month. CPL: $0.05. Even the most conservative LTV calculation makes the platform cost trivially small relative to the lifetime value it generates.
Retention investment
The jump from "one-time visitor" ($35 LTV) to "biweekly visitor" ($1,323 LTV) is a 37x increase in value. That jump is driven by the first automated welcome email that brings them back for a second visit.
What this means: A welcome email that costs $0.002 to send and converts 10% of first-time visitors into biweekly visitors is the highest-ROI marketing action available to any venue.
VIP treatment thresholds
If weekly regulars have an LTV of $3,528 and represent 15% of the database, they deserve VIP treatment:
- •Personal recognition from staff
- •Exclusive offers and early access
- •Referral program enrollment (their referrals are likely similar high-value profiles)
- •Win-back investment if they show signs of churn (a $20 incentive to save a $3,528 relationship is 0.6% of LTV)
Presenting LTV to clients
The revelation conversation
Most venue operators have never calculated LTV. Showing them the number is a revelation.
"Your average guest who comes back more than once is worth $1,260 over their lifetime. Right now, you're losing 60% of first-time visitors after one visit — each one of those is a $1,260 relationship you're throwing away. The welcome email sequence costs $0.002 per send. If it recovers even 50 of the 300 first-timers you lose every month, that's $63,000 per year in protected revenue."
That's a conversation that sells WiFi marketing at any price point.
The report
Include LTV data in the monthly client report:
| Metric | Value |
|---|---|
| New contacts captured this month | 1,200 |
| Estimated lifetime value of new contacts | $378,000 (based on segment-weighted average LTV) |
| First-to-second visit conversion rate | 42% |
| Active regulars (4+ visits) | 480 |
| Estimated annual value of regular base | $201,600 |
When clients see their marketing platform generating $378,000 in projected lifetime value from $49/month in platform cost, retention conversations become effortless.
FAQ
Can I calculate LTV without POS data? Yes, partially. WiFi provides visit frequency and retention data. For spend-per-visit, ask the venue operator for their average check/ticket amount. Most venue operators know this number within 10%.
How long does it take to calculate a retention curve? Minimum 6 months of WiFi data. At 6 months, you can see the first 6 points on the retention curve. At 12 months, the curve is reliable enough for LTV projections.
What if different venues in the same vertical have very different LTVs? They will. A downtown lunch spot has different frequency and lifespan than a destination restaurant. Calculate LTV per venue, not per vertical. Vertical benchmarks are useful for sales conversations; venue-specific LTV is useful for operations.
Should I discount future revenue (present value calculation)? For precision, yes. Apply a discount rate (10–15% annually) to future revenue. For sales conversations and monthly reports, the undiscounted LTV is simpler and still directionally accurate.
How does WiFi marketing increase LTV? Three mechanisms: (1) Automated welcome emails increase first-to-second-visit conversion, bringing more customers onto the retention curve. (2) Retention campaigns slow the decay rate, extending customer lifespan. (3) Engagement campaigns (events, promotions) increase visit frequency.
Start measuring guest lifetime value at your client venues. Start a free trial and build the visit history data that makes LTV calculable within 90 days.