Skip to main content

Blog Archives

Newer posts

ADA helped a global retailer create a modern unified data platform on Databricks to reduce operational costs and streamline data workflows

Case Study

ADA helped a global retailer create a modern unified data platform on Databricks to reduce operational costs and streamline data workflows

Get a Demo
Segment

Retail

The Results

0 %
Costs reduction from streamlined workflows and optimized code
0
Dashboards
Medallion architecture on Databricks enabled faster dashboard refresh rates.
Data Confidence
Data validation measures ensured data accuracy and integrity post migration.

The Challenge

The customer is a leading global sporting goods retailer with a footprint in 56 countries and selling products from over 20 brands.

The Solution

The customer built their existing data platform on disparate cloud services (Amazon Redshift for data storage, Python/SQL for data processing, and Jenkins for workflow automation). The existing platform introduced many integration challenges that led to increased costs and reduced operational efficiencies.

ADA helped design, implement, and migrate their existing data to a new unified data platform on Databricks. We successfully resolved many technical challenges including handling and migrating diverse data sources, overcoming limited support for converting Python code to PySpark using innovative solutions, and ensuring data alignment between the old platform and the new Databricks platform.

The project was executed seamlessly, preserving data integrity and security while avoiding disruptions to ongoing operations.

The Approach

Our goal is to establish a gold layer within the Databricks system, utilizing data from the silver layer for business intelligence reporting. Our approach to achieve this involves:

  • Data Source Analysis: Understand current data sources and associated codes for a clear migration foundation.
  • Code Transformation with Optimization and Quality Checks: Convert Python/SQL to PySpark/Spark SQL, adding data quality checks for reliable data integrity and optimizing it for space and speed.
  • Data Validation and Comparison: Verify Databricks data against Redshift data, ensuring seamless alignment.
  • Data Orchestration: Schedule jobs using Databricks workflows, implementing monitoring and alerts for a reliable workflow.
  • Documentation and Knowledge Transfer: Document the migration process for reference and conduct knowledge transfer sessions for enhanced team adoption.
Table Of Contents
The Results
The Challenge
The Solution
The Approach

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

Book a Demo

How Boost Malaysia Achieved 3X Efficiency and 57% Higher Engagement with CRM Integration

Case Study

How Boost Malaysia Achieved 3X Efficiency and 57% Higher Engagement with CRM Integration

Get a Demo
Segment

Financial Services

The Results

0 X
productivity boost: campaign setup and execution become faster and more efficient
0 %
higher open and click rates on WhatsApp compared to other channel like push notifications and email
0
reduced cost-per-acquisition through optimized campaign strategies, achieving parity with conversion campaigns through optimized campaign strategies, achieving parity with conversion campaigns
Improved CPA performance

The Challenge

Boost Malaysia, Southeast Asia’s leading mobile wallet provider, encountered critical operational hurdles in their customer engagement strategy:

  1. Campaign Complexity: Their teams spent excessive time manually managing cross-channel campaigns, creating bottlenecks in customer outreach.
  2. Engagement Deficit: Traditional channels yielded suboptimal engagement metrics, particularly in open and click-through rates.
  3. Data Silos: The absence of WhatsApp campaign integration with their primary CRM created blind spots in customer journey analytics.

The Strategy

Through comprehensive analysis, Boost recognized the need for a unified marketing ecosystem. The solution: integrating CleverTap’s capabilities with ADA Asia’s Business Messaging Platform (BMP) to create a seamless, data-driven engagement engine. Hence, ADA Asia delivered a three-pronged solution:

  1. Seamless Integration: Unified CleverTap CRM with ADA’s BMP, enabling end-to-end campaign automation.
  2. Precision Marketing: Deployed targeted WhatsApp campaigns using advanced customer segmentation.
  3. Interactive Engagement: Implemented CTWA campaigns with intelligent bot flows, backed by real-time analytics from CleverTap and Facebook Ad Manager.

The Execution

  • Deployed AI-driven customer segmentation through CleverTap for precise WhatsApp targeting.
  • Established real-time performance monitoring for comprehensive campaign insights.
  • Implemented data-driven A/B testing to maximize CTWA campaign effectiveness.

Table Of Contents
The Results
The Challenge
The Strategy
The Execution

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!

Book a Demo

ADA used AI and Tech to improve sales forecast, inventory management and marketing strategy for a client

Case Study

ADA used AI and Tech to improve sales forecast, inventory management and marketing strategy for a client

Get a Demo

The Results

0 %
Sales forecast accuracy, with error deflection of less than 3.7% in model validation.
≥ Precision
Improved sales forecasting leads to better inventory management to meet sales demand
≥ Effectiveness
Enhanced marketing campaigns and effectively allocate budgets based on sales forecast

