Predicting the customer service forecast for Q4 can be challenging. The surge in e-commerce activity as a result of Covid, coupled with current logistics disruptions, is complicating the forecasting process even further.

Either way, you can simplify customer service forecasting by converting transaction or revenue forecast into a valid agent headcount forecast.

At HelpFlow, we run 24/7 live chat and customer service teams for over 100 stores. We’ve been through five holiday seasons and have built an incredibly robust forecasting in KPI process. In this post, I will walk through how to simplify Q4 customer service forecasting to make sure you’re ready to rock (and not get rocked) this holiday season.

Customer Service Forecast: The Most Important Metric

Most important metric for forecasting is your transaction to ticket ratio. In short, you can forecast the number of tickets created for every 100 transactions and be extremely confident that this will hold steady as growth and transactions happens.

Here’s how to set your transaction to ticket ratio:

• Get transaction count for a recent time period, such as April to August. Post Covid is best.
• Get ticket count for the same time period.
• Calculate the ratio. Transactions divided by tickets.

We see the transaction to ticket ratio anywhere from 20 to 50% plus depending on the level of sophistication in the customer service operation (automations, self serve, etc) and scope of issues with fulfillment at any given time.

Use The Ratio To Project Volume

With the transaction to ticket ratio in hand, you can employ several methods to develop a customer service forecast for anticipated ticket volumes.

You can use your media spend plans to project traffic and then use your conversion rate to project the number of transactions that should result in.

You can also use revenue forecasts or your demand planners data to project the number of transactions for Q4.

Once you have the projected transactions, simply use the ratio to convert that into ticket volume.

How Many Agents Are Needed?

Once you have the projected ticket volume, you can easily figure out how many agents you need to handle the workload without sacrificing customer service quality or burning your team out.

1. Use historical data to calculate agent capacity per FTE (full time equivalent) agent.
2. And forecast the total FTE agents needed based on the ticket volume you projected.
3. If you realize you’re going to need to bring in temporary staff or hire new people, consider discounting down the agent capacity a bit or ideally use new hire agent capacity if you track that.

You’re now at a point where you will be able to see the additional agents you need to handle the Q4 workload that you’re forecasting.

Covid Has Thrown Everything Off

Covid has been a blessing for many e-commerce stores by shifting much of consumer buying habits online that used to be offline. For this reason, everyone agrees that this Q4 is going to be bigger than we thought before Covid.

But Covid has been a blessing and a curse. E-commerce shipping has become a nightmare, and with the growth of holiday spending, it’s likely to only get worse. Consumers know that shipping is a problem, but e-commerce brands are usually the ones blamed with negative reviews and chargebacks.

In your customer service forecast, it’s prudent to rely more on the latest data, particularly the transaction to ticket ratio. Make sure to incorporate data from the post-Covid era, and if you’ve encountered significant shipping issues lately, give more weight to the data from that period. It’s wise not to expect an automatic improvement in Q4.

What to do next?

Get a forecast in place for Q4 so you can maximize success while not breaking your business or your brand. The main steps are to calculate your transaction to ticket ratio and just got to figure out additional agents needed.

Here at HelpFlow, we were on 24/7 live chat and customer service teams for over 100 stores. We’ve been through five years of holiday shopping and have a very robust forecasting in customer service operation for our clients.  I’d be happy to talk through how we may be able to help you, or just get on a call to talk through a few questions you may have to prepare your internal team.