100 Best Gemini KPI and Dashboard Prompts for Mortgage Brokers

Direct Answer

The best Gemini prompts for KPI and dashboard for mortgage brokers are a practical collection designed to drive measurable improvements in loan origination, funding speed, risk, and client experience. Use these prompts to build dashboards, automate reports, and monitor channel performance; tailor data sources and time frames to your stack, validate outputs, and iterate with stakeholders.

Introduction

This page provides a ready-to-use library of Gemini prompts focused on KPI and dashboards for mortgage brokers. It helps analytics teams, operations leaders, and loan officers design metrics that improve efficiency and profitability.

By following these prompts, mortgage broker teams can standardize metrics, accelerate decision making, and create dashboards that clearly communicate performance to executives and frontline staff.

How to Use These Gemini Prompts

• Replace placeholders like [industry], [audience], and [format] with your specific data and stakeholders.
• Add constraints such as data latency, acceptable error margins, and refresh cadence to ensure outputs stay relevant.
• Request outputs in formats suitable for dashboards, such as JSON schema, CSV snippets, or visualization-ready descriptions.
• Verify outputs against source systems and sample data to ensure accuracy before embedding in production dashboards.
• Iterate prompts with feedback from users to improve clarity and usefulness of results.

100 Best Gemini KPI and Dashboard Prompts for Mortgage Brokers

