How do I use the "Create Real-Time Sales Dashboard" prompt?

Copy the prompt template, fill in the variables (BUSINESS_TYPE, INDUSTRY, TEAM_SIZE, SALES_CHANNELS, PRODUCTS_SERVICES, TARGET_AUDIENCE, CURRENT_CHALLENGES, DATA_SOURCES, UPDATE_FREQUENCY, USER_LEVELS, PLATFORM), and paste it into ChatGPT, Claude, or Gemini.

What AI tools work with this data 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?

Start with the most critical KPIs first - don't try to build everything at once Ensure data quality by implementing validation rules and anomaly detection Design for mobile-first since sales teams are often on the go Include drill-down capabilities so users can investigate trends and outliers Set up automated data pipeline monitoring to catch integration issues early

data advanced

Create Real-Time Sales Dashboard

Build comprehensive real-time sales dashboards with AI. Get KPI layouts, visualizations, and data connections for actionable insights.

Works with: chatgptclaudegemini

Prompt Template

You are a senior business intelligence analyst and dashboard architect. Create a comprehensive real-time sales dashboard specification for [BUSINESS_TYPE] with the following requirements: **Business Context:** - Industry: [INDUSTRY] - Sales team size: [TEAM_SIZE] - Primary sales channels: [SALES_CHANNELS] - Key products/services: [PRODUCTS_SERVICES] - Target audience: [TARGET_AUDIENCE] - Current challenges: [CURRENT_CHALLENGES] **Technical Requirements:** - Data sources: [DATA_SOURCES] - Update frequency: [UPDATE_FREQUENCY] - User access levels: [USER_LEVELS] - Platform preference: [PLATFORM] **Dashboard Specifications Needed:** 1. **Executive Summary Section:** - Top-level KPIs with current vs target values - Trend indicators and alerts - Revenue forecasting widgets 2. **Performance Metrics:** - Sales by period (daily, weekly, monthly, quarterly) - Conversion funnel analysis - Lead source effectiveness - Sales rep performance rankings 3. **Visual Components:** - Chart types for each metric - Color coding schemes - Interactive filters and drill-down capabilities - Mobile responsiveness considerations 4. **Data Integration:** - API connections required - Data refresh schedules - Data validation rules - Backup and failover procedures 5. **Alerting System:** - Threshold definitions - Notification methods - Escalation procedures Provide detailed specifications including layout mockups, data modeling requirements, implementation timeline, and maintenance procedures. Include specific metrics formulas and technical architecture recommendations.

Variables to Customize

[BUSINESS_TYPE]

Type of business (e.g., SaaS company, retail store, manufacturing)

Example: B2B SaaS company

[INDUSTRY]

Industry vertical or sector

Example: Enterprise software solutions

[TEAM_SIZE]

Number of sales representatives

Example: 25 sales reps across 3 regions

[SALES_CHANNELS]

Primary methods of selling

Example: Direct sales, partner channel, online self-service

[PRODUCTS_SERVICES]

Main offerings being sold

Example: CRM software, analytics platform, consulting services

[TARGET_AUDIENCE]

Primary customer segments

Example: Mid-market companies (100-1000 employees) in financial services

[CURRENT_CHALLENGES]

Existing problems with sales tracking

Example: Delayed reporting, inconsistent data, lack of real-time visibility

[DATA_SOURCES]

Systems containing sales data

Example: Salesforce CRM, HubSpot, QuickBooks, Google Analytics

[UPDATE_FREQUENCY]

How often data should refresh

Example: Every 15 minutes during business hours, hourly after hours

[USER_LEVELS]

Different types of dashboard users

Example: C-level executives, sales managers, individual reps

[PLATFORM]

Preferred dashboard technology

Example: Tableau with web and mobile access

Example Output

**Real-Time Sales Dashboard Specification for B2B SaaS Company** **Executive Summary Section:** - Revenue Today: $45,230 (Goal: $50,000) with red alert indicator - Monthly Recurring Revenue: $1.2M (+8.5% MoM) - Pipeline Value: $3.4M (Forecast: $980K this quarter) - Conversion Rate: 24% (Target: 28%) **Key Performance Metrics:** - Daily/Weekly/Monthly revenue charts with trend lines - Sales funnel: 450 leads → 108 opportunities → 26 closed deals - Lead source ROI: Direct (32%), Partners (28%), Webinars (18%) - Top performers leaderboard with activity scores **Visual Layout:** - 3-column grid layout with KPI cards at top - Interactive revenue trend chart (center) - Regional performance heat map (right panel) - Real-time activity feed (bottom) - Color scheme: Green (above target), Yellow (at risk), Red (below threshold) **Technical Architecture:** - Salesforce API integration with 15-minute sync - Data warehouse staging layer for historical analysis - Redis caching for sub-second dashboard loads - WebSocket connections for live updates **Alert System:** - Daily revenue <80% of target: Email to sales manager - Deal stuck >30 days: Slack notification - Major deal closed: Team celebration alert **Implementation Timeline:** 6-week phased rollout with user training and feedback incorporation.