Advertising & Design

Enterprise BI & Reporting

Modern BI Improves Campaigns, Saves Time for Worldwide Auto Advertiser

and/or

A global auto industry advertising powerhouse takes pride in its close relationships with client dealerships, providing each one with a dealer-partner manager to ensure the effective execution of every custom-designed digital marketing strategy.

But these dealer-partner managers were spending more time mired in the complexities of a dated report-generating system than in their important face-to-face client meetings for which the reports were produced.  The agency decided to simplify the process by embracing a modern business intelligence and analytics solutions suite using a Hadoop-based environment.  

car-dealership-marketing-analytics.jpg

Complicated Reporting Takes Valuable Time

The advertising giant works hand in hand with thousands of auto dealers to develop its digital marketing campaigns and to create innovative ways for dealerships to increase incoming lead volumes and connect with targeted consumers. Once a custom plan is in place, it must be closely tracked to ensure success. The solutions are designed to be unique to each dealership, so measuring the performance of each program adds a layer of complexity.

Dealer-partner managers bring performance reports to their on-site advertising training and implementation meetings. These reports help monitor campaign performance and impact. But because the data required to compile these reports was mixed among PDFs, forms, screen scrapes, and a Hadoop environment, they took significant time and effort to compile. Often, creating the reports took the dealer-partner managers’ time away from the more important function of effectively identifying and implementing potential campaign improvements for their client dealerships.

Streamlined Solutions Make for Simplified Reports

The agency ultimately sought to eliminate the bulk of manual data preparation for dealership status meetings. The group initially created an internal solution, but when the result wasn’t achieving the anticipated performance, the company reached out to BlueGranite. We helped their I.T. team implement improved data extraction and preparation performance by pulling together the disparate source material, and we updated the design of account team dashboards.

The successful analytics overhaul created a streamlined and simplified way to generate reports. Now the agency’s dealer-partner managers are able to spend their valuable time uncovering advertising insights using printer-friendly, up-to-date dashboards.

Please contact us to learn the many ways we can make your data work harder for you!

WANT TO LEARN MORE ABOUT BLUEGRANITE SOLUTIONS?

FEATURED EBOOK

Powe[R] BI: Enhance Your
Microsoft Power BI Experience
with R

As a specialized, open source statistical environment, R
represents the primary analysis language for many data
scientists and statisticians. By extending Power BI with R,
Microsoft has created several opportunities to enhance your
Business Intelligence solutions and visualizations.

Power-BI-Main.png