Skip to main content

We helped improve operational agility and reduce turnaround time by implementing Customer Data Platform (CDP)

Case Study

We helped improve operational agility and reduce turnaround time by implementing Customer Data Platform (CDP)

Segment

Financial Services

The Results

≥ BI team workload
Substantial decrease in BI team workloads
≥ Data Retrieval Times
Achieved faster data retrieval times, Zenhancing overall operational efficiency.
Unified Customer Data Across Platforms
A single customer view across products promotes consistency and coherence in customer data.
Efficient Segment Creation
Enabled the creation of segments based on different criteria and conditions across various products.

The Challenge

1 Data Fragmentation and Management Complexity​​

The client, a credit service company offering a range of credit and finance products, manages data for approximately 2 million actively transacting customers. ​ The client grappled with challenges related to ineffective marketing efforts and missed revenue opportunities. The business units heavily relied on the BI team for data extracts due to siloed datasets, causing operational inefficiencies, execution delays, and straining resources.​​rnrnAs the company expanded, the surge in customer data across multiple systems and marketing channels led to fragmented data silos. This resulted in incomplete records and inconsistent data quality, impacting all business units. This fragmentation hindered a comprehensive view of the customer journey, undermining the accuracy of customer analysis for segmentation strategy and activation approaches.​​

2 Overreliance on BI for Data Access​

Business units were reliant on the BI team for data extracts due to the isolated nature of datasets, preventing them from obtaining data autonomously. This caused a bottleneck, resulting in time-consuming processes, project timeline delays, and an overburdened BI team. These challenges collectively impact the overall agility and performance of the business.​rnrnADA implemented a system that enables direct, self-service data access for business units, crucial to streamlining workflows, expediting decision-making, and relieving the excessive demands placed on the BI team.​

The Solution

With the implementation of the Customer Data Platform (CDP), the client could unify customer data from all sources, cleanse it, and make it available for analysis, segmentation, and activation. The solution enabled the client to personalise interactions and deliver a better customer experience. By consolidating customer data into a single source of truth, they could perform credit criteria analysis and improve the SLA / abandoned rate when handling customer inquiries. Furthermore, the CDP solution eliminated the need for multiple tabs to view customer information in our core system, thereby increasing productivity.

The Master Segment Creation feature was used to develop a Centralised Customer Data Repository. This repository efficiently stores all relevant customer data, including personal details, contact information, current active product details, past application history, card transaction details, loan repayment history, etc. Additionally, a comprehensive Data Dictionary was created for business users.

This implementation provided the client with a unified 360-degree view of customer data, significantly enhancing data integrity and management. It aided in the accurate creation of customer segments, enhancing marketing and customer service strategies.

To address the challenge, ADA developed three automated dashboards using Power BI, exporting unified customer data from the CDP. These dashboards include a Single Customer View Dashboard, a Cross-Sell Campaign Report, and a Customer Demographic Dashboard. The primary goal was to reduce the reliance on the BI team by providing direct access to essential data visualisations and insights.

The dashboards featured performance metrics, interactive filters, and clear data visualisations to track progress towards specific goals, customising views based on individual needs, and displaying data in an easily understandable format.

This implementation enabled business unit teams to take swift actions, reduced the turnaround time for generating insights, and ensured data accuracy by eliminating manual processes. The prioritisation of these dashboards was determined by the project team, aligning with the specific needs of different business units within the company.

Content
The Results
The Challenge
The Solution
Get in touch

Explore More Resources on Commerce Personalization

Wine.com Drives AttributeBased Recommendations for Personalization
Food & Beverage US

Wine.com Drives AttributeBased Recommendations for Personalization

See full story
0 %
Reduction in out-of-stock across stores
0 %
increase in revenue

Let’s turn your data and AI into measurable outcomes!

We helped a digital-first company create major cost & time savings with data synchronisation and automation

Case Study

We helped a digital-first company create major cost & time savings with data synchronisation and automation

Segment

Healthcare

The Results

0 hrs
Time saved every month.Finance now relies on a singular, definitive source for reporting regulatory reports.
0 %
Of the cost saved on the monthly fines previously accrued for tardy tax filings with the government.

