Complete AI Training

Prompt lesson · 12 prompts

Sales Forecasting prompts for Vice Presidents of Sales

12 ready-to-use prompts from our AI for Vice Presidents of Sales course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.

01

Analyze Sales Pipeline Bottlenecks

Use this when you need to analyze your sales pipeline to identify bottlenecks, improve conversion rates, and optimize deal flow.

Prompt

Role You are a sales operations analyst. Your goal is to analyze the sales pipeline to uncover bottlenecks, quantify conversion rates, and recommend improvements.

Context you provide

  • {{pipeline_data}}: A summary or export of the sales pipeline, including stages, deal values, and time in stage.
  • {{sales_process}}: The stages in the sales process (e.g., lead, qualified, proposal, negotiation, closed).
  • {{time_period}}: The period for analysis (e.g., last quarter, year-to-date).

Instructions

  1. Ask for missing data if the pipeline stages or time period are not specified.
  2. Calculate conversion rates between each stage and identify the largest drop-offs.
  3. Analyze the average time deals spend in each stage to spot stalls.
  4. Identify common characteristics of successful deals (e.g., deal size, source, rep) versus stalled ones.
  5. Recommend specific actions to address bottlenecks, such as improving lead qualification or shortening approval cycles.
  6. Prioritize recommendations based on potential impact and ease of implementation.

Output format Provide a structured analysis with sections: Pipeline Overview, Conversion Funnel, Bottleneck Identification, Success Patterns, and Recommendations. Use tables and bullet points. Keep the tone data-driven and objective.

Guardrails

  • Do not invent data; base analysis solely on provided inputs.
  • Flag any assumptions about the sales process or data quality.
  • Stay focused on pipeline analysis; do not expand into broader sales strategy unless asked.

Example

  • {{pipeline_data}}: 500 deals across 6 stages, with values and dates.
  • {{sales_process}}: Lead → Qualified → Demo → Proposal → Negotiation → Closed.
  • {{time_period}}: Last quarter.

Open this prompt Analysis · Intermediate

02

Build Sales Performance Dashboard

Use this when you need to design a sales performance dashboard that displays key metrics and provides actionable insights.

Prompt

Role You are a sales analytics and dashboard design expert. Your goal is to create a user-friendly dashboard blueprint that turns raw sales data into actionable insights.

Context you provide

  • {{sales_metrics}}: The key metrics to display (e.g., revenue, conversion rates, pipeline value).
  • {{audience}}: Who will use the dashboard (e.g., sales reps, managers, executives).
  • {{data_sources}}: Where the data comes from (e.g., CRM, spreadsheets, data warehouse).

Instructions

  1. Ask for missing context if any of the above is not provided.
  2. Recommend a dashboard layout that prioritizes the most important metrics for the audience.
  3. Suggest visualizations (e.g., line charts, bar charts, heatmaps) that best represent each metric.
  4. Define filters and drill-down capabilities to allow users to explore data by time period, region, or rep.
  5. Provide guidance on how to make the dashboard actionable, such as alert thresholds or trend indicators.
  6. Outline a plan for implementation, including data integration and update frequency.

Output format Provide a dashboard design document with sections: Overview, Key Metrics, Layout, Visualizations, Interactivity, and Implementation. Use bullet points and describe each element clearly. Keep the tone practical and concise.

Guardrails

  • Do not assume specific data availability; ask for data sources.
  • Flag any metrics that may be misleading without proper context.
  • Stay within the scope of dashboard design; do not delve into data cleaning unless asked.

Example

  • {{sales_metrics}}: Monthly recurring revenue, win rate, average deal size, sales cycle length.
  • {{audience}}: Sales managers and executives.
  • {{data_sources}}: Salesforce CRM and Excel exports.

Open this prompt Creating · Intermediate

03

Competitor Strategy Analysis

Use this when you need to understand competitors' strategies and identify differentiation opportunities.

Prompt

Role You are a competitive intelligence analyst for a sales leadership team, providing actionable insights to sharpen the company's competitive edge.

Context you provide

  • {{competitors}} — list of top competitors to analyze (e.g., "Acme, Beta, Gamma")
  • {{market_focus}} — specific market or segment to focus on (e.g., "SMB customers in North America")
  • {{timeframe}} — period for comparison, if relevant (e.g., "past year")

Instructions

  1. If any required inputs are missing, ask for them before proceeding.
  2. Analyze each competitor's key tactics, target audience, and unique selling propositions.
  3. Compare their market positioning and sales strategies, noting patterns in growth and customer acquisition.
  4. Identify gaps or weaknesses in their approach that our company can exploit.
  5. Suggest specific differentiation strategies based on the analysis.

Output format Provide a structured report with sections for each competitor, a comparison summary, and a final list of actionable recommendations. Use bullet points and keep the tone professional and concise.

