05-29-2014 11:15 PM - edited 03-14-2019 01:29 PM
HI..
Can someone please tell me how to calculate Abandoned Calls from Termination Call Detail Table ?.
Thanks in advance.
07-24-2014 02:58 AM
Hi, Gergely.
I think, I found those abandoned calls. Here we have a Voice Record system. So each call from the client is in fact in conference with the agent and Voice Record system.
I analyzed the Agent State Trace, particulary EventName and AgentState columns.
And I found, that for a normal call the flow is :
DateTime | EventName | Code |
2014-07-05 12:02:59.000 | 6 | WORK_READY |
2014-07-05 12:03:00.000 | 3 | READY |
2014-07-05 12:03:01.000 | 8 | RESERVED |
2014-07-05 12:03:02.000 | 4 | TALKING |
2014-07-05 12:03:02.003 | 10 | CALL_HELD |
2014-07-05 12:03:02.010 | 9 | CALL_INITIATED |
2014-07-05 12:03:02.013 | 4 | TALKING |
2014-07-05 12:03:02.020 | 13 | CALL_CONFERENCED |
2014-07-05 12:03:49.000 | 6 | WORK_READY |
And here is the call flow for the abandoned call, this is where CALL_HELD goes straight to WORK_READY. So I assume it is lost from hold.
DateTime | EventName | Code |
2014-07-05 12:00:40.000 | 6 | WORK_READY |
2014-07-05 12:00:41.000 | 3 | READY |
2014-07-05 12:00:42.000 | 8 | RESERVED |
2014-07-05 12:00:43.000 | 4 | TALKING |
2014-07-05 12:00:43.003 | 10 | CALL_HELD |
2014-07-05 12:00:43.010 | 9 | CALL_INITIATED |
2014-07-05 12:00:43.013 | 4 | TALKING |
2014-07-05 12:00:43.020 | 13 | CALL_CONFERENCED |
2014-07-05 12:02:58.000 | 10 | CALL_HELD |
2014-07-05 12:02:59.000 | 6 | WORK_READY |
The only thing I have not figured yet, how to track ANI for such calls.
07-24-2014 03:06 AM
Hi,
just a quick question about your ANI question: is there a RouterCallKeyDay and RouterCallKey column in the report you are looking at? RCKD and RCK is supposed to be the unique call id for the whole duration of the call (with some exceptions).
G.
07-24-2014 04:28 AM
Got it. Exactly what I was looking for. Now I can track them down in the TCD table by RCK. Thanks a lot Gergely, apreciate your help.
07-24-2014 05:07 AM
Dennis, this is great news indeed.
One more thing: did you/would you spend some time with the agent to gain more information about these calls? I would like to see what happened there, from the point of view of the agent.
Thanks for the rating.
G.
07-24-2014 07:39 AM
Gergely, unfortunately I did not have a chance to talk to that agent. Will try to get in touch and gain more details.
Thanks.
06-24-2016 05:28 AM
Hi Gergely,
Could you let me know how to take logs of calls hitting cvp error DN ?
01-15-2020 05:01 AM - edited 01-15-2020 06:22 AM
Hi,
The query in blow shows abandon in queue.
DECLARE @from DATETIME = DATEADD(DAY,-1,GETDATE())
DECLARE @to DATETIME = GETDATE()
DECLARE @calltype INT = 5591
SELECT
tcd.*
from
Termination_Call_Detail tcd
inner join
Route_Call_Detail rcd on tcd.RouterCallKey = rcd.RouterCallKey and tcd.RouterCallKeyDay = rcd.RouterCallKeyDay and tcd.CallTypeID = rcd.CallTypeID
where
rcd.RouterErrorCode = 448 and
tcd.DateTime BETWEEN @from and @to AND
rcd.DateTime BETWEEN @from and @to and
rcd.CallTypeID = @calltype and
rcd.RequeryResult != 5 and
tcd.RouterCallKeySequenceNumber = 1
------ For Rona calls
select
tcd.*
from
Termination_Call_Detail tcd
where
tcd.DateTime BETWEEN @from and @to and
tcd.CallDisposition = 19 and
tcd.CallTypeID = @calltype
01-15-2020 05:11 AM
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide