Interpreting your Call Data Records (CDR’s)

Overview

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