The Challenge

Our client is a major player in India’s digital healthcare realm, operating in both B2B and B2C sectors. Offering medicines, diagnostics tests, online consultations, and healthcare products, the platform connects users and retailers with trusted vendors and professionals, revolutionizing healthcare accessibility in the nation.

The client’s finance team faced significant challenges in their monthly processes, spending a minimum of 40 labour-intensive hours manually verifying and correcting missing data in Microsoft D365.

With no unified source of truth, they struggled to consolidate data from disparate sources, leading to manual reconciliation efforts and delays in filing regulatory financial reports. Consequently, these inefficiencies resulted in fines imposed by the government due to late submissions.

The Solution

Bar charts showing the number of terminated customers between the termination of the contract and the start date of the new contract, the number of unsubscribed customers by sales channel, the number of unsubscribed customers through purchasing channel, the number of customers lost by store, and more.
Content
The Results
The Challenge
The Solution
Get in touch

Explore More Resources on Commerce Personalization

Wine.com Drives AttributeBased Recommendations for Personalization
Food & Beverage US

Wine.com Drives AttributeBased Recommendations for Personalization

See full story
0 %
Reduction in out-of-stock across stores
0 %
increase in revenue

Let’s turn your data and AI into measurable outcomes!

We transformed client’s operations through Customer Data Platform (CDP) integration for growth and enhanced revenue streams

Case Study

We transformed client’s operations through Customer Data Platform (CDP) integration for growth and enhanced revenue streams

Segment

Financial Services

The Results

≥ 9.35% Conversion rate
Our campaign witnessed an increase of conversion rates from 2.78% to 3.04% in cross-sell campaigns.
≥ Data Retrieval Times
Achieved faster data retrieval times, enhancing overall operational efficiency.
Unified Customer Data Across Platforms
A single customer view across products promotes consistency and coherence in customer data.
Efficient Segment Creation
Enabled the creation of segments based on different criteria and conditions across various products.

The Challenge

1 Data Fragmentation and Management Complexity

The client, a credit service company, grappled with challenges related to ineffective marketing efforts and missed revenue opportunities. The business units heavily relied on the BI team for data extracts due to siloed datasets, causing operational inefficiencies, execution delays, and straining resources.

As the company expanded, the surge in customer data across multiple systems and marketing channels led to fragmented data silos. This resulted in incomplete records and inconsistent data quality, impacting all business units. This fragmentation hindered a comprehensive view of the customer journey, undermining the accuracy of customer analysis for segmentation strategy and activation approaches.

2 Inadequate Customer Segmentation and Campaign Strategy

The absence of a unified customer dataset and analysis capabilities resulted in inefficient and ineffective customer segmentation strategies. The marketing team’s inability to perform informed data analysis impeded the creation of personalised and high-converting campaigns, leading to less impactful marketing efforts and lost revenue opportunities.

ADA implemented a Customer Data Platform (CDP) to resolve the challenges faced by the client.

The Solution

With the implementation of the Customer Data Platform (CDP), the client could unify customer data from all sources, cleanse it, and make it available for analysis, segmentation, and activation. The solution enabled the client to personalise interactions and deliver a better customer experience. By consolidating customer data into a single source of truth, they could perform credit criteria analysis and improve the SLA / abandoned rate when handling customer inquiries. Furthermore, the CDP solution eliminated the need for multiple tabs to view customer information in our core system, thereby increasing productivity.

The Master Segment Creation feature was used to develop a Centralised Customer Data Repository. This repository efficiently stores all relevant customer data, including personal details, contact information, current active product details, past application history, card transaction details, loan repayment history, etc. Additionally, a comprehensive Data Dictionary was created for business users.

This implementation provided the client with a unified 360-degree view of customer data, significantly enhancing data integrity and management. It aided in the accurate creation of customer segments, enhancing marketing and customer service strategies.

The client employed the Audience Studio feature for seamless customer segmentation creation. An advanced Propensity Scoring model at the Product Category Level was developed. This model assigns propensity scores to customers for each product SKU or scheme, assessing the likelihood of a customer successfully applying for specific products across six main product categories. The scores range from 0 to 1, indicating the level of fit between the product category and the customer’s needs and preferences.

