Callers data hangup during ivr

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Callers data hangup during ivr

Postby muyousif » Fri Dec 14, 2018 11:40 am

Hi,

Is it possible to extract inbound callers data who hangup during ivr/call menus before reaching to inbound group?

Thanks.
ViciBox v.6.0.3 | VERSION: 2.14-685a BUILD: 180825-2100| Asterisk 1.8.29 | Cluster: 1 DB: 16Core@2.67GHz 16RAM | 1 WEB: 8Core@2.50GHz 16RAM | 8 Tel: QuadCore@2.93GHz 8RAM
muyousif
 
Posts: 119
Joined: Wed May 14, 2014 5:29 am

Re: Callers data hangup during ivr

Postby ambiorixg12 » Sat Dec 15, 2018 4:43 pm

What data exactly would you like to extract ?
ambiorixg12
 
Posts: 448
Joined: Tue Sep 17, 2013 10:35 pm

Re: Callers data hangup during ivr

Postby muyousif » Sun Dec 16, 2018 1:58 pm

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.
ViciBox v.6.0.3 | VERSION: 2.14-685a BUILD: 180825-2100| Asterisk 1.8.29 | Cluster: 1 DB: 16Core@2.67GHz 16RAM | 1 WEB: 8Core@2.50GHz 16RAM | 8 Tel: QuadCore@2.93GHz 8RAM
muyousif
 
Posts: 119
Joined: Wed May 14, 2014 5:29 am

Re: Callers data hangup during ivr

Postby ambiorixg12 » Sun Dec 16, 2018 4:12 pm

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
ambiorixg12
 
Posts: 448
Joined: Tue Sep 17, 2013 10:35 pm

Re: Callers data hangup during ivr

Postby muyousif » Mon Dec 17, 2018 3:14 am

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);
ViciBox v.6.0.3 | VERSION: 2.14-685a BUILD: 180825-2100| Asterisk 1.8.29 | Cluster: 1 DB: 16Core@2.67GHz 16RAM | 1 WEB: 8Core@2.50GHz 16RAM | 8 Tel: QuadCore@2.93GHz 8RAM
muyousif
 
Posts: 119
Joined: Wed May 14, 2014 5:29 am


Return to Support

Who is online

Users browsing this forum: No registered users and 66 guests