November 25, 2024

Transform Your Dealership with a Business Intelligence Tool

Making Metrics Matter: How We Use a Business Intelligence Tool to Transform Our Dealership

When it comes to running a car dealership, data isn’t just a set of numbers—it’s the lifeline of the business. We’ve all been there: staring at reports, wondering how to turn raw stats into real-world improvements. That’s where a business intelligence (BI) tool comes in. For us, it’s become the secret sauce that keeps everything on track, from sales and service to finance and inventory.

But here’s the kicker: it’s not just about having data; it’s about using it. That’s why we track these key metrics, set actionable goals, and build alerts that let us know the moment something needs attention. Let me take you behind the scenes of how we’re working these numbers daily.

Transactions and Sales: Keeping the Big Picture in Focus

Total Transactions

The first thing I check each morning is the number of total transactions. This gives me a bird’s-eye view of how we’re doing across the board. If the numbers are lower than expected halfway through the month, I know it’s time to dig deeper. Are leads converting? Is inventory an issue? For example, last quarter, we noticed a dip in total transactions and found that delays in vehicle deliveries were holding us back. A quick adjustment to our scheduling process made all the difference.

Transactions Per Salesperson

Breaking it down by salesperson is where it gets personal. This metric highlights the individual performance of our team. I can easily see who’s crushing their goals and who might need extra coaching. For example, one of our reps had strong numbers but low profits. A quick coaching session on negotiation strategies helped them strike a better balance between closing deals and maintaining margins.

Trade-Ins: Maximizing Inventory and Sales

Total Transactions with Trade-Ins

Trade-ins are gold. They bring in used inventory and often close the deal for new sales. I keep a close eye on the percentage of total transactions that include trade-ins. If this number dips, it’s a red flag that we’re not offering enough value or communicating the benefits of trading in.

Trade-In vs. Delivered Ratio Per Salesperson

This metric reveals how well each salesperson is converting trade-ins into sales. For instance, if someone has a high volume of trade-ins but few deliveries, it might mean they’re not aligning trade values with customer expectations. A quick role-play session during a team meeting can help refine their approach.

Trade-Ins Sold

Tracking how many trade-in vehicles are sold is just as important. It tells me how effectively we’re reconditioning and pricing these cars to move them off the lot. Recently, we noticed a slowdown in this area, and it turned out our marketing wasn’t highlighting certified pre-owned options enough. A targeted email campaign fixed that in no time.

Inventory Management: The Backbone of the Business

Used Vehicle Purchases

Used inventory is a cornerstone of any dealership’s success, especially in today’s market. If the quantity of used vehicles we’re acquiring starts to drop, it’s a sign we need to adjust our trade-in offers or source vehicles more aggressively.

Real-Time Aging Reports

Every day a vehicle sits on the lot, its profitability shrinks. That’s why I use real-time aging reports to track how long each car has been in inventory. When a vehicle approaches the 60-day mark, alerts trigger adjustments like price drops or enhanced marketing.

Internal Reconditioning Costs

Reconditioning is essential to move used cars, but costs can spiral if you’re not careful. We track the average internal reconditioning cost to ensure we’re staying efficient without cutting corners. For instance, we renegotiated rates with a local service provider when we noticed costs creeping up.

Customer Engagement: Building Long-Term Relationships

Missed Calls

Missed calls are missed opportunities. If I see a spike in this number, I know we need to adjust staffing or review our phone-handling processes. For example, during a recent holiday promotion, we set up an overflow system to handle increased call volumes. It saved countless leads from slipping away.

Follow-Up Calls

Every lead needs attention, and tracking follow-up calls ensures we’re staying on top of customer inquiries. A salesperson once mentioned they were overwhelmed with leads, so we automated follow-up reminders in our CRM. It was a game-changer for efficiency.

Sales and Profitability: Measuring What Matters

Profit Per Salesperson

