Page 1 of 1
Callers data hangup during ivr
Posted:
Fri Dec 14, 2018 11:40 am
by muyousif
Hi,
Is it possible to extract inbound callers data who hangup during ivr/call menus before reaching to inbound group?
Thanks.
Re: Callers data hangup during ivr
Posted:
Sat Dec 15, 2018 4:43 pm
by ambiorixg12
What data exactly would you like to extract ?
Re: Callers data hangup during ivr
Posted:
Sun Dec 16, 2018 1:58 pm
by muyousif
Callers info who disconnected during ivr before reaching to agents, who just listened to ivr options but didn't press 0 to reach agent and disconnected call.
Re: Callers data hangup during ivr
Posted:
Sun Dec 16, 2018 4:12 pm
by ambiorixg12
All calls inbound and outbound are stored on table call_log, but using this table I dont see a way for you to indentify if caller listen to the IVR and then hangup. I would suggest make little script in a custom context and catch ${CALLERID(num)} variable and time before send the call to the call menu. In this way you will have a least a list of caller who dial in to the IVR. Dont know if is there is an easy method using vicidial GUI, as I used to custom code most of the things I need, dont blame me, I'm a frustrated developer lol
Re: Callers data hangup during ivr
Posted:
Mon Dec 17, 2018 3:14 am
by muyousif
Thanks for your help, following query helped me to catch required data.
select distinct(phone_ext) from live_inbound_log where uniqueid NOT IN (select distinct(uniqueid) from vicidial_closer_log);