The function streamlined the segmentation process, allowing for quick and intuitive creation and management of customer segments. Meanwhile, the Propensity Scoring model provided a quantifiable measure of a customer’s likelihood to engage in cross-selling campaigns.

This dual approach not only improved the accuracy and efficiency of targeting in marketing campaigns but also optimised resource allocation by focusing efforts on customers with the highest propensity to convert, significantly enhancing the effectiveness of marketing strategies.

Content
The Results
The Challenge
The Solution
Get in touch

Explore More Resources on Commerce Personalization

Wine.com Drives AttributeBased Recommendations for Personalization
Food & Beverage US

Wine.com Drives AttributeBased Recommendations for Personalization

See full story
0 %
Reduction in out-of-stock across stores
0 %
increase in revenue

Let’s turn your data and AI into measurable outcomes!

We helped a multi-national electronics firm improve performance by enabling data-driven, automated decision making

Case Study

We helped a multi-national electronics firm improve performance by enabling data-driven, automated decision making

The Results

≥ Improved Visibility u0026 Planning
Improved visibility u0026 planning for BU Performance across HQ u0026 RHQ.
Faster Decision Making
Dynamic u0026 Interactive dashboards that provide data across multiple cuts and levels.
Automation
Automated report refresh with no manual effort u0026 zero errors.

The Challenge

Optimizing the performance of individual business units is a cornerstone of sustained success. Our client, a renowned Japanese multinational conglomerate, operates across diverse sectors, including photography, electronics, biotechnology, and chemicals.

However, confronted with the challenge of manual reporting processes, they sought a streamlined solution to automate analytics for headquarters (HQ) and regional HQs across their various business units.

To address this pressing need, our client embarked on the implementation of a Business Intelligence (BI) Dashboard. Through this initiative, our client aims to enhance efficiency and maintain its leadership across multiple industries.

The Solution

We developed a Business Intelligence (BI) Dashboard—an automated tool that enables real-time analysis of financial performance, eliminating manual efforts and providing actionable insights.

Cash Conversion Cycle

  • Cash Conversion Cycle: Trend of Budget vs Actual
  • Amount Receivable & Payable
  • Inventory Trend
  • Gap Analysis: Inventory, AR, AP, WC

Corporate Level View

  • HQ vs Regional HQ Analysis
  • COGS, Sales, & AR/AP Days
  • Business Unit Level Analysis & Comparison

Planning

  • AR, AP, & Inventory Turnover Days
  • Cash Cycle Conversion Days
  • Business Unit Level Analysis & Comparison
Dashboard Visualization Examples

Content
The Results
The Challenge
The Solution
Get in touch

Explore More Resources on Commerce Personalization

Wine.com Drives AttributeBased Recommendations for Personalization
Food & Beverage US

Wine.com Drives AttributeBased Recommendations for Personalization

See full story
0 %
Reduction in out-of-stock across stores
0 %
increase in revenue

Let’s turn your data and AI into measurable outcomes!

We assisted a prominent regional company in enhancing their contract management process, resulting in significant time savings​

Case Study

We assisted a prominent regional company in enhancing their contract management process, resulting in significant time savings​

Segment

Consumer Goods

The Results

0 %
Reduced Processing Time at the Contract Review Phase​
Easier identification of critical contract groups u0026 corresponding processing time. Automated report refresh with no manual effort u0026 zero errors​

The Challenge

In the fast-paced realm of biotechnology, strategic decision-making is imperative for success. Our client, a prominent biotechnology company, is dedicated to pioneering scientific advancements to deliver life-saving medicines to those in need.

However, amidst their commitment to innovation, they faced a significant operational challenge: effectively managing contracts across diverse categories.

Recognizing the need for data-driven insights to streamline contract processing, our client sought to implement a robust Business Intelligence (BI) Dashboard. This dashboard would offer a comprehensive overview of contract categories and processing times, enabling informed decisions to optimize efficiency and drive operational excellence.

