CLIENT SUCCESS STORY

How We Assisted a UK Insurance Company in Cleansing and Consolidating Over 3 Million Customer Records

THE CLIENT

A Prominent UK-Based Insurance Firm

Our client is a well-established insurance provider in the UK, offering services directly to consumers and through diverse channels, including Independent Financial Advisers (IFAs), brokers, and strategic partners such as trade unions and national societies.

The company operates in two primary areas of financial services. First, they provide general insurance policies covering a wide range of needs, including home, vehicle, business, and travel insurance. Second, they offer life and pension insurance policies, focusing on life protection, retirement plans, savings, and investment solutions.

PROJECT BACKGROUND & CHALLENGES

Resolving Errors, Duplicate Entries, and Missing Data in a CRM Database of Over Three Million Records

The insurance company faced considerable challenges in managing its customer relations database, which had expanded to over 3 million records. The database was riddled with errors, duplicate entries, and missing or inaccurate information, hindering the company’s ability to market its services effectively, gain valuable customer insights, and maintain meaningful engagement.

Key challenges included merging multiple databases within the CRM into a unified database, entering data for approximately 130,000 new customers and accounts, and quickly cleansing the extensive customer records to support enhanced marketing efforts and sales.

These issues had a significant impact, making it difficult to track customer interactions and preferences. As a result, the company missed sales opportunities and experienced reduced customer satisfaction, contributing to a decline in sales over the past year.

Recognizing the urgency of the situation, the insurance company partnered with SunTec to implement a robust data management solution to resolve these challenges efficiently.

Project Scope

  • Consolidating multiple databases into a unified system.
  • Inputting data for approximately 130,000 new customers and accounts into the CRM.
  • Cleaning over 3 million records, including resolving duplicate entries caused by multiple sources or database merges.
  • Adding metadata, profiling, and segmenting accounts to enhance customer insights for the client.

Human-in-the-loop approach

To ensure the accuracy and completeness of the client’s database, we employed a human-in-the-loop approach, seamlessly integrating automated tools with human expertise. Our team meticulously cleansed, standardized, appended, and validated the data while also inputting new customer information and segmenting the database. This segmentation empowered the client to deliver personalized marketing messages tailored to specific customer groups.

The human element in this process ensured thorough data checks for accuracy, resolving errors and inconsistencies comprehensively. This approach enabled the client to make informed decisions, enhance customer engagement, and drive increased sales.

Project Outcome

project outcome
Accurate and comprehensive customer data enabled the client to design more personalized and targeted marketing campaigns, leading to increased engagement rates and improved return on investment.
project outcome
The client achieved a 50% increase in response rates for email marketing campaigns, with email ID accuracy improving by 85%.
project outcome
By segmenting and profiling customer data, the client was able to target specific groups with personalized services, leading to a 65% increase in customer acquisition.
project outcome
Consolidating multiple databases provided the client with a unified view of customer data, allowing them to gain a comprehensive 360-degree perspective of their customers, enhance customer service, and more effectively promote their insurance plans.