Skip to content

Dashboard templates

Financial services · Marketing

Consumer finance company acquiring borrowers through digital ads, messaging to past customers, dealer open days and dealer referrals. Applications, disbursements and bad debt, plus the marketing funnel: spend, loan application leads, qualification rate, CPL, CAC, budget and marketing cost per application and per loan.

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

For marketing heads at consumer finance companies who win borrowers through digital ads, messages to past customers and events at dealers. The "Marketing and disbursements" dashboard links spend to lending results: marketing cost per application, per disbursed loan, and marketing spend as a share of disbursements. The "Campaigns and budget" and "Marketing funnel" dashboards cover spend, leads, qualified lead rate, CPL, CAC and budget utilization. Needs branch, loan product, loan application, loan, daily marketing spend and lead data.

Use this template to

  • Stop campaigns with a low CPL whose leads never turn into loans.
  • Allocate budget by cost per disbursed loan, not by clicks.
  • Watch campaigns about to go over budget this month.

6 ready-made dashboards

Marketing and disbursements

Marketing cost versus loan applications and disbursed loans company-wide.

  • Marketing cost per disbursed loan
  • Marketing cost per loan application
  • Marketing spend to disbursements
  • Marketing spend
  • Weekly marketing cost per loan
  • Cost per new borrower by campaign

Marketing funnel

Cost, leads, qualification rate, new customers and cost per new customer by channel and source.

  • Marketing spend
  • Leads
  • Cost per lead (CPL)
  • Customer acquisition cost (CAC)
  • Funnel by marketing channel
  • Lead qualification rate by source
  • Lead-to-customer rate by source
  • Weekly leads by channel

Campaigns and budget

Budget, cost, budget utilization and performance of each marketing campaign.

  • Budget utilization
  • New customer value to spend (marketing ROI)
  • New customers from marketing
  • Click-through rate (CTR)
  • Results by campaign
  • Budget utilization by campaign
  • Cost per new customer by channel
  • Weekly marketing cost by channel

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 marketing cost per loan application change compared with last month?”
  • “What is driving marketing cost per disbursed loan this quarter?”
  • “Show marketing spend to disbursements by month for the last six months.”
  • “Where is campaign budget highest this month, and why?”

33 defined metrics

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

MetricDefinitionUnit
Marketing cost per loan applicationMarketing campaign cost in the period divided by loan applications submitted company-wide in the period.= Marketing spend / Loan applicationsCurrency
Marketing cost per disbursed loanMarketing campaign cost in the period divided by loans disbursed company-wide in the period (all channels: branch counter, dealer, online).= Marketing spend / Loans disbursedCurrency
Marketing spend to disbursementsMarketing campaign cost in the period divided by the total amount disbursed company-wide in the period.= Marketing spend / Disbursed amountRatio (%)
Campaign budgetTotal budget of campaigns starting in the period. The full campaign budget is recorded on its start date.Currency
Budget utilizationMarketing spend divided by campaign budget. Above 100% means over budget.= Marketing spend / Campaign budgetRatio (%)
Customer acquisition cost (CAC)Marketing spend divided by new customers (by conversion date).= Marketing spend / New customers from marketingCurrency
ClicksTotal clicks (or engagements that drive traffic) of campaigns by day.Count
Cost per lead (CPL)Marketing spend divided by leads created in the period.= Marketing spend / LeadsCurrency
Click-through rate (CTR)Clicks divided by impressions.= Clicks / ImpressionsRatio (%)
New customer first-order valueTotal value of the first transaction of leads converted in the period, by conversion date.Currency
ImpressionsTotal impressions (or reach) of campaigns by day.Count
Lead-to-customer rateLeads created in the period that have become customers divided by leads created in the period.= mkt_converted_leads / LeadsRatio (%)
LeadsNumber of leads (prospects) created in the period, by creation date.Count
MQL rateMarketing-qualified leads divided by leads created in the period.= Marketing-qualified leads (MQL) / LeadsRatio (%)
Marketing-qualified leads (MQL)Leads created in the period that passed marketing qualification (status MQL, SQL or converted to customer).Count
New customers from marketingLeads that became customers in the period, by conversion date. Converted leads with no conversion date fall in no period.Count
New customer value to spend (marketing ROI)New customer first-order value divided by marketing spend. Above 1 means first orders have covered the cost.= New customer first-order value / Marketing spendNumber
Marketing spendTotal cost of marketing campaigns by spend date.Currency
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_application, loan, mkt_spend_daily, mkt_lead

Add if you have it (unlocks more metrics)

dealer, borrower, repayment, loan_balance_monthly, mkt_campaign

Three steps to this dashboard

  1. 1

    Connect your data

    Upload an Excel file or connect a source with: branch, loan_product, loan_application, loan, mkt_spend_daily, mkt_lead.

  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 33 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 · Marketing with your own data

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