custom report with accurate dialer report

[abduuu]

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

[mflorell]

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.

[abduuu]

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

[mflorell]

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.

[abduuu]

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?