Share:
Studio 1 · Lead Analytics

Show Rate — CRM Report vs Our Report

📅 Wed, 26 Aug 2026 → Tue, 22 Sept 2026  ·  the same show rate measured two ways, side by side
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 calendarShow RateBookedShow %
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 calendarShow RateBookedShow %
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.