Skip to main content

ADA derives insights for a Japanese departmental store with location & data analytics

Case Study

ADA derives insights for a Japanese departmental store with location & data analytics

The Results
  • The client gained a firm understanding on the type of consumers who are seen in the malls.
  • A comprehensive report on each of the 10 outlets was produced to show the mall profile, demographics, willingness of visitors to travel, footfall density and more, allowing the client to profile potential consumers that they could win over from competitors and gauge the largely contributing tenants in different outlets.
The Challenge

Although the Singapore economy is slated for recovery due to local vaccination efforts, factors such as continued social distancing measures, reduced footfall traffic, and low volume of visitor arrivals continue to dampen the recovery of the retail industry.

The client turned to ADA by leveraging XACT, ADA’s proprietary data management platform (DMP) and AI-driven solution to uncover data-driven insights on customers in their existing store locations, the locations of their primary competitors, as well as the demographics of selected locations with the goal of increasing customer acquisition.

The Solution
1 Location selection & geofencing

We identified our target audience, competing malls, and potential malls to open new departmental stores. We geofenced 10 mall outlets to extract profiles of visitors, either by mapping the whole mall, or a section of the mall to best capture the audience for our analysis.

2 IFA extraction & profiling

The IFAs of devices seen within the geofenced locations were extracted. Then they were run through our XACT database for consumer profiling.

3 Derive insights

The identified data sets were analysed, with a focus on the following areas: Cross-visitation patterns, Willingness to travel, Footfall traffic, Catchment heatmap, and more to offer competitive insights.

The Execution
4 The insights on competitor mall outlets

The target audience for each brand / mall were mapped out. Colour gradients were used to showcase least to most concentration catchment areas. The distance travelled by the target audience to arrive at the identified malls is tracked from their home / work locations.

5 The Insights on visitor analysis

The movement of the target audience was tracked by day of the week and were categorised for footfall analysis by Weekdays and Weekends. Age group, gender, persona, and behaviours were derived and supplemented using XACT. Affluence is derived from condition-based attributes. The device price tiers and home property price tiers were then segmented.

Content
Results
Challenge
Solution
Execution
Get in touch

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

Revamping customer emails for Owndays with marketing automation

Case Study

Revamping customer emails for Owndays with marketing automation

The Challenge

With digitalisation in focus for brands, there remains a shortage of skilled marketing technology (MarTech) talent in Singapore. OWNDAYS, the fast-growing multinational eyewear brand, was seeking to improve its data consolidation practices and optimise its use of marketing technology ‚Äî but lacked the internal capabilities to do so. As their data was siloed within different platforms, the brand found it difficult to form and act on a comprehensive, unified view of the customer, making it difficult to plan and take the optimal actions based on customers’ needs and preferences. OWNDAYS needed a partner to help them reach out to both current and potential customers at the moment of truth, with the right vehicle and message.

‚:

The Strategy

Optimise email engagement

ADA tailored the customer email engagement with a fit-for-purpose MarTech stack. The objective was to identify opportunities proactively as well as capture customer data in real time, while also sending personalised emails that meaningfully lifted conversion rates.

Build a solid foundation in MarTech

ADA partnered with OWNDAYS to build a solid foundation in MarTech and hone a data-driven mindset.

The Execution

Systems integration

When MarTech tools complement each other, a stack is worth more than the sum of its parts. The result is not only automation and workflow optimisation, but also smoother cross-departmental communication, and higher return on marketing investment.

Email automation

ADA worked with OWNDAYS to set up automated email workflows for current and potential customers, reducing the time spent by the marketing team to compose and manually send emails to different audience segments.

Email optimisation

The workflow was optimised via a four-step process: Discovery, Identify automation opportunities, Develop findings, and Automation implementation.

‚:

The Results
  • OWNDAYS acquired the tools to maximise their email marketing performance and to integrate previously walled-off data points, so they can deliver always-on and targeted email campaigns seamlessly to customers.
  • Generate monthly in-depth performance reports as well as send automated newsletters to engaged subscribers complete with relevant promotions, new product launches, and personalised reminders on abandoned carts.
  • 15% to 20% increase in open rate or automated customer emails.
  • MarTech Enablement empowered OWNDAYS to deliver personalised value to customers in the long-term.
Content
Challenge
Solution
Execution
Results
Get in touch

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