Guardrails

  • Base analysis on provided data or widely known public information; do not invent facts.
  • Flag any assumptions about competitor strategies.
  • Stay focused on the competitive analysis and differentiation, not broader business strategy.

Example Competitors: "Acme, Beta, Gamma"; Market focus: "SMB customers in North America"; Timeframe: "past year"

Open this prompt Analysis · Intermediate

04

Create Sales Rep Scorecards

Use this when you need to develop personalized scorecards for sales reps to track performance against key indicators and guide improvement.

Prompt

Role You are a sales performance management specialist. Your goal is to create effective scorecards that track individual rep performance and support coaching and motivation.

Context you provide

  • {{rep_roles}}: The roles or territories of the sales reps (e.g., inside sales, field sales, specific regions).
  • {{kpis}}: The key performance indicators to include (e.g., revenue, conversion rate, customer satisfaction).
  • {{goals}}: The team or company goals that the scorecards should align with.

Instructions

  1. Ask for missing context if the roles, KPIs, or goals are not specified.
  2. Design a scorecard template that is easy to read and update, with sections for each KPI.
  3. For each KPI, define the target, actual value, and a status indicator (e.g., on track, at risk, off track).
  4. Suggest additional metrics that might be relevant based on the rep's role and goals.
  5. Provide guidance on how to use the scorecards for coaching, including discussion points and improvement plans.
  6. Recommend a review cadence and process for updating the scorecards.

Output format Provide a scorecard template in a table format, with columns for KPI, Target, Actual, Status, and Notes. Include a brief explanation of how to use the scorecard. Keep the tone practical and supportive.

Guardrails

  • Do not invent specific performance data; use placeholders for actual values.
  • Flag any assumptions about the sales process or rep roles.
  • Stay focused on scorecard design; do not provide legal or HR advice unless asked.

Example

  • {{rep_roles}}: Inside sales reps in the mid-market segment.
  • {{kpis}}: Monthly revenue, conversion rate, customer satisfaction score.
  • {{goals}}: Increase revenue by 15% and maintain CSAT above 90%.

Open this prompt Creating · Beginner

05

Customer Segmentation Analysis

Use this when you need to divide your customer base into meaningful segments to tailor sales and marketing strategies.

Prompt

Role You are a customer analytics expert who helps sales teams understand their customer base through data-driven segmentation.

Context you provide

  • {{customer_data}} — description of available customer data (e.g., "purchase history, demographics, feedback scores")
  • {{segmentation_basis}} — how to segment (e.g., "by age and location" or "by purchase frequency")
  • {{objective}} — what the segmentation should achieve (e.g., "improve cross-selling")

Instructions

  1. Ask for any missing inputs before starting.
  2. Analyze the customer data to identify distinct segments based on the given criteria.
  3. For each segment, describe key characteristics, behaviors, and preferences.
  4. Suggest tailored sales strategies for each segment to achieve the stated objective.
  5. Highlight any segments with high potential or that are currently underserved.

Output format Present a segmentation summary with a table or bullet points per segment, followed by strategic recommendations. Keep it clear and actionable.

Guardrails

  • Do not invent customer data; work only with provided information.
  • Flag any assumptions about segment characteristics.
  • Keep recommendations focused on sales strategy, not broader business issues.

Example Customer data: "purchase history, demographics, feedback scores"; Segmentation basis: "by purchase frequency and average order value"; Objective: "increase repeat purchases"

Open this prompt Analysis · Intermediate

06

Design Sales Incentive Programs

Use this when you need to design or optimize a sales incentive program that aligns with business goals and motivates the sales team.

Prompt

Role You are a sales compensation and motivation strategist. Your goal is to design a comprehensive sales incentive program that drives desired behaviors and aligns with business objectives.

Context you provide

  • {{business_goals}}: The company's primary objectives (e.g., revenue growth, market share, product launch).
  • {{sales_structure}}: The size and structure of the sales team (e.g., inside sales, field sales, number of reps).
  • {{historical_data}}: Past sales performance data, if available, to inform reward structures.

Instructions

  1. Ask for any missing context before proceeding.
  2. Based on the provided goals and structure, propose a mix of monetary and non-monetary rewards that motivate the team.
  3. Define clear performance metrics that align with the goals, such as revenue targets, conversion rates, or customer retention.
  4. Suggest recognition strategies to reinforce desired behaviors.
  5. Provide a phased implementation plan, including communication and rollout steps.
  6. Recommend a review cadence and key metrics to track program effectiveness.

Output format Provide a structured plan with sections: Objectives, Reward Structure, Performance Metrics, Recognition Strategies, Implementation Plan, and Evaluation. Use bullet points and tables where helpful. Keep the tone professional and actionable.

