How do I use the "Create a Comprehensive Sales Dashboard" prompt?

Copy the prompt template, fill in the variables (COMPANY_TYPE, TEAM_SIZE, SALES_CHANNELS, PRODUCTS_SERVICES, REPORTING_PERIOD, TARGET_AUDIENCE), and paste it into ChatGPT, Claude, or Gemini.

What AI tools work with this sales prompt?

This prompt works with chatgpt, claude, gemini. Simply copy and paste the template into any of these AI assistants.

Tips for getting the best results?

Focus on actionable metrics rather than vanity metrics - choose KPIs that directly correlate with revenue outcomes Design for mobile viewing since sales managers often check dashboards on-the-go Include drill-down capabilities so users can investigate anomalies or opportunities in detail Set up automated alerts for critical thresholds to enable proactive management Test dashboard usability with actual end-users before full deployment to ensure adoption

sales advanced

Create a Comprehensive Sales Dashboard

AI prompt to design comprehensive sales dashboards with KPIs, metrics, and visualizations. Perfect for sales managers and analysts.

Works with: chatgptclaudegemini

Prompt Template

You are an experienced sales analytics expert tasked with creating a comprehensive sales dashboard for [COMPANY_TYPE]. Design a detailed dashboard structure that will help track performance, identify trends, and drive strategic decisions. Company Context: - Business type: [COMPANY_TYPE] - Sales team size: [TEAM_SIZE] - Primary sales channels: [SALES_CHANNELS] - Key products/services: [PRODUCTS_SERVICES] - Current reporting period: [REPORTING_PERIOD] - Target audience for dashboard: [TARGET_AUDIENCE] Create a sales dashboard that includes: 1. **Executive Summary Section** - Top-level KPIs and performance indicators - Period-over-period comparisons - Achievement vs. targets visualization 2. **Revenue Analytics** - Revenue breakdown by product/service, region, and sales rep - Revenue trends and forecasting - Deal pipeline value and conversion rates 3. **Sales Performance Metrics** - Individual and team performance rankings - Activity metrics (calls, meetings, emails) - Lead generation and qualification rates 4. **Customer Analytics** - Customer acquisition cost (CAC) - Customer lifetime value (CLV) - Churn rate and retention metrics 5. **Pipeline Management** - Deal stage progression - Sales cycle length analysis - Win/loss ratios by various dimensions For each section, specify: - Key metrics to display - Recommended visualization types (charts, graphs, tables) - Data sources needed - Refresh frequency - Interactive filtering options - Alert/notification triggers for key thresholds Also provide implementation recommendations including tool suggestions, data integration requirements, and best practices for dashboard maintenance and user adoption.

Variables to Customize

[COMPANY_TYPE]

Type of business or industry

Example: B2B SaaS company

[TEAM_SIZE]

Number of sales team members

Example: 25 sales representatives across 3 regions

[SALES_CHANNELS]

Primary sales channels used

Example: Inside sales, field sales, and partner channel

[PRODUCTS_SERVICES]

Main products or services sold

Example: Enterprise software licenses, implementation services, and ongoing support

[REPORTING_PERIOD]

Time period for dashboard reporting

Example: Monthly with quarterly deep-dives

[TARGET_AUDIENCE]

Who will be using the dashboard

Example: Sales managers, VPs of Sales, and C-level executives

Example Output

# Sales Dashboard for B2B SaaS Company ## Executive Summary Section **Key Metrics:** - Total Revenue: $2.4M (↑12% vs. last month) - Monthly Recurring Revenue (MRR): $1.8M - New Customer Acquisitions: 47 - Pipeline Value: $8.2M **Visualizations:** Revenue gauge charts, trend lines, and progress bars against quarterly targets ## Revenue Analytics **Breakdown Structure:** - By Product: Enterprise (68%), Professional (24%), Starter (8%) - By Region: North America (55%), EMEA (32%), APAC (13%) - By Rep: Top 5 performers with revenue contribution **Forecasting:** 3-month rolling forecast with 85% confidence interval **Data Source:** CRM system, updated daily ## Sales Performance Metrics **Individual KPIs:** - Quota Attainment: 87% team average - Average Deal Size: $52K - Sales Cycle Length: 89 days average **Activity Tracking:** - Calls per day: 45 team total - Meetings booked: 156 this month - Email response rate: 18% ## Implementation Recommendations **Tools:** Tableau/Power BI for visualization, integrate with Salesforce CRM **Refresh:** Real-time for pipeline, daily for revenue metrics **Alerts:** Sub-80% quota attainment, deals stalled >30 days in stage

Pro Tips for Best Results

Focus on actionable metrics rather than vanity metrics - choose KPIs that directly correlate with revenue outcomes
Design for mobile viewing since sales managers often check dashboards on-the-go
Include drill-down capabilities so users can investigate anomalies or opportunities in detail
Set up automated alerts for critical thresholds to enable proactive management
Test dashboard usability with actual end-users before full deployment to ensure adoption