ADA helped a global retailer get a holistic view of their online business by consolidating their data on Amazon Redshift

Case Study

ADA helped a global retailer get a holistic view of their online business by consolidating their data on Amazon Redshift

The Results
Understand the impact of clickstream data on revenue.
Consolidated transaction and clickstream data for further data analysis.
The Execution

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

The customer was in need of an E-Commerce Digital Performance Dashboards to provide insights on its rapidly expanding E-Commerce business. However, its transactional and clickstream customer interaction data were located in separate data silos hampering consolidated view of its data.

ADA helped to migrate the customers clickstream data from GCP BigQuerry and consolidated the data with its transactional data on AWS Redshift. We helped to merge the session level data with revenue data to create a holistic analytics data set. ADA then built AWS Quicksight dashboards to provide

Content
Results
Challenge
Solution
Get in touch

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

ADA helped a leading Direct-To-Consumer player automate data collection to help accelerate business decisions

Case Study

ADA helped a leading Direct-To-Consumer player automate data collection to help accelerate business decisions

The Results
Eliminated manual data collection requirements.
Eliminated data discrepancy issues.
The Execution

The customer is a leading Direct-To-Consumer (D2C) player that invests in developing e-commerce capabilities for digital-first brands in the beauty, fashion, and personal care sector.

The company was previously collecting data from their managed brands manually which resulted in data inaccuracies and delays in getting business insights for decision making activities. They also had no visibility on data from their managed brands ecommerce platforms and marketplaces.

ADA helped to build and end-to-end data pipeline and data warehouse on Amazon AWS to gather insights from many different data sources for sales, returns, inventories, and finance. ADA also built bespoke API connectors for various eCommerce platforms to enrich collected data.

The new data warehouse helped to provide up to date and accurate data for data analytics and data science team to make business intelligence dashboards and construct ML models.

The Approach
__wf_reserved_inherit
This chart demonstrated the accuracy of ADA’s robust modelling technique in the forecasting model.

We observed close alignment between the actual sales and predicted values for Y2023, with difference of only 6.8%:

– Prediction for Y2023: 21,339 units (overall)

– Actual for Y2023: 22,067 units (overall)

‚:

Content
Results
Challenge
Solution
Execution
Get in touch

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

Accelerating AI Growth: 2.5× GMV Surge for a Gaming Chair Brand

Case Study

Accelerating AI Growth: 2.5× GMV Surge for a Gaming Chair Brand

The Results
0 x
compared to the set benchmark
0 st
gaming chair in Indonesia
0 %
market coverage
The Challenge

A Singapore-based gaming chair manufacturer sought to expand its reach by entering the Indonesian market and entrusted ADA with the tasks to raise awareness and engage with potential customers. To achieve this, we decided to sell the gaming chair on two leading ecommerce platforms, Tokopedia and Shopee. However, the challenge of selling a high-end gaming chair in Indonesia is formidable, given the dominance of more affordable brands and the non-primary utility niche market. Nonetheless, we are determined to succeed by crafting a well-conceived strategy that capitalizes on the market’s potential. With the right approach, this endeavour has the potential to be a game-changing opportunity for our client.

The Strategy
1 Conquering a new market via insights

First, to understand the customers and customer journey, we observed and analysed how brands delivered a competitive advantage in the market previously.

2 Understanding customers’ wants and needs

We gathered feedback and ratings for the products, which gave us an overview of consumers’ sentiments. Then, we refined the products and services to meet our customers’ expectations. Positive reviews and ratings propel the brand’s image and showcase its gaming chairs in the best light possible.

3 Launching promotional campaigns

To promote our gaming chairs, we participated in over 200 brand and platform-initiated campaigns that align with the brand’s product and personality.

The Execution
4 Crafting an effective strategy that drives growth

With data, we crafted a customised on-site niche marketing strategy that optimises growth. Since the brand is selling gaming chairs on two giant eCommerce platforms, we assisted them in observing potential buyers, their preferences, and purchase patterns on each platform.

5 Experimenting with multiple variables

We conducted A/B testing during the campaigns to identify which messaging strategies work best, the best time to drive sales, and the type of promotions that attract customers best.

6 Capturing potential new segments

ADA collaborated and partnered with other brands to capture new segments while considering price discrimination in each region. This approach helped our client to tap into new market opportunities, build a broader customer base, and enhance brand awareness.

