Calculate a sales meeting no-show rate only after defining the population and denominator. Include only records with a final attendance decision, and apply the same rules to every comparison. The same label can describe an empty conference room, a missed event registration, an empty desk, or a prospect who skipped a booked sales demo; those figures answer different questions.1 A precise rate can still answer the wrong question if its population or denominator is undefined. Define both before comparing sources or reminder cadences.
Define the population
Decide which meetings enter the measurement and whose absence counts. This keeps attendance failures separate from other meeting failures.
The meeting no-show rate is the share of scheduled meetings where the required attendee did not join.2 Put that definition in the report before pulling records, including the meeting types, required attendee, and reporting period.
Keep attendance separate from conversion. A booked-meeting count includes no-shows and cancellations and therefore measures a different failure.3 Tracking no-show rate separately shows whether the problem is getting buyers into the room or converting the people who attend.4
Clean the records
Resolve every record into a final attendance outcome before doing the arithmetic. Keep records without an outcome in a separate queue until someone can classify them.
Mark each no-show as an explicit outcome so the data can be pushed into a CRM for rate analysis.5 Use one status vocabulary across sources and representatives. Keep the raw meeting record behind each status so unusual changes can be audited.
Freeze the status set at the reporting cutoff. A meeting without a final outcome should not quietly become a show or a no-show because the dashboard needs a number.
Calculate the rate
After the included records have an outcome, use one formula and leave it unchanged across reports. The denominator should contain meetings that ended in attendance or attendee absence.
Use attendee no-shows / (held meetings + attendee no-shows) as the meeting no-show rate.6 This is the share of attendance decisions that ended in a no-show.
Check the denominator whenever the result moves sharply. The same 60 no-shows can read as 6.00 percent or 8.82 percent depending on which records you divide by.7 A changed denominator can create the movement you were about to attribute to a source, representative, or reminder cadence.
Store the numerator, denominator, and resulting rate together. The next person can then reproduce the result instead of relying on a percentage without its record set.
Compare segments
Use the overall rate as a starting point, then cut it by fields that can affect how the meeting was created or handled. Keep the population and status rules identical in every slice.
Break the metric down by meeting source, including inbound, outbound, partner, and event, to see where no-shows are most common.8 Keep source labels stable so a naming change does not look like a change in attendance.
For each source, record who books the meeting and how quickly booking follows the point when intent peaks.9 For reminders, record cadence, channel, and sender identity as separate fields.10 This shows whether a difference follows the source, timing, or reminder setup.
Keep routing visible by recording who receives the meeting and how no-shows are credited back.11 Use the number of meetings with a no-show outcome for the report's y-axis.12 The report can then show how many no-shows occur by representative and whether efforts to reduce them are working.13
Before comparing a segment with the overall rate, check that both use the same exclusions. A source with more pending or invalid records can look better or worse because of record handling alone.
Interpret movement
Use a change in rate to choose the next place to inspect. The rate describes attendance, while the cause may sit earlier in the booking path.
Show rates reflect upstream channel selection, messaging, and the intent level of people who reach the booking page.14 A high rate in one source should send you back to the source, message, booking path, and qualification record before you change reminders.
When a substantial portion of meetings booked by Sales Development Representatives are no-shows, the meeting metric can become inflated and misleading, while sales resources' time is wasted.15 Read the attendance rate beside the booking source and routing fields so a weak result points to a place you can inspect.
What not to do
These mistakes make a clean formula answer a different question from the one you intended.
- Do not put cancelled, rescheduled, or invalid bookings into the denominator.16
- Do not leave pending meetings in a live dashboard denominator, because they lower the apparent no-show rate.17
- Do not calculate show rate as one minus no-show rate unless cancelled, rescheduled, pending, and unverified records have already been excluded.18
- Do not average published B2B no-show figures across your report. Their populations and denominators differ, so the result has no reliable comparison value.19
Put the formula and exclusion rules beside every report so each segment can be read on the same basis.