The Clerb blog
Posts, guides, and updates from the team building Clerb.
Filtered by tag: engineeringClear
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.