Profitability is where the rubber meets the road. Tracking profit by salesperson lets us celebrate top performers and identify areas for improvement. One team member consistently hit their volume goals but struggled with upselling. We paired them with a mentor, and their profit per unit skyrocketed.

Overall Closing Rate

The closing rate is a key indicator of how well our sales process is working. If it dips, we dig into the details. Are we qualifying leads effectively? Is there a bottleneck during test drives? Identifying the issue quickly prevents a downward spiral.

Finance Metrics: Navigating Approvals and Refusals

Finance Approvals and Refusals

Understanding the ratio of approved to refused financing applications gives us insights into our customer base. A high refusal rate might mean we need to adjust our advertising to target buyers with better credit or explore additional lending options.

Finance Profit Per Unit

Tracking finance profit per unit ensures our F&I department is contributing to the dealership’s bottom line. If profits drop, it’s often tied to a lack of upselling on warranties or insurance. A refresher training session typically brings these numbers back up.

New and Used Vehicle Deliveries: Staying on Schedule

Deliverable Vehicles

Knowing how many vehicles are ready to be delivered is critical for maintaining customer satisfaction. If delays stack up, it impacts everything—from our reputation to our cash flow. Alerts tied to this metric help us resolve bottlenecks in reconditioning or financing before they affect deliveries.

Ups for New and Used Vehicles

Tracking customer traffic—or “ups”—gives us insight into how effective our marketing efforts are. If ups for used vehicles drop, for instance, it might be time to revamp our online inventory listings or run a targeted promotion.

Profitability Insights: The Bigger Picture

New and Used Vehicle Profit Margins

We monitor profit margins for both new and used vehicles to ensure we’re staying competitive while maximizing earnings. For example, if new vehicle profits are lower than expected, it might signal the need for dynamic pricing adjustments based on market demand.

Total Gross Profit

This is the ultimate metric—the big number that tells us if we’re hitting our financial goals. We review it weekly to ensure all departments are pulling their weight. If it’s lower than expected, we’ll dig into each area to identify and address issues.

Managing Cancellations and Approvals

Canceled Deals

Every canceled deal represents lost revenue, so we keep close tabs on these. A high cancellation rate might indicate customer dissatisfaction or unrealistic expectations during the sales process. Recently, we updated our delivery timelines to be more transparent, which significantly reduced cancellations.

Approval Rates

Approval rates for new and used vehicles are another key area of focus. A low rate for used vehicle financing, for instance, might mean we need to renegotiate terms with lenders to offer better options for customers.

Setting Alerts and Taking Action

Here’s the thing: tracking these metrics is only half the battle. The real power comes from setting alerts that trigger when something needs immediate attention. For example:

  • If the average reconditioning cost for used vehicles exceeds a set threshold, I get a notification to review supplier costs.
  • When missed calls spike during a weekend promotion, an alert prompts us to adjust staffing immediately.
  • If trade-in conversion rates for a salesperson drop below a certain percentage, we schedule a coaching session.

Service Metrics: Driving Efficiency and Customer Satisfaction

When it comes to service departments, metrics are more than just numbers—they’re the heartbeat of the operation. From understanding technician productivity to tracking customer behavior, these insights help dealerships deliver exceptional service while boosting profitability. Let’s break down the key service metrics we help our clients track and how they’re used to stay ahead.

Work Orders (WO) Opened by Advisor

Tracking how many work orders each advisor opens gives a clear view of performance. For example, if an advisor consistently opens fewer WOs than their peers, it might be time to evaluate their approach to customer engagement or upselling.

Revenue Goals and Potential Revenue

Setting revenue goals for service advisors and comparing them to the potential revenue helps dealerships stay focused. By identifying gaps between potential and actual revenue, advisors can prioritize upselling services like alignments, brake replacements, or specialized maintenance.

Work Orders by Type

Categorizing work orders (e.g., internal, retail, warranty, wholesale) helps dealerships understand where their service revenue is coming from. For instance, if warranty repairs are high, it might indicate an opportunity to improve vehicle quality checks or manage manufacturer claims more effectively.