1. Lead to loan conversion metric: Act as a KPI analyst for a mortgage brokerage. Your task is to define a KPI that measures lead-to-loan conversion efficiency. Provide a schema showing data source, calculation method, data latency, and a sample monthly dashboard card. Output: a concise table with fields: KPI name, definition, formula, data source, data owners, refresh cadence, and a sample visualization description.
2. Monthly portfolio summary: You are a dashboard designer for a mortgage broker. Create a monthly portfolio summary that shows total funded loans, outstanding balance, average loan size, and delinquencies by region. Include filters for date range, product type, and channel. Output: a dashboard-ready JSON snippet with metrics, time granularity, and recommended visuals.
3. Sales funnel heatmap: Role: BI analyst. Build a sales funnel heatmap for mortgage originations by stage (lead, pre-qualification, application, approval, fund). Include color scale rules, thresholds, and a toggle for quarter-over-quarter comparison. Output: a specification block with axes, legend, and data flow notes.
4. Rate lock velocity: You are an analytics engineer. Create a KPI and visualization set to measure rate lock velocity by loan officer and product, including lag analysis and variance by rate tier. Output: a compact dashboard widget spec with filters and expected variance bands.
5. Average time to close: Act as a performance analytics consultant. Define a KPI for average time from application to funded loan. Provide breakdowns by channel (online, broker, branch) and loan type. Output: a recommended chart suite and data lineage notes.
6. Originations by channel: Role: analytics architect. Create a dashboard section that shows originations by channel (broker, direct, correspondent). Include trend lines, seasonality, and quarterly benchmarks. Output: a dashboard card description and KPI calculations.
7. Customer acquisition cost: You are a KPI designer. Define CAC for mortgage sales, including marketing spend, referral incentives, and support costs. Provide a normalized CAC per closed loan and a visualization plan for the dashboard.
8. Deal aging analysis: Act as a dashboard engineer. Build an aging analysis for active applications by days in progress, with alerts for aging > 15, 30, and 45 days. Output: a rule-driven dashboard specification.
9. Pipeline win rate: Role: performance analyst. Calculate pipeline win rate by loan type and channel, with confidence intervals and historical trend. Output: a dashboard-ready KPI card and an alert rule.
10. Delinquency trend: You are a risk analyst. Create a delinquency trend KPI by product, region, and loan officer, with a 12-month rolling window and dashboard widgets. Output: a narrative plus visuals.
11. Funding speed: Act as a dashboard designer. Define funding speed as days from approval to funded, by lender and product. Include control charts, target benchmarks, and drill-down capabilities.
12. Credit performance mix: Role: credit analytics. Build a KPI showing mix of credit tiers used in funded loans and its impact on default rates. Output: a matrix with tier, share, and risk score.
13. Turnover of loan officers: You are a performance manager. Monitor loan officer turnover impact on pipeline velocity and new client acquisition. Provide a KPI and visual alerts.
14. Referral source yield: Act as a marketing analytics specialist. Compute yield by referral source (real estate agents, builders, banks) and track changes over time. Output: dashboard widgets and data notes.
15. Cross-sell rate: Role: analytics consultant. Measure cross-sell rate per customer (services beyond mortgage) and correlate with NPS. Output: a KPI card and guidance for strategy.
16. Application completeness: You are a data quality engineer. Define a KPI for application completeness by required fields, with a scoring rubric and remediation actions. Output: a dashboard spec with data quality rules.
17. Document turnaround: Act as a process analyst. Create KPI for document upload and verification turnaround times, segmented by channel. Output: a visual scoreboard and alerting plan.
18. Underwriting cycle time: Role: operations analyst. Build a KPI for underwriting cycle time by risk tier and product line. Output: a dashboard blueprint with filters and targets.
19. Approval rate by product: You are a product analytics expert. Track loan approval rate by product type, with confidence intervals and seasonal adjustments. Output: a dashboard spec.
20. Funding gap alerts: Act as an operations engineer. Define KPI for funding gaps and create alert rules when funding falls behind projection. Output: a dashboard-ready alert schema.
21. Cost per funded loan: Role: finance analyst. Compute cost per funded loan including origination, processing, and overrides, with unit economics visuals. Output: a KPI card and breakdown.
22. NIM contribution: You are a financial strategist. Assess net interest margin contribution by loan segment and channel. Output: a dashboard section with levers and scenarios.
23. Portfolio health score: Act as a risk advisor. Create a portfolio health score combining delinquency, credit mix, and exposure. Output: a composite score with components.
24. Prepayment analysis: Role: analytics architect. Analyze prepayment rate by loan type and geography, with scenario planning. Output: a dashboard panel and data notes.
25. Regulatory compliance KPI: You are a compliance analytics lead. Define KPIs for file retention, privacy controls, and audit readiness. Output: a dashboard overview with controls.
26. Marketplace benchmark: Act as a market analytics consultant. Compare mortgage KPIs to a benchmark dataset, with gap analysis and recommendations. Output: a visualization plan.
27. SLA adherence: Role: operations manager. Define service level agreement adherence for document processing and app response times. Output: a KPI dashboard row with thresholds.
28. First-time close rate: You are a growth analyst. Compute first-time close rate by channel and consultant. Output: a dashboard panel and insights notes.
29. System availability: Act as an IT metrics analyst. Monitor system uptime, data refresh latency, and API errors affecting dashboards. Output: a reliability scorecard.
30. Client churn risk: Role: customer analytics. Build a churn risk score for borrowers at early post-close phase. Output: a dashboard widget and intervention flags.
31. Geo lending concentration: You are a risk modeler. Measure lending concentration risk by geography and product. Output: a risk heatmap and alert levels.
32. Rate lock default risk: Act as credit risk modeler. Analyze rate lock default risk by rate tier and loan purpose. Output: risk-adjusted KPI with warnings.
33. Annualized origination: Role: portfolio manager. Compute annualized origination rate by quarter and region. Output: a dashboard card and trend line.
34. Broker performance index: You are a broker performance analyst. Create an index aggregating broker revenue, conversion, and retention. Output: dashboard frame with weights.
35. Loan type profitability: Act as a financial planner. Assess profitability by loan type after costs and hedging. Output: a profitability matrix and visuals.
36. Digital application rate: Role: digital analytics. Track digital application rate vs. total apps, by channel and device. Output: an interaction chart and insights.
37. Avg order value by broker: You are a broker analytics lead. Calculate average loan size per broker and trend over time. Output: a dashboard card with comparator breaks.
38. Underwriter workload: Act as an operations analyst. Measure underwriter workload by day, product, and complexity. Output: a heatmap and staffing recommendations.
39. Document quality score: Role: data quality manager. Define a document quality score based on completeness, legibility, and verification status. Output: a dashboard badge and remediation plan.
40. Conversion by device: You are a UX analytics specialist. Analyze conversion rate from mobile vs desktop, by stage, with funnel probabilities. Output: a dashboard table and heatmap.
41. Loan officer ROI: Role: finance analyst. Compute ROI per loan officer considering compensation, productivity, and churn. Output: a dashboard card and recommendations.
42. Regulatory review cycle: Act as a governance analyst. Track cycle time for regulatory reviews by file type and region. Output: a KPI panel and bottleneck notes.
43. Inflow vs outflow cash: You are a treasury analyst. Monitor cash inflows from closings and outflows for operations. Output: a liquidity dashboard with alerts.
44. Portfolio diversification: Role: risk manager. Assess diversification across regions, products, and loan sizes. Output: a dashboard chart and risk guidance.
45. Marketing qualified leads: Act as a marketing analyst. Define MQLs for mortgage funnel, with conversion pathway to funding. Output: dashboard gates and definitions.
46. Application drop-off points: You are a funnel analyst. Identify key drop-off points in the application process by stage. Output: a prioritized remediation plan.
47. Data latency watchdog: Role: data engineer. Monitor data freshness and timeliness for critical dashboards. Output: alert rules and a performance report.
48. Forecast accuracy score: Act as a forecasting specialist. Measure forecast accuracy for monthly origination volumes and variance drivers. Output: a dashboard summary and error analysis.
49. Retention of clients: You are a CRM analyst. Track client retention post-close and cross-sell uptake. Output: a KPI panel and action plan.
50. Escrow hold management: Role: operations analyst. Monitor escrow hold durations and release accuracy. Output: a dashboard with SLA targets.
51. Cumulative defaults: Act as a risk analyst. Track cumulative defaults by vintage and region with escalation paths. Output: a risk dashboard card.
52. Credit utilization trend: You are a credit risk engineer. Analyze borrower's credit utilization trend and impact on approvals. Output: a dashboard visual and notes.
53. Rework rate: Role: process improvement. Measure rework rate in file processing, with root cause tagging. Output: a KPI card and action plan.
54. Document error rate: Act as data quality auditor. Compute document error rate by source and reviewer. Output: a dashboard filter and remediation steps.
55. Acceptance speed by channel: You are an operations analyst. Compare acceptance speed across broker, online, and bank channels. Output: a visualization plan and thresholds.
56. Expense per close: Role: finance analytics. Break down expenses per closed loan by category and quarter. Output: a dashboard cost sheet.
57. Turnaround time by region: Act as regional analyst. Measure processing turnaround time by geography and channel. Output: a regional KPI map.
58. Time to funding variance: Role: analytics engineer. Compare time to funding variance across lenders and product lines. Output: a dashboard variance report.
59. Client satisfaction index: You are a customer insights analyst. Build a satisfaction index aligned with NPS, by broker and channel. Output: a dashboard widget and actions.
60. Workflow automation readiness: Act as a process automation consultant. Assess readiness for automation in application flow and document checks. Output: a scoring rubric and dashboard hints.
61. Cost of risk: Role: risk finance. Estimate cost of risk by product line and region. Output: a dashboard with risk-adjusted profitability.
62. Queue length alerts: You are an IT operations analyst. Monitor queue lengths for document verification and loan approvals. Output: alert thresholds and runbooks.
63. Active vs funded loans: Act as portfolio analyst. Compare active applications to funded loans by stage and channel. Output: a dashboard card and guidance.
64. SLA breach frequency: Role: operations manager. Track frequency of SLA breaches by process step. Output: a dashboard with incident notes.
65. Product mix impact: You are a product analytics lead. Analyze how product mix affects profitability and risk. Output: a dashboard with scenario sliders.
66. Geography risk map: Act as risk mapping specialist. Create a geographic risk map for mortgage exposure. Output: a heatmap with thresholds.
67. Policy compliance score: Role: governance lead. Build a policy compliance score across processes and teams. Output: a dashboard badge and remediation steps.
68. Credit pull efficiency: You are a data ops analyst. Track number of credit pulls per approved loan and cost per pull. Output: a KPI chart and notes.
69. Underwriting approval mix: Act as credit ops analyst. Analyze approval mix by underwriter and risk tier. Output: a dashboard panel and governance notes.
70. Loan funding forecast: Role: forecasting expert. Generate monthly funding forecast by region and product with confidence intervals. Output: a dashboard forecast card.
71. Beneficiary payout timing: You are a treasury analytics lead. Monitor payout timing to brokers and partners post-funding. Output: a KPI visualization and SLA guidance.
72. Client onboarding time: Act as onboarding analyst. Measure time from lead to active customer, by channel. Output: a dashboard timeline and optimization tips.
73. Data quality heatmap: Role: data QA. Create a heatmap of data quality scores by data source and field. Output: a dashboard with remediation priorities.
74. Audit trail completeness: You are an compliance data manager. Ensure audit trails are complete for each loan file. Output: a compliance dashboard panel.
75. Loan relapse rate: Act as risk analyst. Track relapse rate for previously funded loans reborrowing within two years. Output: a KPI with risk flags.
76. Processing bottlenecks: Role: operations engineer. Identify bottlenecks in processing pipeline and suggest optimizations. Output: a dashboard with bottleneck notes.
77. Vendor performance index: You are a vendor analytics lead. Score third-party vendors by timeliness, quality, and cost. Output: a dashboard frame.
78. Customer journey map: Act as UX researcher. Build a journey map for mortgage applicants from lead to funding. Output: a storyboard-style dashboard plan.
79. Rate spread analysis: Role: market data analyst. Compare offered rates vs market rate spreads by product. Output: a dashboard widget and interpretation notes.
80. Credit bureau usage: You are a data strategy analyst. Track credit bureau pulls per loan and cost per pull by channel. Output: a KPI panel.
81. Liquidity coverage ratio: Act as treasury risk manager. Compute LCR impact of mortgage funding cycle. Output: a dashboard with stress scenarios.
82. Escrow forecast: Role: operations planner. Forecast escrow balances by loan and region. Output: a dashboard forecast card.
83. Fraud risk signals: You are a suspicious activity analyst. Define dashboard signals for mortgage fraud risk and thresholds. Output: a risk alert panel.
84. Deal velocity heatmap: Act as deal desk lead. Create a velocity heatmap across broker, channel, and product. Output: a dashboard tile spec.
85. Cross-border lending: Role: compliance analytics. Track KPI for cross-border mortgage approvals and regulatory exposure. Output: a dashboard section.
86. Referral funnel health: You are a marketing funnel specialist. Monitor referral funnel health and conversion to funding. Output: a KPI dash with action cues.
87. Funding source mix: Act as finance analyst. Break down funding sources by lender and their cost of funds. Output: a visualization plan.
88. Automation ROI: Role: automation strategist. Estimate ROI of dashboard automation for mortgage workflows. Output: a cost-benefit dashboard note.
89. Flash report template: You are a reporting engineer. Create a weekly flash report template for KPI and dashboard status. Output: a ready-to-use report schema.
90. Productivity heatmap: Act as performance analyst. Build a productivity heatmap for loan officers by day and week. Output: a dashboard card plan.
91. Portfolio growth pace: Role: portfolio strategist. Measure portfolio growth pace by quarter and geography. Output: a dashboard trend card.
92. Compliance exceptions: You are a compliance analyst. Track number and severity of compliance exceptions by process. Output: a dashboard with drill-down filters.
93. On-time disclosures: Act as disclosure manager. Monitor on-time loan disclosures and delivery timeliness. Output: a KPI panel.
94. Rate lock utilization: Role: risk analytics. Analyze rate lock utilization by product and term. Output: a dashboard with utilization score.
95. Data lineage map: You are a data governance lead. Produce a lineage map for key mortgage dashboards, including data sources and transformations. Output: a visual spec description.
96. Peer comparison matrix: Act as competitive analytics. Compare your KPIs against peer mortgage brokers’ bands and trends. Output: a dashboard table with gaps.
97. Scenario planning board: Role: strategy analyst. Create a scenario planning board for interest rate shifts and volume changes. Output: dashboard widgets and guardrails.
98. Aging file risk: You are a risk officer. Flag aging files at risk of non-compliance, with recommended actions. Output: a dashboard card and workflow notes.
99. Loan progression checkpoints: Act as process architect. Define checkpoints from application to funding and assign owners. Output: a dashboard timeline.
100. Executive KPI summary: Role: executive reporting. Build a concise KPI summary dashboard for mortgage leadership, with top metrics and interpretation cues. Output: a single-page dashboard spec.

