VICIdial Asterisk CDR Analysis for Connect Rate Optimization

Your VICIdial system generates a CDR (Call Detail Record) for every single call attempt. In a 50-agent outbound operation dialing aggressively, that's tens of thousands of records per day. Most call center operators treat the CDR as a logging artifact — something that exists for billing disputes and compliance audits. That's leaving money on the table. The CDR is the most granular data source you have for understanding what happens between the moment a call leaves your system and the moment it either connects to a human or doesn't. When you analyze it systematically, you can identify carriers that silently fail, time windows where connect rates spike, and call patterns that distinguish a live answer from dead air or a fast busy. This guide covers the CDR table structure, the queries that matter, and how to turn raw CDR data into connect rate gains. CDR Table Structure in VICIdial's Asterisk Database VICIdial stores CDR data in the cdr table within the asteriskcdrdb database. This is se