Automotive Digital Marketing

Professional Community for Car Dealers, Marketing, Advertising and Sales Leaders

Loading... Be Patient!

The Time Has Come: An Automotive Data Warehouse To Provide Executive Insights

To all Dealer Principals or General Managers reading this post, "Are you tired of having a dozen+ stand alone reports to review each month?  Are you challenged to know how to leverage vendor reports to make business decisions?"

How many reports are generated each month by dealership vendor partners? My quick list of potential monthly reports includes:


• Website Vendor Reports
• Google Analytics
• Google Adwords
• Google Places
• Yelp Reviews
• DealerRater Reviews
• Chat Reports
• Retargeting/Behavior Targeting Reports
• Phone Tracking Reports
• Dealix/AutoUsa Reports
• ZAG/TrueCar Reports
• Mail House Reports
• Hooklogic/Incentives Reports
• Radio, TV, and Newspaper Spends



Creating an Automotive Data Warehouse


Has anyone switched vendors lately?  What happens to all your historical data?  In many cases, the historical data is lost. Year over year comparsions are difficult without pulling out piles of printed reports.  Where are those printed files anyway?


As I have been working with dealers through our PCG Consulting division, it became clear to me that the reporting tool we had created just for PCG customers would be perfect for the larger dealer community.  


Dealer Principals and General Managers need their current and historical data easily accessible and safely stored regardless if they change vendor partners.


I believe dealership executives need to be able to see "Cause and Effect" relationships between their vendors. Dealer Principals and Executive Managers would love to have their historical monthly advertising and marketing budgets and compare the results with the vendor reports.  Today that is not very easy to do.



The Automotive Data Warehouse To Be Unveiled


Imagine a software tool that would allow dealers to store all the high level data from their vendor partners in one tool.  A tool that would allow them to access, analyze, and make management decisions from their own data.   A tool that would allow them to enter in their monthly advertising and marketing budgets to see how changes in spending impacted their calls, leads, and traffic.


The graphic above is just a sampling of the many companies that dealers leverage to operate their business.  All of the roll-up data that executive managers need to run their business can now be stored in a new vendor neutral data warehouse tool. 


This new product will be unveiled at the upcoming Automotive Boot Camp in Las Vegas.   ADM members will also be given a special opportunity to sign-up for this software at a discounted price.  If interested, send an email with your contact information to:  



How It Works


The consolidated executive data dashboard does not replace any existing vendor products; it's a brand new product category of its own. This product actually enhances existing vendor solutions because it brings their data to the Dealer Principal and GM in a format that they can use and will prefer!


Dealers will still need their vendor partners to provide tools that provide "tactical" automation for SEO, SEM, Social Media, IRM, Chat, etc.  For example, the data warehouse reports will show all dealership online reviews and chart the trends across all review websites.  However, if a dealer needs to respond to reviews, they will still need to use their current IRM management tools or processes.  


This Executive Data Dashboard will summarize the "KEY" data that managers need to analyze the ROI of their investments and marketing decisions.  Much of the data will be entered into the data warehouse through direct automated feeds. Other numbers, such as traditional advertising budgets will be entered into the warehouse manually each month.



How Would A Centralized Data Tool Help Your Dealership?


I would love to hear feedback from the ADM community on this new data tool.  If you could store all your budget data and detailed analytics, metrics, and results from your vendor partners in one place, how would that benefit your dealership?


Keep in mind that once the data is in the warehouse, you will be able to chart, analyze, and use the tools provided to spot opportunities for your dealership.  The software will have alerts and insights that will give dealership executives insights into their data.   If your dealership changes vendor partners, the new data feed will pickup where the last vendor data stopped.  Nothing would be lost.


Does this interest you?




Views: 536

Tags: automotive data dashboard, automotive data tool, data tool, data warehouse


Oops... You need to stop "Lurking" on ADM and become a more genuine Automotive Professional by completing your membership registration. As a registered ADM Member, you can post comments, publish your own articles (be a star!) and start Forum discussions. Stop being an online "Peeping Tom" and JOIN ADM RIGHT NOW!

Join Automotive Digital Marketing

Comment by William Finsilver on May 23, 2012 at 12:45pm

Are you referring to the Dataium suite of reporting tools?

Automotive Professional Network and Resource Exchange for Car Dealers, Managers, OEM and Marketing Practitioners seeking Best Practices.

ADM Sponsor

William B. Terry
Rated by Super Lawyers

loading ...

Please Consider Automotive Marketing Professional Community Sponsors

ADM Badge


Based On Your Interests...

ADM Consulting, LLC

Onsite/Offsite Combination ADM Consulting, LLC Professional Services
Select the maximum monthly investment you plan to make
Sign up for

Automotive Marketing Tools

Get ADM Toolbar

Click here to take the ADM Member Survey

Getting too many emails from ADM? Click mailbox below to control which types of alerts and updates you are sent......



ADM Professional Services
Phone Consultation
Topic or Issue:

Top Automotive Marketing Forum Discussions

1. BDC or Virtual BDC

Posted by Peter Stratton on February 26, 2020

Share the Best Content w/AutoMarketing Community

© 2020   Created by Ralph Paglia.   Powered by

ADM Badges  |  Report an Issue  |  Terms of Service