Analysing and processing a CDR file

Navigating to the call details screen


There are two ways of reaching the call details screen which is used to analyse and process your call charges, either after you have uploaded a CDR file into Billingbooth or from the uploaded calls listings page as detailed below:


  1. Click the Upload Calls link in the left-hand navigation menu and then find the uploaded calls you wish to anaylse/process in the uploaded calls listings.
  2. Once you've found the CDR, click its respective View button located within the Actions column.


Call details screen overview


The Call Details screen shows you a variety of information, such as:


Total calls

A count of all the calls within the CDR(s) you've uploaded as well as a download link to download the rows of all CDR files related to this upload in one file.


Calls without rates

A count of all calls that couldn't be matched against rates within the rate sheet you've uploaded for the provider you assigned to the CDR file, as well as a download link to download a "report", which is simply a slimmed down CDR formatted file featuring the rows that couldn't be matched against rates.


Calls without customers

A count of all calls that couldn't be matched against the CLIs you have assigned to your customers within Billingbooth, as well as a download link to download a "report", which is simply a slimmed down CDR formatted file featuring the rows that couldn't be matched against customers.


Status

The status of the call charges associated to this CDR file.


File(s)

The CDR filenames associated to these call details, additional files can be uploaded using the Add CDR file button at the bottom of the screen. Allowing you to process CDR files from alternate providers simultaneously.


Summary

Giving you the total amount of valid calls (calls matched to rates and customers), the total minutes used by your customers and the total monetary amount of call charges.


Customer Listings

A list of every customer with calls assigned to them within the CDR file(s), including the respective amount of calls they've made, minutes they've used, monetary amount of their charges and the ability to download a "report" of their calls, which is a slimmed down CDR formatted file featuring the rows pertaining to the respective customer.


Call details workflow


  1. Check that all your calls are matched against customers, some common causes of calls not being matched against customers are:
    • The CLI of the call has not been associated to one of your customers.
    • The CDR file(s) have corrupted data, this commonly occurs when the file has been opened and saved within Excel, which, by default, strips out leading zeroes from all numerical data.

  2. (Optional) If you had to amend your customer CLIs, click the Analyse button to get Billingbooth to check through the CDR file(s) again. If you had to update the CDR file, it's best to delete this call upload and start the process again.

  3. Check that all your calls are matched against rates, some common causes of calls not being matched against rates are:
    • No rate sheet has been uploaded for the provider you have selected.
    • The rate sheet you have uploaded is incomplete or out of date (contact your provider if you need help with this).
    • The CDR file(s) have corrupted data, this commonly occurs when the file has been opened and saved within Excel, which, by default, strips out leading zeroes from all numerical data.

  4. (Optional) If you had to amend your rate sheets, click the Analyse button to get Billingbooth to check through the CDR file(s) again. If you had to update the CDR file, it's best to delete this call upload and start the process again.

  5. Once everything is matched you can click the Process button to assign the call charges against the matched customers.







Updated on 2017-05-26 10:18:44 +0100

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.