How to Forecast Sales Inquiry Volume by Season and Plan Your Team
To forecast sales inquiry volume by season, count the enquiries you received in each month of the past one to three years, compare the same months year on year, and use the pattern to plan next year's staffing and holidays. You don't need a statistical model. A spreadsheet and an honest export of your inbox or CRM are enough.
The goal isn't a precise number. It's knowing roughly when the busy weeks arrive, so you aren't deciding who covers the inbox once the peak has already started.
Why seasonal patterns matter more than averages
A monthly average hides the problem. If an event agency gets most of its enquiries in a few autumn weeks, an average tells you the team is fine. In practice, replies slip, quotes go out late and follow-ups get forgotten exactly when the most revenue is at stake.
Seasonality looks different in each business:
- Event and production firms: surges ahead of the year-end party season and before spring conferences, with quiet gaps between.
- Equipment rental: peaks that follow festivals, trade shows, and building or filming seasons.
- B2B services: enquiries often rise after budget planning and fall around main holiday periods.
Treat these as hypotheses. Your own data decides which ones are true for you.
Step-by-step: build your seasonal forecast
- Export your enquiries. Pull them from your shared inbox, Gmail or Outlook folders, or from HubSpot or Pipedrive. You need at least the received date and a rough label for the type of request. Go back as far as your history is reliable, ideally two or three years.
- Clean the list. Remove spam, supplier mail, duplicates and replies within the same thread. Count one enquiry once. Decide the rule and keep it the same every year.
- Count by week or month. Weeks show peaks more sharply. Months are fine if you receive few enquiries. Put each year in its own column so you can compare the same period side by side.
- Mark the pattern. Highlight the busiest and quietest periods in each year. If they land in the same place two years running, that's a seasonal pattern. If they move, look for a cause such as a one-off event, a campaign or a large customer.
- Write the forecast as a range. For each month, note "high", "normal" or "low" and a likely range based on past years. Add a short note on what could shift it, such as a marketing push or a new product line.
If you want to go a level deeper on what the history says about price friction and demand timing, reading pricing patterns in your own enquiries uses the same export.
Separate volume from workload
Ten enquiries are not always ten units of work. A one-line price request takes minutes. A complex production brief can take hours of clarification and a custom quote.
Tag by effort
Add a simple column: quick, standard or complex. Then forecast both numbers. A month with fewer enquiries but more complex ones can be heavier than a month with plenty of quick ones.
Watch incomplete requests
Enquiries that can't be quoted yet create extra rounds of email. If your peak months are full of them, your real workload is higher than the count suggests. Counting the hours lost to clarification loops shows how to measure that.
Turn the forecast into staffing and scheduling decisions
A forecast is only useful if it changes a decision. Use it for four things:
- Holiday planning: avoid having several people away in your high-volume weeks. Agree cover for the inbox before the peak, not during it.
- Temporary help: decide early whether you need a freelancer, a part-timer or a shared rota for the busy period.
- Preparation work: update price lists, standard quote wording and question sets in the quiet weeks before a peak.
- Response targets: set a realistic reply window for peak weeks and measure it. Measuring enquiry response time gives you a number to watch while volume is high.
In slumps, use the time for the work you postpone otherwise: reviewing open quotes, following up older ones and cleaning your data. If follow-ups are your weak spot, the answer on how to stop forgetting quote follow-ups covers the basics.
Common mistakes when forecasting inquiries
- Using one year only. One year can be distorted by a big project or a campaign. Use two or three if you have them.
- Counting everything as an enquiry. Mixed-in newsletters and supplier emails inflate the peaks.
- Ignoring the source. A peak caused by one directory listing or one partner behaves differently from steady demand.
- Forecasting once and forgetting it. Compare forecast with actuals every month and adjust the ranges.
- Treating the forecast as a promise. It supports planning. It doesn't tell you how many orders you'll win.
To see what happens after enquiries arrive, calculating quote conversion rate is the natural next measure.
How BOTrento helps you keep the data and handle the peak
Forecasting needs a clean history, and peaks need a process that keeps working when everyone is busy. BOTrento Chief of Staff is a managed process for enquiries and quotes. It watches enquiries in your mailbox and in the data you upload, and every working morning it shows a "Today 1+3" overview in the app and by email.
It prepares draft replies, quotes and follow-ups in four languages, and it picks up promises such as "I'll get back to you by Friday" and reminds you of them. Nothing is sent without a person approving it. BOTrento doesn't replace your CRM or accounting, and it doesn't send anything on its own.
At the start of a trial, a "Lost money" report looks back at past enquiries, though only for a mailbox connected via IMAP. You can import a CSV or XLSX export from your CRM or spreadsheet. AI is included in the plan with a monthly usage limit, and an own API key is optional (currently Anthropic only). You can see a walkthrough of the process first. For plans, see pricing. If cost is your question, there's also a short answer on what an AI sales assistant costs a small business.
Our own internal pilot ran over 7 days on BOTrento's own processes: 35 enquiries, 18 emails, 24 quotes and 15 actions. It's not a client reference, just an indication of the kind of workload the process handles.
FAQ
How far back should I go to predict inquiry volume?
Two to three years is ideal, because one year can be skewed by a single project or campaign. If you only have one year, treat the forecast as a rough guide and update it monthly.
Do I need a CRM to forecast inquiries by month?
No. A shared inbox export or a spreadsheet with received dates is enough. A CRM such as HubSpot or Pipedrive makes the export easier, but it isn't required.
Should I forecast by week or by month?
Use weeks if you get enough enquiries, because they show peaks more clearly. Use months if volume is low, and plan quarterly staffing from the monthly view.
What if my business has no obvious season?
Then the data will show a flat pattern, which is useful too. Look instead at weekday and time-of-day patterns, or at spikes linked to campaigns and specific sources.
Can AI forecast my inquiry volume?
AI can help you clean and read the history, but the forecast still rests on your own data and your judgement. Treat any forecast as a planning range, not a guarantee.
Summary
- Export two to three years of enquiries, clean them and count by week or month.
- Compare the same periods year on year to separate real seasonality from one-off spikes.
- Forecast workload as well as volume by tagging quick, standard and complex requests.
- Use the forecast for holiday cover, temporary help and preparation in quiet weeks.
- Review forecast against actuals every month and adjust.
Try BOTrento free for 14 days
Start your 14-day free trial on your own enquiries and quotes. Nothing is sent without your approval, and we'll help connect your mailbox within 24 hours on working days. Fill in a few details and your access arrives by email right away. We are happy to help you connect your mailbox.
14 days free, no card and no API key of your own. The trial starts only once your data is first loaded. Then from €79 per month excl. VAT, AI included.
Nothing is sent without your approval. You add a card at the end, only if you continue; without payment access is blocked until you pay, we keep your data for 30 days and the export stays available. Pricing · See the process demo
Thank you, we have your sign-up.
We have sent a sign-in link and first steps to your email. If it does not arrive within a few minutes, please check your spam folder.