---
title: "Developing sales forecasting models"
slug: "developing-sales-forecasting-models"
date: "2024-11-13"
updated: "2024-11-13"
status: "published"
featured: false
access: "pro"
difficulty: "beginner"
one_liner: "How to use ChatGPT to create forecasting models that predict sales trends."
tools: ["ChatGPT"]
topics: ["Sales", "Data & Reporting"]
roles: ["Product Manager"]
categories: ["Sales"]
---

<!-- migrated_from_webflow_csv -->

<!-- UNRESTRICTED -->

<div class="unrestricted">

<p id="">As revenue grows, it’s important to start planning how your business will grow. That starts by forecasting your sales. Once you understand how much your business can generate in the future, you can understand where to spend and allocate resources.</p><p id="">In this tutorial, you’ll learn how to:</p><ul id=""><li id="">Develop a sales forecast for your business</li><li id="">Understand the benefits and drawbacks of different sales forecasting methods</li><li id="">Identify trends and generate predictions for your business</li></ul><h4 id="">Step 1: Understand sales forecasting</h4><p id="">Sales forecasting is a crucial aspect of business planning that helps predict future sales based on historical data and market analysis. Accurate sales forecasts enable businesses to make informed decisions about inventory, staffing, budgeting, and growth strategies.</p>

</div>

<!-- RESTRICTED -->

<div class="restricted" data-access="pro">