The Execution

A Malaysian subsidiary of the global automotive giant saw an immediate need to solve the challenge of parts inventory management and allocating marketing budgets efficiently based on anticipated sales for each vehicle model per outlet. The current flaw has impacted the sales and marketing departments – hindering campaign performance and potentially missing sales targets.

With ADA’s expertise in data management and predictive modelling, we implemented a data-driven solution by first unifying all sources of data in a Customer Data Platform (CDP), developing a forecasting model and building a dashboard for analysis and monitoring.

The automation has greatly improved sales forecasting accuracy, reduced parts inventory shortages, and ultimately empowered the client to invest resources in areas where they can generate the highest impact.

Table Of Contents
The Results
The Execution

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!

Book a Demo

ADA helped a leading ecommerce brand increase order value and customer retention rate

Case Study

ADA helped a leading ecommerce brand increase order value and customer retention rate

Get a Demo
Segment

Retail

The Results

0 %
Reduction in the time allocated for the task
Introduced an effective fraud detection approach. All team members involved in this task now consistently rely on the tool for their daily work. 

The Challenge

Our client is a global leader in consumer electronics, home appliances, and mobile communications. One of its subsidiaries, Hi-Care Solutions, specialises in providing maintenance services to customers who have contracted rental services of various LG electronics products, such as air purifiers, water purifiers, and more. Periodic customer management and routine visits are conducted to ensure the seamless operation of all related services following the rental contract agreement.

Recently, a challenge surfaced as several sales representatives unintentionally received bonuses through the contractual process. This has resulted in financial discrepancies and losses for our client.

The Solution

ADA developed a three-phased solution to effectively address the identified challenges.

In the initial phase, ADA aided in the transformation by constructing custom dashboards and transitioning fraud detection from a manual to an automated process. These dashboards were seamlessly integrated with the client’s base system data, utilising the existing detection logic.

Next, the detection logic underwent expansion, addressing complexities and volumes of data processing that were beyond the capabilities of human intervention.

In the final and ongoing phase, ADA introduced specialised artificial intelligence (AI) to enhance fraud detection, leveraging the insights derived from the collected data. This approach ensures a robust and adaptive solution to counteract potentially fraudulent activities.

Following that, the PDCA (Plan – Do – Check – Analyse) cycle was initiated. A series of interviews and workshops were held to optimise the solution. This proactive approach allowed for the rapid collection of feedback, facilitating the continuous improvement of both the detection logic and dashboards. The iterative process ensured that adjustments were made swiftly, leading to an increasingly accurate and effective solution.

The Execution

Upon conducting a thorough review to identify instances of fraud, it became evident that the manual process was too time-consuming and could not efficiently cover all cases. There was a pressing need for automation to effectively detect fraudulent activities within the workplace.

ADA automated the fraud detection process by building specialised dashboards and implementing AI, resulting in a reduction of fraud incidents.

Table Of Contents
The Results
The Challenge
The Solution
The Execution

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!

Book a Demo

How Lotte Rental Achieved 21% Conversion Lift in 3 Months with Customer 360

Case Study

How Lotte Rental Achieved 21% Conversion Lift in 3 Months with Customer 360

Get a Demo
Segment

Retail

The Results

21% conversion increases | 10 distinct customer personas identified

0 %
conversion increases
0
distinct customer personas identified

The Challenge

Lotte Rental, a leading vehicle rental company in South Korea, had a sales effectiveness problem. Contact centre salespeople had almost no information when customers called, just a phone number and a name. No rental history, no preferences, no context about what the customer might need.rnrnMeanwhile, IoT data from rental vehicles sat unused. Every rental generated driving behaviour data refuelling patterns, locations, driving styles that could have informed customer understanding. But this data was siloed and invisible to sales teams.

The Solution

ADA implemented Treasure Data CDP to build Customer 360 profiles with preferences, usage patterns, and purchase considerations. These profiles integrated directly with the contact centre, giving salespeople real-time customer context during every conversation.rnrnCustom analytics on driving behaviour revealed 10 personas that had been invisible before. The personas enabled dynamic pricing based on driving risk. Within 3 months, conversion rate increased 21%.

Table Of Contents
The Results
The Challenge
The Solution

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!

Book a Demo

How an Indonesian Real Estate Developer Achieved 5.5X Appointment Increase with CDP

Case Study

How an Indonesian Real Estate Developer Achieved 5.5X Appointment Increase with CDP

Get a Demo

The Results

5.5X increase in appointments per month | 18% increase in booking deposits | 30% increase in total deposit value

0 x
increase in appointments per month
0 %
increase in booking deposits
0 %
increase in total deposit value

The Challenge

