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.
05-30-2014 02:42 AM
Hi,
it depends on what you mean by "Abandoned calls". Is it the number of calls abandoned while waiting in the queue + the number of calls abandoned while ringing at the agent phone?
If so, TCD might not be the best option. What I would do is to insert CallTypes into the ICM script and then check the Call_Type_Interval view (or Call_Type_Half_Hour, depends on if your setup supports 15 minutes long intervals or not) and take the number of RouterCallsAbandQ (and perhaps RouterCallsAbandToAgent) for that particular CallType.
G.
05-30-2014 03:59 AM
Hello Gergely,
Thanks for your reply.
Actually, I wanted to calculate Abandoned calls network wise (network name based on ANI) in both cases as below.
"abandoned while waiting in the queue + the number of calls abandoned while ringing at the agent phone"
From which TCD leg, I can get this?
05-30-2014 04:00 AM
Hi, it depends. What is your ICM and IP IVR (or CVP) version?
G.
05-30-2014 04:26 AM
Hi Gergely,
In our case its 8.5.
Thanks.
05-30-2014 08:19 AM
Hi,
alright, it's
CallDisposition 6 for the VRU PG's and CallDisposition 3 for the CUCM PG.
For instance:
SELECT COUNT(*) FROM Termination_Call_Detail tcd WHERE tcd.DateTime > CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME) AND tcd.PeripheralID = 5000 AND tcd.CallDisposition = 3
SELECT COUNT(*) FROM Termination_Call_Detail tcd WHERE tcd.DateTime > CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME) AND tcd.PeripheralID IN (5001,5002) AND tcd.CallDisposition = 6
G.
07-22-2014 06:03 AM
Hi, Gergely.
Could you advise, how to get the list of calls that were abandoned while being held at an agent position from TCD? I need to figure exact ANIs for such calls. Tried to search for calls with CallDisposition 6, but there are no such calls at all. However, I know that there are some from the WebView Agent22 report (Aban Hold counter) and from Agent_Skill_Group_Half_Hour.AbandonHoldCallsToHalf field.
07-22-2014 07:44 AM
Hi,
that's kind of strange. Can you get me a list of Peripherals and CallDispositions for that particular day?
You probably want to run SELECT tcd.PeripheralID, tcd.CallDisposition, COUNT(*) AS cnt FROM Termination_Call_Detail tcd WHERE tcd.DateTime > @desiredDateFrom AND tcd.DateTime < @desiredDateTo GROUP BY tcd.PeripheralID, tcd.CallDisposition ORDER BY 1,2
Thanks.
G.
07-22-2014 10:55 PM
Thanks for reply, Gergely.
One thing I forgot to mention, I need that information in regards of one agent.
So here is the output for the procedure, there are some CallDispositions of 6.
PeripheralID CallDisposition cnt
------------ --------------- -----------
5000 1 76
5000 3 192
5000 4 79
5000 6 9
5000 7 53778
5000 10 474
5000 13 1086
5000 14 14570
5000 15 4946
5000 19 25
5000 26 9
5000 27 5
5000 28 2053
5000 29 50
5000 30 16841
5001 6 7601
5001 13 2731
5001 28 7592
5002 6 15849
5002 13 4879
5002 28 15192
5003 3 1
5003 4 5
5003 6 2
5003 7 3996
5003 10 1645
5003 13 1
5003 14 1930
5003 26 150
5003 27 9
(30 row(s) affected)
But when I use the same select and specify the AgentPeripheralNumber I get only this:
PeripheralID CallDisposition cnt
------------ --------------- -----------
5000 4 2
5000 7 36
5000 13 1
5000 14 237
5000 28 14
5000 29 1
5000 30 247
(7 row(s) affected)
However, I know from Webview report and Agent_Skill_Group_Half_Hour.AbandonHoldCallsToHalf table that this agent had 4 aban hold calls for the specified day.
07-22-2014 11:30 PM
Hi,
let's try the other way around, filtering out rows with CallDisposition 6 and then take a look at all call legs. I have a feeling that the agent was in the middle of transferring the call when the customer disconnected. This could actually mean that it's not even going to be CallDisposition 6
Can you try the following SQL queries, export the result to CSV, post the result to here:
DECLARE @dateFrom DATETIME, @dateTo DATETIME
SET @dateFrom = '2014-07-22 00:00:00' /* use your datetime here */
SET @dateTo = '2014-07-23 00:00:00'
SELECT tcd.RouterCallKeyDay, tcd.RouterCallKey,tcdx.*
FROM Termination_Call_Detail tcd
LEFT OUTER JOIN (SELECT * FROM Termination_Call_Detail WHERE DateTime > @dateFrom AND DateTime < @dateTo) tcdx
ON tcd.RouterCallKeyDay = tcdx.RouterCallKeyDay AND tcd.RouterCallKey = tcdx.RouterCallKey
WHERE tcd.DateTime > @dateFrom AND tcd.DateTime < @dateTo
AND tcd.CallDisposition = 6 AND tcd.RouterCallKeyDay > 0
ORDER BY 1,2
Then the following one too (this filters out rows for the agent):
DECLARE @dateFrom DATETIME, @dateTo DATETIME
SET @dateFrom = '2014-07-22 00:00:00'
SET @dateTo = '2014-07-23 00:00:00'
SELECT tcd.RouterCallKeyDay, tcd.RouterCallKey,tcdx.*
FROM Termination_Call_Detail tcd
LEFT OUTER JOIN (SELECT * FROM Termination_Call_Detail WHERE DateTime > @dateFrom AND DateTime < @dateTo) tcdx
ON tcd.RouterCallKeyDay = tcdx.RouterCallKeyDay AND tcd.RouterCallKey = tcdx.RouterCallKey
WHERE tcd.DateTime > @dateFrom AND tcd.DateTime < @dateTo
AND tcd.AgentSkillTargetID = 6349 /* your agent's skilltargetid */
AND tcd.RouterCallKeyDay > 0
ORDER BY 1,2
Thanks.
G.
07-23-2014 12:03 AM
07-23-2014 01:39 AM
Hi, can you please tell me the SkillTargetID of the agent plus the approximate time (from the Agent_Skill_Group_Half_Hour table). Thanks.
G.
07-23-2014 03:39 AM
Sure, SkillTargetID of that agent is 12017. Below is the part of the Agent_Skill_Group_Half_Hour table for the specified agent and day, where I found the abandoned hold calls.
DateTime | SkillTargetID | SkillGroupSkillTargetID | RecoveryKey | AbandonHoldCallsToHalf | |
05.07.2014 | 12:00:00 | 12017 | 5106 | 644205499225 | 2 |
05.07.2014 | 14:00:00 | 12017 | 5106 | 644205500356 | 1 |
05.07.2014 | 14:30:00 | 12017 | 5106 | 644205500590 | 1 |
Thanks!
07-23-2014 11:17 AM
Hi,
I don' understand this.
This way: I don't have a 8.5 UCCE handy, only a 8.0 one (with IP IVR) and a 10.0 one (with IP IVR as well). I decided to replicate this issue on the 8.0 UCCE.
First try: incoming ACD call, agent picks it up, places the call on hold, caller disconnects. TCD CallDisposition 6 on Peripheral 5000, with the correct AgentSkillTargetID filled in. Agent_Skill_Group_Interval table AbandondHoldCalls incremented.
Second try: incoming ACD call, agent picks it up, initiates a consult transfer, call is placed on (network) hold, caller disconnects. Same result (CD 6, periph 5000, AbandonHoldCalls incremented).
Third try: incoming ACD call, agent picks it up, initiates a single step transfer to a CTI route point with a simple script behind it, the caller is placed into a queue which in turn places the call on hold (IP IVR script Call Hold step). Caller disconnects. Now this is getting interesting, the row with the AgentSkillTargetID is marked with CD 28 (blind transfer) and if I read on the rows with the same RCKD and RCK, the call is marked with CD 6 but on the VRU Peripheral. AbandonHoldCalls is not incremented.
I am out of ideas.
Is the Agent State Trace enabled for this particular agent? Can you take that for me, too?
Is there any other call scenario your agent(s) use? For instance, do they initiate conferences?
G.
07-24-2014 12:37 AM
Hi, Gergely.
Thank you for your help, I realy appreciate this.
I agree this is a stange behavior, by the way, we have 7.5(1) version.
Luckly we have Agent State Trace enabled. I attached the csv file with the events for this particular agent for the entire day.
Regarding the call scenarios, I will make a research. I am new to that system, it was configured before me. But I think it is quite possible, that conference might be a case.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: