Abandoned Call Calculation From Termination Call Detail

[umartanveer]

HI..

Can someone please tell me how to calculate  Abandoned Calls  from Termination Call Detail Table ?.

Thanks in advance.

[Denis]

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.

[Gergely Szabo]

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.

[Denis]

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.

[Gergely Szabo]

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.

[Denis]

Gergely, unfortunately I did not have a chance to talk to that agent. Will try to get in touch and gain more details.

Thanks.

[Muhammed Thasleem]

Hi Gergely,

Could you let me know how to take logs of calls hitting cvp error DN ?

[pulatsahin]

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

[pulatsahin]

-- this query you can use

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