The Solution

1 Contract Management Dashboard

  • Summary of Contract by Status.
  • Distribution of contract across owner organization.
  • Contract distribution & USD value across business category.
  • Dynamic charts whose X axis changes based on selection.

2 Average Processing Time​

We developed a Business Intelligence (BI) Dashboard that offers a comprehensive overview of contract categories and processing times, enabling informed decisions to optimize efficiency and drive operational excellence, including matrix on:

  • Target metric for the dashboard.
  • Track average processing time across Contract Owner Organization and Workflow Stage.

3 Trend​

  • Contract Value Growth over time.
  • Contract Value Growth over time and contract category.

Content
The Results
The Challenge
The Solution
Get in touch

Explore More Resources on Commerce Personalization

Wine.com Drives AttributeBased Recommendations for Personalization
Food & Beverage US

Wine.com Drives AttributeBased Recommendations for Personalization

See full story
0 %
Reduction in out-of-stock across stores
0 %
increase in revenue

Let’s turn your data and AI into measurable outcomes

We enabled a leading global retailer to increase revenue through improved targeting and personalisation

Case Study

We enabled a leading global retailer to increase revenue through improved targeting and personalisation

Segment

Retail

The Results

0 %
Increase in Revenue
0 %
Campaign CTR Increase

The Challenge

The client faced a challenge with outdated predictive models for customer spending, leading to suboptimal conversion rates and missed revenue opportunities. Additionally, inefficient customer segmentation hindered targeted marketing efforts.

The Solution

ADA helped to enhance its marketing strategies by integrating a sophisticated Purchase Propensity Classification Model, employing Naive Bayes algorithms for predictive analytics, with Salesforce, to streamline and personalize its marketing efforts, significantly sharpening customer targeting and campaign efficacy.

The new strategic adoption of advanced machine learning techniques and CRM integration proved essential in capturing market share and driving growth through improved customer insights and targeted communication.

The implementation of a predictive analytics model and CRM system integration resulted in a substantial increase in marketing efficiency, highlighted by a 50% rise in click-through rates and a 0.8% increase in revenue.

Content
The Results
The Challenge
The Solution
Get in touch

Explore More Resources on Commerce Personalization

Wine.com Drives AttributeBased Recommendations for Personalization
Food & Beverage US

Wine.com Drives AttributeBased Recommendations for Personalization

See full story
0 %
Reduction in out-of-stock across stores
0 %
increase in revenue

Let’s turn your data and AI into measurable outcomes

We helped a leading retail brand bolster revenue with advanced predictive analytics and CRM integration

Case Study

We helped a leading retail brand bolster revenue with advanced predictive analytics and CRM integration

Segment

Retail

The Results

0 %
Increase in Revenue
0 %
Increase in Click through rates (CTR)

The Challenge

The client faced a challenge with outdated predictive models for customer spending, leading to suboptimal conversion rates and missed revenue opportunities. Additionally, inefficient customer segmentation hindered targeted marketing efforts.

The Solution

ADA helped enhance its marketing strategies by integrating a sophisticated Purchase Propensity Classification Model, employing Naive Bayes algorithms for predictive analytics, with Salesforce to streamline and personalise its marketing efforts. This significantly sharpened customer targeting and improved campaign effectiveness.

The strategic adoption of advanced machine learning techniques and CRM integration proved essential in capturing market share and driving growth through deeper customer insights and more targeted communication.

The implementation of the predictive analytics model and CRM integration resulted in a substantial increase in marketing efficiency, highlighted by a 50% rise in click-through rates and a 0.8% increase in revenue.

Content
The Results
The Challenge
The Solution
Get in touch

Explore More Resources on Personalized Marketing

Wine.com Drives AttributeBased Recommendations for Personalization
Food & Beverage US

Wine.com Drives AttributeBased Recommendations for Personalization

See full story
0 %
Reduction in out-of-stock across stores
0 %
increase in revenue

Let’s turn your data and AI into measurable outcomes

We improved client’s lead management by integrating Customer Data Platform (CDP) with Salesforce

Case Study

