apointoo.
Request access
Healthcare Attribution

No-Show Rate by Original Booking Source: An Internal Reporting Formula

cmsapointoo··7 min read

Calculate no-show rate within each original booking-source cohort. Use finalized no-shows as the numerator and finalized attended appointments plus finalized no-shows as the denominator. Multiply by 100. Keep cancellations, reschedules, future appointments, and open records outside both sides of the formula, then report them separately.

This is an editorial measurement contract for clinic-owned reporting. Zocdoc documents no-show as a distinct post-appointment status and keeps cancellation and rescheduling as separate actions. NHS England publishes an outpatient DNA definition that excludes cancelled appointments from its denominator. Neither source defines the clinic’s booking-source segmentation.

What is the internal no-show-rate formula?

For one original booking source and one defined cohort, use this contract:

no_show_rate = finalized_no_shows / (finalized_attended + finalized_no_shows) * 100

The formula compares two terminal outcomes that answer the same attendance question. The patient either attended under the clinic’s rule or the appointment was finalized as no-show. Records without a final attendance answer stay outside the denominator.

Do not call the result a vendor metric unless the vendor documents the same numerator, denominator, exclusions, time window, and source grouping. This article defines an internal report. The booking system supplies states; the clinic supplies the measurement contract.

What do the official sources establish?

Zocdoc’s Appointment Actions page says a post-appointment status can be updated to arrived or no_show. It defines no_show as the patient not showing up for the scheduled appointment and limits that API action to a stated period after the appointment. The same page documents cancellation and rescheduling separately.

NHS England’s guidance uses specific national attendance codes for its outpatient DNA numerator. Its denominator is total outpatient appointments under the stated NHS scope, excluding cancelled appointments and specified administrative events. It also advises reading DNA rates beside other markers.

Those facts support separating attendance, no-show, cancellation, and rescheduling. The NHS code set is not a universal definition for private clinics, dental practices, or other jurisdictions. Copy the separation principle, then document the clinic’s own eligible population.

Which appointments enter the denominator?

Include only appointments whose scheduled time has passed and whose attendance outcome is final under the clinic’s rule. In the compact model used here, that means finalized attended and finalized no-show records.

Appointment state Numerator Denominator Separate report
Finalized no-show Yes Yes No-show count
Finalized attended No Yes Attended count
Cancelled No No Cancellation count and rate
Rescheduled placeholder or superseded slot No No Reschedule count
Future appointment No No Open pipeline
Past appointment with unresolved status No No Data-quality queue
Test or duplicate record No No Excluded-record audit

The clinic booking outcome taxonomy helps keep these states distinct. Adapt its terms to the operational schedule, then freeze the definitions for the reporting period.

Why group by original booking source?

Original booking source describes where the appointment first entered the schedule. It stays stable when the patient later calls, opens a portal, or asks reception to move the time. Grouping by latest action channel would shift rescheduled bookings into phone or portal cohorts and distort acquisition comparisons.

Marketing source is another field. A website scheduler can receive demand from paid search, organic search, email, or an unknown journey. Report no-show rate by booking source first. Add marketing source as a second approved dimension only when evidence and cohort size support it.

The guide to appointment source versus marketing source explains the two axes. Do not merge them into a broad label such as “Google” or “online.”

How should reschedules be counted?

A reschedule is not a final attendance outcome. Exclude a superseded time slot from both numerator and denominator, keep one booking lineage, and evaluate the final eligible appointment after its new time passes.

If the scheduling product updates one record, the lineage may be straightforward. If it cancels one record and creates another, use a tested clinic-owned rule to connect them. Do not count both records as independent attendance opportunities unless the operational facts show that they were separate appointments.

Preserve the original booking source across the lineage. The article on reporting by original lead cohort shows why later state changes should mature a cohort instead of moving records between acquisition periods.

Why report cancellations and open records separately?

Exclusion does not mean disappearance. A source with a low no-show rate may still have a high cancellation rate. Another may have many future appointments whose outcomes have not matured. Publishing only the no-show percentage can hide both conditions.

Place counts beside the rate: finalized attended, finalized no-show, cancelled, rescheduled, future, unresolved, duplicate, and total received. Readers can then see why the denominator differs from the booking total.

Use the same observation cutoff for every source. Late status updates should enter the next refresh or a documented restatement. Do not freeze favorable sources early while waiting longer for unfavorable ones.

How do you handle local status mappings?

Create a mapping from each scheduling status to the reporting states. Review it with operations because names can be misleading. “Completed” may mean that staff closed a record rather than that the patient attended. “Confirmed” is not an attendance outcome.

  1. List every source status observed in the period.
  2. Assign each to attended, no-show, cancelled, rescheduled, future, unresolved, test, or duplicate.
  3. Record who approved the mapping and when it takes effect.
  4. Reject unmapped statuses from the formula.
  5. Version the rule when the vendor or clinic workflow changes.

Never coerce an unknown status into attended to complete the report. An unresolved count is useful evidence about data quality.

What should the final report show?

Show source, cohort window, observation cutoff, numerator, denominator, rate, excluded counts, rule version, and last source update. Avoid rankings when one source has too few finalized records for a useful comparison.

Keep the report aggregate. Patient identifiers, appointment notes, visit reasons, treatment details, and free text do not belong in a marketing view. If the clinic needs to investigate a data-quality exception, route it to an authorized operational workflow.

No-show rate is one operational measure. Review it beside cancellations, reschedules, booking volume, and cohort maturity, as NHS England’s guidance also recommends using multiple markers when assessing DNA improvement.

A validation checklist before publication

  • The formula uses finalized no-show over finalized attended plus no-show.
  • Every row belongs to one original booking-source cohort.
  • Cancelled, rescheduled, future, and open records are excluded from both sides.
  • Excluded outcomes remain visible as separate counts.
  • Duplicate and test records are removed under a documented rule.
  • Unmapped statuses fail closed into a review queue.
  • All sources use the same cohort and observation cutoff.
  • The report names its rule version and system of record.

Frequently asked questions

Should cancellations count as no-shows?

No under this model. Report cancellations separately and exclude them from the no-show numerator and denominator. NHS England also excludes cancelled appointments from its national outpatient DNA denominator.

Should future appointments enter the denominator?

No. Their attendance outcome is not final. Keep them in an open-pipeline count and include them only after the scheduled time passes and the clinic records a final eligible status.

Does a rescheduled appointment create two denominator records?

Not when both records represent one appointment lineage. Exclude the superseded slot and count the final eligible appointment once. Document how the integration links vendor records.

Is the NHS formula mandatory for every clinic?

No. It is an institutional reporting example with a defined scope and code set. A clinic should document its own contract and avoid presenting a local method as a legal or universal standard.

References

Related articles