Interpreting your Call Data Records (CDR’s)
From the Callroute portal’s reporting page, you can view your channel usage and historical calling information. You can also export your Call Data Records as a CSV file which is in a format based on the recommendations from the Federation of Communication Services.
This article explains the various fields shown in the CSV download, to ensure you can interpret your call data in a meaningful way.
CDR download file fields
The default CDR file format is designed for interoperability across billing systems and as such can be a little tricky to navigate to the uninitiated. Below is a list of the fields, their data types and some examples.
|Field name||Field format||Description||Example value|
|CallType||Text (max length 4)||The type of call being made:|
V = Standard Outbound voice call
I = Standard Inbound call (usually not billable e.g. Raw call data)
|V or I|
|CustomerIdentifier||Text (max length 100)||An identifier to which the call charge can be allocated.||CRT-123456|
|TelephoneNumberDialled||Text (max length 50)||Requested destination telephone number, in E.164 Format.||+441234567890|
|CallDate||Date||Date call started (format DD/MM/YYYY).||31/12/2021|
|CallTime||Time||Time call started (format HH:MM:SS).||23:59:59|
|Duration||Integer||Duration of call (in whole seconds).||3600|
|Description||Text (max length 100)||Description of the destination called.||London|
|DDI||Text (max length 50)||Destination DDI number, if known, in E.164 Format.||+441234567890|
|RingTime||Integer||Duration of the ring time in whole seconds||3|
|PresentationNumber||Text (max length 50)||The Calling Line Identity (CLI) presented by the calling party in E.164 format||+441234567890|
|ContractName||Text (max length 100)||Reserved for future use – currently mirrors CustomerIdentifier||CRT-123456|
|Salesprice||Decimal||Final sales price (omitted in certain situations; contact your sales partner for more information). Outbound calls rated at zero value will be related to the consumption of inclusive minutes within your package||13.59164|