100 Best ChatGPT KPI and Dashboard Prompts for Mortgage Brokers

Direct Answer

The best ChatGPT prompts for KPI and dashboard for mortgage brokers are a curated set of 100 actionable prompts that cover lead generation, application funnel, funding speed, product profitability, risk, and compliance metrics. Use them to build, audit, and optimize dashboards that drive mortgage performance and informed decisions.

Introduction

This page is a practical prompt library for KPI and dashboard prompts tailored to mortgage brokers. It helps professionals build clear, actionable dashboards without writing complex queries.

Designed for mortgage brokers, sales managers, and analytics teams, the prompts translate business questions into precise prompts that yield ready-to-use metrics, charts, and insights.

How to Use These ChatGPT Prompts

• Replace placeholders like [industry], [audience], and [format] with your data and preferred output style.
• Add constraints to specify time ranges, regions, or product types to keep prompts focused.
• Request concrete output formats such as tables, charts, JSON, or bullet lists to simplify integration into dashboards.
• Verify outputs by cross-checking with source systems and validating key assumptions.
• Iterate by refining prompts based on what insights are most actionable for your team.

100 Best ChatGPT KPI and Dashboard Prompts for Mortgage Brokers

1. Lead generation KPI overview: Role: Analytics assistant. Task: Generate a KPI dashboard sketch for mortgage lead generation. Context: Use data from marketing channels, CRM, and site analytics. Output format: bullet list with 5 core KPIs and 3 drill-down charts. Constraints: include quarterly targets, trend arrows, and data freshness within the last 24 hours.
2. Application funnel stages: Role: BI analyst. Task: Define the mortgage loan application funnel stages and KPI signals. Context: Include visitors, leads, pre-qualifications, applications, approvals, closes. Output format: table with stage, metric, target, and RAG status. Constraints: include conversion rate between stages and seasonality notes.
3. Application to approval delta: Role: Performance analyst. Task: Compute delta between applications and approvals by channel. Context: Use last 12 weeks data, breakouts by channel, mortgage product, and region. Output format: summary paragraph plus a chart data series in JSON-like structure. Constraints: flag channels with negative delta and provide remediation.
4. Close rate by broker: Role: Portfolio manager. Task: Create KPI prompt that outputs close rate by broker, with confidence intervals. Context: Data from CRM, lender feeds, and regional offices. Output format: ranked list of brokers with close rate, sample size, and lower/upper bounds. Constraints: exclude brokers with fewer than 20 cases.
5. Time to funding: Role: Operations analyst. Task: Track time from lender submission to funding. Context: Use average days, median days, and outliers by product. Output format: dashboard widget definitions and alert thresholds. Constraints: include data quality checks and data provenance notes.
6. Turnaround time targets: Role: Operations lead. Task: Define SLA targets for each loan processing step and visualize heatmap of SLA attainment. Context: Include document collection, underwriting, condition clearance, and funding. Output format: bullet list with targets and current attainment, plus a heatmap data array.
7. NPS by mortgage product: Role: Customer insights analyst. Task: Build KPI prompt to track Net Promoter Score by product line. Context: Include HELOC, fixed-rate, adjustable-rate, jumbo. Output format: table and sentiment breakdown by reason. Constraints: provide action items for detractors.
8. Customer lifetime value: Role: Finance analyst. Task: Estimate CLV for mortgage clients across segments. Context: Include repeat refi potential, referral value, and cross-sell. Output format: financial projection table and a bar chart dataset. Constraints: discount rate and churn assumptions clearly stated.
9. Referral channel performance: Role: Marketing analyst. Task: Assess referral sources for mortgage loans and calc ROI. Context: Use last 6 quarters data. Output format: ROI by channel with confidence intervals and recommended bets. Constraints: include cost per lead adjustments.
10. Cross-sell opportunity heatmap: Role: Portfolio strategist. Task: Identify cross-sell opportunities within existing clients (home equity products, insurance). Context: Use client tiers and product adjacency. Output format: heatmap matrix and 5 prioritized offers. Constraints: ensure regulatory compliance notes.
11. Operational risk score: Role: Risk manager. Task: Create a KPI that scores operational risk per branch. Context: Include compliance checks, SLA misses, data quality events. Output format: numeric risk score plus trend and recommended mitigations.
12. Regulatory compliance KPIs: Role: Compliance officer. Task: Define KPIs to monitor regulatory adherence in mortgage processing. Context: Include form accuracy, disclosure timing, and data privacy checks. Output format: dashboard cards with status, owner, and latest update.
13. Data quality freshness: Role: Data steward. Task: Produce KPI for data freshness across mortgage data feeds. Context: Include last load timestamp, data latency, and feed health. Output format: trend lines and a table of feed statuses.
14. Forecast loan volumes: Role: Revenue planner. Task: Build a forecast KPI for monthly loan volume by product. Context: Use historical seasonality and external factors. Output format: line chart data, 12-month forecast, and confidence bands.
15. Deal flow velocity: Role: Sales ops. Task: Measure velocity from lead to funded loan. Context: Include stage durations and bottleneck flags. Output format: funnel plus average duration per stage and a bottleneck bar chart.
16. Campaign attribution: Role: Marketing analyst. Task: Attribute loan closes to campaigns with time decay. Context: Include multi-touch attribution, last-click vs first-click. Output format: attribution table and visuals showing top campaigns.
17. Lender performance index: Role: Portfolio manager. Task: Create index scoring lenders on approval rate, funding speed, and conditions. Context: Compare top 5 lenders. Output format: star rating and ranked list with rationale.
18. Product mix by region: Role: Market analyst. Task: Visualize product mix by region and product. Context: Include jumbo vs conforming and adjustable rate vs fixed. Output format: stacked bar chart data and regional notes.
19. Reject reasons analysis: Role: Underwriting analyst. Task: Analyze loan rejection reasons to reduce future declines. Context: Provide top 5 reasons and recommended policy changes. Output format: bullet list plus action plan.
20. Condition clearance tracking: Role: Operations supervisor. Task: Monitor conditions required before funding. Context: Track status by loan and by condition type. Output format: table and trend line with flags.
21. Turnaround time drilldown: Role: Operations manager. Task: Drill down SLA misses by team and product. Context: Include root cause tags. Output format: tabular drilldown and suggested fixes.
22. Customer journey map: Role: UX analyst. Task: Map mortgage client journey and KPI touchpoints. Context: Include awareness, education, application, and post-close support. Output format: journey stages with associated KPIs.
23. Churn risk indicators: Role: Customer success. Task: Identify churn indicators among refinance customers. Context: Use lifecycle data and activity signals. Output format: risk score and recommended retention actions.
24. Referral conversion rate: Role: Growth marketer. Task: Measure referral conversion rate for mortgage referrals. Context: Include benchmark against industry. Output format: conversion rate table and top referral sources.
25. SLA breach alerts: Role: Risk and operations. Task: Create automated alerts for SLA breaches. Context: Include thresholds by team. Output format: alert rules and notification workflow.
26. Cost per loan: Role: Finance analyst. Task: Calculate cost per loan originations with breakdown by channel. Context: Include staffing, technology, and compliance costs. Output format: cost table and efficiency chart.
27. Turnaround by product: Role: Product manager. Task: Compare SLA attainment across loan products. Context: Include fixed, adjustable, FHA/VA. Output format: comparative chart dataset and recommendations.
28. Fraud risk indicators: Role: Compliance analyst. Task: Identify fraud risk signals in mortgage applications. Context: Use historical fraud cases and real-time signals. Output format: risk score and mitigation steps.
29. Credit policy compliance: Role: Underwriting supervisor. Task: Check policy adherence across applications. Context: Include credit score bands and income verification. Output format: compliance scorecard and exceptions log.
30. Portfolio health snapshot: Role: Portfolio manager. Task: Produce a quarterly health snapshot for the mortgage book. Context: Include delinquency, repurchase, and write-offs. Output format: dashboard card set and trend charts.
31. Delinquency trend by region: Role: Risk analyst. Task: Visualize delinquency rates by region over time. Context: Include cohort analysis and external factors. Output format: line chart data and regional notes.
32. Repurchase risk forecast: Role: QA analyst. Task: Forecast loan repurchases and buybacks. Context: Use last 8 quarters data. Output format: forecast table and sensitivity analysis.
33. Pricing optimization prompts: Role: Pricing analyst. Task: Suggest pricing adjustments to improve volume without margin loss. Context: Include competitive rates and cap rates. Output format: scenario table and recommended moves.
34. Productivity by tier: Role: Ops lead. Task: Measure staff productivity by role and tier. Context: Include loan officers, processors, and underwriters. Output format: stacked bars and per-person efficiency.
35. Regulatory changes impact: Role: Compliance strategist.Task: Assess impact of regulatory changes on processing times. Context: Include transition plan and risk mitigations. Output format: impact table and action list.
36. Data lineage map: Role: Data steward. Task: Produce data lineage for mortgage KPI sources. Context: Include data origin, transformation, and downstream usage. Output format: diagram data and documentation notes.
37. Audit readiness score: Role: Auditor. Task: Create KPI to measure audit readiness. Context: Include documentation completeness, control tests, and remediation speed. Output format: scorecard and improvement plan.
38. Customer sentiment trends: Role: CX analyst. Task: Track customer sentiment from support interactions. Context: Include channels and issue categories. Output format: sentiment trend chart and top drivers.
39. Cross-border mortgage KPIs: Role: Global mortgage ops. Task: KPI prompt for cross-border lending metrics. Context: Include regulatory parity and currency considerations. Output format: regional KPI table and risk notes.
40. Digital channel efficiency: Role: Digital ops. Task: Measure efficiency of digital loan submission channels. Context: Include form abandonment rate and average time to submission. Output format: funnel and efficiency score.
41. Underwriting turnaround: Role: Underwriting lead. Task: KPI for underwriting turnaround times. Context: Segment by product and channel. Output format: bar chart data and root cause tags.
42. Disclosure timing KPI: Role: Compliance officer. Task: Track timing of required disclosures. Context: Include state variations and document access. Output format: timeline chart and compliance status.
43. Automation impact: Role: Automation engineer. Task: Assess impact of automation on processing speed. Context: Include RPA and AI-assisted tasks. Output format: before-after metrics and ROI estimate.
44. Data quality scorecard: Role: Data steward. Task: Create a scorecard for data quality in mortgage data. Context: Include completeness, accuracy, and timeliness. Output format: color-coded scorecard and remediation backlog.
45. Loan product profitability: Role: Finance analyst. Task: Compare profitability by loan product. Context: Include servicing costs and risk-adjusted margins. Output format: profitability table and guidance notes.
46. Agent performance metrics: Role: Channel manager. Task: KPI prompt for loan officer performance. Context: Include conversion, speed, and customer satisfaction. Output format: ranked list and trend visuals.
47. SLA adherence by region: Role: Operations lead. Task: Visualize SLA adherence per region. Context: Include regional staff and product mix. Output format: map chart data and notes.
48. Compliance training impact: Role: Training manager. Task: Measure impact of compliance training on processing errors. Context: Include time since training and error rates. Output format: correlation table and recommended actions.
49. Finance and risk alerts: Role: Controller. Task: Create alert system for financial risk indicators in mortgage lending. Context: Include liquidity, credit risk, and concentration. Output format: alert rules and sample alerts.
50. Forecast accuracy check: Role: Forecasting analyst. Task: Validate accuracy of loan volume forecast. Context: Include historical bias and error metrics. Output format: accuracy dashboard with confidence bands.
51. Niche product KPIs: Role: Product lead. Task: KPIs for niche mortgage products (jumbo, VA, FHA). Context: Include approval rates and pricing accuracy. Output format: product-specific KPI table.
52. Lender diversification: Role: Portfolio manager. Task: KPI prompt for lender diversification and concentration risk. Context: Include share by lender and exposure limits. Output format: diversification chart and risk notes.
53. Alerts for data gaps: Role: Data ops. Task: Define alerts for missing data in feeds. Context: Include critical fields and remediation steps. Output format: alert rules and runbooks.
54. Customer onboarding metrics: Role: Customer success. Task: Track onboarding speed and satisfaction. Context: Include document submission and welcome call timing. Output format: onboarding scorecard and first-week feedback visuals.
55. Post-close retention: Role: CRM analyst. Task: KPI for post-close engagement and referrals. Context: Include communication cadence and value realization. Output format: retention curve and top touchpoints.
56. Portfolio risk tiering: Role: Credit risk analyst. Task: Tier mortgage portfolio by risk score. Context: Include delinquency probability and loss given default. Output format: risk tier map and recommended actions.
57. Refinance propensity: Role: Growth strategist. Task: Identify customers likely to refinance within 2 years. Context: Use credit behavior and equity data. Output format: propensity score table and targeting list.
58. Operational cost trimming: Role: Cost optimizer. Task: Find 5 high-impact cost reductions without service impact. Context: Include back-office and tech spend. Output format: cost-cutting options and ROI.
59. LTV to cost ratio: Role: Finance analyst. Task: Compute LTV to cost ratio per loan. Context: Include servicing revenue and cost to originate. Output format: ratio table and recommendations.
60. Customer contact rate: Role: CX manager. Task: Monitor customer contact rate per loan stage. Context: Include channels and reasons for contact. Output format: rate chart and action plan.
61. Appraisal turnaround: Role: Appraisal coordinator. Task: KPI for appraisal ordering to receipt turnaround. Context: Include lender requirements and vendor performance. Output format: timeline chart and vendor scorecard.
62. Documentation completeness: Role: Compliance auditor. Task: Scorecard for required mortgage documents. Context: Include missing items and remediation time. Output format: completeness score with drill-down view.
63. Disclosures automation: Role: Compliance tech. Task: Automate disclosure generation and tracking. Context: Include responsible parties and versioning. Output format: automation status and sample disclosure log.
64. Credit pull efficiency: Role: Underwriting ops. Task: Track efficiency of credit checks. Context: Include soft pulls vs hard pulls and time to decision. Output format: efficiency chart and recommended controls.
65. Closing cost optimization: Role: Product manager. Task: Identify opportunities to reduce closing costs for customers. Context: Include lender credits and fee disclosures. Output format: savings ideas and impact estimates.
66. Branch performance score: Role: Regional ops. Task: Score branches on loan volume, quality, and service. Context: Include regional market factors. Output format: branch leaderboard and insights.
67. Funding speed by lender: Role: Treasury analyst. Task: Compare funding speeds across lenders. Context: Include SLA attainment and batch processing. Output format: chart and recommendations.
68. Education resource KPI: Role: Education manager. Task: KPI for client education resources effectiveness. Context: Include usage, comprehension, and outcomes. Output format: usage heatmap and learning outcomes.
69. Complaint resolution time: Role: Customer support lead. Task: Track time to resolve mortgage-related complaints. Context: Include severity levels and escalation paths. Output format: SLA adherence and root causes.
70. Data governance readiness: Role: CIO. Task: KPI for data governance maturity in mortgage data. Context: Include policies, stewardship, and data catalogs. Output format: maturity score and next steps.
71. Investor reporting KPIs: Role: Investor relations. Task: KPIs for loan portfolio reporting to investors. Context: Include risk metrics, delinquency, and cash flow. Output format: investor-ready dashboard data.
72. Workflow automation impact: Role: Automation lead. Task: Quantify impact of workflow automation on cycle times. Context: Include ROI and risk. Output format: before-after metrics and a summary.
73. Education to conversion: Role: Growth marketer. Task: Measure education content to loan application conversion. Context: Include content types and time-to-apply. Output format: conversion table and content ROI.
74. Support channel mix: Role: CX strategist. Task: KPI for support channel mix during peak seasons. Context: Include response time and satisfaction. Output format: channel performance table.
75. Credit policy drift: Role: Compliance analyst. Task: Detect drift from standard credit policy. Context: Include anomaly detection and remediation steps. Output format: drift report and action plan.
76. Portfolio diversification metrics: Role: Portfolio manager. Task: KPI for diversification across loan types, regions, and lenders. Context: Include concentration thresholds. Output format: diversification dashboard with alerts.
77. Regulatory exposure heatmap: Role: Compliance officer. Task: Map regulatory exposure by geography and product. Context: Include upcoming changes. Output format: heatmap and mitigation notes.
78. Applicant satisfaction by channel: Role: CX analyst. Task: Satisfaction scores by submission channel. Context: Include driving factors. Output format: table and action items.
79. Procurement cost per loan: Role: Ops finance. Task: Track vendor costs for loan processing per loan. Context: Include service level costs. Output format: cost breakdown and optimization ideas.
80. Data latency alerts: Role: Data operations. Task: Set alerts for data latency breaches. Context: Include critical fields. Output format: alert rules and runbook.
81. Agent onboarding metrics: Role: Channel manager. Task: KPI for onboarding mortgage agents. Context: Include training completion and quota attainment. Output format: onboarding scorecard and trends.
82. Post-close referrals: Role: CRM marketer. Task: Track referrals from closed loans. Context: Include referral sources and conversion rate. Output format: table and top sources.
83. Customer health score: Role: Customer success. Task: Create composite health score for clients. Context: Include activity, payments, support tickets. Output format: score and risk notes.
84. Underwriter workload: Role: Ops lead. Task: Balance underwriting workload across teams. Context: Include backlog and overtime. Output format: distribution chart and staffing plan.
85. Dispute escalation rate: Role: Compliance supervisor. Task: Monitor dispute escalation rate. Context: Include root causes and resolution time. Output format: rate trend and action plan.
86. Marketing qualified leads: Role: Demand gen. Task: KPI for MQLs converting to mortgage applications. Context: Include lead scoring criteria. Output format: conversion funnel and MQL health.
87. Lending risk concentration: Role: Risk manager. Task: Track concentration risk by borrower segment. Context: Include exposure limits. Output format: concentration chart and mitigation steps.
88. Credit pull pass rate: Role: Underwriting supervisor. Task: Pass rate for credit checks by bureau. Context: Include variations by bureau. Output format: pass rate table and action notes.
89. Inefficiency flags: Role: Ops auditor. Task: Flag recurring inefficiencies in the loan process. Context: Include time deltas and owners. Output format: list of flags with recommended fixes.
90. Cash flow scenario planning: Role: Finance planner. Task: Scenario analysis for loan portfolio cash flow. Context: Include rate shifts and prepayment assumptions. Output format: scenario table and charts.
91. Vendor SLA compliance: Role: Procurement. Task: KPI for vendor SLA adherence in mortgage processing. Context: Include penalties and credits. Output format: compliance score and remediation actions.
92. Portfolio cash yield: Role: Portfolio analyst. Task: Calculate cash yield by loan product. Context: Include servicing fees and prepayment. Output format: yield table and note on assumptions.
93. Usage analytics by feature: Role: Product analyst. Task: KPI for feature usage in mortgage platform. Context: Include adoption, retention, and user satisfaction. Output format: feature map and adoption curves.
94. Accessibility compliance: Role: Compliance officer. Task: KPI for accessibility of online mortgage portal. Context: Include WCAG checks and remediation backlog. Output format: accessibility score and plan.
95. Early payoff risk: Role: Risk strategist. Task: Identify risk from early payoff behavior. Context: Include incentives and scenario impact. Output format: risk assessment and mitigation ideas.
96. Claims and repurchases: Role: Finance admin. Task: Track loan repurchase claims and timelines. Context: Include dispute status. Output format: claim chart and cure plan.
97. Branch training ROI: Role: Training program manager. Task: ROI of training for branches. Context: Include time to proficiency and error reduction. Output format: ROI table and recommendations.
98. Digital docs compliance: Role: Compliance tech. Task: Verify digital document compliance and e-signature usage. Context: Include audit trail. Output format: compliance dashboard and notes.
99. Incident response readiness: Role: IT security. Task: KPI for mortgage platform incident readiness. Context: Include detection, response time, and recovery time. Output format: readiness score and runbook links.
100. Executive performance summary: Role: CFO. Task: Generate executive-ready KPI summary for mortgage lending. Context: Include top-line revenue, risk, and utilization metrics. Output format: one-page dashboard data and notes.

