Talk about feeling right at home! I am ripping my hair out just trying to figure out who I got in the door! We have a CRM in place, but the salesman never log their leads and the GM will not enforce it. I am the ISM at a dealership with on avg about 300 used cars in inventory. I take the pictures ( about 2o per car), I am responsible for comments on all of them. I answer all of the incoming Internet phone leads, and Email leads. I am building a new secondary website from the ground up- meaning I taught myself web design, and how to use Photoshop for the graphics. I set up a facebook page that is driving more click thru's to our website than Cars.com. Also I brought the amount of "trackable" deals from 5-10 a month to 50+! With all this in order to find out how many deals I got I have developed the most insane process.
First: I take pictures of our desk logs for the previous week.
second: I record all customer info into an excel file.
Third: I download my incoming call history from my cell phone provider into another excel file.
Fourth: I export my inbound internet leads (customer names and phone #'s) into another excel file.
Fifth: I then use a formula in excel to cross refrence all of this data to find out who ive communicated with.
Once I have a list of all the names I then stare at the sales board to find out if they sold.
This takes hours even now when I have it down to a science. Not to mention all the customers whos names are not recorded on the logs correctly (one letter off and they fall through the cracks), End up buying under a different name than the original lead name, or call me from a different phone than they record in F&I - if they give one at all! I am not complaining about how much I make because I do better than the other ISM's in my autogroup with similar pay plans, but how much time is wasted on this when I could be working on simply driving in more floor traffic?
Jason's pay structure just blew my mind! I am going to appoarch the GM tomorrow morning with this idea!
The first clue for me is when someone has a lot of local drive by's.
