How Ometis helped Johnsons Cars automate daily reporting across 42 dealerships

The challenge

Having grown to 42 car dealerships, Johnsons had inherited multiple systems which meant a complete view of site and staff performance was hard to achieve without lots of manual intervention and input.

Visibility of staff and dealership performance, and sales pipelines across the various markets was difficult due to the number of systems involved, and often required manual data entry. To address this, Johnsons needed a solution to present their orderbook results across the business every day.

The solution

Using QlikView, we created an Order Book Analysis solution combining data from the various systems. This allows any brand, dealership or salesperson to be compared across the group.

It provides a trusted view of the sales funnel across the group and various channels including new or used car orders, GAP insurance, warranty sales and more. Data sources are updated daily without any manual intervention and a report is distributed to Sales and Management teams by email each morning.

The results

We provided daily reports on all key metrics, including order date, vehicle delivery date, cancellation, GAP insurance, warranty sales, delivery trends, cancellation trends, salesperson performance and projected sales forecast.

The solution moved from a time consuming, infrequent exercise to an automated daily process. Johnsons gained greater control of vehicle stocks and a trusted view of the sales pipeline, with easier analysis of brand and dealership performance.

"Johnsons Cars shows what happens when a successful business outgrows their systems. Connecting four different platforms to give them one view across 42 dealerships was complex, but seeing them go from manual reporting to automated daily insights for every salesperson and manager has been brilliant."

Simon Blackbourne, Business Development Director at Ometis

Next steps

Struggling with multiple systems across different locations?

Book a call with our team to see how we can help you automate daily reporting and get complete visibility across your business.