File 20170707 23720 q96r8o.jpg?ixlib=rb 1.1

Using data visualisation to beat the call centre curse

Using data visualisation to beat the call centre curse

Have you ever found yourself locked in a circular conversation about a missing bolt for your barbecue? Have you ever listened to classical hits for ten minutes while you wait to argue about a discrepancy on your bank statement? If so, then you will understand the pain of the call centre. The good news is that a dive into call data can help make the pain go away.

The past two decades have seen a massive expansion of the call centre industry. In the UK alone, there are now an estimated 5,000 in operation, employing about a million workers and generating revenue of £2.3 billion.

Some liken call centres to the modern equivalent of factories; the public face and first contact in an economy now dominated by the services industries. Long wait times and extended conversations where customers are bounced from operator to operator have the potential to create negative, long-lasting impressions. These are situations everyone wants to avoid.

But how to make sense of all the calls? Across the UK, over a quarter of a million calls provide more than 4m data points (or so-called “call events”) every day. When data is recorded at this scale, it is easy to get lost in the weeds and lose sight of the bigger picture.

Call and answer

But when we visualise this data, there is a way to sift through this massive amount of information to reveal larger trends and find trouble spots. We find ways to help callers and managers smooth the whole experience.

Our team created software to build images from 24 hours of anonymised call centre activity data of over 200,000 calls from a local company, QPC Ltd, which has a range of clients including Vodafone and Virgin. The sample image below may look complicated, but it shows how hot spots can be easily identified and targeted. Each tiny, individual rectangle represents a single phone call. And each rectangle, or cell, is ordered by the time at which the call started. The size and colour of the cells represents the length of each call.

Sample image generated using the software. Red spots indicate problematic areas that users can zoom in to inspect.

These images can be modified to focus on call length, wait times, resolved calls and so on. And we can zoom in and out to get either a high level view or a detailed inspection of a particular record. The information gets broken down into more meaningful blocks of information. So each hour is broken into into six ten-minute blocks, and each call split into the period when the caller is listening to a pre-recorded message, the time queuing, and the time talking to an actual human.

If you have ever dialled in to a call centre you’ll know that there can be multiple times that all of these happen on a single call. And so we gave each of these “events” their own time stamps so we could better gather detailed information.

This approach is a simpler way to gather insights for those managing the call centre and trying to handle the huge flow of calls. Call centres can find patterns in caller behaviour and spot any outliers. They can identify when we, the callers, abandon ship and hang up in frustration. They can work out how to filter calls more sensibly, and discover the moments when wait times increase and decrease.

Beating the odds

Perhaps more importantly this data visualisation offers some simple tips to make callers lives easier too. Next time you grit your teeth and dive into a world of hold music and apologetic recorded messages, consider these three simple pieces of advice.

Don’t call at lunchtime. Not only are you on your lunch break, so are a number of staff at the call centre. Expect to wait. Or to give up.

Avoid evening calls. The rate of abandoned calls increases during the day and peaks in the evening from 8pm.

Bite the bullet and call early. Our visualisation shows early morning calls yield the shortest queue and call times.

There are some worthwhile insights behind this advice. Using the visualization software, we can observe a dense cluster of abandoned calls typically between 1.10pm and 1:15pm. Perhaps these are the callers who thought they could get everything done while unwrapping a ham sandwich, but who soon think better of it.

The number of abandoned calls is clearly linked to wait time. You might wonder who is calling in between midnight and 8am, and they might be thinking twice too, as callers during these hours are twice as likely to abandon as those that dial in during normal business hours. We also get impatient after 8pm, when the percentage of callers who abandon takes another sharp rise.

One reason that those evening calls start to clog up the system might be that this is when the furious are calling in. Staff at QPC Ltd identified a special group which calls in the evening, waits longer than 15 minutes to talk to an agent, and then speaks to the agent for up to 15 minutes. It thought this is indicative of dissatisfied customers, prepared to wait to get the point across, and stick around until they get results. The normal average call length is a little over five and a half minutes.

Just be thankful you are not in that small but unfortunate group which suffers more than five “queue events” and ends up speaking to the agent for more than an hour. The only hope is that the call centre managers can spot these outliers in the data and call them back to check the pain was all worth it.