Content
Results
Challenge
Strategy
Execution
Get in touch

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

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

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

The Results

100%​ Accuracy in migration of 90% of the datasets | 3 months​ Successful migration of 400+ tables and 200+ stored procedures

0 %
Accuracy in migration of 90% of the datasets.​
0 months
Successful migration of 400+ tables and 200+ stored procedures.
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

An eminent Indian ecommerce entity specializing in fashion, beauty, and lifestyle products, faced the significant challenge of migrating its data warehouse from AWS to Microsoft Azure. ​

This strategic move necessitated a data engineering partner proficient in both cloud platforms, with a deep understanding of the nuanced data requirements essential for their business and technical objectives. ​

ADA spearheaded the migration. The team replicated the existing AWS Redshift data structures and objects onto Azure Synapse, optimizing them for enhanced performance and ease of use. ADA employed shell scripts to automate the migration of data from AWS S3 buckets to Azure Blob storage, leveraging Azkaban for batch workflow scheduling to oversee the migration process efficiently.​

This also positioned the company to capitalize on Azure’s advanced data warehousing capabilities, marking a significant milestone in its data management evolution.​

The Execution

Previous systems

New system

 

Results
Challenge
Solution
Execution
Get in touch

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

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

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

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.

Results
Challenge
Solution
Execution
Get in touch

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

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

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

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.

Meanwhile, 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.

Custom 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%.

Results
Challenge
Solution
Get in touch

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

How a Leading Retailer Cut P&L Forecasting From 60 minutes to 1 minute 

Industry type

How a Leading Retailer Cut P&L Forecasting From 60 minutes to 1 minute 

Where every touchpoint earns trust, every interaction creates value, and every decision is powered by realtime insight.
The Results

98% efficiency gain in P&L forecasting | 90% efficiency gain in sales analysis | 80% efficiency gain in budget optimization | 80% GMV growth

0 %
Efficiency Gain in P&L Forecasting
0 %
Efficiency Gain in Sales Analysis
0 %
Efficiency Gain in Budget Optimization 
0 %
GMV Growth
The Challenge

A personal care retailer’s ecommerce team was trapped in manual work. P&L forecasting: 60 minutes. Budget optimization: 5 minutes per query. Sales analysis: 10 minutes per request. The team spent their time pulling data from multiple systems and reconciling numbers, not making decisions. By the time insights were ready, the opportunity had often passed. SKU-level performance went unanalyzed because nobody had time to dig. Product potential was going unrecognized.

The Solution

ADA deployed AI Command Center with CoPilot, enabling natural language queries against commerce data. The team could ask “What’s the P&L forecast for next month?” and get an answer in one minute instead of building a 60-minute report.

The system surfaced SKU-level patterns the team had never seen products underperforming relative to category benchmarks, inventory imbalances across channels, campaign timing mismatches. Analysts stopped building spreadsheets and started acting on recommendations.

Results
Challenge
Solution
Get in touch

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

How ADA Built, Managed, and Enhanced D2C for leading Apparel Company across APAC

Industry type

How ADA Built, Managed, and Enhanced D2C for leading Apparel Company across APAC

Where every touchpoint earns trust, every interaction creates value, and every decision is powered by realtime insight.
The Results

40% YoY Growth | 159K Products Managed | 22K Items Sold Year 1 | 70K subscriber base 

0 K
product catalogue managed
0 K
items sold in Year 1
0 %
YoY GMV growth
0 K
subscriber base 
The Challenge

A global footwear and apparel brand needed to establish a direct-to-consumer presence across Southeast Asia but had no infrastructure to do it. There was no online retail platform in Malaysia, Singapore, or Hong Kong. The brand lacked both an ecommerce team for daily operations and a technical team for platform development.

The gap was comprehensive from frontend customer experience to backend catalogue management for 159K SKUs. They couldn’t just build a platform; they needed someone to run it, maintain it, and continuously improve it.

The Solution

ADA delivered end-to-end D2C platform build with CX design, technology development, and ongoing operations across all three markets. 159K products were onboarded with SKU upload and master catalogue coordination.

Continuous feature development averaged 20+ new functions per year, with 100+ features delivered across the engagement. CRM and email marketing automation built a 70K subscriber base with 1M+ annual emails. Year 1 delivered 22K items sold; subsequent years delivered 30-40% YoY GMV growth.

 

Results
Challenge
Solution
Get in touch

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