A leading Indonesian real estate developer with 76+ projects across 33 cities needed to improve digital marketing for new development launches. Generic ads reached broad audiences without personalization, prospects interested in luxury condos received the same messaging as those interested in affordable housing.rnrnWithout unified customer data, there was no way to personalize targeting. Each campaign started from scratch with no ability to leverage insights from previous interactions.

The Solution

ADA implemented Treasure Data CDP with personalised targeting for Facebook and Google campaigns. The CDP unified data from website visits, past inquiries, and property preferences into profiles that could drive segmentation.rnrnInstead of broad audiences, campaigns reached segments defined by demonstrated preferences: project type, budget range, location preference, and purchase timeline signals. Appointments increased 5.5X per month. Booking deposits increased 18%. Total deposit value increased 30%.

Table Of Contents
The Results
The Challenge
The Solution

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!

Book a Demo

How a Top 5 Auto Manufacturer Generated $500M in Sales with CDP-Powered Intent Segmentation

Case Study

How a Top 5 Auto Manufacturer Generated $500M in Sales with CDP-Powered Intent Segmentation

Get a Demo

The Results

11% conversion rate | $500M sales generated

0 %
conversion rate
0 $
million in sales generated

The Challenge

A Top 5 global auto manufacturer in Malaysia had an 800K customer base but was treating them all the same. Marketing campaigns used broad targeting with generic messaging. Without the ability to distinguish high-intent customers from general audience, advertising costs were high relative to results.rnrnCustomer data sat in multiple systems, CRM, dealer management, website analytics, service records with no unified view. There was no way to identify purchase signals or score intent.

The Solution

ADA unified customer data using CDP, integrating showroom visits, website behaviour, service history, and previous purchases into single profiles. Identity resolution matched the same customer across systems.rnrnPropensity scoring identified high purchase intent customers based on behavioural signals: website visits to specific models, service appointments suggesting vehicle aging, digital engagement patterns correlating with purchase timing. High-intent segments activated through app push, dealer personal selling, and Facebook Lookalike. The result: 11% conversion rate and $500M in sales.

Table Of Contents
The Results
The Challenge
The Solution

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!

Book a Demo

We helped a leading ecommerce retailer migrate their existing data warehouse from AWS to MS Azure while ensuring seamless business continuity​

Case Study

We helped a leading ecommerce retailer migrate their existing data warehouse from AWS to MS Azure while ensuring seamless business continuity​

Get a Demo

The Results

100% migration accuracy | 400+ tables migrated | 200+ stored procedures migrated

0 %
migration accuracy
0 +
tables migrated
0 +
stored procedures migrated

The Challenge

A leading fashion ecommerce company needed to migrate their data warehouse from AWS Redshift to Microsoft Azure. The migration had to happen without disrupting business operations, dashboards, reports, and analytics all needed to keep running while the underlying infrastructure changed.rnAny data loss or inconsistency would break downstream reporting and erode trust in the platform. The company needed migration that was fast, accurate, and seamless.

The Solution

ADA replicated AWS Redshift structures to Azure Synapse, automating the migration using shell scripts and Azkaban orchestration. The approach ensured business continuity throughout, parallel running validated accuracy before cutover.rnrn400+ tables and 200+ stored procedures were migrated in 3 months with 100% accuracy across 90% of datasets. No data loss, no business disruption.

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!

Book a Demo

We delivered 74% ROI for a Global Pet Care Leader with AI-driven Bundling

Case Study

We delivered 74% ROI for a Global Pet Care Leader with AI-driven Bundling

Get a Demo
Segment

Retail

The Results

The campaign didn’t just resonate, it converted, turning a regulatory challenge into a mobile marketing success.

Brand Interest & Awareness

  • 4.6× increase in branded search between October and December
  • Steady, month-on-month growth in web traffic and engagement

Performance & Acquisition

Through ongoing optimisation and AI-powered signal learning:

  • Conversions increased by 33%
  • CPA dropped by 89%
  • Direct traffic surged by 471%, reflecting stronger trust, recall, and word-of-mouth

Media & Strategy Impact

  • High-impact formats delivered scale across parents’ daily digital touchpoints
  • Parenting communities and KOL recommendations built credibility and mid-funnel momentum
  • Meta ASC became a standout innovation, outperforming manual campaigns and proving viability for financial services
  • Dual PMax streams delivered a 45% uplift, thanks to smarter segmentation of promotional vs. always-on periods
0 %
Project ROI
0 %
ROI Uplift on the budget spent for bundles

The Challenge

A top global pet care brand allowed each distributor to create their own product bundling schemes, leading to inconsistent offers, poor targeting, and low ROI from promotions. With no centralised view of order and product-level data, bundling strategies lacked insight into customer preferences and failed to maximise returns.

  • Fragmented bundling decisions by distributors
  • No consolidated order & product-level data
  • Lack of product affinity insights by country and segment
  • Bundles are often mismatched to actual customer buying patterns
  • Limited ability to track ROI on bundles

