Dropped Call Report

Debug Information:

Date Range: 2026-06-14 to 2026-07-14

Selected Campaign: All Campaigns

Timeout Range: All Timeouts

VICIdial Log Records (60 days): 0

Unique Campaigns: 0

Unique Agents: 0

Unique Statuses: 0

Data Range: to

vicidial_log table found with 18 columns

Available columns: uniqueid, lead_id, list_id, campaign_id, call_date, start_epoch, end_epoch, length_in_sec, status, phone_code, phone_number, user, comments, processed, user_group, term_reason, alt_dial, called_count

vicidial_users table found with 155 columns

vicidial_campaigns table found with 367 columns

Using termination-based drop detection:

term_reason column: Available

hangup_cause column: Not available

Main Query Debug:

        SELECT vl.campaign_id, COUNT(*) as total_calls, COUNT(CASE WHEN vl.term_reason IN ('ABANDON', 'TIMEOUT', 'CALLER_HANGUP') OR vl.length_in_sec <= 3 THEN 1 END) as dropped_calls, COUNT(CASE WHEN NOT (vl.term_reason IN ('ABANDON', 'TIMEOUT', 'CALLER_HANGUP') OR vl.length_in_sec <= 3) THEN 1 END) as successful_calls, ROUND(AVG(vl.length_in_sec), 2) as avg_call_duration, ROUND(AVG(CASE WHEN vl.term_reason IN ('ABANDON', 'TIMEOUT', 'CALLER_HANGUP') OR vl.length_in_sec <= 3 THEN vl.length_in_sec END), 2) as avg_drop_duration, COUNT(DISTINCT vl.user) as agents_involved, MIN(vl.call_date) as first_call, MAX(vl.call_date) as last_call, COUNT(CASE WHEN vl.term_reason IN ('ABANDON', 'TIMEOUT', 'CALLER_HANGUP') OR vl.length_in_sec <= 3 AND vl.length_in_sec = 0 THEN 1 END) as instant_drops, COUNT(CASE WHEN vl.term_reason IN ('ABANDON', 'TIMEOUT', 'CALLER_HANGUP') OR vl.length_in_sec <= 3 AND vl.length_in_sec BETWEEN 1 AND 3 THEN 1 END) as quick_drops, COUNT(CASE WHEN vl.term_reason IN ('ABANDON', 'TIMEOUT', 'CALLER_HANGUP') OR vl.length_in_sec <= 3 AND vl.length_in_sec > 3 THEN 1 END) as delayed_drops, ROUND((COUNT(CASE WHEN vl.term_reason IN ('ABANDON', 'TIMEOUT', 'CALLER_HANGUP') OR vl.length_in_sec <= 3 THEN 1 END) * 100.0 / COUNT(*)), 2) as drop_percentage, COALESCE(vc.campaign_name, vl.campaign_id) as campaign_name
        FROM vicidial_log vl
        LEFT JOIN vicidial_campaigns vc ON vl.campaign_id = vc.campaign_id
        WHERE DATE(vl.call_date) BETWEEN ? AND ?
        GROUP BY vl.campaign_id
        HAVING total_calls > 0
        ORDER BY dropped_calls DESC
        LIMIT 50

Drop Condition: vl.term_reason IN ('ABANDON', 'TIMEOUT', 'CALLER_HANGUP') OR vl.length_in_sec <= 3

Parameters: 2026-06-14, 2026-07-14

Query Results:

Detection Method: termination_based

Campaigns Found: 0

Total Calls: 0

Total Drops: 0

Overall Drop Rate: 0%

Dropped Call Report

Start Date

End Date

Campaign

Reset

0

Total Calls

0

Dropped Calls

0%

Drop Rate

Method: termination_based

0

Active Campaigns

Data: vicidial_log + campaigns

No dropped call data found for the selected criteria.
Try expanding the date range, removing filters, or