A canceled appointment can still become a completed job

TL;DR

• In the invented example, $6,000 is assigned to 60 distinct scheduled jobs, with 42 completed by the cutoff. Acquisition cost is $142.86 per completed job.
• Those jobs create 74 appointment records, including 26 canceled appointments. Twelve canceled appointments later become completed work under the original job IDs.
• Freeze the acquisition group and reporting cutoff. Keep open jobs separate, and attach later rebooks to their original jobs before revising the result.

A homeowner cancels Tuesday's appointment, calls back Thursday and gets the repair done Friday. Your office handled two appointments and completed one job. An appointment export can make that history look like two bookings, one cancellation and one new success.

That can change the number beside the advertising bill even when the underlying work stays the same. Before cutting a campaign because cancellations look high, reconcile the jobs behind those events.

What exactly are you counting?

Use one row per distinct job for the acquisition calculation. Keep appointment events in a second table or beneath that row. The job needs a stable ID, its original inquiry date, acquisition source, appointment history and outcome at the reporting cutoff.

A new appointment ID does not establish a new job. A new repair scope might. Write the rule with your office manager: a return to finish the same agreed work retains the original job; a separate purchased service receives its own job record. Keep any parent-child link your system uses.

Customer identity alone cannot resolve this. The same homeowner can buy a water-heater replacement and a separate drain repair. Merging everything by phone number would erase real jobs. Conversely, treating every fresh calendar entry as new work can multiply a single repair.

The booking-rate guide covers the earlier step from inquiry to scheduled work. This check starts with jobs that already reached the schedule. It cannot calculate an inquiry-to-booking rate without the distinct inquiry denominator.

Cancellations and cost per completed job: a reconciled example

Everything below is an invented teaching example. The business, job counts, dates and costs are made up.

Assume one September acquisition group has $6,000 in assigned acquisition costs. This includes its advertising and assigned campaign fees. Sixty distinct jobs from that group reached the schedule. Freeze their outcomes at October 31, 2026, 11:59 p.m. local time.

Here is the complete history through that cutoff. Each replacement appointment follows one canceled original appointment.

The job outcomes reconcile: 42 completed + 6 open + 12 closed canceled = 60 unique jobs. The appointment events also reconcile: 42 completed + 26 canceled + 6 open = 74 records.

Both totals are correct. They describe different units.

Dividing $6,000 by 74 gives $81.08 per appointment record. Dividing by the 60 distinct jobs that reached the schedule gives $100 per scheduled job. Dividing by the 42 completed jobs gives $142.86 per completed job.

Use the last figure when discussing acquisition cost per completed job. The $100 figure remains useful for a clearly labeled scheduled-job report. Neither measures the cost of performing the work, collections or profit.

Keep recovered cancellations visible

The 26 canceled appointment events include 12 jobs that were completed by the cutoff. Removing every job that ever had a cancellation would discard those 12 completions. Counting their replacement appointments as fresh acquisitions would inflate the acquisition total.

Keep a recovered flag on the job row alongside its final status. Your office can then see both facts: the original slot was canceled, and the work eventually happened. The canceled slot may still have consumed CSR time or left an opening too late to refill.

A useful cancellation review separates customer cancellations, company cancellations and unresolved reasons. The arithmetic above does not establish who caused the empty slot. Have the office inspect the notes before attributing it to lead quality, reminders or dispatch.

Also keep completed and paid separate. A technician marking a job complete establishes neither the collected amount nor the final margin. If the bill is refunded later, preserve the refund against that original job and show the financial revision.

What happens when the customer rebooks next month?

Suppose one of the 12 closed canceled jobs calls on November 7 and completes the original work on November 12. Retain its September acquisition link. Update the current job outcome and preserve the October snapshot.

At a new November 30 cutoff, assume nothing else changes. The same group now has 43 completed jobs, six open jobs and 11 closed canceled jobs. The revised acquisition cost is $6,000 ÷ 43 = $139.53.

That revision does not prove an advertising improvement. More time passed. It also does not create a second acquisition for the same job.

For a comparison between sources, apply the same group definition and cutoff to both exports. When comparing different acquisition months, also give the groups equal observation time. The lead-conversion-delay example shows how an older group can look better merely because it has had longer to produce work.

Write the cutoff beside every result. A report pulled today and a cancellation export pulled last Friday can disagree honestly because they captured different stages.

What this doesn't cover

This reconciliation does not prove which jobs advertising caused or whether the assigned acquisition costs are complete. It assumes the source links and distinct job IDs have already been checked. It excludes job delivery costs, cancellation fees, refunds, collection losses and the financial effect of unused crew time.

The dates and recovery counts are invented. They are neither a contractor cancellation benchmark nor a forecast. Open jobs can still complete or cancel; keep that uncertainty visible.

Do this in your account

Allow 15 minutes for one small acquisition group. Use the same export cutoff throughout.

1. Minutes 0–3: Write the acquisition period, cost scope and cutoff. Export job IDs and appointment IDs with status dates.
2. Minutes 3–6: Join replacement appointments to their original jobs. Inspect five canceled jobs manually to check that the link means the same work.
3. Minutes 6–9: Give every unique job one outcome at cutoff: completed, open or closed canceled. Keep recovered cancellations as a separate flag.
4. Minutes 9–12: Reconcile the job count and the appointment-event count independently. Investigate duplicate completions and unexplained missing rows.
5. Minutes 12–15: Divide the assigned acquisition cost by completed unique jobs. Save the export and record how later rebooks will revise it.

Your worksheet needs only seven job-level columns: job ID, original inquiry date, source, first appointment date, completed date, outcome at cutoff and recovered-cancellation flag. Keep the full appointment history available for exceptions.

More checks for connecting advertising to actual work are in the sold jobs and CRM guides.

Questions owners ask

Should a rescheduled appointment count as a cancellation?

Keep the event according to your operational definition, then show the job's outcome separately. A reschedule can matter for dispatch even when the job eventually completes. Record the definition beside the report so a change in office labeling cannot masquerade as a change in performance.

What if a rebook creates a new job number?

Add a link from the new number to the original acquisition job after confirming the scope. Preserve both system records for the office. Your reporting table can then count the agreed work once.

Should I remove canceled jobs from the advertising cost?

Keep the acquisition expense associated with the whole defined group, including unsuccessful jobs. Removing their share would hide part of the cost of producing the completed work. Show documented credits separately if they reduce the actual acquisition bill.

Sources and method

• SBA: Break-even point, read October 17, 2026. General reference for separating fixed and variable costs.
• The reconciliation, worksheet and all numerical inputs are original hypothetical examples. The SBA source supplies no cancellation or recovery rates.

Lonta AI manages advertising for home service businesses. Bring a reconciled job report to a free strategy review.