Sales Dashboard with Essential KPIs for Commercial Managers
Sales metrics dashboard with the indicators that actually matter for decision-making.
Define essential sales KPIs and create the structure for an operational and strategic dashboard so commercial managers can track performance in real time.
At a glance
Access
Free prompt
Open to copy without upgrading.
Prompt objective
Define essential sales KPIs and create the structure for an operational and strategic dashboard so commercial managers can track performance in real time.
Real use case
The Commercial Director at IndusTech (industrial automation) receives monthly Excel reports with 47 different metrics. They don't know which ones matter and make decisions based on gut feeling. They want a clean dashboard that shows in 30 seconds whether the team is on track.
Customize these fields first
Replace the placeholders with your own context before you run the prompt. That usually improves the first output more than adding more instructions later.
Prompt
Create a sales dashboard structure for [COMPANY NAME], with [NUMBER] salespeople, a monthly target of $[MONTHLY TARGET], and [CRM PLATFORM] as the CRM.\n\n**1) Level 1 KPIs — Results (Big Numbers, top of dashboard):**\n- Closed revenue vs. target (current month)\n- Total pipeline vs. required coverage\n- Monthly win rate\n- Average deal size\n- For each KPI: formula, data source, update frequency\n\n**2) Level 2 KPIs — Activity (trend charts):**\n- Meetings held per salesperson/week\n- Proposals sent per salesperson/week\n- Prospecting calls/emails per day\n- Average response time to inbound leads\n- For each KPI: benchmark, target, alert (red/yellow/green)\n\n**3) Level 3 KPIs — Efficiency (comparative tables):**\n- Conversion by funnel stage (funnel visualization)\n- Average sales cycle (6-month trend)\n- Loss reasons (Pareto — top 5)\n- Revenue by lead source (which channel generates the most)\n- CAC by channel\n\n**4) Per-Salesperson KPIs (ranking):**\n- Table with each salesperson and their indicators\n- Target achievement (% and $)\n- Deals in pipeline (quantity and value)\n- Activity (meetings, calls, proposals)\n- Individual win rate\n- Highlight top performer and who needs attention\n\n**5) Visualization and Layout:**\n- Dashboard mockup (detailed visual description)\n- Hierarchy: what to see first, second, third\n- Essential filters (period, salesperson, segment, product)\n- Mobile version (which KPIs to show on small screens)\n\n**6) Review Cadence:**\n- Daily standup (which metrics to check, 5 min)\n- Weekly review (which metrics to analyze, 30 min)\n- Monthly business review (complete report, 60 min)\n- Quarterly strategic review (trends and adjustments)\n\n**7) Automated Alerts:**\n- Deal stalled for more than [X] days\n- Pipeline below [X]% coverage\n- Salesperson below [X]% of target by week Y of month\n- Inbound lead with no response for more than [X] hours\n\nInclude setup instructions for each widget in [CRM PLATFORM] or complementary tool.
Open directly in an AI — the text is pre-filled:
How to use this prompt
- 1Replace the key placeholders first: COMPANY NAME, NUMBER, MONTHLY TARGET, CRM PLATFORM.
- 2Replace any bracketed placeholders like [this] with your own context.
- 3Add extra background information when you want more tailored results.
- 4Combine multiple prompts in one conversation when you need a richer output.
- 5Save your best-performing prompts so they are easy to reuse later.
Next best step
Open the guide first, then branch only if you still need more.
A guide for sales teams that want better prospecting, follow-up, qualification, and pipeline support with AI.
If this prompt is close but not quite right, generate variants next. If the job is recurring, move into the course library after the guide.
Related prompts
View allHubSpot Sales Pipeline Configuration for B2B Teams
Complete pipeline setup with stages, properties, and automations in HubSpot CRM.
Best for
Configure a professional sales pipeline in HubSpot with clear stages, required fields, automations, and reports that give the sales manager real visibility into pipeline health.
Weighted Sales Forecasting Model
Revenue forecasting system based on weighted pipeline and velocity analysis.
Best for
Build a reliable sales forecast model that combines stage-by-stage probability, historical conversion data, and pipeline velocity analysis to predict revenue within a 15% margin of error.
CRM Migration with Zero Data Loss and Team Adoption
Complete plan to migrate from one CRM to another without losing history and ensuring the team uses it.
Best for
Plan and execute CRM migration (e.g., Pipedrive to HubSpot, or spreadsheets to RD Station) while preserving historical data, automations, and guaranteeing 100% team adoption within 30 days.
RD Station CRM Sales Automations for Small Businesses
Practical automation setup in RD Station CRM for small sales teams.
Best for
Create automations in RD Station CRM that save sales reps time on repetitive tasks, ensure no lead falls through the cracks, and accelerate the sales pipeline.
Explore other prompt categories
Move sideways into adjacent libraries when the current category is not the full answer.
Free browsing stays open. Premium prompts unlock the reusable workflow layer.
Use the guides and role paths to validate the job first. Upgrade when you want the full prompt text, editable premium prompts, and the surrounding course paths in one place.
Free access
- Browse guides, role paths, and category pages.
- Preview prompts before you decide to upgrade.
- Find the right starting point without friction.
Membership access
- Unlock premium prompts and the full copy text.
- See more workflow paths and course connections.
- Keep the reusable templates in one place.
