-
IndustryBFSI
-
LocationIndia
-
Solutions
GA4
BQ
Looker Studio
-
Results
Achieved 95-97% accuracy with CRM data of MLI
5+ Business dashboards created for custom KPIs
Max Life Insurance Company Limited is an Indian life insurance company headquartered at New Delhi, and the largest non-bank private-sector life insurer in India
Matching the CRM data and custom KPIs with GA4 data by using GA4 ‘Explore’ feature and its scalability (Slicing-dicing, Custom Metrics etc).
Resolving GA4 and looker studio quota error, which was challenges and leaving us handicapped to be data informed & pull intelligent insights.
We have integrated GA4 with BigQuery, enabling continuous export of raw event data for detailed analysis. A custom schema was designed to align with the CRM structure, ensuring consistency. We built tailored dashboards in Looker Studio, leveraging BigQuery’s data processing power, and implemented rigorous data validation and clean-up
Reduced Data Discrepancy: Aligning GA4 data with CRM records via BigQuery significantly minimized discrepancies, providing more reliable and actionable insights
Regular Refinement: Iterative development and stakeholder feedback refined data collection, processing, and reporting logic to meet business needs.
Scalable Reporting Infrastructure: Established a scalable reporting framework in Looker Studio that can evolve with the business’s needs.
Enhanced Decision-Making: Provided accurate, real-time insights into marketing and product performance, enabling data-backed strategic decisions.
Accuracy Improvement: Achieved an accuracy rate of around 95% in aligning GA4 data with backend data, which is significantly above the industry standard.
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.
-
97%
Data Accurancey
-
5+
Custom Metrics Dashboards
Related case studies
