SGA Phone-Conversion Findings — Peerlogic Network Analysis

2-slide explainer • As of 2026-05-27
Slide 1 — Thesis (the "what")
Phase: Action • As of 2026-05-27

60% of SGA's missed calls are stuck in 51 broken phone lines.

60%
of network missed calls concentrated in just 51 DIDs
51
broken DIDs
18,082
missed calls (Jan '25 – Mar '26)
What we found
  • 51 DIDs across the network ring 80%+ unanswered
  • Combined: 18,082 missed calls over 10 months (Jan 2025 – Mar 2026)
Fixing routing + staffing on these 51 lines recovers the single largest call-handling lever in the network.
Worst three practices (practice-level rollup)
New Horizons Dental Care
600 missed / 608 calls (98.7%)
Dr. Anthony Bain Dentistry for Children
469 missed / 472 calls (99.4%)
Nashville Aesthetic Dentistry
337 missed / 391 calls (86.2%)
Phase: Action These aren't analytical curiosities — they're operations work.
SGA Dental Partners • Peerlogic Phone-Conversion Brief • Slide 1 of 2
Slide 2 — Methodology & Evidence (the "how I know")
Source: Peerlogic SQL • 72 practices • 1,270 DID-months

How the 60% / 51-DID finding was built

Source
Peerlogic SQL backend export — "Gen4 SQL Output" Google Sheet (1P-Uo-81TKVj0WVskWFP6VyVGnqaVvuEzPoBwIcfg6mI)
Method
Per-DID rollup, sum-all-rows across the 10-month window. Matches Peerlogic per-practice dashboard within ~1% on missed calls and ~2.5pt on NP conversion (validated March 2026).
Coverage
72 practices • 1,270 DID-months • 87,841 total calls
Window: 2025-01 → 2026-03 (10 months)
Definition of "sink"
DID with ≥100 calls AND ≥80% missed across the window.
Network context
30,167 missed of 87,841 calls (34.3%).
Top 51 sinks = 18,082 missed (59.9% of all missed).
Top 10 broken DIDs by missed calls
# Practice / DID Missed / Calls % Missed
1
Peak Family Dental Care - Flagstaff
+19284408207
3,133 / 3,13599.9%
2
Peak Family Dental Care - Flagstaff
+19287742500
3,121 / 3,14199.4%
3
Northeast Texas Periodontal Specialists - Rockwall
9727718640
882 / 882100.0%
4
Peak Family Dental Care - Flagstaff
+19287740131
638 / 638100.0%
5
Peak Family Dental Care - Flagstaff
+19287742500 <4001>
635 / 64798.2%
6
New Horizons Dental Care
+17858257197 <4001>
509 / 51698.6%
7
Peak Family Dental Care - Flagstaff
+19284401288
473 / 473100.0%
8
Apache Dental Center
+14809824200 <4001>
437 / 46394.4%
9
Dr. Anthony Bain Dentistry for Children
+15129896900 <4001>
417 / 42099.3%
10
Peak Family Dental Care - Flagstaff
+19284408856
382 / 38599.2%

Caveats

  • Ad-hoc Peerlogic SQL pulls — not a clean monthly trend yet
  • Monthly subset uneven (1–6 practices per month in current pull)
  • Some DIDs may be deprecated already — sink list needs ops validation

Next steps

  • Phone audit list to OM / Ops Director per practice
  • Activate Daybreak T03 Call Conversion tile (in progress)
  • Re-pull Peerlogic SQL with consistent monthly schema for trend
Validation tier: matches Peerlogic dashboard within ~1% missed / ~2.5pt NP conversion. • Slide 2 of 2