Average Call Length
Average length of answered calls.
The average length of answered calls.
The overall average call length is calculated as a weighted mean of avg_call_length_seconds, weighted by calls_answered. This is preferable to a simple average of weekly averages because weeks with more answered calls should contribute more to the overall result.
Calculation
Calculate a weighted average of weekly average call length, weighted by the number of answered calls.
NoteExample queries
Weighted average over a period:
SELECT
SUM(
CAST(avg_call_length_seconds AS DOUBLE)
* CAST(calls_answered AS DOUBLE)
)
/ NULLIF(SUM(CAST(calls_answered AS DOUBLE)), 0) AS weighted_avg_call_length_seconds
FROM call_centre.weekly_activity_report
WHERE CAST(date_range_start AS DATE) BETWEEN DATE '2026-01-01' AND DATE '2026-05-31';By week:
SELECT
date_range_start,
date_range_end,
CAST(avg_call_length_seconds AS DOUBLE) AS avg_call_length_seconds,
CAST(calls_answered AS BIGINT) AS calls_answered
FROM call_centre.weekly_activity_report
ORDER BY date_range_start;Weighted average over a period:
tbl(con, in_schema("call_centre", "weekly_activity_report")) |>
filter(
as.Date(date_range_start) >= as.Date("2026-01-01"),
as.Date(date_range_start) <= as.Date("2026-05-31")
) |>
summarise(
weighted_avg_call_length_seconds =
sum(avg_call_length_seconds * calls_answered, na.rm = TRUE) /
sum(calls_answered, na.rm = TRUE)
)By week:
tbl(con, in_schema("call_centre", "weekly_activity_report")) |>
arrange(date_range_start) |>
select(
date_range_start,
date_range_end,
avg_call_length_seconds,
calls_answered
)Interpretation notes
Use a weighted average rather than a simple average of weekly averages. A simple average may give too much influence to low-volume weeks.
Includes test calls. The weekly report gives the number of test calls, not their length, so they cannot be taken out of the average.
Alternative names
- average call duration
- average handle time
- average length of call
- typical call length
- average time on call