Calculating Customer Lifetime Value from WiFi Session Data

Why CLV Is the Most Important Number You Are Not Tracking

Most venue operators know their average transaction value. Few know their average customer lifetime value. The gap between these two numbers explains most marketing decision-making failures in hospitality.

If your average transaction value is €18 and you spend €25 to acquire a new customer via paid social advertising, it looks like a loss. If your CLV is €1,800, spending €25 to acquire a customer with that lifetime value is a 72x return. The same marketing decision looks completely different depending on which number you are using.

WiFi session data gives you the inputs to calculate CLV with meaningful precision — not as a guess based on industry averages, but as a calculation grounded in your specific venue's actual customer behaviour.

The CLV Formula for Hospitality

CLV = Visit frequency (per year) × Average spend per visit × Expected customer lifespan (in years)

Each variable is estimable with WiFi data:

Visit frequency: WiFi session count divided by the period since first login gives you an annualised visit rate per subscriber. For your regular segment (5–9 visits on record), you can calculate visit frequency directly from session data.

Average spend per visit: Requires POS integration for precision, but can be estimated from your average cover value. If your average lunch bill is €22 and average dinner bill is €38, and WiFi session data tells you the split of lunch vs dinner sessions per subscriber, you can estimate average spend per visit with reasonable accuracy.

Customer lifespan: This requires longitudinal data — tracking when cohorts of subscribers stop visiting. After 12 months of WiFi data, you can calculate the churn rate and derive expected lifespan from it. Lifespan = 1 / monthly churn rate.

Worked Example: Independent Café

A specialty café in Berlin has the following WiFi data after 18 months:

• Average visit frequency for Regular segment (5–9 visits): 2.3 visits/week = 120/year
• Average spend per visit: €9.20 (from POS data)
• Monthly churn rate among regular subscribers: 3.2%
• Expected customer lifespan: 1 / 0.032 = 31.25 months = 2.6 years

CLV = 120 × €9.20 × 2.6 = €2,870 per regular customer

This single calculation transforms the economics of customer acquisition and retention. Spending €15 on a win-back campaign (one email with a €5 free item) to recover a regular at €2,870 CLV is not a cost — it is a highly leveraged investment.

Segmenting CLV by WiFi Cohort

CLV varies substantially by acquisition cohort. WiFi data enables cohort analysis: group subscribers by when they first connected (Q1 2024 cohort, Q2 2024 cohort, etc.) and track their cumulative visit frequency over time.

Early cohorts (guests who joined 18 months ago) provide the most reliable CLV data because you can see their actual long-term behaviour. Later cohorts provide less complete data but reveal whether your marketing has changed the quality of new subscriber behaviour over time.

A venue that launched birthday campaigns 6 months ago can compare the visit frequency of post-launch cohorts with pre-launch cohorts to see whether birthday campaigns have improved retention — and by extension, CLV.

Using CLV to Justify Marketing Spend

Once you have a CLV estimate, marketing spend decisions become straightforward:

Acquisition via WiFi portal: Cost per acquired subscriber = platform monthly cost ÷ new subscribers per month. Typical range: €0.04–€0.15 per subscriber. If CLV is €2,870, an acquisition cost of €0.15 is a 19,000x return on the acquisition investment.

Retention via re-engagement campaigns: Cost per recovered subscriber = (campaign cost + offer cost) ÷ subscribers recovered. Typical range: €1.50–€4.00 per recovered regular. Against a CLV of €2,870, this is still transformative.

VIP programme investment: Premium offers for your top 10% of subscribers (VIP segment) are justified at significantly higher per-subscriber cost than general campaigns, because VIP CLV is typically 3–5x the average.