1 / 22

DATA OVERLOAD

DATA OVERLOAD. Presented by Victor Vella Ecommerce Director Spitzer Auto Group Digital Dealer 13 Oct. 25 2012. What is Data Overload?. SRP/ VDP Google Analytics SEM AutoTrader.com vAuto Cars.com Social Media Online Reviews Phone Call Tracking

darena
Download Presentation

DATA OVERLOAD

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. DATA OVERLOAD Presented by Victor Vella Ecommerce Director Spitzer Auto Group Digital Dealer 13 Oct. 25 2012

  2. What is Data Overload? • SRP/ VDP • Google Analytics • SEM • AutoTrader.com • vAuto • Cars.com • Social Media • Online Reviews • Phone Call Tracking • Other Key Performance Indicators (KPIs)

  3. Data Overload

  4. What’s the Solution? • 3 Step Plan • Identify and Filter • Organize and Process • Present and Analyze

  5. Step 1 - Identify and Filter • It is unrealistic to expect to keep track of all the available data by yourself • Identify which KPIs are the most important for your dealership(s) • Which Criteria is going to lead to more traffic and sales

  6. Real Life Example • Beginning ofFebruary we averaged only 60% of our inventory being pictured online • We decided that we needed to track the number of vehicles that were missing photos • We determined that we wanted to track the following criteria: • New, Used, and Total vehicles missing • Average # of Photos • % with Vehicle Description

  7. Real Life Example • February • Group Average 32.67% Missing Photos • 873 Vehicles without photos • September • Group Average 13.30% Missing Photos • 317 Vehicles without photos

  8. Step 2 - Organize and Process • This is the most time intensive stage • Key things to do in this stage: • Cull out irrelevant data • Assemble relevant data into groups • Perform any operations on the datasets • Sum, Average, ect

  9. What Tools Should You Use • Microsoft Excel • Macros (Visual Basic) • Advanced Filtering • Conditional Formatting • SQL Database • Long-term storage • Powerful for data mining Need Help? vvella@spitzer.com jbogzevitz@spitzer.com

  10. Real Life Example

  11. Real Life Example

  12. Step 3 - Present and Analyze • Whether you are making the decisions or someone else is, it is critical that you make your data readable

  13. Compare

  14. Real Life Example • What are some techniques you can use to improve your readability? • Conditional Formatting • Color coding • Icon sets • Gradients • Graphs and Charts • Sorting

  15. Real Life Example

  16. Real Life Example

  17. Real Life Example

  18. Real Life Example

  19. Review • Isolate which metrics are most important for your dealership • Organize and process the raw data into something that is usable • Present your data in a readable format that will enable you to easily see trends and make the best decisions for your dealership

  20. Moving to the Next Level • Interactive Reporting Dashboards • Allow managers to drill down to the data that they need instead of what you think they need • Easily view trends overtime • Look at a global overview or drilldown to a single store with the click of a mouse • Robust, scalable, and fun!

  21. Questions? • Email addition questions to vvella@spitzer.com

  22. Thank You for Attending

More Related