<div class="gmail_quote">On Mon, Apr 18, 2011 at 5:49 AM, Steven Howes <span dir="ltr"><<a href="mailto:steve-lists@geekinter.net">steve-lists@geekinter.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im">On 18 Apr 2011, at 11:06, bilal ghayyad wrote:<br>
> I am using Asterisk for Call Center (so agents login, logout, ready, not ready, ... etc). To be able to have a good call center reporting, on what I have to depend? On the CDR of Asterisk or there is another way?<br>
><br>
> Is there a good open source tool to be used for Asterisk call center reporting?<br>
<br>
</div><a href="http://www.google.com/search?q=asterisk+call+cener+reporting" target="_blank">http://www.google.com/search?q=asterisk+call+cener+reporting</a><br>
<br>
There are certainly some nice commercial ones. Can't comment on OSS stuff. But given it's for a call centre, I'd be tempted by the "you don't get something for nothing" approach.<br>
<div><div></div><div class="h5"><br>
S<br>
--<br></div></div></blockquote></div><br>I actually have implemented some very very good statistics by judicious use of the queue_log via odbc, running to a MySQL server, a few triggers, and then just wrote views that I can then filter on...<br>
<br>Currently I have the following quickly accessible to me via running simple select queries (with date range constraints where needed):<br><br><ul><li>Per Agent and Queue:</li><ul><li>Number of calls taken <br></li><ul>
<li>Can be grouped by day of month, day of week, or hour</li></ul></ul><li>Number and Percentage of calls:</li><ul><li>answered</li><li>abandoned</li><li>timed out</li><li>exit via keypress</li><li>exit due to leavewhenempty constraints</li>
<ul><li>broken down per queue</li><li>Can be grouped by day of month, day of week, or hour<br></li></ul></ul><li>Average, Minimum, and Maximum:</li><ul><li>Call Duration</li><ul><li>Per agent, queue, or both</li><li>grouped by day of month, day of week, or hour<br>
</li></ul><li>Wait Time resulting in various results (abandon, exit with key, answer, etc...)</li><ul><li>Per agent, queue, or both</li><li>grouped by day of month, day of week, or hour</li></ul></ul></ul>and that's just the stuff I did easily...I'm currently working on some more complicated statistics and the methods of generating those statistics...<br>
<br>I hope to release my little stats project as an open source offering, and it will definitely be part of my open source PBX solution "SamuPBX" (Asterisk configuration web interface and supporting backend code, think FreePBX without all the overhead and flatfiles)<br>