📅 Wed, 26 Aug 2026 → Tue, 22 Sept 2026 · the same show rate measured two ways, side by side
✅ This range is settled (leads ~8+ weeks old) — the two bases should line up closely.
CRM Show Rate
55.7%
showed 1,595 ÷ on-calendar 2,865 · appointment date
Our Show %
50.5%
showed 1,226 ÷ booked 2,428 · lead cohort
Gap
+5.2 pp
CRM minus ours — shrinks to ~0 when settled
Our Lead→Show %
3.2%
showed ÷ ALL leads 37,938 — different question
💡 Click any column heading to sort — numbers sort highest → lowest, click again to reverse.
By Supplier — CRM Show Rate vs Our Show %
Supplier
CRM basis — by appointment date
Our report — by lead date
GapCRM − ours (pp)
Lead→Show %showed ÷ leads
On calendar
Show Rate
Booked
Show %
Blue Rooms KIDS
790
60.9%
769
52.4%
+8.5
4.1%
Blue Rooms Other
674
55.2%
610
48.4%
+6.8
3.3%
Alan
516
50.2%
367
52.0%
-1.8
3.5%
Lead Pronto
443
57.8%
383
54.8%
+3.0
3.3%
Neil
391
50.6%
274
41.2%
+9.4
1.7%
Other
23
65.2%
5
40.0%
+25.2
0.5%
Organic
18
50.0%
20
60.0%
-10.0
4.8%
Boost
10
50.0%
0
—
—
—
By City — CRM Show Rate vs Our Show %
City
CRM basis — by appointment date
Our report — by lead date
GapCRM − ours (pp)
Lead→Show %showed ÷ leads
On calendar
Show Rate
Booked
Show %
Florida
733
56.3%
632
51.1%
+5.2
3.2%
Dallas
406
57.1%
359
52.1%
+5.1
3.7%
New York
377
52.8%
331
44.4%
+8.4
3.0%
Boston
359
54.3%
244
48.8%
+5.5
3.2%
Chicago
347
63.1%
306
54.9%
+8.2
3.4%
Houston
324
56.2%
269
52.8%
+3.4
2.7%
Nashville
318
48.4%
251
50.2%
-1.8
3.8%
Unknown
1
100.0%
36
38.9%
+61.1
2.0%
Two ways to measure the same thing — why the columns differ. CRM basis (appointment date) = of the shoots that were on the calendar in this range, how many showed up (showed ÷ on-calendar). This is the exact basis of the CRM’s own Show Rate report, so it always reads settled — the appointment already happened or it didn’t. Cancellations are counted here as no-shows (in the denominator). This is attendance. Our basis (lead date) = of the leads received in this range, what share booked and then showed (Show % = showed ÷ booked). Because it’s pinned to the lead date, a recent range reads low until those leads’ appointments happen (~8 weeks to fully settle). Pick a settled range and it converges on the CRM number — that’s the Gap column shrinking to ~0. Lead→Show % = showed ÷ all leads — a different question again (“of the leads we bought, how many became a show”, ~2–5%). It divides by leads, not appointments, so it’s not comparable to the two Show Rate columns — it’s the true bottom-line output per lead. Recycled (…R) codes fold into their parent. Both sides exclude nothing else.