100 Best Gemini KPI and Dashboard Prompts for Financial Advisors

Direct Answer

The best Gemini prompts for KPI and dashboard for financial advisors are a practical library of 100 prompts designed to define, monitor, and visualize key performance indicators and dashboard metrics for advisory firms. They cover revenue, client health, onboarding, risk, planning, and operations, with clear data sources and visualization guidance. Use them to standardize reporting and drive data-driven decisions.

Introduction

This page is a practical prompt library focused on KPI and dashboard prompts for financial advisors. It helps practitioners build consistent, data-driven dashboards and reports for client meetings and practice management.

Designed for financial planners, wealth managers, and analysts, the prompts enable rapid creation of KPI definitions, dashboards, and data workflows without drafting prompts from scratch.

How to Use These Gemini Prompts

• Replace placeholders with your firm data such as your industry, audience, and data sources to customize each prompt.
• Add constraints for data freshness, security, and compliance where required.
• Specify output formats like bullet lists, tables, or dashboards, and ask for step-by-step reasoning when needed.
• Verify outputs by cross-checking KPI calculations with your data sources and performing spot checks on sample clients.
• If you need a concise dashboard, request a one-page summary and export-friendly formats for reports.
• When using these prompts, clone common structures for consistency across prompts to maintain comparability.

100 Best Gemini KPI and Dashboard Prompts for Financial Advisors

