Calculate Call Answer Rate
RéponduHi,
I hope someone can help me.
I'm currently working on a query to evaluate the "real" call answer rate:
I have the following table per country where I can see in the Subtotal the Total amount of calls for that Country. Now, when I sum all Agents Calls I get, in this example, 2227 calls answered by an agent while 2123 where answered by "null", so routed to voicemail or some overflow.
My calculation would now be 2123/4351*100 to get my real Call Answer rate.
How can I achieve this with Talk. When I just hide the results for Null my Subtotal is not correct anymore.
-
Hi Christoph,
Create a standard calculated metric and call it Call Agent = Blank
IF ([Call agent name]!=NULL) THEN [Call ID] ENDIFThen create another calculated metric and call it Call Agent = Not Blank
IF ([Call agent name]!=NULL) THEN [Call ID] ENDIFThis will display the same information as the standard "Calls" metric but instead in two columns.
You then want to create a Result Manipulation - Result Metric Calculation, name it Answer Rate
D_COUNT(Call Agent = Not Blank)/D_COUNT(Call Agent = Blank)*100This will give you the number of calls answered by country / by the calls where no country is visible to establish the answer rate
-
Thanks for taking the time to share this Kerry!
Vous devez vous connecter pour laisser un commentaire.
2 Commentaires