Calculate Your Detailing Repeat Booking Rate

Why Your Window and Cohort Definition Matter More Than the Rate Itself

The repeat booking rate is a ratio: customers who returned at least once divided by the total distinct customers in your starting cohort, expressed as a percentage. The word 'cohort' is key. You are measuring a specific group of customers whose first visit fell inside a defined period, not every customer who has ever paid you money. If you mix cohorts, you get a blended number that drifts with your business volume and tells you nothing about whether your follow-up habits are improving.

The follow-up window is the maximum number of days after a customer's first visit during which a return booking counts as a repeat. A window that is too short will deflate your rate because some customers simply take longer to need another detail. A window that is too long makes the number almost meaningless because nearly everyone comes back eventually if you wait years. For most detailing services, 90 to 180 days is a reasonable starting point, but you should pick a window based on how long the service you sold actually lasts, not on what makes the number look good.

Step One: Define New Customers Correctly

A new customer is a distinct person or household whose first completed appointment with you falls inside your cohort period. Do not count their vehicle count, their invoice count, or their contact record creation date. Count the person, and count only their first visit. If someone booked two cars in the same month, they are one customer, not two. If your records show a contact created date but the first appointment was three months later, use the appointment date.

Exclude customers who entered through a recurring or maintenance plan if you are trying to measure whether one-time buyers come back. Those customers already committed to a schedule; including them inflates the rate and hides the real question, which is how often customers who paid once on their own terms decide to return without a standing agreement.

Step Two: Count Repeats Without Double-Counting

A customer counts as a repeat once, even if they return five times inside the window. You are measuring whether they came back at all, not how many times. This means a customer who booked monthly interior cleans and a customer who came back once for a wash both count as exactly one repeat booking. If you want to measure visit frequency, that is a separate calculation.

Only count completed appointments as repeats, not scheduled future appointments that have not yet happened. A customer with a future booking looks like a repeat, but you do not know yet whether they will show. If you include future bookings in your rate, the number will drop as those dates pass and some cancel. Measure what actually happened, not what is on the calendar.

Step Three: Pick a Cohort Period You Can Actually Close

A cohort period is closed when the follow-up window has expired for every customer in it. If your cohort is customers whose first visit was in January and your window is 90 days, you cannot calculate the final rate until late April. If you try to measure it in February, most of the window is still open and the rate will look low. This is the most common mistake: calculating repeat booking rate on a cohort that is still in-window.

Pick a past period that is fully closed. For example, if you are measuring in July with a 90-day window, use a cohort whose first visits were no later than March. Everything from April forward is still inside the window and should not be included in the rate you act on today.

Repeat Booking Rate Worksheet

Use this worksheet each time you calculate. Fill in the shaded fields; the formula does the rest. Run it quarterly or whenever you suspect your follow-up habits have changed.

REPEAT BOOKING RATE WORKSHEET

Step 1 — Set the cohort period
Cohort start date: ___________
Cohort end date: ___________
(Choose a period old enough that your follow-up window has fully expired.)

Step 2 — Set the follow-up window
Window length (days): ___________
Window closes on: cohort end date + window length = ___________
Is today past that close date? If no, stop. The cohort is not ready to measure.

Step 3 — Count distinct new customers in the cohort
List each customer whose FIRST completed appointment falls in the cohort period.
Count each person once regardless of vehicle count or invoice count.
Exclude recurring-plan customers (if isolating one-time buyer behavior).
Total new customers (A): ___________

Step 4 — Count customers who returned
For each customer in Step 3, check whether they had at least one additional completed appointment
between their first visit date and (their first visit date + window length).
Count each returning customer once.
Total returning customers (B): ___________

Step 5 — Calculate the rate
Repeat Booking Rate = B divided by A, multiplied by 100
Rate: ___________ %

Step 6 — Note what you will do differently
Did you send a follow-up message after their first visit? Y / N
If yes, how many days after? ___________
What will you change before the next cohort period? ___________

Hypothetical Worked Scenario

Suppose a solo operator named Dana runs a mobile detail business and wants to measure repeat booking rate for January. Dana uses a 90-day follow-up window, so the cohort closes on March 31 and Dana calculates in May when the window is fully expired.

Dana's records show 18 distinct customers whose first completed appointment was in January. Of those, 3 were on monthly maintenance plans, so Dana excludes them, leaving 15 one-time buyers in the cohort. Dana checks each of the 15 customers to see whether they completed at least one more appointment between their first visit and 90 days after that first visit. Six customers returned at least once. Dana's repeat booking rate is 6 divided by 15, or 40 percent. Dana also notices that of the 9 who did not return, Dana only sent a follow-up message to 4 of them, and none of the 5 who received no follow-up came back. That observation does not prove causation, but it is enough for Dana to make follow-up messages standard practice for the February cohort.

Common Traps That Break the Number

The most damaging trap is measuring a cohort that is still open. A second trap is using invoice count instead of customer count, which inflates both the cohort size and the repeat count if customers buy multiple services per visit. A third trap is counting a future scheduled appointment as a completed repeat; this makes your rate look better than it is and then drops unexpectedly when appointments cancel.

A subtler trap is changing your window mid-stream to make the number look better. If you used 90 days last quarter and switch to 180 days this quarter, the two rates are not comparable. Pick a window, write it down, and use it consistently so you can actually see whether your follow-up process is working.

Using Weavr to Gather the Inputs

Calculating this rate manually requires reliable appointment and contact records. Weavr's CRM tracks contacts and appointment history, so you can pull a list of customers whose first appointment fell in your cohort period and check whether a subsequent completed appointment exists within the window. Linking a follow-up task to each first-time appointment gives you a record of whether you actually sent the message, which makes the comparison Dana did above easier to reproduce.

What to Do With the Rate Once You Have It

The rate is only useful if you compare it across cohorts using identical definitions. If your January cohort rate is 40 percent and your April cohort rate is 55 percent, and the only thing you changed was sending a follow-up message to every first-time customer within 48 hours, you have a directional signal worth acting on. That is not proof, but it is more than a guess.

If the rate does not move despite follow-up messages, look at what your messages actually say. A message that just says thanks is not an invitation to rebook. A message that names the specific service performed, notes when it will likely need refreshing, and makes it easy to reply or click a link gives the customer a reason to act. Improving the message content is a separate project from measuring the rate, but knowing the rate is what tells you a project is worth starting.

The practical takeaway

Pick one closed cohort, set a fixed window, count distinct customers once each, and only count completed return visits. Run the worksheet above before changing anything about your follow-up process so you have a baseline to compare against.

Explore the relevant WeavrCRM workflow · Review integrations and requirements