Sample Audit · Data Audit

Express Car Wash Operator Membership data audit

Analysis of 3,820 members from DRB SiteWatch, prepared for the group acquiring the wash. Client identity withheld.

← QWave Labs sample audits Companion: the Growth Playbook → Prepared by QWave Labs
Contents

What's Inside

01 — Executive Summary

The Numbers at a Glance

0
Total Members
$0
Estimated MRR
0
Ghost Members
(30+ days no visit)
0
Payment Risk
(Declined + Expired + Expiring)
Summary

the Operator the location has 3,820 members generating an estimated $147,600/month in recurring revenue. But beneath the surface, 1,025 ghost members and 582 at-risk payments represent over $67,000/month in revenue exposure. This audit breaks down exactly where the risk sits and where the opportunity lives.

02 — Membership Breakdown

Plan Status & Pricing Tiers

Plan Status Distribution

Renewed 3,283 85.9%
Joined 186 4.9%
Discontinued 134 3.5%
Expired 75 2.0%
Transfer In 49 1.3%
Terminated 49 1.3%
Discontinuing 42 1.1%

Plan Pricing Tiers

Tier Monthly Members
Express$24.99388
Premium$39.99274
ExpressFS$49.99253
Full-Service$59.99399
Family Plan$24.99204
Retention Plans$24.99 – $49.99~500+

Top Plans by Member Count

Unl. RockFS Retention
500
Unlimited Full-Service
399
Unlimited Express
388
Unlimited Premium
274
Unlimited ExpressFS
253
Unlimited FamilyPlan
195
Unl. 1x30 Full-Service
185
03 — Visit Frequency Analysis

How Often Do Members Wash?

0 visits/mo
205 (5.4%)
>0 to <1 visit/mo At Risk
958 (25.1%)
1–2 visits/mo Moderate
1,139 (29.8%)
2–3 visits/mo Healthy
762 (20.0%)
3+ visits/mo Power
959 (25.1%)
Retention Insight

Members washing 3+ times in their first 30 days are 76% more likely to stay. Only 25% of current members hit that threshold.

04 — Ghost Member Analysis

Who Stopped Showing Up?

30.6%
25.3%
17.3%
12.9%
6.0%
5.4%
<7 days — 1,169 (30.6%)
7–14 days — 966 (25.3%)
14–30 days — 660 (17.3%)
30–60 days — 494 (12.9%)
60–90 days — 94 (2.5%)
90+ days — 230 (6.0%)
Never used — 207 (5.4%)
<7 days
1,169
7–14 days
966
14–30 days
660
30–60 days At Risk
494
60–90 days Ghost
94
90+ days Dead
230
Never used Dead
207
0
Total Ghost (30+ Days)
26.8%
of All Members
$0
Avg Revenue per Ghost
Critical Insight

Over 1 in 4 members haven't washed in 30+ days. These are cancellations waiting to happen — each one represents $42/month in recurring revenue at risk.

05 — Payment Risk

A Ticking Time Bomb

0
Card Declined
0
Card Expired
0
Credit Card Changed
0
Expiring Soon
(12% of all members)
0
Immediate Risk (Declined + Expired + Changed)
0
Total Including Expiring
Revenue Exposure

At $42/month average, 582 at-risk payments = $24,444/month in jeopardy. Automated card update reminders can recover 40–60% of declined payments before they churn.

06 — Growth & Acquisition

New Member Velocity

0
Joined Last 30 Days
0
Joined 31–60 Days
0
Joined 61–90 Days
0
Total Last 90 Days
(~226/month)

Member Tenure Distribution

<1 month
184
1–3 months
498
4–12 months
802
13–24 months
575
24+ months
1,466
Growth Insight

226 new members joining per month. Strong organic acquisition — but with 225 churning, net growth is nearly flat.

07 — Family Plan Gap

The Untapped Multi-Vehicle Opportunity

0
Family Plan Members
(5.3% of total)
27%
Longer Retention
(family vs. individual)
19 mo
Avg Family Tenure
(vs 15 mo individual)
Opportunity

Industry data shows family plans retain 27% longer (19-month average vs 15-month individual). At $24.99/month, they are the cheapest plan tier — making them an easy upsell from individual Express plans. With 3,616 non-family members, even converting 10% adds 362 stickier members to the base.

08 — Revenue Analysis

Where the Money Lives

$0
Estimated MRR
$41.97
Avg Monthly Membership
24.8 mo
Avg Member Tenure
(median: 14.3 mo)
$0
Total Historical Sales

Additional Revenue Metrics

MetricValue
Retail Wash Revenue (3 months)$36,472
Retail Wash Revenue (monthly avg)$12,157
Detail Services Transactions659
Detail Services Revenue$0
Average $/Wash$44.66
Average Upsell Revenue per Member$1.87
Median Monthly Membership$40.74
Dormant Revenue Stream

The detailing bay had 659 service transactions in DRB but $0 revenue — it has been dormant. With renovation underway, this is a new revenue stream waiting to be activated.

09 — Reputation

Online Standing

4.1
Google Stars
(below 4.3 trust threshold)
Low
Yelp Reviews
(tanked from pre-acquisition)
Context

New ownership took over March 26, 2026. The current review profile reflects the previous operator. A focused reputation management campaign can move the Google rating above the 4.3 consumer trust threshold within 60–90 days.

10 — Key Findings

Five Red Flags That Demand Action

Finding 01

1,025 Ghost Members

26.8% of the membership base hasn't washed in 30+ days. Each one represents $42/month at risk. Total exposure: $43,050/month in recurring revenue that could vanish with a single cancellation wave.

Finding 02

582 Payment Failures

110 declined + 14 expired + 458 expiring soon. That is $24,444/month in jeopardy. Automated card update reminders can recover 40–60% of these before they churn — but only if you act before the cards lapse.

Finding 03

Activation Gap

Average visits per month is 2.24. Only 25% of members are power users (3+ washes/month). The other 75% are underusing their membership — and underused members cancel. The first 30 days are make-or-break for building the wash habit.

Finding 04

Family Plan Desert

Only 5.3% of members are on family plans. Industry data shows family plans retain 27% longer. At $24.99/month, they are the cheapest plan tier — an easy upsell that locks in multi-vehicle households and dramatically improves lifetime value.

Finding 05

$0 Detailing Revenue

659 transactions logged in DRB but zero revenue. The detailing bay has been dormant. With renovation underway, this is pure untapped revenue sitting on site — a new profit center waiting to come online.