20 of the best prompts for sales forecasting, step by step across 4 stages. Works with ChatGPT, Claude, and Gemini.

20 of the best prompts for sales forecasting, step by step across 4 stages. Works with ChatGPT, Claude, and Gemini.
Published June 27, 2026
Getting Sales Forecasting right takes more than a single prompt. This 4-stage guide covers Gather Historical Sales Data, Analyze Sales Trends, Create Sales Forecast, and more, breaking the whole process into focused steps where each prompt builds on the last. Accurate sales forecasting is critical for businesses to make informed decisions and allocate resources effectively. These prompts guide users through every stage of the forecasting process, from gathering historical data to analyzing trends and generating actionable insights. Every prompt is optimized and runs in ChatGPT, Claude, and Gemini.
Compiling historical sales data is the foundation of any effective forecasting model. These prompts help you collect and organize relevant data before making predictions.
Compile sales data by region
"I need to gather historical sales data for the past [TIME FRAME] to improve our forecasting accuracy. Here is the raw data I have: [PASTE RAW DATA]. Organize this data into a structured format by region, including total sales per month and key product categories. Ensure that each region is clearly labeled, and provide a summary table at the end. If any region has incomplete data, note it separately for further investigation."
Summarize seasonal sales trends
"I need to analyze seasonal trends in our sales data for [PRODUCT OR SERVICE]. I have compiled the sales data over the last [TIME FRAME]: [PASTE SALES DATA]. Please identify any noticeable patterns or trends and summarize them in a brief report, including at least three key insights. Present the findings in a bullet-point format, and ensure each point is concise and clear. If any anomalies are detected, note them separately for further investigation."
Identify top-selling products
"I need to analyze our sales performance to understand which products have driven the most revenue over the last [TIME FRAME]. Here is the sales data for our products: [PASTE SALES DATA]. Please list the top five products by sales volume, along with the percentage of total sales each product represents. Ensure the output is formatted as a table with columns for product name, sales volume, and percentage. If any product has zero sales, note it separately for further investigation."
Collect competitor sales data
"I need to analyze our sales performance relative to our competitors. I have gathered the sales figures from competitors for the last [TIME FRAME]: [PASTE COMPETITOR DATA]. Please summarize the findings in a report, highlighting specific areas where we outperform and underperform compared to these competitors. Organize the output into a table format, listing the key metrics side by side for easy comparison. If there are any significant discrepancies, note them separately for further investigation."
Determine customer segments
"I need to analyze our customer segments to enhance our sales forecasting efforts. Specifically, I have historical purchasing behavior data for the past [TIME FRAME]: [PASTE SALES DATA]. Please break this down into distinct customer segments, including their respective sales contributions, and present the findings in a table format with columns for segment name, total sales, and percentage contribution to overall sales. Additionally, flag any segments that have less than [X]% contribution for further investigation."
Understanding trends in historical sales data is crucial for developing accurate forecasts. These prompts help you analyze the data to uncover insights.
Calculate year-over-year growth
"I need to calculate the year-over-year growth for our sales data from [PASTE SALES DATA]. This analysis is essential for understanding our performance trends over time. Please provide a detailed report that includes the percentage change for each year and observations on overall growth trends. Present the findings in a table format with columns for year, sales figures, and percentage change. If any year shows a decline in sales, note it separately for further investigation."
Visualize sales trends
"I need to create a visual representation of our sales trends over the last [TIME FRAME]. This is important for understanding how our sales performance has evolved and for making informed decisions. Here is the sales data I have collected: [PASTE SALES DATA]. Please suggest the best types of charts or graphs to use, and provide a brief interpretation for each suggestion. Include at least three different chart types. If any data points appear out of trend, note them separately for further investigation."
Identify correlations with marketing efforts
"I need to analyze the impact of our marketing efforts on sales for [COMPANY NAME]. I have compiled a summary of our marketing activities alongside sales data for [TIME FRAME]: [PASTE DATA]. Please identify any correlations between the marketing initiatives and sales performance, providing insights in a bullet-point format. Aim for at least three key findings. If any marketing activity appears to have no discernible effect on sales, note it separately for further investigation."
Analyze customer feedback impact
"I need to analyze how customer feedback has influenced our sales performance over the past [TIME FRAME]. I have collected feedback data alongside corresponding sales data: [PASTE DATA]. Please summarize the findings in a concise report, highlighting three key insights and two actionable areas for improvement. Present the insights in bullet points and ensure each area for improvement includes a suggested strategy. If any feedback has no clear impact on sales, note it separately for further investigation."
Examine economic factors
"I need to analyze how external economic factors have influenced our sales performance. I have gathered the economic data for the last [TIME FRAME]: [PASTE DATA]. Identify the top three factors that had the most significant impact on our sales and summarize your findings in a clear report. Include specific examples for each factor and present them in bullet points. If any factor shows conflicting data, note it separately for further investigation."
Developing a sales forecast based on analyzed data is essential for strategic planning. These prompts guide you in creating a forecast that is both realistic and actionable.
Generate a short-term sales forecast
"I need to create a short-term sales forecast for the next [TIME FRAME]. As part of my strategic planning, I am analyzing our sales performance to project future sales. Based on the historical sales data: [PASTE DATA], please provide a detailed forecast that includes expected sales volume and identifies potential factors influencing this forecast. Format the output as a bullet-point list. If there are any discrepancies in the data, note them separately for review."
Develop a long-term sales forecast
"I need to create a long-term sales forecast for the next [TIME FRAME]. This forecast will help my team at [COMPANY NAME] make informed strategic decisions based on the historical data and trends identified: [PASTE DATA]. Please provide a detailed projection in a table format, including quarterly estimates and key assumptions for each period. Additionally, highlight any potential risks that could impact these projections. If any assumptions are based on incomplete data, note those separately for further review."
Create multiple forecasting scenarios
"I need to develop multiple sales forecasting scenarios for my team, considering various market conditions that could impact our performance. Here are the key variables to consider: [PASTE VARIABLES]. Create three scenarios: an optimistic forecast, a pessimistic forecast, and a most likely forecast. For each scenario, provide a detailed explanation of the assumptions made and the potential outcomes. If there are any conflicting data points, note them separately for further analysis."
Estimate sales impact of new product launch
"I need to estimate the sales impact of launching a new product in the next [TIME FRAME]. This forecast is crucial for our strategic planning, and I want to base it on relevant historical data: [PASTE DATA]. Please provide a detailed forecast that includes projected sales figures for the next [TIME FRAME], considering potential market reception and the performance of existing products. If there are any unusual trends in the data, note them separately for further analysis."
Validate forecast assumptions
"I need to validate the assumptions made in our sales forecast for [PRODUCT OR SERVICE]. We are aiming to ensure that our projections are grounded in reality to guide our strategic decisions effectively. Here are the assumptions we have outlined: [PASTE ASSUMPTIONS]. Analyze each assumption and provide evidence to support or challenge them in a bullet-point format. Include at least three pieces of supporting data or insights for each assumption. If any assumption lacks sufficient evidence, note it separately for further investigation."
Sales forecasts should be monitored and adjusted based on real-time data and feedback. These prompts help you create a plan for ongoing evaluation and adjustment.
Set up a monitoring plan
"I need to create a monitoring plan for our sales forecast, which is crucial for aligning our strategies with actual performance. Here are the key metrics to track: [PASTE METRICS]. Outline a plan that details how often to review these metrics (suggesting intervals such as weekly or monthly), and specify what actions to take based on different outcomes. Provide at least three potential scenarios and corresponding responses. If any metric deviates significantly from expectations, note it separately for further investigation."
Adjust forecast based on actual sales
"I need to adjust our sales forecast based on actual sales performance for the last [TIME FRAME]. Here are the actual sales figures: [PASTE SALES DATA]. Please provide a revised forecast in a bullet-point format, including three key adjustments made to the original forecast based on the data provided. Additionally, include a brief explanation for each adjustment. If there are any significant discrepancies between the forecast and actual sales, note them separately for further analysis."
Analyze forecast accuracy
"I need to analyze the accuracy of our previous sales forecasts for [PRODUCT/SERVICE]. Here is the past forecast data compared to actual sales: [PASTE DATA]. Identify discrepancies and suggest at least three specific improvements for future forecasts, focusing on methodology, data sources, and assumptions. Present your findings in a bullet-point format for clarity. Additionally, flag any significant discrepancies greater than [PERCENTAGE] that may require immediate attention or adjustment to our forecasting approach."
Incorporate feedback into forecast adjustments
"I need to adjust our sales forecast based on team feedback. Here is the feedback I received: [PASTE FEEDBACK]. Summarize the key points into a concise list of three actionable suggestions that can be integrated into the current forecast. For each suggestion, provide a brief rationale for its inclusion. If any feedback lacks supporting data or clarity, note it separately for further exploration before finalizing the adjustments."
Create a reporting structure for forecast updates
"I need to establish a reporting structure for updating stakeholders on our sales forecast. This is crucial to ensure everyone is aligned with our goals and performance metrics. Please include the following key information in each report: [PASTE DATA]. Organize this into a structured format with sections for current forecast accuracy, adjustments made, and any insights gained. I would like these updates to be delivered weekly. If any significant deviations occur, note them separately for further analysis."
Consider historical sales data, market trends, economic conditions, competitor performance, and customer behavior. Additionally, factor in any upcoming product launches or marketing campaigns.
To improve accuracy, use a combination of qualitative and quantitative data, regularly review and adjust forecasts based on actual performance, and incorporate feedback from sales teams and market insights.
There are various tools available, including spreadsheet software like Excel, specialized forecasting software, and CRM systems that offer built-in forecasting features.
Sales forecasts should be updated regularly, ideally on a monthly basis, or whenever there are significant changes in market conditions, sales performance, or business strategy.
Short-term sales forecasting typically focuses on the next few months and is based on immediate trends and data, while long-term forecasting looks at a broader timeframe, often using historical data and market projections.
AI Prompts for Resolving Conflicting API Routes
Lovable may generate API endpoints or page routes that conflict with existing ones, causing unexpected behavior in your application.
See promptsAI Prompts for Eliminating Unnecessary Abstraction Layers
Lovable creates wrapper functions or utility layers for logic used only once, causing unnecessary complexity.
See promptsAI Prompts for Managing Context Window Limits
Bolt runs out of context mid-task, causing it to lose progress on large codebases.
See prompts