We improved client’s lead management by integrating Customer Data Platform (CDP) with Salesforce

The Results

Enhanced Lead Management
Significant increase in qualified lead acquisition and conversion efficiency
Streamlined Sales Process
Accelerated sales cycles and heightened productivity with minimal manual intervention and time-to-close.
Informed Marketing Decisions
Improved marketing strategies and customer engagement
Resource Optimisation and ROI Improvement
Reduction in operational costs and maximised ROI

The Challenge

Our client is a leading digital imaging and networking technologies company. They were gearing up for a brand-new marketing initiative. The strategy encompasses the development of a website, a revitalised marketing and sales pipeline, and a comprehensive lead management system.

The Solution

1 Digital Integration

The absence of a cohesive digital ecosystem that encompasses a new website, marketing channels, and a B2B-tailored lead management system. ​

2 Data Consolidation

Lack of visibility due to the absence of seamless integration of various activities and customer interactions into a single platform.​

3 Reporting and Alerts

A need for the development of a comprehensive reporting and dashboard system to provide real-time insights. Establishing an efficient alert mechanism is essential to notify the regional sales teams across 7 countries about critical leads and updates.​rnrnWith CDP implementation, ADA helped manage leads more effectively by establishing a cohesive digital ecosystem and streamlining the sales process.​

The Execution

1 Website Integration and Lead Generation

First, we integrated essential lead generation forms such as ‘Contact Us’, ‘Content Download’, and ‘Webinar Registration’ on the website. This captures every customer interaction as a potential lead, funnelling them directly into the sales pipeline and ensuring no opportunities are missed. ​

2 Marketing Channel Integration

​Digital marketing channels like Mailchimp were seamlessly integrated for email campaigns and LinkedIn for targeted ads. This strategy aims to widen the reach and ensure consistent messaging across platforms. ​

3 Lead Segmentation and Alerts

​Next, we implemented an automated system for lead segmentation based on market and other pertinent criteria. This facilitates personalized communication and enables regional sales teams in 7 countries to receive timely alerts about critical leads, ensuring immediate and relevant follow-up. ​

4 Lead Deduplication and Verification

A mechanism was established for de-duplicating lead entries. This system was integrated with Mailchimp to send confirmation emails after form submissions, verifying the authenticity of email addresses. This process enhances the quality of leads and focuses sales efforts on genuine prospects.​

5 Lead Scoring Model

We then developed a comprehensive lead scoring model that ranks leads based on their engagement level, potential for conversion, and other key factors. This model aids in prioritizing leads and strategically guiding them through the sales funnel.​

6 Comprehensive Dashboard and Analytics

We deployed Power BI to create an all-encompassing dashboard, acting as a control centre for real-time monitoring of metrics such as lead funnel progress, engagement rates, conversion rates, and campaign effectiveness. This centralization facilitates informed decision-making and ongoing performance optimization. ​

7 Salesforce Integration

Finally, we integrated the Customer Data Platform (CDP) with Salesforce (SFDC) to provide the sales team with seamless access to comprehensive lead information and customer interactions. This integration ensures an efficient lead management process and enhances the capability of the sales team to effectively engage with leads at every stage of the sales cycle.​

Content
The Results
The Challenge
The Solution
The Execution
Get in touch

Explore More Resources on Personalized Marketing

Wine.com Drives AttributeBased Recommendations for Personalization
Food & Beverage US

Wine.com Drives AttributeBased Recommendations for Personalization

See full story
0 %
Reduction in out-of-stock across stores
0 %
increase in revenue

Let’s turn your data and AI into measurable outcomes

We helped a leading manufacturer in implementing data-driven strategies for capital management, enhancing their operational efficiency

Case Study

We helped a leading manufacturer in implementing data-driven strategies for capital management, enhancing their operational efficiency

The Results

Improved Visibility u0026 Planning
Better cash monitoring with expedited account receivable u0026 payable plan
Improved Credit Management
Better supplier u0026 customer relations with focus on timely payments u0026 invoice settlement monitoring
Automation
Automated report refresh.

The Challenge

