custom report with accurate dialer report

All installation and configuration problems and questions

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

custom report with accurate dialer report

Postby abduuu » Wed Sep 08, 2021 7:29 am

when using lead report export with extended
i found there is no field match the billing time as my provider and also there is some lead from list not appear in this report when i traced i found that it has cancel or congestion dialstatus on the database
but it is not exported with this report
the data found in table vicidial_carrier_log

and i found it has
status NEW
and called_count 2
in vicidial_list table

hangup_cause dialstatus channel------------------------------------------dial_time----answered_time----- length_in_sec
16-----------------ANSWER Local/70xxxxxxxxxx@default-00000821;2 ------- 7 ---------------0 -------------------13
19 ----------------- BUSY Local/70xxxxxxxxxx@default-00000820;2 ------- 0 --------------- 0 ------------------- 0
16 ----------------- ANSWER Local/70xxxxxxxxxx@default-00000819;2 ------- 8 --------------- 0 ------------------- 5
16 ----------------- ANSWER Local/70xxxxxxxxxx@default-00000818;2 ------- 7 --------------- 0 ------------------- 43


the report url
serverip/vicidial/lead_report_export.php

is there any way to fix the answered time to reflect the billing time and to make all leads appear in the report
-how the lead have called_count 2 and its status still NEW
__________________________________________
ViciBox v.9.0.0 190913-1108
VERSION: 2.14-825a
BUILD: 210812-1609
esxi 6.5
asterisk version 13.27.0-vici
SVN Version: 3493
Last edited by abduuu on Wed Sep 08, 2021 7:34 am, edited 1 time in total.
abduuu
 
Posts: 10
Joined: Sat Oct 24, 2020 2:37 am

Re: custom report with accurate dialer report

Postby mflorell » Wed Sep 08, 2021 7:34 am

The Asterisk log times will never match your carrier billing time. The best option we've found is to use a separate OpenSIPs server to log connect time for calls, which tends to be much closer to how most carriers bill. But there are some carriers that we've never found a reliable way of comparing billing time.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: custom report with accurate dialer report

Postby abduuu » Wed Sep 08, 2021 7:42 am

ok i will try another system to calculate the bill time for these calls
is there a way to update this report from the other system or i will need to make custom report for it so i can calculate the bill time for each campaign separately
what about the missing lines on the report which have congestion or cancel dialstatus is this is a normal behavior for this report or it need to be fixed
abduuu
 
Posts: 10
Joined: Sat Oct 24, 2020 2:37 am

Re: custom report with accurate dialer report

Postby mflorell » Wed Sep 08, 2021 8:00 am

Since the lead export report is based upon leads and not calls, it will never be accurate for all calls placed. If you want a per-call report you should use the Calls Export Report or one the Carrier/Hangup reports in the Admin Utilities section.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: custom report with accurate dialer report

Postby abduuu » Wed Sep 08, 2021 9:37 am

I tried the Export Call Report
and it has the same issue with leads called but not found in the output of this report
is the congestion and cancel dialstatus calls should not be in these reports?
or i have issue in the report need to be fixed?
abduuu
 
Posts: 10
Joined: Sat Oct 24, 2020 2:37 am


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 63 guests