A custom analytics platform on top of CCC ONE. Reports that crashed CCC now load in 2 seconds. Leadership stopped finding out about problems at month-end.
The Challenge
Late 2023. QCG was running 40+ OEM-certified collision repair centers and acquiring more every quarter. Their leadership team couldn't see the operation in real time — and the data was sitting in CCC, just out of reach.
And worse — when something went wrong at a shop, leadership found out late. A cycle-time spike would surface in month-end reports. WIP aging would emerge 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
A complete operational analytics platform: nightly pulls from CCC's API, normalized into a cloud warehouse, served as dashboards that load in seconds — with alerting that catches problems before they become patterns.
Same CCC data. Same accuracy. No waiting.
Leadership used to ask why a shop's cycle time was off — and we'd find out next month. Now we get the alert before anyone notices.
Know first, not last
Static thresholds and statistical anomaly detection running on top of the warehouse. Alerts hit Slack, email, and the dashboard the moment a metric crosses.
No more finding out about problems at month-end review. No more PE sponsors asking questions before you have answers.
What We Built
One screen, the whole company. WIP count, cycle time trend, sales velocity, gross profit — synced nightly, rendered instantly, shown on screens at HQ.
Current count by shop. Aging buckets. Delivered-not-closed list. Automated alerts when WIP ages past threshold or jumps a band overnight.
Every location side-by-side on the same metrics. Sortable, filterable, drillable. The view PE sponsors actually want.
Median, p90, full distribution. Carrier and severity splits. Flagged a shop averaging 37-day cycle times — before it became a pattern.
Tracks qualifying parts purchases across all locations. Reconciles to manufacturer-incentive payouts so QCG captures every dollar earned.
Technical Implementation
Boring infrastructure on purpose. Each layer does one thing well, every layer is observable, every failure has a runbook.
Results
Data infrastructure scaled with the M&A pipeline. New shops onboarded in days, not weeks. Same dashboards, same KPIs, same numbers — day one.
All-time queries that used to crash CCC now load instantly. Leadership stopped waiting for reports and started using the data the morning it landed.
Every shop comparable on the same metrics. The 37-day cycle-time outlier surfaced automatically — before it became a pattern leadership had to explain.
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 — tired of waiting for reports, or tired of finding out about problems after they've already hurt — let's talk.
Schedule a Call →