Skip to main content

Escalation Rate

Share of call centre calls escalated to Partner Success and Operations.

The share of call centre calls escalated to Partner Success and Operations (PSO). See Escalations to PSO for what counts as an escalation.

Calculation

Divide the escalations by the distinct calls (call_no) in call_centre.weekly_topic_dump over the same span of call dates. Both come from the same table, so they cover the same calls. The examples group by calendar month, but any span of call dates works.

Start no earlier than 2026-06-29, when escalation to PSO began.

SELECT
    date_trunc('month', call_date) AS month,
    COUNT(DISTINCT call_no) AS calls,
    -- transactiontype is padded with trailing spaces
    COUNT(DISTINCT CASE WHEN trim(transactiontype) = 'Callback' THEN call_no END) AS escalations,
    CAST(COUNT(DISTINCT CASE WHEN trim(transactiontype) = 'Callback' THEN call_no END) AS DOUBLE)
        / COUNT(DISTINCT call_no) AS escalation_rate
FROM call_centre.weekly_topic_dump
-- set the reporting window; escalation to PSO began on 2026-06-29
WHERE call_date BETWEEN DATE '2026-07-01' AND DATE '2026-09-30'
GROUP BY date_trunc('month', call_date)
ORDER BY month;
tbl(con, in_schema("call_centre", "weekly_topic_dump")) |>
  filter(
    # set the reporting window; escalation to PSO began on 2026-06-29
    call_date >= as.Date("2026-07-01"),
    call_date <= as.Date("2026-09-30")
  ) |>
  # transactiontype is padded with trailing spaces
  mutate(escalated_call = if_else(str_trim(transactiontype) == "Callback", call_no, NA)) |>
  group_by(month = floor_date(call_date, "month")) |>
  summarise(
    calls = n_distinct(call_no),
    escalations = n_distinct(escalated_call)
  ) |>
  mutate(escalation_rate = as.numeric(escalations) / calls) |>
  arrange(month)

Interpretation notes

The denominator is the topic dump, not the weekly report. The weekly report’s calls_accepted has no call dates, so it cannot be cut to the same span as the escalations, and it includes test calls. The topic dump has no test calls, but it misses calls with no topic logged, so it reads slightly below the weekly report. That pushes the rate up slightly.

One call moves the rate. Escalations are rare, so a single call can change a month’s rate by a percentage point or more. Show the counts next to the rate, and prefer longer spans.

A partial period is a rate to date. Label it with its last day of call centre data, and cut escalations and calls at that same day.

Alternative names

  • callback rate
  • share of calls escalated
  • percent of calls escalated
  • escalation share