Using Microsoft SQL Server Reporting Services, T4G developed a new business intelligence dashboard, and delivered a suite of reports allowing Mr. Lube’s executives to interact with their sales data in real-time.
Mr. Lube is investing heavily in new product lines at their stores. To build customer trust, and ensure vehicles get the services they need, Mr. Lube implemented a system known as the Electronic Owners Manual (EOM). Based on the current odometer reading, and vehicle service history, this system displays services already performed on a vehicle as green bars, required services coming up as yellow bars, and overdue services as red bars. T4G was asked to build a new reporting system for the EOM system that allowed franchisees to understand how this new tool was being accepted by customers and staff to increase customer trust and Mr. Lube’s bottom line.
Mr. Lube also needed to enhance their email marketing program to provide more timely and targeted communications with customers, updating them on the growing list of products and services. T4G was asked to design and implement a variety of ETL import and export scripts and a series of database and application modifications to synchronize customer data between the Mr. Lube database and the new CRM platform. A key component of this project was also to ensure that CASL (Canadian Anti-Spam Legislation) requirements were being met.
T4G’s solution of Mr. Lube’s seamless integration with the CRM resulted in a high-quality, personalized service available to more than 1.6 million active Club members. Red bar reporting created a stronger connection between franchises and their customers, increasing return visits and increasing customer trust. In addition, T4G’s custom business intelligence dashboard helped Mr. Lube’s leadership to quickly assess sales data and make smarter, more informed business decisions.
We’re always looking for new challenges and teammates.