Best Practices

• Keep prompts specific to mortgage KPI goals and avoid generic metrics.
• Structure prompts to produce dashboard-ready outputs with clear data lineage and owners.
• Test prompts against historical data to validate accuracy and timeliness.
• Document data sources and calculation logic for auditability and reuse.
• Reuse prompts by pairing similar KPI definitions with different time frames or regions.

Common Mistakes to Avoid

• Asking for too many KPIs in one prompt leading to cluttered outputs.
• Ignoring data governance and data source ownership in prompts.
• Using vague definitions like ROI without specifying scope and costs.
• Not specifying time frames or refresh cadence, causing stale dashboards.
• Neglecting testing and validation of outputs against real data.

FAQ

What makes a KPI dashboard effective for mortgage brokers?

An effective KPI dashboard for mortgage brokers provides clear, action-oriented metrics with defined data sources, owners, refresh cadence, and visual cues to drive decisions.

How should I choose which prompts to use first?

Start with core funnel, funding speed, and channel performance prompts to establish baseline metrics, then add risk, compliance, and client experience metrics.

Can these prompts be adapted for my CRM system?

Yes. Map data sources to your CRM fields, adjust calculations to reflect your data model, and export outputs in your dashboard-compatible formats.

How do I ensure data quality in these prompts?

Define data quality rules within prompts, reference source data owners, and implement validation steps to audit inputs and calculations.

What formats should outputs be delivered in?

Outputs should be provided as dashboard-ready descriptions, JSON snippets, or CSV exports that can be plugged into your BI tool.

How often should dashboards refresh?

Choose a cadence that matches data latency and decision needs, typically daily for activity metrics and monthly for portfolio metrics.