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

Segment

Retail

The Results

  • The client gained a firm understanding of 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 u0026 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 u0026 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

1 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.

2 The Insights on visitor analysis

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

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!

Revamping customer emails for Owndays with marketing automation

Case Study

Revamping customer emails for Owndays with marketing automation

Segment

Retail

The Results

  • OWNDAYS acquired the tools to maximise their email marketing performance and to integrate previously walled-off data points, enabling them to 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 for automated customer emails.
  • MarTech Enablement empowered OWNDAYS to deliver personalised value to customers in the long term.

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 Solution

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.

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!

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

Segment

Retail

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 needed E-Commerce Digital Performance Dashboards to provide insights into its rapidly expanding e-commerce business. However, its transactional and clickstream customer interaction data were located in separate data silos, hampering a consolidated view of its data.

ADA helped migrate the customer’s clickstream data from GCP BigQuery and consolidated it with its transactional data on AWS Redshift. We merged session-level data with revenue data to create a holistic analytics dataset. ADA then built AWS QuickSight dashboards to provide:

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!

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

Segment

Retail

The Results

Eliminated manual data collection requirements.
Eliminated manual data collection requirements.
Data Accuracy
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 into data from their managed brands’ ecommerce platforms and marketplaces.

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

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

The Approach

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 a difference of only 6.8%:

  • Prediction for Y2023: 21,339 units (overall)
  • Actual for Y2023: 22,067 units (overall)
Table Of Contents
The Results
The Execution
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!

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

Segment

Retail

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

1 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.

2 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.

3 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.

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!

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

Segment

Retail

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

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!

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

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!

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

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!

How a Leading Ecommerce Group Achieved Single Source of Truth Across Channels 

Case Study

How a Leading Ecommerce Group Achieved Single Source of Truth Across Channels 

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

Retail

The Results

Single Source of Truth Achieved | Improved Stock Forecasting | Cross-channel Promo ROI Visibility 

The Solution

ADA implemented AI Command Center to unify fragmented data, improve stock forecasting and classification, and enable voucher/discount ROI measurement across all channels, giving leadership visibility they never had before. 

Table Of Contents
The Results
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

See How ADA Verify Can Simplify Your Customer Onboarding

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

Case Study

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.
Segment

Retail

The Results

98% Efficiency Gain in P&L Forecasting | 90% Efficiency Gain in Sales Analysis | 80% Efficiency Gain in Budget Optimization 

0 %
Efficiency Gain in P&L Forecasting
0 %
Efficiency Gain in Sales Analysis
0 %
Efficiency Gain in Budget Optimization 

The Solution

ADA deployed AI Command Center with CoPilot to identify hidden SKU potential, speed up campaign planning, and provide data-backed recommendations, transforming analysis time from hours to minutes and surfacing insights that were previously never available. 

Table Of Contents
The Results
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

See How ADA Verify Can Simplify Your Customer Onboarding