HSBC commercial bank were looking to transform their segmentation models to minimise human error, misinformation and operational efficiency. This was in order to gain insights to develop effective global multi-channel marketing strategies.
We created an ‘extract, transform and load’ (ETL) pipeline that accepts raw data before it is entered into the spreadsheet and inserted into a structured data model.
This could then be enriched by other data sets – opens, clicks and dwell times of past campaigns – to create a holistic view of the current campaign and channel.
Next came a set of exclusion reports to help improve their internal validation processes and continually improve the quality of the incoming data.
We also produced a set of user-friendly dashboards allowing the client to cut and slice their reporting by campaign, channel and customer segments.
More client stories
How to execute advance campaigns
Adobe Campaign enablement
Use advanced Adobe Campaign
workflow techniques and personalise your emails
Digitise your online customer journey
Student digital transformation
Create web application forms,
email journeys and campaign reporting
Design a customer retention strategy
Churn model & win-back
Know which customers are at
risk of churn before it’s too late
Target customers at the right time
Propensity to buy
Predict when your customer
is likely to purchase next
Time and day analysis
Best time to send?
Maximise engagement –
communicate with customers
at the ‘right’ time
Commercial critical insights
Business intelligence live insights
Make smart business decisions
based on real-time data-driven insights
Understand customer needs
Understand customer evolving needs
Natural language processing
Voice of the consumer
Analyse customer feedback from
reviews, texts, survey responses,
online & social media
Feed data into dashboard
Merge multiple data sources
Provide a powerful and unified
analytics environment for big data