تفاصيل العمل

This dashboard contains customer information, the loan portfolio, a summary of the previous marketing campaign, and the current marketing campaign.

📌On the first page, the loan portfolio is presented.

✅The loan portfolio is very healthy. The default rate is only 2%, which means the bank has a low level of credit risk.

✅Housing loans are the most popular product, representing 56% of all loans.

✅Married customers hold the largest share of deposits, making them the most valuable customer segment. This also explains why housing loans are the most popular product.

✅Retired customers and tertiary-educated customers have the highest average balances.

✅Blue-collar workers(manual labor workers) and secondary-educated customers have high borrowing levels but relatively low balances.

✅Personal loans represent only 16%, which creates an opportunity for cross-selling.

📌On the second page, I summarize the previous marketing campaign.

✅The campaign achieved an 18% success rate among contacted customers, while 37,000 customers had never been contacted. This represents a great opportunity for future marketing campaigns.

✅Cellular communication was the most effective way to reach customers and achieve subscriptions.

✅The most responsive customer segments were management, technicians, and customers with secondary education.

📌On the third page, the current marketing campaign

✅focused on addressing the main weakness of the previous campaign, which was the 37,000 customers who had never been contacted.

As a result, the campaign achieved around 40,000 subscriptions, while only about 5,000 customers did not subscribe.

✅The top customer segments were blue-collar workers, management employees, and customers with secondary education.

✅Cellular communication remained the most effective communication channel for achieving customer responses and subscriptions.

📌Recommendations

✅Increase investment in mobile marketing.

✅Target the most responsive customer segments.

✅Expand cross-selling opportunities.

I look forward to your feedback and would be happy to hear any comments or suggestions. I really appreciate your time.

بطاقة العمل

اسم المستقل
عدد الإعجابات
0
تاريخ الإضافة
المهارات