Calculating Customer Lifetime Value from WiFi Session Data

Why CLV Is the Number Most Venues Are Not Tracking

Most operators know their average bill. Far fewer know what a regular is worth over the whole time they keep coming in. That second number is customer lifetime value (CLV), and it changes how marketing costs look.

A €5 voucher looks expensive next to a €9 coffee order. It looks cheap next to a guest who would otherwise spend a few hundred euros with you over the next two years. Same voucher, different decision, depending on which number you hold it against.

Guest WiFi does not hand you CLV directly. What it does give you is a dated record of when each known guest logged in, which is most of what the calculation needs.

The CLV Formula for Hospitality

The simple version:

CLV = visits per year × average spend per visit × expected years as a customer

Where each input comes from:

Visits per year. Count the distinct days each guest logged in over a period and annualise it. Count days, not sessions: a guest who drops off the network and reconnects twice in one lunch is still one visit. VoqadoWiFi counts visit days per guest in venue local time for this reason. Work this out per segment (regulars, occasional guests), not as one venue average, because a handful of daily regulars will drag the average far away from a typical guest.

Average spend per visit. WiFi data does not know what anyone spent. Take this from your till: the average ticket for the daypart your regulars mostly come in. VoqadoWiFi has no POS link, so this number is yours to bring.

Expected years as a customer. Work out what share of a group stops visiting each month (monthly churn). Expected lifetime in months is roughly 1 divided by that rate. This assumes churn stays steady, which it rarely does exactly, so treat the result as an estimate, not a forecast.

Two honest caveats before you trust the output. First, WiFi only sees visits where the guest connects. Regulars whose phones stay on mobile data, or who never log in again after the first time, look less frequent than they are. Second, you need at least several months of history before the churn figure means anything.

Illustrative example: Independent Café

Illustration, not a benchmark. Every number here is an assumption chosen to show the arithmetic.

A café looks at guests in its Regulars segment:

• They visit about twice a week. Over 50 trading weeks that is 100 visits a year.
• The till average for a morning order is €9.
• Each month, about 4% of last month's regulars stop coming. Expected lifetime is 1 ÷ 0.04 = 25 months, or about 2.08 years.

CLV (revenue) = 100 × €9 × 2.08 ≈ €1,875 per regular

If the café's gross margin on those orders is 65%, the contribution from one regular is about €1,219. Use the margin figure, not revenue, when you compare it with what you spend to keep that guest. A €3 cost of offer to bring back one lapsing regular is small against either figure, but only the margin figure tells you what you actually keep.

Segmenting CLV by WiFi Cohort

One venue-wide CLV hides more than it shows. Group guests by the month they first logged in (the March cohort, the April cohort and so on) and track how many of each cohort are still visiting 1, 3 and 6 months later.

Older cohorts give you the most reliable lifetime estimate because you can see what they actually did. Newer cohorts tell you whether something you changed (a new menu, a loyalty card, a thank you message after the first visit) is keeping new guests longer than before.

In VoqadoWiFi, the dashboard segments give you a quick read without building cohorts by hand: Regulars (visited on 3 or more days in the last 60, most recently under 30 days ago), At risk (was a regular, no visit for 30 to 89 days) and Lost (no visit for 90 days or more). Watching how many guests move from Regulars to At risk each month is a rough churn signal. For proper cohort tables, export the guest list as CSV and work in a spreadsheet.

Using CLV to Justify Marketing Spend

Once you have even a rough CLV, three spending questions get easier.

Cost of collecting a guest. Divide what you pay for the WiFi platform each month by the number of new guests who opted in to marketing that month. Illustration: on the Growth plan at $49 a month, 350 new opted in guests in a month works out at 14 cents each. On the free Starter plan (up to 500 guest logins a month, one location) the platform cost is zero and your cost is the hardware and the internet line you already pay for.

Cost of winning back a lapsing regular. Add the cost of the offer to any sending cost and divide by the number of guests who actually came back. Run it on guests in the At risk segment first: they are recent enough to remember you. VoqadoWiFi has "we miss you" messages at 30 and 60 days without a visit; they are off by default and switch on venue by venue as guest email goes live.

Spending more on your best guests. It is reasonable to spend more per head on guests with a higher lifetime value, but check it with your own numbers. Compare the CLV of your Regulars segment with the CLV of everyone else before you decide how much more.

When not to bother: if you have fewer than a few hundred known guests, or under six months of visit history, the churn figure will swing too much to be useful. Collect data first and come back to this.