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
• CRM Reports
• Cars.com
• Autotrader.com
• 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 data 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.   Community 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:
brian@pcgmailer.com  

Best of all:  No Long Term Contracts! 

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 third party lead data or 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 this 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.

What say you about this opportunity?