- May 1, 2006
- 3,519
- 2,442
- Awards
- 12
- First Name
- Alex
I am new to the forums but I have a similar setup to danoneil. I manage 6 different dealerships housed under an autogroup. The dealerships are all in one location, or at least in spitting distance - but our ISM's are in one room at one of the dealerships. I made up a spreadsheet that has been evolving since I stepped foot in my role as Internet Director about 7 months ago.
I manually input in information regarding the sale that I receive from the "recap" after the sale (date, salesperson, customer, showroom, trade, gross, gross with holdback, back, lead source). All that information then populates in the other side of the spreadsheet.
I then enter my information I get from my CRM (# of leads per source, # of leads per salesperson, etc).
I then can see closing ratios, cost per lead, cost per sale, net per sale and quite a bit more. I will post up a screen shot if I can.
With 6 stores I had a to come up with a way to monitor everything and even though there is some manual input - it is the best way I can measure cost per lead, closing ratio, net per sale, etc. I have been happy with it so far - but it is ever changing.
EDIT: Removed Image
Marc - great spread sheet! I have seen a few people get in trouble for posting confidential stuff, so I removed it. If it is okay with your boss, post it back up. I just don't want to see anyone on DealerRefresh get in trouble when seeking help.