▪️Customer

This section will help you understand customer groups, their behavior, and how well they are being retained over time.

Customer Segmentation

This section provides a breakdown of customers categorized by segment and key demographic metrics.

Table:

• Customer Segment: Customers are grouped into five categories — A, B, C, D, and E — based on their age groups.

• Age Group: Each segment is further categorized by age brackets: 0–17, 18–25, 26–35, 36–50, 51+

• Gender Distribution: This column displays the percentage of male and female customers within each segment. For example, in Segment C:

  • Male: 50%

  • Female: 50%

• Product Usage Metrics: Indicates the average number of products used per customer in each segment.

Visualization:

This section includes visual insights to help you better understand customer distribution and behavior:

• Product Usage Chart: A line or bar chart displays how many products customers are using over time.

  • Y-axis: Number of products

  • X-axis: Dates

  • Each customer segment is color-coded for clarity e.g:

    • Segment A – Green

    • Segment B – Yellow

    • Segment C – Blue

    • Segment D – Black

    • Segment E – Red

• Filters Available: You can refine the data shown using filters for:

  • Branch

  • Customer Segment

  • Age Range

  • Time Period

Customer Retention & Churn

This section helps you track how well your institution is retaining clients and identify those at risk of churning. Customers are grouped into segments based on their loan activity and transaction history. This makes it easier to analyze retention patterns among different types of clients — from high-value to inactive ones.

Table:

• Customer Segment: Each client is evaluated against the following segments:

  1. Segment A (Premium/High-Value Customers) – Total disbursed amount is greater than 5,000,000.

  2. Segment B (Growth Customers) – Has taken three or more loans, but does not qualify for Segment A.

  3. Segment C (Casual Customers) – Has active loans or recent transactions, but does not qualify for Segment A or B.

  4. Segment D (Cost-Sensitive Customers) – Default segment for clients who do not meet any of the above conditions.

• Total Customers: The number of customers who fall within the different segments.

• Retained Customers: The number of customers who have made at least one transaction within two months before the end date.

• Churned Customers: The number of customers who did not make any transactions within two months before the end date.

• Retention Rate: The percentage of retained customers compared to the total number of customers: