Skip to main content

Call Centre

Metrics in this section are calculated from call centre activity and topic data.

Call centre metrics are useful for understanding support demand, service responsiveness, caller wait times, average call duration, and common reasons for contact. The source data is weekly, so these metrics are typically reported at a weekly level or aggregated across weeks.

The relevant call centre tables are:

date_range_start and date_range_end are stored as text, so date-range filters cast them to DATE before comparing to date literals.

Activity Metrics

Metrics in this section describe call centre operations, sourced from call_centre.weekly_activity_report.

Metric Description
Calls Accepted Calls the call centre accepted in a reporting period, excluding staff test calls.
Calls Answered Number of calls agents answered in a reporting period.
Average Call Length Average length of answered calls.
Average Delay Average wait before a call is answered.
Abandonment Rate Share of accepted calls abandoned before an agent answered.
Answer Rate Share of accepted calls answered by an agent.
Service Level (Answered Within 60s) Share of calls answered within 60 seconds.
Average Handle Time Average agent time per call, including after-call wrap-up.
Calls per Active User Call volume relative to the active user base, comparable across weeks.
Escalations to PSO Calls the call centre escalated to Partner Success and Operations.
Escalation Rate Share of call centre calls escalated to Partner Success and Operations.
No matching items

Topic Metrics

Metrics in this section describe why people contact the call centre, sourced from call_centre.weekly_topic_dump. Because a single call can generate multiple topic rows, these metrics count topic records rather than distinct calls. Clean statobject before grouping, since it often carries leading, trailing, or repeated whitespace.

Metric Description
Call Topic Share Each call topic’s share of all topic records.
Calls by Topic Category Calls about each topic or category, as a share of calls, not of topic records.
Top 10 Call Topics The ten most common call topics.
No matching items