A leading bank in Belgium was looking to offer the most relevant products and services for each client’s situation and monitor the sales performance of its agency network.
But they suffered from a lack of visibility on the clients’ relationship with the bank and their activities' intensity.
The goals of this project were threefold:
We first searched for all indicators of clients’ activity by extracting product holding data, the amounts and variability of assets on the accounts, the variation from one product to another, the renewal rate on the existing product, and socio-demographic information from databases. We also extracted the transactional information needed to establish an accurate profile of the client’s usage.
Secondly, we built a historical data mart to establish a clear vision of each client’s product possessions and types of transactions for the last two years of the relationship.
Third, we summed up each client’s assets and information, then we weighted these levels of activity to assign clients to the relevant segment.
Finally, we automated the creation of this data mart and a monthly Excel reporting on the percentage of clients in each segment, available for the entire bank’s agency network.
This project achieved three results:
Since 2015, Agilytic helps innovative leaders solve their biggest challenges through the smarter use of data. With over 100 successful projects to date, we have perfected a pragmatic approach to putting data at the service of business goals, be they commercial, operational, financial, or human. Reach out today for a quick introduction, we’d love to hear from you.