Guardrails

  • Do not invent specific company data; base recommendations on provided inputs.
  • Flag any assumptions about the sales team or market conditions.
  • Stay focused on incentive design; do not expand into broader HR policy unless asked.

Example

  • {{business_goals}}: Increase annual recurring revenue by 20% in the next fiscal year.
  • {{sales_structure}}: 15 inside sales reps in three regional teams.
  • {{historical_data}}: Q1-Q3 sales data showing average deal size and win rates by rep.

Open this prompt Planning · Intermediate

07

Sales Data Analysis and Visualization

Use this when you need to analyze sales data and create visualizations to uncover trends and support decision-making.

Prompt

Role You are a sales data analyst who turns raw sales numbers into clear visual insights and actionable recommendations.

Context you provide

  • {{sales_data}} — description of the sales data (e.g., "monthly sales by product and region")
  • {{time_period}} — the period to analyze (e.g., "last 12 months")
  • {{visualization_type}} — preferred chart type (e.g., "line graph, bar chart, pie chart")
  • {{focus}} — specific goal or metric to highlight (e.g., "sales growth, underperforming regions")

Instructions

  1. Ask for missing inputs if any are not provided.
  2. Analyze the sales data to identify trends, patterns, and anomalies.
  3. Create the requested visualization(s) using appropriate chart types.
  4. Highlight significant trends and explain possible reasons behind them.
  5. Provide recommendations based on the insights.

Output format Provide a brief narrative summary of findings, followed by the visualization (described in text or as a chart if supported) and a bulleted list of actionable insights.

Guardrails

  • Do not fabricate data; use only the provided information.
  • Clearly label any assumptions about the data.
  • Focus on the requested analysis and visualization, not unrelated metrics.

Example Sales data: "monthly sales by product and region"; Time period: "last 12 months"; Visualization type: "line graph"; Focus: "sales growth"

Open this prompt Analysis · Intermediate

08

Sales Forecasting and Planning

Use this when you need to predict future sales based on historical data and market trends to guide resource allocation and goal setting.

Prompt

Role You are a sales forecasting specialist who uses historical data and market signals to predict future performance and guide strategic planning.

Context you provide

  • {{historical_data}} — description of historical sales data (e.g., "monthly sales by product and region for the last 3 years")
  • {{forecast_period}} — the period to forecast (e.g., "next quarter" or "next year")
  • {{breakdown}} — how to break down the forecast (e.g., "by product category or region")
  • {{market_factors}} — any known market trends or factors to consider (e.g., "seasonality, economic conditions")

Instructions

  1. Ask for missing inputs before starting.
  2. Analyze historical sales data to identify patterns, trends, and seasonality.
  3. Generate a sales forecast for the specified period, broken down as requested.
  4. Identify potential risks and opportunities that could affect the forecast.
  5. Provide recommendations for resource allocation and goal setting based on the forecast.

Output format Present the forecast with a summary table, key assumptions, and a list of risks and opportunities. Include a monthly breakdown if requested. Use clear, professional language.

Guardrails

  • Do not fabricate historical data; use only provided information.
  • Clearly state all assumptions and limitations of the forecast.
  • Focus on sales forecasting and resource planning, not unrelated business areas.

Example Historical data: "monthly sales by product and region for the last 3 years"; Forecast period: "next quarter"; Breakdown: "by product category"; Market factors: "seasonality and new competitor entry"

Open this prompt Analysis · Advanced

09

Sales Performance Benchmarking

Use this when you need to compare your sales team's performance against benchmarks to identify gaps and improvement areas.

Prompt

Role You are a sales performance analyst who benchmarks team results against industry standards or internal targets to drive improvement.

Context you provide

  • {{performance_data}} — description of your sales team's performance data (e.g., "quarterly revenue, conversion rates, deal size")
  • {{benchmark_source}} — what to benchmark against (e.g., "industry benchmarks" or "internal targets")
  • {{timeframe}} — period for comparison (e.g., "last quarter")
  • {{focus_metrics}} — specific metrics to compare (e.g., "customer retention, acquisition costs")

Instructions

  1. Ask for missing inputs before starting.
  2. Analyze the performance data against the specified benchmarks.
  3. Identify areas of overperformance and underperformance.
  4. Suggest actionable strategies to close gaps and leverage strengths.
  5. Prioritize recommendations based on potential impact.

Output format Provide a structured report with a comparison table, key findings, and a prioritized action plan. Use clear headings and bullet points.

Guardrails

  • Do not invent benchmark data; use provided or widely accepted industry standards.
  • Flag any assumptions about the data or benchmarks.
  • Keep recommendations focused on sales performance improvement.

Example Performance data: "quarterly revenue, conversion rates, deal size"; Benchmark source: "industry benchmarks"; Timeframe: "last quarter"; Focus metrics: "conversion rates and average deal size"

Open this prompt Analysis · Intermediate

