Calls Accepted
The number of calls accepted by the call centre during a reporting period, not counting the test calls staff make to check the line.
This metric is useful for tracking call centre demand and understanding how contact volume changes over time.
Calculation
Subtract test_calls from calls_accepted by reporting period, or sum the difference across periods for a total. A missing test_calls means none were made, so read it as 0. Test calls are a subset of accepted calls, and at current volumes they are large enough to matter.
By week:
SELECT
date_range_start,
date_range_end,
CAST(calls_accepted AS BIGINT) AS calls_accepted,
CAST(COALESCE(test_calls, 0) AS BIGINT) AS test_calls,
-- a missing test_calls means none were made
CAST(calls_accepted - COALESCE(test_calls, 0) AS BIGINT) AS calls
FROM call_centre.weekly_activity_report
ORDER BY date_range_start;Total over a period:
SELECT
SUM(CAST(calls_accepted - COALESCE(test_calls, 0) AS BIGINT)) AS total_calls
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:
tbl(con, in_schema("call_centre", "weekly_activity_report")) |>
arrange(date_range_start) |>
transmute(
date_range_start,
date_range_end,
calls_accepted,
test_calls = coalesce(test_calls, 0),
# a missing test_calls means none were made
calls = calls_accepted - coalesce(test_calls, 0)
)Total 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(
total_calls = sum(calls_accepted - coalesce(test_calls, 0), na.rm = TRUE)
)Interpretation notes
Calls accepted may not be identical to calls answered, depending on call centre definitions and routing logic.
Test calls are left out by default across the call centre recipes. Only this count can drop them: the weekly report gives the number of test calls, not their waits, lengths, or outcomes. The recipes built on answered or abandoned calls, and the averages, say that they include them. The topic dump has no test calls.
Alternative names
- calls received
- accepted calls
- calls excluding test calls
- weekly call volume
- call centre demand
- number of calls handled by the queue