Using weighted averages to calculate ASA and abandonment rate

Your ACD should report ASA and abandonment rate for defined time periods, considering the volume handled. However, if management wants you to combine time periods, using a weighted average provides a more realistic picture of a particular measurement versus a straight average

Published: 30 Jul 2009

Upper management would like me to use weighted averages for determining average speed of answer and abandonment rate. I believe they were referring to call volume, which is (10% - 20%) higher on certain days of the week. However, I do not see a direct correlation between call volume and average speed of answer and abandonment rate (due to staffing levels, types of calls, distribution of calls, etc.). So, I'm not sure if weighted averages would apply in this case and I'm not even sure how I would apply weighted averages. Your thoughts?

Your ACD should report ASA and abandonment rate for defined time periods, considering the volume handled. However, if management wants you to combine time periods, using a weighted average provides a more realistic picture of a particular measurement versus a straight average which skews data and weights all periods equally. The example below shows calculations for straight averages and weighted averages.

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

Example: Calls handled SVL Monday 550 80% Tuesday 300 65% Wednesday 150 90%

Total 1000 Straight average (80+65+90)/3 = 78.3% Weighted average (550x80)+(300x65)+(150x90)/ 1000 = 77%

The "right" way to do it depends on your definitions and targets, and how your system calculates. For example, if your target is to meet a certain abandon rate each day, then your system should provide the required data. If you need to meet a target each week, you'll need to look at whether your system provides that performance indicator on a weekly basis, and how it calculates it.

Dig Deeper on Customer loyalty and retention

Cord-cutting driving global broadband usage to surpass 500GB of data per month Exodus from traditional video services to online spurs surge in average broadband data usage, presenting untapped opportunities for service providers

UK tech firms spend less, deliver more on training Survey shows technology firms spend 46% of the national average on learning and development per employee, but deliver an above-average number of hours’ training

EU firms slow in detecting cyber attacks, study shows European firms take an average of 469 days to discover a compromise, compared with an average of 146 days globally, according to Mandiant

Average networking salary below rest of IT, but few look for new gigs The average networking salary is $20,000 less than the average for all IT, but few networking pros seek new jobs, says a recent TechTarget survey.

UK average internet speeds up 48% The latest State of the Internet report from Akamai shows the UK rising up the ranks when it comes to average connection speeds

Salary statistics reveal modest growth in IT sector in 2012 TechTarget's salary statistics reveal the average pay raise and salary rates for the most common roles in the IT organization.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Customer Experience experts

View all Customer Experience questions and answers

Please create a username to comment.

Personalization engines help engage and retain customers

New capabilities added to Alfresco Governance Services

Top 5 Office 365 skills for SharePoint administrators

AWS seeks niche in the cloud UC market

CPaaS market evolves to meet changing business needs

Zoom Chat update takes vendor further beyond video

Data warehouse technologies evolve as vendors look skyward

How to streamline feature engineering for machine learning

Top database cloud migration considerations for enterprises

How GE uses a 'Humble AI' approach to manufacturing

AWS, NFL machine learning partnership looks at player safety

AI in networking helps keep systems running

Process mining software pulls back curtains on how processes work

Epicor ERP system focuses on distribution

5 ERP implementation best practices CIOs should know

Dig Deeper on Customer loyalty and retention

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.