1. KPI baseline definition: Adopt the role of a KPI strategist. Given a financial advisory firm with assets under management, client types, and service levels, output a baseline set of 8 KPIs with definitions, data sources, and calculation formulas. Include a short rationale for each KPI and the ideal data cadence (daily, weekly, monthly) and a recommended visualization type.
2. Client segmentation KPIs: Act as a dashboard designer. For client segmentation by AUM tiers, risk tolerance, and product mix, list 6 KPIs, specify data sources, calculation method, and a recommended chart per KPI. Provide a one-sentence use case for advisory decisions and a note on data quality checks.
3. Revenue and fee mix: Assume the role of a finance analytics lead. Create 7 KPIs tracking revenue streams from fees, commissions, and wrap fees. For each KPI, provide the formula, data sources, expected trend, alert thresholds, and a suggested dashboard widget.
4. Productivity benchmarks: Take the perspective of an operations analyst. Propose 6 productivity KPIs for advisor activity such as client meetings, proposals, and onboarding. Include target benchmarks, data sources, and a sample daily dashboard layout showing these metrics.
5. Client retention metrics: As a client success analyst, define 5 KPIs to monitor client retention and renewal likelihood. Provide calculation steps, data fields needed, and a dashboard arrangement that highlights at-risk accounts with recommended actions.
6. Portfolio performance metrics: Role play as a portfolio analytics engineer. List 6 KPIs for portfolio performance attribution, risk-adjusted return, and benchmark tracking. Include formulas, data feeds, and how to visualize overviews for advisors during meetings.
7. Scenario forecasting: Act as a scenario modeler. Build 4 KPI scenarios (base, optimistic, pessimistic, stress) for a given advisor book. For each, specify input variables, expected KPI changes, and a dashboard section to compare scenarios side by side.
8. Pipeline health metrics: Take the role of a CRM analyst. Produce 6 KPIs to measure sales pipeline health for new client acquisitions, including lead-to-prospect conversion rates and proposal win rates. Include data sources, computation steps, and a compact dashboard layout.
9. Compliance-ready metrics: As a compliance-focused analyst, output 5 KPI templates that ensure reporting aligns with regulatory expectations. Provide data lineage notes, access controls, and an export-friendly dashboard section with audit trails.
10. Time-to-value indicators: Act as a value-delivery analyst. Define 5 KPIs that measure time from onboarding to first implemented recommendation. Include calculation method, data fields, and a lightweight dashboard mockup.
11. Cost efficiency metrics: In the role of a financial operations analyst, list 5 KPIs to monitor cost per client, average advisor hours per revenue, and overhead vs revenue. Provide data sources and a simple visualization plan.
12. Client journey map KPIs: Take the perspective of a CX designer. Create 6 KPIs mapped to stages of the client journey (awareness, onboarding, planning, implementation, review). Include stage-specific data fields and recommended dashboard visuals.
13. Advisor utilization metrics: Act as a resource planner. Propose 5 KPIs that track advisor utilization by time spent on client work vs. non-billable activities, with calculated utilization rates and a dashboard wireframe.
14. Goal attainment tracking: As a goal-tracking engineer, specify 6 KPIs that measure progress toward firm financial goals and individual client goals. Include data sources, targets, and a dashboard layout to show attainment by advisor and client segment.
15. Asset mix insights: Role-play as a data storyteller. Generate 5 KPIs showing client asset allocation health, diversification gaps, and drift alerts. Provide data requirements and one-page dashboard sketch.
16. Risk dashboard essentials: Act as a risk analytics consultant. List 6 risk-related KPIs applicable to financial advisory practice, including volatility exposure, concentration risk, and liquidity. Include calculation notes and visualization ideas.
17. Benchmark comparison prompts: In the role of a benchmarking expert, craft 4 KPIs that compare client performance against chosen benchmarks. Provide data mapping and a dashboard panel layout for quick insights.
18. Client acquisition cost: As a marketing analytics lead, define 4 KPIs for CAC related to advisor outreach. Include data sources, attribution window, and a sample dashboard segment for leadership reviews.
19. Advisor churn indicators: Take the position of a strategic analyst. Identify 5 KPIs signaling advisor churn risk, data sources, and alert thresholds. Propose a dashboard component to monitor retention actions.
20. Client profitability metrics: Act as a profitability analyst. List 6 KPIs to measure client-level profitability by cost-to-serve, revenue, and service intensity. Provide formulas and a dashboard design concept.
21. Proposal win analysis: Role of a business analyst. Create 5 KPIs evaluating proposal win rate, average deal size, and cycle time. Include data sources and a compact dashboard mockup.
22. Onboarding success KPIs: Data analyst perspective. Define 4 onboarding KPIs, such as time-to-complete onboarding and document completeness. Provide data fields and a starter dashboard frame.
23. Meeting effectiveness: As a client meeting coach, generate 5 KPIs evaluating meeting outcomes, follow-ups, and action item completion. Include data capture steps and visualization ideas.
24. Service level tracking: Act as an operations manager. List 4 SLA KPIs for response times, issue resolution, and client satisfaction. Provide calculation rules and a dashboard example.
25. Data quality checks: In the role of a data quality engineer, specify 6 data quality KPIs such as completeness and accuracy. Include data checks, thresholds, and a dashboard-ready summary.
26. Client health score: Role-play as a health scoring analyst. Define 5 components of a client health score and compute a composite KPI. Provide data sources and a sample health dashboard layout.
27. Forecast accuracy: Act as a forecasting specialist. List 5 KPIs to assess forecast accuracy for assets, revenue, and client acquisition. Include calculation method and dashboard presentation plan.
28. Expense variance alerts: Take the perspective of a financial controller. Create 4 KPIs tracking expense variance against budget and forecast. Include alert thresholds and a concise dashboard panel.
29. Billing accuracy: As an AR analyst, define 4 KPIs for billing accuracy, timing, and dispute rate. Provide data sources and a one-page dashboard layout.
30. Client segmentation drift: Role as a data drift analyst. Propose 5 KPIs that detect segmentation drift over time and trigger re-segmentation. Include data lineage and a dashboard concept.
31. Advisor activity heatmap: Act as a visualization designer. Create a heatmap KPI suite for advisor activity by day of week and hour, with 6 metrics and action-ready insights.
32. Net new revenue: In the role of a revenue analyst, list 5 KPIs for net new revenue from new clients and new assets. Include calculation details and a dashboard sketch.
33. Productivity by client: As a portfolio advisor, generate 4 metrics showing revenue per client and time-to-delivery for services. Provide data sources and a dashboard layout proposal.
34. Annual client value: Role-play as an advisor value modeler. Define 5 KPIs to estimate lifetime value per client with retention multipliers and a dashboard storyboard.
35. Plan adoption rate: Act as a planning adoption analyst. List 4 KPIs measuring how often clients adopt recommended financial plans, with data points and a panel design.
36. Advisor coaching metrics: Take the role of a learning and development analyst. Define 5 KPIs to track advisor training impact and certification progress, with a dashboard layout.
37. Service usage insights: As a product insights analyst, craft 5 KPIs showing which advisory services are most utilized. Include data sources and a visualization plan for leadership reviews.
38. Workflow bottlenecks: In the role of a process engineer, identify 5 KPIs that reveal bottlenecks in advisory workflows. Provide data requirements and a dashboard sketch.
39. Client feedback metrics: Act as a voice of the client analyst. List 5 KPIs summarizing client feedback, NPS correlates, and sentiment trends with a dashboard outline.
40. Compliance incident rate: Role-play as a risk officer. Define 4 KPIs for compliance incidents, remediation time, and audit findings. Include data sources and a dashboard section.
41. Referal funnel metrics: As a growth analyst, create 5 KPIs tracking a referral funnel from referral source to new client. Provide data mapping and a dashboard layout.
42. Asset under management growth: Act as a growth analytics lead. List 4 KPIs showing AUM growth by quarter, client segment, and advisor contribution. Include calculation steps and a dashboard concept.
43. Dividend and yield insights: Take the perspective of a portfolio data analyst. Define 4 KPIs for income generation metrics and yield trends for client portfolios with a dashboard idea.
44. Cost-to-serve dashboard: As a cost analyst, craft 5 KPIs that measure cost-to-serve per client or per advisory service. Include data sources and a compact dashboard layout.
45. Planning cycle time: In the role of a planning manager, list 4 KPIs for planning cycle duration, approval delays, and plan quality. Provide data requirements and visualization suggestions.
46. Cash flow readiness: Act as a liquidity analyst. Define 5 KPIs to assess client cash-flow readiness and liquidity risk, with a dashboard layout for client meetings.
47. Portfolio drift alerts: Role-play as a risk analytics engineer. Create 4 KPIs tracking portfolio drift relative to targets, with thresholds and a dashboard drill-down concept.
48. Trade efficiency: Take the stance of a trading operations lead. List 4 KPIs for trade execution time, error rate, and settlement delays. Include data sources and a concise dashboard view.
49. Client engagement score: Act as a client engagement analyst. Define 5 components to compute a client engagement score and a dashboard panel to monitor changes over time.
50. Advisor fee transparency: Role-play as a compliance-friendly marketer. Create 4 KPIs that measure fee disclosure quality and client understanding, with a dashboard snippet for reviews.
51. Client risk profiling: As a risk advisor, define 5 KPIs to validate client risk profiles against portfolios, with data checks and a sample dashboard layout.
52. Scenario plan prompts: In the role of a scenario planner, generate 4 prompts to simulate market scenarios affecting KPIs with a side-by-side comparison dashboard.
53. Data lineage trace: Act as a data governance lead. List 4 KPIs tracking data lineage quality and source reliability. Provide a dashboard view for auditors.
54. Client satisfaction trends: Take the position of a CX analyst. Define 5 KPIs for satisfaction over time and correlate with service changes, with a simple dashboard sketch.
55. Asset concentration alerts: As a risk analytics officer, define 4 KPIs to detect concentration risk in client portfolios and trigger alerts with a dashboard example.
56. Tax planning impact: Role-play as a tax strategy analyst. Create 4 KPIs measuring tax efficiency improvements from planning recommendations, with data sources and visuals.
57. Goal drift detection: Act as a goal-tracking engineer. List 4 KPIs that flag drift from client financial goals and show corrective actions in a dashboard.
58. Referral program ROI: In the role of a marketing analytics lead, craft 5 KPIs to assess ROI of referral programs with attribution details and a dashboard layout.
59. Roi per advisor: Take the stance of a performance analyst. Define 5 KPIs computing return on advisor activity per quarter, including data sources and a dashboard framework.
60. Client onboarding dropoff: As an onboarding specialist, list 4 KPIs to monitor onboarding drop-off points and suggest interventions with a dashboard plan.
61. Meeting outcome tracking: Act as a meeting optimization consultant. Provide 4 KPIs measuring follow-through from meetings and impact on next steps, with visualization ideas.
62. Data lag alerts: Role as a data operations manager. Create 4 KPIs that detect data lag between sources and dashboards, with remediation steps and a dashboard snippet.
63. Portfolio rebalancing prompts: In the role of a portfolio administrator, list 4 KPIs for rebalancing frequency, reason codes, and impact, with a dashboard suggestion.
64. Client lifetime value: As a client value modeler, define 5 KPIs to estimate lifetime value under different retention scenarios, with a dashboard concept.
65. New asset growth: Take the perspective of a growth planner. List 4 KPIs for new assets growth by advisor and channel, with data sources and visuals.
66. Risk-adjusted return: Act as a risk and return analyst. Define 5 KPIs for risk-adjusted performance, explaining Sharpe-like metrics, data needs, and a display plan.
67. Expense control prompts: Role-play as a finance controller. Create 4 KPIs focused on expense control during advisory operations, with thresholds and a dashboard idea.
68. Billing cycle timing: As an AR manager, list 4 KPIs for billing cycle timing and aging, with a dashboard view for collections.
69. Product mix optimization: In the role of a product strategist, define 5 KPIs to optimize service/product mix offered to clients, with data sources and visuals.
70. Client outcome metrics: Act as an outcomes analyst. Provide 6 KPIs linking planning actions to client outcomes, with a dashboard arrangement.
71. Advisor collaboration: Take the stance of a collaboration coach. List 4 KPIs measuring cross-advisor collaboration frequency and impact, with a dashboard mockup.
72. RFP win rate prompts: As a proposal analytics lead, craft 4 KPIs evaluating RFP responses, with data mapping and a leaderboard-style dashboard.
73. Client communication cadence: Role-play as a communications planner. Define 5 KPIs for cadence, channels, and client response quality, with a dashboard layout.
74. Portfolio quality metrics: Act as a portfolio quality assessor. List 4 KPIs to monitor diversification, concentration, and exposure limits with visualization ideas.
75. Cost per report: In the role of a reporting officer, create 4 KPIs measuring cost per client report and automation rate, with a dashboard concept.
76. Advisor pulse survey: As a feedback analyst, design 5 KPIs from quarterly pulse surveys about advisor satisfaction and performance, with a dashboard sketch.
77. Goal attainment by segment: Take the role of a segment analyst. Define 4 KPIs comparing goal attainment across client segments, with data sources and a display plan.
78. Workflow automation impact: Act as an automation analyst. List 5 KPIs showing impact of automation on speed, error rate, and cost, with a dashboard outline.
79. Client risk score drift: Role-play as a risk modeler. Create 4 KPIs tracking drift in client risk scores after advisor actions, with alerts and visuals.
80. Annual reporting KPIs: As a reporting specialist, define 5 KPIs to ensure annual client reports are on time, accurate, and complete, with a dashboard snippet.
81. Fee dispute metrics: In the stance of a dispute analyst, list 4 KPIs for fee disputes resolution time and resolution quality, with a dashboard plan.
82. Regulatory readiness: Act as a regulatory readiness lead. Define 4 KPIs to monitor readiness for audits and compliance checks, with data lineage notes.
83. Client data privacy: Role as a privacy officer. Create 4 KPIs ensuring client data privacy controls, access logs, and breach response times, with visualization ideas.
84. Revenue per client: Take the perspective of a revenue analyst. List 5 KPIs for revenue per client and per advisor, with data sources and a dashboard concept.
85. Lead-to-client speed: Act as a conversion specialist. Define 4 KPIs measuring lead-to-client conversion speed and quality, with a dashboard layout.
86. Service renewal rate: In the role of a client success manager, create 4 KPIs for service renewals, upsell rate, and churn reduction, with a dashboard plan.
87. Cash reserve adequacy: Role-play as a liquidity strategist. List 4 KPIs for client cash reserves adequacy and liquidity safety margins, with visuals.
88. Client portfolio fit: Act as a fit analysis expert. Define 5 KPIs assessing portfolio fit to client goals and risk tolerance, with a dashboard schematic.
89. Benchmarking prompts: As a benchmarking specialist, craft 4 prompts to compare firm KPIs against industry benchmarks, with data sources and a comparison dashboard.
90. Actionable insights prompts: Take the role of a insights engineer. Generate 6 prompts that produce concise, decision-ready insights from KPI data, with recommended visuals.
91. Data completeness prompts: In the role of a data integrity analyst, list 5 prompts ensuring data fields are complete for KPI calculations and dashboards, with validation steps.
92. Portfolio health prompts: Act as a health monitor. Create 4 prompts to assess overall portfolio health, including drift, risk, and return, with dashboard guidance.
93. Advisor performance snapshot: Role-play as a leadership analyst. Define 5 KPIs to summarize advisor performance in a single snapshot with a dashboard layout for executives.
94. Client revenue forecast: Take the stance of a forecasting analyst. List 4 KPIs for forecasting client revenue and assets under management by quarter with a dashboard view.
95. Quality of client plans: Act as a plan quality auditor. Create 4 KPIs to evaluate the thoroughness and feasibility of financial plans, with a dashboard example.
96. Portfolio tax impact: In the role of a tax-aware advisor, define 4 KPIs measuring tax impact of portfolios and planning recommendations, with data needs and visuals.
97. Cost recovery metrics: As a profitability strategist, list 4 KPIs for recovering costs through advisory products, with a dashboard plan.
98. Client engagement depth: Role as a client engagement analyst. Define 5 KPIs measuring depth of client engagement and complexity of services used, with visuals.
99. Strategic initiative KPIs: Act as a program manager. Create 4 KPIs to track the progress of strategic initiatives in the advisory firm, with a dashboard layout.
100. Executive KPI summary: Take the perspective of an executive dashboard designer. List 6 core KPIs for top-level governance, with a concise, readable dashboard concept.