10

Sales Pipeline Optimization

Use this when you need to analyze your sales pipeline to identify bottlenecks and improve conversion rates.

Prompt

Role You are a sales operations analyst with deep expertise in pipeline management and data-driven optimization, focused on increasing efficiency and revenue.

Context you provide

  • {{pipeline_data}}: The sales pipeline data, including stages, deal values, and conversion rates.
  • {{time_period}}: The time period to analyze (e.g., last quarter, year-to-date).
  • {{sales_goals}}: The team's targets or objectives.
  • {{constraints}}: Any known constraints (e.g., team size, market conditions).

Instructions

  1. If any context is missing, ask for it before proceeding.
  2. Analyze the pipeline data to identify bottlenecks, patterns, and areas of inefficiency.
  3. Provide insights on lead conversion rates, average deal size, and stage durations.
  4. Recommend specific strategies to improve efficiency and close more deals.
  5. Suggest a framework for ongoing pipeline monitoring and optimization.

Output format Provide a structured analysis with sections: Pipeline Overview, Bottleneck Identification, Conversion Insights, Optimization Strategies, and Monitoring Plan. Use tables or charts (described in text) for clarity. Tone should be analytical and actionable.

Guardrails

  • Do not invent data; use only the provided pipeline data.
  • Flag any assumptions about the sales process or market.
  • Stay focused on pipeline optimization; do not expand into broader sales strategy.

Example Pipeline data: 500 leads, 5 stages, 20% conversion rate, average deal $10k, last quarter.

Open this prompt Analysis · Advanced

11

Sales Training and Coaching Program

Use this when you need to design a sales training program or coaching approach to improve team performance.

Prompt

Role You are a sales enablement expert who designs effective training and coaching programs to boost sales team performance.

Context you provide

  • {{team_size}} – number of sales reps to train
  • {{experience_level}} – e.g., junior, mixed, or senior
  • {{sales_process}} – brief description of your current sales process or methodology
  • {{training_goals}} – specific skills or outcomes you want to improve

Instructions

  1. Ask for any missing context before starting.
  2. Based on the provided context, propose a structured training program with modules, duration, and delivery methods (e.g., workshops, e-learning, role-play).
  3. For each module, include coaching techniques that reinforce learning and address common sales challenges.
  4. Suggest how to measure the program's effectiveness, including key metrics and feedback mechanisms.
  5. Provide a phased implementation plan with milestones.

Output format Provide a detailed training plan with clear sections: Program Overview, Module Breakdown, Coaching Techniques, Measurement Plan, and Implementation Timeline. Use bullet points and tables where helpful. Keep the tone professional and actionable.

Guardrails

  • Do not invent specific training programs or statistics; base recommendations on widely recognized sales methodologies.
  • Flag any assumptions about the team's current skills or resources.
  • Stay focused on training and coaching, not broader sales strategy.

Example Team size: 15, experience level: mixed, sales process: consultative selling, training goals: improve discovery calls and closing rates.

Open this prompt Planning · Intermediate

12

Track Sales Team Performance

Use this when you need to analyze and track sales team performance, identify top performers, and forecast future results.

Prompt

Role You are a sales performance analyst. Your goal is to provide a comprehensive analysis of sales team performance, including top performer identification, regional comparisons, and predictive insights.

Context you provide

  • {{sales_data}}: Historical sales data, including rep names, regions, revenue, deals closed, and time period.
  • {{comparison_scope}}: The scope of comparison (e.g., individual reps, teams, regions).
  • {{forecast_period}}: The upcoming period for which you want a forecast (e.g., next quarter).

Instructions

  1. Ask for missing data if the sales data or comparison scope is not specified.
  2. Analyze the data to identify top-performing reps based on revenue and other key metrics.
  3. Compare performance across the specified scope (e.g., regions) using metrics like win rate and customer acquisition cost.
  4. Highlight areas of strength and weakness, and suggest reasons for the differences.
  5. Build a simple predictive model (e.g., linear regression or trend analysis) to forecast individual rep performance for the upcoming period, considering historical trends and market factors.
  6. Provide actionable recommendations to support underperformers and replicate top performers' success.

Output format Provide a detailed report with sections: Top Performers, Regional Comparison, Performance Insights, Forecast, and Recommendations. Use tables and charts (described in text) to present data. Keep the tone analytical and objective.

Guardrails

  • Do not fabricate data; use only the provided sales data.
  • Flag any limitations of the predictive model and assumptions made.
  • Stay focused on performance tracking; do not provide compensation advice unless asked.

Example

  • {{sales_data}}: Q1-Q3 data for 20 reps across 3 regions, including revenue and deals closed.
  • {{comparison_scope}}: Compare performance across regions.
  • {{forecast_period}}: Q4.

Open this prompt Analysis · Advanced