Best Practices

• Use role-based prompts to align outputs with your team’s responsibilities.
• Keep outputs granular enough to be actionable but aggregated for quick reviews.
• Include data provenance notes and data quality checks in dashboards.
• Reuse prompts with different data slices to compare performance across regions or channels.
• Audit prompts periodically to ensure they reflect current regulatory and market conditions.

Common Mistakes to Avoid

• Asking for generic KPIs without context or data sources.
• Ignoring data quality and timeliness when interpreting dashboards.
• Overloading prompts with too many objectives in a single prompt.
• Using vague time frames like 'recent' without specifying dates.
• Neglecting to specify output formats, leading to incompatible dashboard widgets.

FAQ

What is a KPI dashboard for mortgage brokers?

A KPI dashboard combines key performance indicators for mortgage brokering into a visual, real-time view showing volumes, conversion, processing speed, profitability, and risk.

How many prompts are included in this library?

There are exactly one hundred distinct prompts tailored to KPI and dashboard use in mortgage brokering.

Can I customize prompts for specific lenders?

Yes. Replace placeholders with lender names, product types, regions, and policy details to tailor prompts to your lender mix.

What output formats are supported?

Prompts can produce tables, charts, JSON structures, and narrative summaries that are ready to import into dashboards.

How do I ensure data quality in prompts?

Include data provenance, data freshness, and validation steps in prompts to ensure reliable dashboard outputs.

Are these prompts suitable for compliance monitoring?

Yes, several prompts target regulatory and compliance KPIs, disclosures timing, and audit readiness.