Skip to content

Dashboard templates

Financial services · Customer service

A consumer finance company whose customer service center answers the hotline, makes payment reminder calls and replies on Zalo and email about loan lookups, restructuring, fee complaints and loan applications. Applications, disbursements and bad debt plus support tickets, response times, CSAT, abandoned calls and tickets by loan branch and product, without exposing borrowers.

Free plan with no time limit · No card required · Sample workspace ready in minutes

For customer service leads at consumer finance companies handling loan questions by hotline, collection calls, Zalo and email. The "Tickets by loan" dashboard puts tickets next to the loan portfolio, so you see which branches and products generate the most requests, measured as support tickets per billion VND of outstanding balance. The "Customer service" and "CS agents" dashboards track first response time, resolution rate, CSAT and missed calls. Needs branch, loan product, loan and support ticket data. Borrowers never appear on the dashboard.

Use this template to

  • Move call center staff to the branches with the most tickets per billion VND outstanding.
  • Catch a spike in fee complaints early after a fee schedule or loan restructuring policy changes.
  • Coach agents with low CSAT or long first response times.

6 ready-made dashboards

Tickets by loan

Tickets linked to the branch, product and dealer of the loan mentioned, against outstanding balance, without exposing borrowers.

  • Loan-linked support tickets
  • Support tickets per VND 1 bn outstanding
  • Loan-linked ticket share
  • NPL ratio
  • Tickets per billion VND outstanding by branch
  • Weekly loan-linked tickets by category
  • Branches - tickets and portfolio quality
  • Loan-linked tickets by product group

Customer service

Ticket volume, response and resolution speed, and customer satisfaction by channel and category.

  • Support tickets
  • Average first response time (hours)
  • Resolution rate
  • CSAT (satisfaction rate)
  • Daily tickets by category
  • By contact channel
  • Tickets by category
  • First response by channel group
  • NPS
  • Call abandonment rate

CS agents

Productivity, speed and quality of handling for each customer service agent and team.

  • Resolved tickets
  • Tickets per agent per day
  • First contact resolution rate
  • Ticket reopen rate
  • Results by agent
  • CSAT by team
  • Weekly CSAT by team

Credit overview

Company-wide disbursements, approval rate, outstanding balance and bad debt by branch and product.

  • Disbursed amount
  • Approval rate
  • Average outstanding balance
  • NPL ratio
  • Weekly disbursements by product group
  • Disbursements by branch
  • Results by branch

Applications and disbursements

Loan applications by acquisition channel, approval rate, and disbursements by product and partner dealer.

  • Loan applications
  • Approval rate
  • Loans disbursed
  • Average loan size
  • Weekly approval rate
  • Approval rate by acquisition channel
  • Disbursements by loan product
  • Disbursements via partner dealers

Portfolio quality and collections

Outstanding balance by risk group, NPL ratio, PAR30, collection rate and interest income.

  • NPL ratio
  • Portfolio at risk 30+ days (PAR30)
  • Collection rate
  • Interest income collected
  • Outstanding balance by risk group
  • Monthly NPL ratio by product group
  • NPL ratio by branch
  • Monthly collection rate by product group

Ask Si as soon as the build finishes

  • “How did loan-linked ticket share change compared with last month?”
  • “What is driving loan-linked support tickets this quarter?”
  • “Show support tickets per VND 1 bn outstanding by month for the last six months.”
  • “Where is call abandonment rate highest this month, and why?”

31 defined metrics

Versioned definitions, shared by dashboards, Si, reports and MCP.