The client is a leading chemical manufacturer with a strong presence across Asia and international markets. Effective capital management is critical to supporting the company’s long-term growth and profitability, and it has consistently maintained a healthy cash surplus ranging from $6 million to $10 million.

However, changing market conditions created the need for a more strategic approach to capital allocation, budgeting, and financial planning. The client required greater visibility into financial performance to make faster, data-driven investment decisions.

To address these challenges, ADA implemented a Business Intelligence (BI) dashboard that provided real-time insights into capital management and financial planning. The solution enabled more informed decision-making, improved budget forecasting, and strengthened the client’s ability to manage capital efficiently while supporting its growth ambitions.

The Solution

ADA developed a Business Intelligence (BI) Dashboard that provides real-time visibility into cash flow and financial performance. The solution enables the organisation to optimise capital allocation, improve financial planning, and proactively manage financial risks through interactive analytics and reporting.

Cash Flow Dashboard

  • Monitor cash inflows, outflows, and net cash flow across multiple time periods, including weekly, monthly, and year-to-date (YTD).
  • Compare actual cash flow against projected future cash flow.
  • View a detailed financial breakdown, including opening balance, closing balance, receivables, and other key cash flow metrics.

Accounts Receivable Dashboard

  • Track receivables by on-time and overdue status.
  • Monitor invoices and outstanding balances at the customer level.
  • Analyse receivable trends to improve collections and cash flow forecasting.

Accounts Payable Dashboard

  • Track payables by on-time and overdue status.
  • Monitor invoices and outstanding amounts at the supplier or counterparty level.
  • Analyse payment trends to support effective cash management.

Dashboard Visualisation Example

Business Intelligence dashboard visualisation
Content
The Results
The Challenge
The Solution
Get in touch

Explore More Resources on Personalized Marketing

Wine.com Drives AttributeBased Recommendations for Personalization
Food & Beverage US

Wine.com Drives AttributeBased Recommendations for Personalization

See full story
0 %
Reduction in out-of-stock across stores
0 %
increase in revenue

Let’s turn your data and AI into measurable outcomes

ADA helped a leading digital first “House Of Brands” gain competitive market intelligence by building a modern data platform on Databricks

Case Study

ADA helped a leading digital first “House Of Brands” gain competitive market intelligence by building a modern data platform on Databricks

Segment

Retail

The Results

Process Automation
Eliminated manual data collection requirements
Data Accuracy
Eliminated data discrepancy issues
Data Analysis Readiness
Enabled data scientists to make dashboards and ML models

The Challenge

The client is a leading digital-first House of Brands focused on accelerating the growth of direct-to-consumer (D2C) businesses across the region. By managing multiple brands, the company is committed to building a scalable, data-driven retail ecosystem.

The client relied on manual data collection from its managed brands, resulting in reporting delays, data inaccuracies, and limited access to timely business insights for decision-making. In addition, the company lacked visibility into performance data across its brands’ e-commerce websites and marketplace channels, making it difficult to monitor operations and optimise business performance.

The Solution

ADA conducted a series of proof-of-concept (POC) initiatives to evaluate the most suitable cloud platform and technology stack. Based on cost, scalability, and performance, we designed and implemented an end-to-end data pipeline and modern data warehouse using Databricks and Amazon Web Services (AWS).

The new data platform consolidated information from multiple sources, providing a unified view of sales, returns, inventory, and financial performance. This enabled faster reporting, improved data accuracy, and more informed business decision-making.

ADA also developed bespoke API connectors for a range of e-commerce platforms to automate data ingestion and enrich the central data repository. In addition, we implemented web scraping capabilities to collect competitive market intelligence—including pricing, product rankings, and market trends—helping the client optimise its product strategy and respond more effectively to changing market conditions.

Content
The Results
The Challenge
The Solution
Get in touch

Explore More Resources on Personalized Marketing

Wine.com Drives AttributeBased Recommendations for Personalization
Food & Beverage US

Wine.com Drives AttributeBased Recommendations for Personalization

See full story
0 %
Reduction in out-of-stock across stores
0 %
increase in revenue

Let’s turn your data and AI into measurable outcomes!