Notifications & Messages

Jared Hamilton
From: Jared Hamilton
Hey - It’s time to join the thousands of other dealer professionals on DrivingSales. Create an account so you can get full access to the articles, discussions and people that are shaping the future of the automotive industry.
Derrick Woolfson

Derrick Woolfson Business Development

Exclusive Blog Posts

Don't Forget About Your Managers.

Don't Forget About Your Managers.

When we are hit with an unprecedented situation - out of left field - it can easily derail your dealer's efforts. Sustaining everything you have worked…

How to Make Your Social More than Click | KPI Cafe Season 5 Episode 7

How to Make Your Social More than Click | KPI Cafe Season 5 Episode 7

Continuing our series on budgeting, CEO Dave Spannhake and Host Dane Saville dive into the setup of and best practices for your dealership's paid socia…

MDP 048 | TikTok, Like a Savage!

MDP 048 | TikTok, Like a Savage!

#tiktok #savage #GaryV #VDP Design #ROIofYourMother Join David & David talking about TikTok for your dealership, 12 Hour Live Stream from Gary Vaynerch…

WEBINAR RECORDING - Build Your Dealership's Budget for COVID-19 and Beyond

WEBINAR RECORDING - Build Your Dealership's Budget for COVID-19 and Beyond

We had a great discussion with Dane Saville and Dave Spannhake from Reunion Marketing. They laid out a roadmap for optimizing your dealersh…

What Joblessness Means for Service Departments

What Joblessness Means for Service Departments

We’re at the end of May 2020, and the jobless rate in the United States has just surpassed 40 million, or 14.7%. That’s the highest it has …

There's an Excel Sheet for That!

Reporting is essential for understanding what your ROI is, right? So why then are we wasting several hours of your managers time creating reports (using Excel) in the service lane?

More often than not the reason managers are creating their reports mainly due to their not knowing how to pull the correct report. Albeit, there are multiple vendors the dealer works with on a daily basis. However, there is a way of collectively aggregating all of the data using the vendor's platform.

Many if not all vendors have substantial reporting options available within their platforms. And I understand that there is such a thing called analysis paralysis. But, it is best to review your essential vendors - i.e. marketing, appointments, email collection and compile all of the “performance” reports into one cohesive report.

In doing so, it allows you to understand better how the vendors and services interrelate in so far as how they work together. For example, in the service lane, a dealer wants to understand better how many appointments are being booked online.

Who keeps track of appointments on an Excel sheet manually entering them? If you are using a manual report - often having human errors - then you are not getting the whole picture.

Whereas, if you are using the vendor's reports to analyze web traffic, conversion, appointments, and show rate vs. the average dollar per RO for both warranty and customer pay, you can make a much more sound decision. A decision that can have a profound impact on overall sales in the lane.

So while you might already keep track of this using Excel. I do recommend working with your vendors! In fact, when is the last time you called your vendor's account manager asking them to come in or give an update?

Do you still use Excel? How do you manage the monthly reporting?

Simple Dealer Suite

Anyone using excel (or any tool to track performance) is at least looking into their business performance. There are still dealers out there that use white boards and inter-department mail.

It just blows my mind that dealers still do that.

And there is absolutely no tracking in terms of how departments and vendors are performing when it comes to the reconditioning aspect of the inventory management.

If anyone is looking at using excel (upgrade from whiteboard) we offer an excel template that can be used (free of cost) on our website. To download the template go to

 Unlock all of the community & features  Join Now