The Solution

  • We unified order and product-level data across markets via the ADA Data Accelerator Platform
  • Developed a product recommendation algorithm to identify high-performing bundle combinations
  • Standardised bundling strategy, limiting combinations to proven high-affinity flavours per country
  • Implemented ROI tracking dashboards to monitor bundling performance over time
  • Aligned distributors on data-backed bundling rules for consistent execution

The Execution

Our AI-powered platform transforms fragmented data into a cohesive, intelligent strategy, as demonstrated by our partnership with a leading pet care brand. Here is how our solution optimises product bundling to maximise ROI and align business operations.

1. Data Centralisation & Insights

The first step was to address the challenge of decentralised and fragmented data. Using the ADA Data Accelerator Platform, we unified all order and product-level data from various markets and distributors into a single source of truth. This critical process not only provided a consolidated view but also enabled us to move beyond gut-feel decisions. The platform’s AI capabilities then analysed this data to uncover hidden insights into product affinity and customer buying patterns by country and segment, revealing which combinations actually resonated with consumers.

2. Predictive Bundling Strategy

With a centralised view and deep insights, our solution developed a custom product recommendation algorithm. This algorithm identified the most high-performing bundle combinations, providing a data-backed blueprint for success. By standardising the bundling strategy, we were able to limit combinations to only those with proven high-affinity flavours per country. This eliminated mismatched bundles and ensured that every offer was tailored to actual customer preferences, directly addressing the core challenge of inconsistent promotions.

3. Performance Monitoring & Cross-Team Alignment

The final phase was to ensure the new strategy was both adopted and sustained. We implemented ROI tracking dashboards that provided a clear, real-time view of each bundle’s performance over time. This transparency enabled the brand to monitor its returns and make informed decisions. Crucially, we aligned all distributors on the new, data-backed bundling rules. This ensured consistent execution across all markets, transforming the brand’s promotional approach from a fragmented, low-ROI activity into a highly profitable and disciplined operation.

Table Of Contents
The Results
The Challenge
The Solution
The Execution

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!

Book a Demo

We standardized data and deployed AI forecasting to boost ROI by 136% and improve forecasting accuracy by 15% for a global grocer

Case Study

We standardized data and deployed AI forecasting to boost ROI by 136% and improve forecasting accuracy by 15% for a global grocer

Get a Demo
Segment

Retail

The Results

0 %
Project ROI
0 %
Accuracy Uplift: Target and Forecast

The Challenge

A top global grocery retailer was struggling to accurately forecast sales, preventing them from setting realistic targets and fairly assessing team performance. Data was scattered across brands, channels, and countries, making it difficult to compare top-down vs bottom-up forecasts or track accuracy over time.

  • Fragmented data across multiple sources
  • No standardised forecasting framework
  • Inconsistent targets across teams and markets
  • Limited visibility into forecast accuracy
  • Difficulty aligning business planning with actual performance

The Solution

  • We unified all sales data across brands, channels, and countries via the ADA Data Accelerator Platform.
  • Built custom AI forecasting models (time series, organic growth, campaign uplift) to improve accuracy.
  • Delivered trackers and dashboards for teams to monitor forecasts and compare top-down vs bottom-up results in real time.
  • Embedded into workflows to ensure adoption and consistent performance tracking.

The Execution

Driving Smarter Decisions with Unified Data

Our AI-powered solution works by transforming fragmented data into actionable intelligence, enabling you to optimise your business operations and accelerate growth. This is achieved through a three-step process:

1. Unify & Consolidate Data

We begin by unifying and ingesting all data from across your business’s brands, channels, and countries into a single, comprehensive platform. This process consolidates scattered information, providing a unified view of your real-time performance. Our platform ensures that your key performance indicators (KPIs) and business objectives are adopted and clearly displayed, giving you a holistic and accurate overview.

2. Analyse & Predict

With your data unified, our powerful AI capabilities analyse historical information on product demand, seasonality, user behaviour, and market trends. This analysis uncovers patterns that may be invisible to the human eye, providing a deeper understanding of your business landscape. Based on these insights, our predictive module generates accurate demand signals and forecasting recommendations, giving you a clear look into future outcomes.

3. Act & Optimise

The predictive outcomes and real-time performance data enable you to compare top-down and bottom-up results instantly. This clarity allows you to monitor your business’s health and quickly accelerate your decision-making process. By providing a clear and accurate foundation for your strategy, our solution empowers you to pivot with confidence and maximize growth.

Table Of Contents
The Results
The Challenge
The Solution
The Execution

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!

Book a Demo
Newer posts