[asterisk-users] ASR & ACD

[Matt Riddell]

On 11/09/09 10:27 AM, Ivan Stepaniuk wrote:
> B.Masoud @ SH wrote:
>>
>> ASR: Average Success Rate
>>
>> ACD: Average Call duration
>>
> Simply having your CDR on an SQL database would do the trick. For
> example, you can create a query that averages the value of your duration
> column.
>
> Anyway, there are many applications that can be used to analyze your CDR
> and even make charts on that. Google for: asterisk cdr analyzer.

Yep, we just use the cdr records.

ASR: select disposition, count(*) from cdr group by disposition

You'll get:

ANSWERED, 200
BUSY, 100

etc

Add up all the answered, divide by all the non answered (including 
congestion etc) and multiply by 100 - that's ASR

ACD: select sum(billsecs), count(*) from cdr where disposition = "ANSWERED"

sum(billsecs) is the total seconds, count(*) is the total records

divide sum(billsecs) by count(*), multiply by 100 - that's ACD

-- 
Cheers,

Matt Riddell
Director
_______________________________________________

http://www.venturevoip.com/news.php (Daily Asterisk News)
http://www.venturevoip.com/st.php (SmoothTorque Predictive Dialer)
http://www.venturevoip.com/c3.php (ConduIT3 PABX Systems)