We have the following situation: one of our customers wants to know the call duration for one transfer to IVR campaign. He wants to know if his customer listened the entire message or he closed the call before reaching the end.
We tried to do this in two ways:
1. We tried to SET AccountNumber in t_Dialer_detail with some timestamps but it seems that this variable is ReadOnly because we don't see the result in the table. Also CallDuration is NULL in this table.
2. We tried to find the outbound call in t_Termination_Call_Detail via "RecoveryKey" but we have some strange results. How are related the RecoveryKey columns from the two tables? Is is possible to be different?
What is the best method to resolve this request in your opinion?
Any help would be greatly appreciated.
sorry, then this was a misunderstanding, I thought you've got UCCE 7.5.
Anyway. Can you just get the RouterCallKeyDay and RouterCallKey combination for one call?
SELECT tcd.RouterCallKeyDay, tcd.RouterCallKey FROM Dialer_Detail dd JOIN Termination_Call_Detail tcd ON (dd.PeripheralCallKey = tcd.PeripheralCallKey) WHERE dd.CampaignID = 5001
Take one RCKD and RCK pair, then do this again:
SELECT * FROM Termination_Call_Detail tcd WHERE tcd.RouterCallKeyDay = [your RCKD value] AND tcd.RouterCallKey = [ your RCK value ]
Are these IVE Campaigns in IP-IVR, CVP microapps or CVP VXML?