Technician Productivity and Efficiency

  • Productivity per Technician: This measures how much time a technician spends on billable work versus total available time. If productivity dips, we encourage reviewing scheduling or workflow bottlenecks.
  • Overall Technician Efficiency: This looks at the time a technician spends on actual repairs versus the time allotted. High efficiency means technicians are completing jobs on time or faster, which boosts customer satisfaction.
  • Team Efficiency (Excluding Non-Tech Roles): This metric isolates technician performance from other roles, like vehicle washers, giving a clearer picture of how the core team is operating.

Gain Time per Advisor and Technician

This metric tracks how well advisors and technicians use their time to generate additional revenue. For example, if an advisor’s gain time is low, it could mean they’re not maximizing upselling opportunities during service consultations.

Revenue per Work Order

Combining revenue from customer-paid parts and labor into a single metric ($ per WO) gives a comprehensive view of profitability. We help dealerships set alerts if this number drops, prompting a closer look at pricing or upselling strategies.

Active, Inactive, and At-Risk Customers

Understanding customer engagement is crucial.

  • Active Customers: Regularly serviced vehicles and engaged clients.
  • Inactive Customers: Customers who haven’t visited in a while.
  • At-Risk Customers: Clients who show signs of disengagement, like missing scheduled maintenance.

With these insights, dealerships can implement targeted campaigns, like discounts or reminders, to win back at-risk or inactive customers.

Tire Storage and Related Metrics

For dealerships offering tire storage, metrics like the number of stored tires and related services sold provide insights into seasonal opportunities. For instance, upselling new tires during seasonal tire swaps can drive additional revenue.

Customer Satisfaction Index (CSI) for Service

CSI scores are a direct reflection of how customers perceive the service experience. Monitoring this helps dealerships identify areas for improvement, whether it’s shorter wait times, better communication, or improved repair quality.

Goodwill Expenses

Tracking goodwill expenses ensures dealerships strike the right balance between building customer loyalty and managing costs. For example, consistently high goodwill expenses might indicate systemic issues, such as frequent part failures or delays.

Efficiency and Profitability by Operation Code

Metrics like operations by code (alignments, brake jobs) and efficiency—sold vs. actual help dealerships identify their most profitable services. If brake jobs have low efficiency, it could indicate pricing mismatches or process inefficiencies.

Pump In / Pump Out Metrics

This measures how quickly vehicles move through the service process—from the time they’re checked in to when they’re ready for delivery. Any delays here can impact customer satisfaction and overall throughput.

Work in Process (WIP)

Tracking WIP helps dealerships understand how many vehicles are currently in service and ensures the team is operating at optimal capacity. Too many vehicles in process can lead to bottlenecks, while too few might indicate underutilization.

Specialized Maintenance and Cosmetic Services

Advisors play a big role in upselling specialized maintenance (e.g., hybrid vehicle services or extended maintenance packages) and aesthetic services (like detailing or paint protection). Tracking sales in these areas highlights which advisors excel and where additional training might be needed.

Technician Rates and Labor Costs

Monitoring internal labor rates ensures dealerships remain competitive while maintaining healthy profit margins. High labor costs without corresponding efficiency might indicate the need for workflow improvements or process reviews.

Why These Metrics Matter

All these metrics work together to give us a clear picture of the dealership’s health. They tell us what’s working, what’s not, and where we need to pivot. With a BI tool, we don’t just react to problems—we anticipate them. It’s like having a roadmap that shows us where to go next.

What’s Your Next Step?

If you’re not tracking these metrics, you’re leaving money on the table. Start small—pick a few areas that need attention and build from there. The key is to stay consistent and let the data guide your decisions. Trust me, it’s worth it.

How are you using metrics to drive success at your dealership? Let’s compare notes and share insights—there’s always room to learn from each other!

Recent blogs