Page 1 of 1

Callers data hangup during ivr

PostPosted: 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

PostPosted: Sat Dec 15, 2018 4:43 pm
by ambiorixg12
What data exactly would you like to extract ?

Re: Callers data hangup during ivr

PostPosted: 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

PostPosted: 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

PostPosted: 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);