Derrick Woolfson

Company: Beltway Companies

Derrick Woolfson

Beltway Companies

Apr 4, 2017

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?

Derrick Woolfson

Beltway Companies

Business Development

2468

1 Comment

Simple Dealer Suite

Simple Dealer Suite

Apr 4, 2017  

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 http://www.simplerecon.com/Recon-Checklist.htm5

Recommended Posts

Scheimpflug: The Engine Behind New York’s Creative Vision

In a city that never stops creating, Scheimpflug stands as a cornerstone for independent filmmakers, photographers, and producers alike. As a premier camera and lighting rental house in New York, we’re more than just a source for top-tier equipment…

scheimpflugg flugg

napollo

45
April 29th

1. Custom Gifts Show Thoughtfulness

In the corporate world, employee appreciation isn’t just about saying “thank you” once a year—it’s about consistently showing your team how much they mean to your business. While generic gifts like mass-produced mugs or plain pens might see…

stweedmarketing stweedmarketing

napollo

31
April 29th

Premium Probiotic for Mental Health: Omni-Biotic Stress Release & Stress Management

Premium Probiotic for Mental Health: Omni-Biotic Stress Release & Stress ManagementEnhancing Mental Clarity and Emotional BalanceFor individuals struggling with stress and anxiety, or anyone seeking improved mental clarity and emotional balance, …

SEO@omnibioticprobiotic omnibioticprobiotics

napollo

30
April 29th

Powering Online Growth with Expert Ecommerce Management Services

Powering Online Growth with Expert Ecommerce Management ServicesRunning an online store isn’t just about having a nice-looking website—it’s about maintaining a seamless shopping experience, ensuring consistent performance, and staying ahead of …

napollosoftware software

napollo

31
April 29th

Sustainable Flooring Options to Elevate Your Eco-Friendly Home Renovation

When you’re dreaming up your next home renovation, flooring might not be the first thing on your list—but it should be. The material beneath your feet plays a huge role in how your space feels, performs, and, most importantly, how much of an impa…

parmafloor parmafloors

napollo

26
April 29th