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!

13% GMV Growth & 20 Man-Hours Saved: A Data Transformation Case Study

Case Study

13% GMV Growth & 20 Man-Hours Saved: A Data Transformation Case Study

The Results
By providing consolidated, actionable data insights, we empowered Clothing Brand A to leverage previously “lost” time and information effectively, resulting in a remarkable 13.6% increase in Gross Merchandise Value (GMV)
Our proprietary AI Signals instantly analyse, performance trends, enabling the brand to identify best-selling products and market opportunities. This intelligence provides AI-driven recommendations, allowing them to swiftly close sales gaps and maximise revenue.
Our platform offers real-time flagging of potential risks, allowing the brand to proactively mitigate issues before they impact performance. This ensures they remain on track with their goals and significantly reduces potential losses.
The automation of data consolidation eliminated up to 20 man-hours per week previously spent on manual spreadsheet compilation. This freed up valuable human resources, enabling respective business units to minimise their lead time in decision-making by up to 2 days , fostering a more agile and efficient operation.
The Challenge

Clothing Brand A, a multinational retailer operating across three countries and utilising four distinct sales channels (their brand .com and major marketplace platforms like Lazada, Shopee, and TikTok), faced significant hurdles in consolidating and generating timely business reports. Their existing manual process, requiring a full week to aggregate data from multiple sources, led to several critical issues:

  • Outdated Reports: Data became irrelevant by the time it was compiled.
  • Potential for Human Error: Manual data entry and consolidation introduced inaccuracies.
  • Missing Data Gaps: Incomplete information hindered a holistic view.
  • Delayed Reactions: Inability to react swiftly to rapidly changing purchasing behaviours, leading to lost sales opportunities.

The brand urgently sought a solution to centralise their fragmented data into a single source of truth, accessible in real-time to all stakeholders.

The Strategy

Our approach was systematic, focusing on understanding the client’s unique needs and delivering a tailored, intelligence-driven platform.

  1. Deep Dive: Understanding the process and pain-points
    We began with a comprehensive discovery phase, engaging directly with the client to understand their day-to-day data processes, the specific challenges they encountered when pulling reports from various platforms, and their key metrics. This crucial step allowed us to identify current reporting consolidation methods and pinpoint opportunities for automation.‚:
  2. Seamless Integration: Consolidating Data Streams
    With a clear understanding of the pain points, our team proceeded to integrate all of Clothing Brand A’s diverse data sources directly into our intelligence platform. This process ingested fragmented data points, transforming them into an all-in-one, AI-powered dashboard.‚:
  3. Strategic Alignment: Actionable Insights for Business Goals
    Beyond mere data consolidation, we aligned our efforts with Clothing Brand A’s specific business objectives and goals. This enabled us to create a “top-to-bottom” funnel view within our platform. Powered by our Intelligence Commerce capabilities, this allowed the business to seamlessly navigate from overall store performance down to granular individual product insights, providing clarity, speed, and accuracy in their decision-making.
__wf_reserved_inherit

‚:

__wf_reserved_inherit

Content
Results
Challenge
Strategy
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!

How Pakuwon Group Modernised Mall Customer Engagement with WhatsApp Broadcast and OTP Solution

Case Study

How Pakuwon Group Modernised Mall Customer Engagement with WhatsApp Broadcast and OTP Solution

The Results
0 k+
Total customer interactions across all Pakuwon Group properties
0 k+
Average monthly conversations driving customer engagement
0 k+
Marketing and promotional broadcast engagements
The Challenge

In Indonesia’s vibrant retail landscape, where bustling malls serve as community hubs and shopping destinations, connecting with customers has evolved far beyond traditional advertising. Pakuwon Group, a pioneering leader in Indonesia’s real estate sector, recognised this shift early on. With major Jakarta malls under their portfolio, they understand that modern shoppers expect personalised, immediate communication that fits seamlessly into their daily digital habits.

This realisation led Pakuwon Group to reimagine their customer engagement strategy, transforming how they connect with over 65,000 customers through an innovative WhatsApp-powered approach that combines broadcast messaging with secure verification.

Pakuwon Group faced the modern retailer’s dilemma: how to maintain meaningful relationships with customers in an increasingly digital world whilst ensuring security and authenticity in every interaction.

Reaching shoppers beyond the mall floor: While Pakuwon Group’s malls attracted thousands of daily visitors, connecting with them outside their physical spaces proved challenging. Traditional promotional channels weren’t delivering the immediacy and convenience that today’s mall-goers expect, creating a gap between in-mall experiences and ongoing customer relationships.

Creating a community beyond retail transactions: Mall ownership presented unique opportunities for deeper customer relationships, but simply broadcasting promotional content wasn’t enough. Pakuwon Group needed to foster genuine conversations that extended their mall community into the digital realm, creating valuable touchpoints that customers would actively seek out.

Protecting the premium mall experience digitally: As a major mall operator, maintaining trust and security standards was crucial. The customer verification process needed enhancement to protect both shoppers and the business whilst preserving the seamless, premium experience that Pakuwon Group’s mall visitors expect from every interaction.

The Strategy

Working in partnership with ADA, Pakuwon Group developed a comprehensive WhatsApp communication strategy that transformed how they engage with their mall community. The solution seamlessly blends promotional broadcasting with secure customer verification, creating a trusted digital touchpoint that customers actively embrace.

Official Business Account with instant credibility: We have established Pakuwon Group’s verified WhatsApp Business account, complete with the coveted blue tick verification. This immediately built trust and recognition, allowing customers to engage confidently knowing they were communicating with the authentic Pakuwon Group brand.

Intelligent broadcast capabilities for targeted engagement: The platform enables sophisticated promotional messaging that goes beyond mass broadcasting. Customers receive personalized event notifications, exclusive offers, and relevant announcements based on their interests and shopping patterns, creating a curated experience that feels tailored rather than generic.

WhatsApp OTP integration for seamless security: Perhaps most innovatively, we integrated WhatsApp OTP (One-Time Password) functionality, allowing customers to receive secure verification messages through their preferred messaging platform. This familiar channel eliminated the friction often associated with verification processes while maintaining robust security standards.

‚:

The Execution

The implementation focused on three strategic pillars that work in harmony:

Verified Business Presence: Established the official WhatsApp Business account with blue tick verification, creating immediate trust and brand recognition among customers

Targeted Broadcast Strategy: Implemented sophisticated promotional messaging capabilities that deliver personalized content about events, offers, and mall updates directly to customers’ WhatsApp conversations

Deployed OTP in WhatsApp: Deployed WhatsApp OTP functionality for secure customer verification, transforming a traditionally cumbersome process into a seamless, familiar experience

__wf_reserved_inherit

“We feel delighted. The ADA team has consistently provided us with exceptional service and support. The employees are knowledgeable and always ready to share valuable insights, helping us navigate our campaigns with ease.

Working with ADA has truly enhanced our communication efforts, and we appreciate their dedication to our success.”
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!