Define show rate once
Pick one definition and write it down. Mine is simple: meetings held, divided by meetings that were due to happen in the period. Count a meeting on the date it was scheduled for, not the date it was booked. If you mix these up, your trend moves for reasons that have nothing to do with the prospect.
Use three numbers, each with one fixed formula:
- Show rate is held meetings divided by held meetings plus no-shows.
- Cancel rate is meetings cancelled with notice divided by all meetings due.
- Reschedule rate is rescheduled meetings divided by all bookings.
A rescheduled meeting is one booking, not two. Count it again only if it ends as held or a no-show.
Log every meeting with the same six fields
You cannot analyse what you did not record. For every meeting, store the booking date, the meeting date and time, the source, the meeting type, the owner and the outcome. Outcome has four allowed values: showed, no-show, cancelled and rescheduled.
Put these fields in your CRM, for example HubSpot or Pipedrive. A Google Sheets tab is fine while you book fewer than 40 meetings a week. The rep sets the outcome within one working day. A blank outcome is the most common reason this report ends up useless, so check for blanks every Friday.
Read the weekly trend first
Plot show rate by week, then add a rolling four-week average. Single weeks are noisy. With only ten meetings, one no-show moves the rate by ten points, and that is not a trend.
Agree a trigger in advance. For example: if the rolling average falls more than ten points below your normal level, you investigate that week. Without a trigger, the chart becomes decoration.
Split by source
Group meetings by where the booking came from: website form, outbound reply, referral, event, paid ads. This is where the biggest gaps usually show up. A prospect who asked for a conversation after an introduction behaves differently from one who ticked a box to download a guide.
Say your referral meetings show at 90% and your paid ad meetings at 55%. The fix is not one new reminder for everyone. Paid leads may need a confirmation step, a shorter booking window or a qualifying question. Referrals may need nothing at all.
Split by lead time
Lead time is the number of days between booking and meeting. Make four buckets: same or next day, two to four days, five to nine days, ten days or more. Expect the show rate to fall as the gap grows, because the prospect's week changes and the reason they booked fades.
If the long buckets are weak, show only slots within the next week on your booking page. Our chapter on meeting setup covers how to configure that.
Split by weekday and time slot
Group slots into blocks: early morning, mid-morning, lunch, afternoon, late afternoon. Then look at weekdays. Monday first thing and Friday afternoon are common weak spots, but check your own data rather than trusting a rule.
When one block is clearly worse, take it off the booking page for a month and see what happens to the overall rate. That is a cheap test with a clear answer.
Check the sample size before you act
A segment with fewer than 30 meetings is a hint, not evidence. Write it down and watch it. Combine neighbouring segments, for example two quarters instead of one, until the numbers are large enough to trust.
Turn each finding into one change
End every review with one decision. If a source is weak, change the confirmation for that source. If lead time hurts, shorten the window. If a slot is weak, remove it. Then follow up with the chapters on testing reminder timing and copy and reschedules and no-shows.
Common mistakes
- Reporting one blended number and calling it a trend.
- Counting reschedules as new bookings, which inflates the denominator.
- Changing three things in the same week, so nobody knows which one worked.
- Reading small segments as if they were facts.
- Leaving the outcome field to memory instead of making it part of the meeting wrap-up.
How you know it works
On Monday morning you can answer three questions in under ten minutes: what was last week's show rate, which source or slot is dragging it down, and what are you changing about it. After a quarter, the weakest segment has moved up and the gap between your best and worst source has narrowed. If you cannot answer those questions, the logging is the problem, not the prospects.