MetricDefinitionUnit
Loan-linked ticket shareSupport tickets linked to a loan divided by all support tickets created in the period.= Loan-linked support tickets / Support ticketsRatio (%)
Loan-linked support ticketsSupport tickets created in the period (by creation date) whose contract number matches a loan; can be broken down by that loan's branch, product and dealer, and by ticket category.Count
Support tickets per VND 1 bn outstandingLoan-linked support tickets divided by average outstanding balance (in VND billions) for the period. Comparable across branches and products with different portfolio sizes.= Loan-linked support tickets * 1000000000 / Average outstanding balanceNumber
Call abandonment rateCalls where the customer hung up before reaching an agent divided by all inbound calls.= cs_abandoned_calls / Inbound callsRatio (%)
Average first response time (hours)Average hours from when the customer created a ticket to the agent's first response, over tickets created in the period that have a response.= cs_first_response_hours_total / cs_responded_ticketsNumber
Average resolution time (hours)Average hours from creation to resolution for tickets resolved in the period.= cs_resolution_hours_total / Resolved ticketsNumber
Inbound callsCalls into the call center in the period, including calls abandoned by the customer.Count
CSAT (satisfaction rate)Share of surveys with a CSAT score of 4 or 5 on a 1-5 scale, among surveys with a valid CSAT score.= cs_csat_positive / Survey responsesRatio (%)
First contact resolution rateTickets resolved with a single contact and never reopened divided by tickets resolved in the period.= cs_fcr_tickets / Resolved ticketsRatio (%)
NPSNet Promoter Score = (promoters 9-10 minus detractors 0-6) x 100 / NPS responses. Scale -100 to 100.= cs_nps_points * 100 / cs_nps_responsesNumber
Ticket reopen rateTickets resolved in the period that were ever reopened divided by tickets resolved in the period.= cs_reopened_tickets / Resolved ticketsRatio (%)
Resolution rateTickets created in the period that are resolved divided by tickets created in the period.= cs_created_resolved / Support ticketsRatio (%)
Resolved ticketsTickets resolved in the period (by resolution date); status resolved or closed with a resolution timestamp.Count
Survey responsesPost-support surveys with a valid CSAT score (1-5), by customer response date.Count
Support ticketsSupport tickets created in the period (by creation date), any status.Count
Tickets per agent per dayTickets created in the period divided by agent working days with tickets.= Support tickets / cs_agent_daysNumber
Loan applicationsNumber of loan applications submitted in the period (by submission date), across all decisions: approved, rejected, pending review and withdrawn by the customer.Count
Approval rateApproved applications divided by decided applications (approved plus rejected), by submission date. Applications pending review or withdrawn by the customer are excluded.= Approved applications / (Approved applications + Rejected applications)Ratio (%)
Approved applicationsApplications submitted in the period that were approved for a loan (by submission date).Count
Average NPL balanceOutstanding principal in debt groups 3-5, averaged over the month-end snapshots in the period.= fs_npl_outstanding_total / fs_snapshot_countCurrency
Average outstanding balanceOutstanding principal averaged over the month-end snapshots in the period = total outstanding across snapshots / number of snapshots.= fs_outstanding_snapshot_total / fs_snapshot_countCurrency
Average loan sizeDisbursed amount divided by the number of loans disbursed in the period.= Disbursed amount / Loans disbursedCurrency
Collected amountTotal paid by customers (principal and interest) in the period, by payment date.Currency
Collection rateAmount collected on installments falling due in the period divided by the amount due on those installments (by due date, with collections counted up to the data date).= fs_collected_for_due / Amount dueRatio (%)
Disbursed amountTotal principal disbursed for loans in the period (by disbursement date).Currency
Amount dueTotal principal and interest of repayment installments falling due in the period (by due date).Currency
Interest income collectedThe interest portion of customer payments in the period (by payment date). Payments are applied first to the interest of earlier installments, the remainder to principal.Currency
Loans disbursedNumber of loans (credit contracts) disbursed in the period.Count
NPL ratioOutstanding balance in debt groups 3-5 (more than 90 days past due) divided by total outstanding, on the month-end snapshots in the period.= fs_npl_outstanding_total / fs_outstanding_snapshot_totalRatio (%)
Portfolio at risk 30+ days (PAR30)Outstanding principal of loans more than 30 days past due divided by total outstanding, on the month-end snapshots in the period.= fs_par30_outstanding_total / fs_outstanding_snapshot_totalRatio (%)
Rejected applicationsApplications submitted in the period that were declined (by submission date).Count

Data you need

Required

branch, loan_product, loan, cs_ticket

Add if you have it (unlocks more metrics)

dealer, borrower, loan_application, repayment, loan_balance_monthly, cs_agent, cs_survey, cs_call

Three steps to this dashboard

  1. 1

    Connect your data

    Upload an Excel file or connect a source with: branch, loan_product, loan, cs_ticket.

  2. 2

    Approve Si's proposal

    Si proposes how to read your tables and map them to the industry's standard model; you fix anything highlighted and approve.

  3. 3

    Dashboards and Q&A

    The build gives you 6 dashboards and 31 metrics; ask Si anytime.

Data sources for this template

Connectors with a setup guide that feed the entities this template needs. Excel always works.

Related templates

Build Financial services · Customer service with your own data

Free plan with no time limit · No card required · Sample workspace ready in minutes