Call Detail Record¶
Management Customer [Customer Name] CDR
The CDR (Call Detail Record) is an extensive set of information that's collected and stored for each call. This is primarily used for billing purposes as it contains details such as call duration and destination number.
Archived Records
CDR records are "hot" (instantly queries) for the last 3 months guaranteed. After that, they're moved to the warm storage server where they're highly compressed and available for bulk download.
Global CDR
View CDRs for all Customers and Carriers in Global CDR.
Download and recalculate selected CDRs across several customers.
Manage displayed Call Detail Records¶
The Customer CDR tab lists Call Detail Records associated with the selected account. Select the entries to display more detailed information. The created queries on the server get displayed on the portal.
- Columns: You can enable more CDR fields on the Columns tab on the right.
- Column filter/sort: Click the header of each column to filter and sort the displayed entries. Since each call generates a CDR, this function is specifically useful for customers with high call volumes.
- Download: Press
Download
to save the record to your hard drive in CSV format. You can also select the columns to include in the download.
Recalculate Call Detail Record¶
When viewing CDRs for a specific customer, use the Recalc CDR
button to refresh CDR data that may be inaccurate. Each Operation displays different fields.
- Operations
- Refresh Credit (recalculates balances)
- Refresh Summaries & Credit
- Rerate Calls, and Refresh Summaries & Credit
-
Adjust Call Duration, Rerate Calls, and Refresh Summaries and Credit
-
Date (UTC) (for Refresh operations)
-
Release Reason (for Rerate operations)- Select the reason for the call's termination (multiple selections allowed). This will revise the amount charged for the calls.
-
Min Duration (for Adjust Call Duration operations)
-
New Duration (for Adjust Call Duration operations)
Rerating CDRs
If you select either "Rerate" options when recalculating CDRs, this will change your CDRs and isn't reversible.
Original call durations get modified according to the selected criteria.
Query Builder¶
Create advanced filters using any fields of the record. Select either Origination or Termination, or use the Query Builder to customize the data view.
- Match Type: Select "All" or "Any" calls to match.
- Select the CDR field from the drop-down, then "Add Rule" to define parameters to match.
- Select Add Rule to select extra fields and parameters to include in the custom query.
-
Use Add Group to group sets of queries into a series of groups, creating complex, compound, and multi-vector queries.
Using Query Builder with large amounts of data
It's recommended not to run detailed and complex queries on large amounts of data. It's better to write more compact and pared down queries to retrieve this data.
Unlike other providers, ConnexCS doesn't use CDRs for debugging.
You should be able to do all your debugging in the Logging section.
Call Detail Record Time Zone¶
You can view the rated CDR's stored in UTC; day-to-day totals are also calculated in UTC. You can change the time zone of individual CDR records viewed from the time zone selector, but downloads will always be in UTC.