×
Case Studies | Analytics
Achieved 95 to 97% accuracy with MLI’s CRM data
Developed over 5 business dashboards for custom KPIs
Max Life Insurance Company Limited, based in New Delhi, stands as India’s largest private-sector life insurer operating independently of any bank affiliation.
Aligned CRM data and custom KPIs with GA4 data using the GA4 Explore feature and its scalable capabilities, including slicing, dicing, and custom metrics.
Addressed GA4 and Looker Studio quota errors that previously limited our ability to access data and generate insightful analysis.
GA4 was integrated with BigQuery to allow seamless, ongoing export of raw event data for comprehensive analysis. A custom schema was developed to align with the CRM framework, ensuring consistent data mapping. Customized dashboards were created in Looker Studio, harnessing BigQuery’s processing power, alongside thorough data validation and cleansing. This alignment of GA4 data with CRM records via BigQuery greatly reduced data discrepancies, delivering more accurate and actionable insights.
Ongoing Improvement: Continuous iteration and stakeholder input enhanced data collection, processing, and reporting to better align with business requirements.
Scalable Reporting Framework: Developed a flexible reporting infrastructure in Looker Studio designed to grow and adapt alongside the business’s evolving needs.
Improved Decision-Making: Delivered precise, real-time insights into marketing and product performance, supporting informed strategic choices.
Accuracy Enhancement: Reached approximately 95% accuracy in matching GA4 data with backend systems, surpassing typical industry benchmarks.
Achieved 95-97% accuracy with CRM data of MLI.
To be able to roll out dashboards via GCP Big Query has been one of the biggest enablers for our MaxLife Ecom Business. The fact that no one except Google knows the processing algorithm on top of GA4 Big Query raw data, our Analytics Partner DWAO has translated those raw data to meaningful dashboards which has enabled us to take informed decisions with absolute visibility on the Customer Journey and the Behavior.
Commendable job done in collaboration with the DWAO team with >95% match-rate with CRM and with GA4 processed data.
