The Clerb blog
Posts, guides, and updates from the team building Clerb.
Filtered by tag: the-numbers-that-matterClear
How We Track Visit Duration — The Technical Breakdown
Check-in to checkout, in minutes. Distribution analysis, bucketing, outlier handling, and why accurate checkout matters most.
How We Calculate Member Lifetime Value — The Technical Breakdown
Total revenue from a member over their entire relationship. The formula, the cohort approach, and why predictive LTV matters.
How We Track Waitlist Conversion Rate — The Technical Breakdown
From waitlist entry to confirmed booking. State machines, time windows, and the funnel query that measures conversion.
How We Calculate Labor Cost Per Room — The Technical Breakdown
Shift hours times pay rates, divided by rooms served. The allocation model, multi-room shifts, and cost-per-hour-per-room queries.
How We Calculate Peak vs. Off-Peak Ratio — The Technical Breakdown
Classifying hours, counting visits by time bucket, and computing the ratio that drives pricing and staffing decisions.
How We Track Time Between Visits — The Technical Breakdown
Per-member inter-visit intervals. Window functions, rolling averages, and detecting drift before members churn.
How We Measure Room Turnover Time — The Technical Breakdown
The gap between one booking ending and the next one starting. Tracking turnover with booking records, cleaning tasks, and ready-state events.
How We Calculate Add-On Attach Rate — The Technical Breakdown
Attach rate is visits-with-purchases over total visits. Product associations, timing windows, and the queries that drive upsell analytics.
How We Calculate Room Utilization Rate — The Technical Breakdown
Utilization is booked minutes divided by available minutes. The SQL, the edge cases, and why capacity modeling matters.
How We Track Visit Frequency — The Technical Breakdown
Visit frequency is visits per member per time period. Here's how we compute, bucket, and trend it without over-engineering.
How We Calculate Revenue Per Visit — The Technical Breakdown
Every charge tied to the right visit. The data model, query patterns, and edge cases behind reliable RPV calculations.
How We Track Continuous Membership Days — The Technical Breakdown
Store the anchor, not a counter. One date field, one subtraction — how continuous membership tracking actually works under the hood.
Visit Duration — The Metric That Reveals What Your Club Actually Is
Visit duration is the time between check-in and checkout. It reveals what kind of experience your club is actually delivering.
Member Lifetime Value — The Metric That Changes How You Think About Everything
Member lifetime value is the total revenue a member generates over their entire relationship with your club. It changes every decision you make.
Waitlist Conversion Rate — The Metric That Measures Your Recovery
Waitlist conversion rate measures how many people who join a waitlist actually end up in a room. It tells you whether your waitlist is a tool or a graveyard.
Labor Cost Per Room — The Metric That Makes Staffing Decisions for You
Labor cost per room tells you what each room actually costs to operate in human hours and dollars. It's the metric that turns staffing from a guess into a decision.
Peak vs. Off-Peak Ratio — The Metric That Controls Your Margins
Peak vs. off-peak ratio measures how evenly your traffic spreads across operating hours. It determines whether you're staffing for reality or for fiction.
Time Between Visits — The Early Warning System You're Not Using
Time between visits measures the gap between a member's consecutive visits. It's the early warning system that tells you who's drifting away.
Room Turnover Time — The Hidden Cost Between Every Booking
Room turnover time is the gap between one member leaving and the next one entering. It's where your invisible costs live.
Add-On Attach Rate — The Metric That Turns Visits Into Revenue
Add-on attach rate measures how often members buy something beyond their base admission. It's the number that tells you whether your menu is working.
Room Utilization Rate — The Metric That Shows What You're Actually Selling
Room utilization rate is the percentage of your available room-hours that are actually being used. It's the metric that tells you whether your facility is an asset or a liability.
Visit Frequency — The Metric That Predicts Whether They'll Stay or Leave
Visit frequency isn't about counting visits. It's about understanding the rhythm of your members' relationship with your club.
Revenue Per Visit — The Number That Tells You If Your Business Model Is Working
Revenue Per Visit is the single number that tells you whether your pricing, staffing, and upsell strategy are aligned — or quietly bleeding money.
The Metric Your Club Should Be Tracking (But Probably Can't)
Continuous membership days — the unbroken streak of time a member has held an active membership. Here's why it matters and what to do with it.
The Numbers That Matter
A club operator's guide to the metrics that actually move the needle — and what to do with them.