Case Study
How a 100+ Shop MSO Got Real-Time Visibility Into Every Location
The Challenge
In late 2023, Quality Collision Group was growing fast. With 40+ OEM-certified collision repair centers and aggressive acquisition plans, their leadership team faced a familiar problem.
And worse—when something went wrong at a shop, leadership found out late. A cycle time spike would show up in month-end reports. WIP aging would surface when someone finally ran the numbers. Problems festered because no one was watching in real-time.
QCG had API access to CCC. The data was there. They just needed someone to unlock it.
The Solution
We built a complete operational analytics platform that pulls data directly from CCC's API, loads it into a cloud data warehouse, and serves it in dashboards that load in seconds—with automated alerting.
| Metric | Before | After |
|---|---|---|
| Vehicles Delivered (all time) | Crashes CCC | 2 seconds |
| Vehicles Delivered (1 year) | 8-10 minutes | 2 seconds |
| Compare two shops | 20 minutes | 2 seconds |
| Compare all 100+ shops | Impossible | 2 seconds |
Same data. Same accuracy. No waiting.
QCG leadership now gets notified automatically when:
No more finding out about problems in month-end reviews. No more PE sponsors asking questions before you have answers.
What We Built
A single screen showing company health. WIP count, cycle time trends, sales velocity, gross profit—all updated nightly, all loading instantly.
Current count by shop. Age distribution. Vehicles delivered but not closed. Automated alerts when WIP ages past threshold.
Every location side-by-side on the same metrics. Sortable, filterable, comparable.
Averages, distributions, outliers. Flagged a shop averaging 37-day cycle times—before it became a pattern.
Tracks qualifying parts purchases across all locations to ensure QCG captures every dollar of manufacturer incentives.
Technical Implementation
Nightly sync via CCC SOAP API. 23 report types. Full history in BigQuery. Incremental updates throughout the day.
Executive TV dashboard. Shop scorecard. WIP tracking. Cycle time analysis. Ford rebate reporting.
Sync failure alerts. KPI threshold alerts. Daily WIP snapshots. Trend monitoring.
Results
Data infrastructure scaled seamlessly with acquisitions. New shops integrated within days, not weeks.
All-time queries that crashed CCC now load instantly. Leadership stopped waiting and started acting.
Every shop comparable on the same metrics. Anomalies surfaced automatically—including a shop averaging 37-day cycle times.
Quality Collision Group is one of the fastest-growing OEM-certified collision repair organizations in the United States. Backed by Susquehanna Private Capital, QCG operates 100+ locations across multiple states with a focus on premium repairs and exceptional customer experience.
If you're running 10+ shops on CCC ONE and tired of waiting for reports—or finding out about problems after they've already hurt you—let's talk.
Schedule a Call