<p id=""><strong id="">Brief ChatGPT on your business</strong></p><p id="">To create an effective sales forecast, start by providing ChatGPT with a comprehensive overview of your business. Include details such as industry, market, products/services, customer base, and sales history.</p><blockquote id="">You’re going to help me develop sales forecasts for my business. I’ll start by sharing some details about my business. Let me know when you’re ready to proceed.<br/><br/>Business: [summarize business].<br/>Operating history: [add historical detail].<br/>Products: [summarize products].<br/>Sales history: [summarize sales history].</blockquote><figure class="w-richtext-figure-type-image w-richtext-align-fullwidth" data-rt-align="fullwidth" data-rt-max-width="1728px" data-rt-type="image" style="max-width:1728px"><div><img alt="__wf_reserved_inherit" loading="lazy" src="https://cdn.prod.website-files.com/66eeba0c7a01b10910c883da/67263c8a2b0f6a166ac09f4c_Tutorial_Content_CleanShot_May_27.webp"/></div></figure><p id="">ChatGPT may respond with a preliminary plan. If it doesn’t, you can follow-up with:</p><blockquote id="">Our plan is the following. Please let me know if there are other steps you think need to be taken:<br/><br/>1. Data collection - I will collect historical sales data and share it with you.<br/><br/>2. Trends - I will share any observations about the business’ trends. You can also offer suggestions or ideas as to what might be influencing the business.<br/><br/>3. Data analysis - you will review the data to find interesting patterns.<br/><br/>4. Forecasting model - you will explain different forecasting models suggest the one to use. Once I confirm, you will proceed with the forecast.</blockquote><h4 id="">Step 2: Data preparation</h4><p id="">Accurate sales forecasting depends on high-quality data. Data preparation involves collecting sales data and cleaning it to ensure accuracy.</p><p id=""><strong id="">Sales data</strong></p><p id="">You probably have a wealth of data available but to start, have to hand your monthly sales data in a simple format in a CSV file.</p><figure class="w-richtext-figure-type-image w-richtext-align-fullwidth" data-rt-align="fullwidth" data-rt-max-width="516px" data-rt-type="image" style="max-width:516px"><div><img alt="__wf_reserved_inherit" loading="lazy" src="https://cdn.prod.website-files.com/66eeba0c7a01b10910c883da/67263c892b0f6a166ac09e74_Tutorial_Content_May_23_Screenshot_(2).webp"/></div></figure><p id=""><strong id="">Other important notes about your business</strong></p><p id="">As mentioned in the reply from ChatGPT, you’ll want to share business decisions, events, and changes that might help ChatGPT understand your data, and provide better forecasts.</p><p id="">Use the following prompt, along with your sales data attached:</p><blockquote id="">I have attached the past 5 years of sales data.</blockquote><blockquote id="">Other notes:[include other important notes about your business decisions, events, and changes]</blockquote><figure class="w-richtext-figure-type-image w-richtext-align-fullwidth" data-rt-align="fullwidth" data-rt-max-width="1656px" data-rt-type="image" style="max-width:1656px"><div><img alt="__wf_reserved_inherit" loading="lazy" src="https://cdn.prod.website-files.com/66eeba0c7a01b10910c883da/67263c8b2b0f6a166ac0a074_Tutorial_Content_Screenshot_May_23.webp"/></div></figure><h4 id="">Step 3: Model building</h4><p id="">Now that ChatGPT has ingested your historical data with notes, it can start developing a forecast for your business. Rather than simply proceeding, for your own education it’s worth understanding the different models available to you. ChatGPT may suggest an overly simple forecast model when you may believe there’s something better suited for the complexity of your business.</p><p id="">To get more details, ask ChatGPT to explain some models and suggest one to use.</p><blockquote id="">Yes, but can you first explain different types of forecasting models and the one you suggest using?</blockquote><figure class="w-richtext-figure-type-image w-richtext-align-fullwidth" data-rt-align="fullwidth" data-rt-max-width="1678px" data-rt-type="image" style="max-width:1678px"><div><img alt="__wf_reserved_inherit" loading="lazy" src="https://cdn.prod.website-files.com/66eeba0c7a01b10910c883da/67263c8b2b0f6a166ac09f71_Tutorial_Content_May_23_Screenshot_(3).webp"/></div></figure><p id="">With data analysis, ChatGPT can sometimes run into an issue with processing the data. It’s often self-corrective though. It make take a few minutes to complete its analysis and initial predictions.</p><figure class="w-richtext-figure-type-image w-richtext-align-fullwidth" data-rt-align="fullwidth" data-rt-max-width="1694px" data-rt-type="image" style="max-width:1694px"><div><img alt="__wf_reserved_inherit" loading="lazy" src="https://cdn.prod.website-files.com/66eeba0c7a01b10910c883da/67263c8a2b0f6a166ac09f68_Tutorial_Content_May_23_Screenshot_(4).webp"/></div></figure><p id="">You can also ask ChatGPT to reformat the data into a spreadsheet and provide more recommendations.</p><blockquote id="">Reformat the projections into a spreadsheet I can download.<br/><br/>Provide more recommendations for increasing sales over the next 3 years.\</blockquote><figure class="w-richtext-figure-type-image w-richtext-align-fullwidth" data-rt-align="fullwidth" data-rt-max-width="1718px" data-rt-type="image" style="max-width:1718px"><div><img alt="__wf_reserved_inherit" loading="lazy" src="https://cdn.prod.website-files.com/66eeba0c7a01b10910c883da/67263c8b2b0f6a166ac09f6e_Tutorial_Content_Screenshot_May_23_(1).webp"/></div></figure><p id="">Congratulations! You’ve developed a 3-year forecast that will help you make critical business decisions.</p><h4 id="">Bonus: Advanced analysis with ChatGPT API</h4><p id="">The ChatGPT API allows for automation and integration with other tools, enhancing your forecasting capabilities. Every company stores and analyzes its data differently. We suggest starting with this prompt:</p><p id="">Explain how to use the ChatGPT API to automate sales forecasting processes and integrate with other business tools.</p><p id="">ChatGPT can take you step-by-step through scripts, CRM integrations and other advanced forecasting methods.</p><figure class="w-richtext-figure-type-image w-richtext-align-fullwidth" data-rt-align="fullwidth" data-rt-max-width="1724px" data-rt-type="image" style="max-width:1724px"><div><img alt="__wf_reserved_inherit" loading="lazy" src="https://cdn.prod.website-files.com/66eeba0c7a01b10910c883da/67263c8b2b0f6a166ac09f74_Tutorial_Content_Screenshot_May_23_(2).webp"/></div></figure><p id="">This tutorial was created by <a href="https://www.jonahwolfraim.com" id="">Jonah</a>.</p><p>‍</p>

</div>