Best Practices

• Keep KPI definitions aligned with business goals and advisory services.
• Moderate the number of KPIs to avoid noise; start with a core set and expand gradually.
• Include data lineage and source details to ensure trust and auditability.
• Design prompts to generate visuals that support quick decision-making in client meetings.
• Test prompts with real but anonymized data to validate calculations.

Common Mistakes to Avoid

• Overcomplicating dashboards with too many KPIs.
• Using vague formulas or unclear data sources.
• Ignoring data freshness and lag in KPI reporting.
• Not validating KPI outputs against actual firm data.
• Forgetting to tailor prompts to regulatory constraints and client confidentiality.

FAQ

What is the purpose of KPI and dashboard prompts for financial advisors?

They provide ready-to-use, topic-specific prompts to design, calculate, and visualize performance metrics and dashboards for advisory practices.

How many KPIs should a new dashboard include?

Start with a core set of 6 to 12 KPI metrics and expand only as needed based on user feedback and governance requirements.

Can these prompts be used across CRM and portfolio systems?

Yes, adapt data sources and visuals to fit your CRM, portfolio, and reporting tools while preserving KPI integrity.

How do I ensure data quality in KPI dashboards?

Define data lineage, validation rules, and automated checks; regularly sample data to verify accuracy and timeliness.

What formats should be requested for outputs?

Use export-friendly formats like CSV, JSON, and a one-page dashboard summary for leadership reviews.

Are these prompts suitable for compliance needs?

Many prompts include compliance-ready templates; tailor them to your jurisdiction and audit requirements.