📅 Thu, 9 Apr 2026 → Wed, 6 May 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
53.8%
showed 1,676 ÷ on-calendar 3,116 · appointment date
Our Show %
52.5%
showed 1,507 ÷ booked 2,870 · lead cohort
Gap
+1.3 pp
CRM minus ours — shrinks to ~0 when settled
Our Lead→Show %
3.0%
showed ÷ ALL leads 50,688 — 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 %
Alan
1,730
52.0%
1,028
51.7%
+0.4
2.9%
Neil
395
48.6%
405
46.9%
+1.7
1.9%
Boost
365
52.9%
218
41.3%
+11.6
1.5%
Lead Pronto
359
58.2%
450
53.1%
+5.1
3.0%
Blue Rooms KIDS
253
68.4%
713
58.9%
+9.5
5.2%
Organic
14
64.3%
18
66.7%
-2.4
3.8%
Blue Rooms Other
0
—
38
65.8%
—
4.3%
Other
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
719
50.3%
674
49.9%
+0.5
2.8%
Houston
458
52.6%
383
52.2%
+0.4
2.9%
New York
454
54.0%
450
50.4%
+3.5
2.7%
Chicago
427
60.9%
393
58.8%
+2.1
3.2%
Dallas
412
58.3%
412
53.9%
+4.4
3.1%
Nashville
352
43.2%
319
47.6%
-4.5
3.2%
Boston
291
59.5%
239
58.2%
+1.3
3.2%
Unknown
3
100.0%
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.