Customer support metrics dictionary & governance template
A copy-ready data dictionary for defining every support KPI precisely enough that operations, analytics, finance, and frontline leaders calculate the same number — with owners, formulas, populations, clocks, guardrails, source lineage, targets, and change control.
A support metric is not governed because it has a name on a dashboard. It is governed when two people can calculate the same result from the same population, explain which decision it informs, identify what it leaves out, and show who approved the definition.
Use this dictionary to create that record. It is designed for support operations, analytics, workforce management, quality, finance, and leadership to complete together. Copy the whole template into a shared document or data catalog, create one definition record per metric, and link every dashboard back to the approved record.
The rule is simple: a target can change without changing the metric; a metric cannot change without a version. If the formula, population, clock, event logic, aggregation, or source changes, record the break. Do not make last quarter mean something different after the fact.
For the operating principles behind the template, start with the customer support metrics guide. Use the glossary to reconcile common terms and the benchmark library for external context only after your internal definition is stable.
1 — Dictionary control block
Fill this once for the complete dictionary.
| Field | Decision |
|---|---|
| Dictionary owner | [name / role] |
| Executive sponsor | [name / role] |
| Data steward | [name / role] |
| Scope | [team / region / product / channels] |
| Canonical location | [URL] |
| Approved dashboard | [URL] |
| Current dictionary version | [v1.0] |
| Effective from | [YYYY-MM-DD] |
| Review cadence | [quarterly / twice yearly] |
| Next review | [YYYY-MM-DD] |
| Change approvers | [support owner + data owner + affected decision owner] |
Ground rules
- Every metric has one accountable business owner and one technical data owner
- Every dashboard, QBR, board pack, incentive, and vendor report uses the canonical definition or labels the difference
- Definitions are separate from targets, benchmarks, and commentary
- Counts can be reconciled to a sample of real contacts or events
- Averages are not used where a median, percentile, rate, or distribution answers the decision better
- Every efficiency metric has a customer, quality, or people guardrail
- Definition changes create a new version, effective date, impact note, and backfill decision
- Deprecated definitions remain visible so historical reports can still be interpreted
2 — Metric register
This is the index people should see first. Keep it short; the full record behind each row carries the detail.
| ID | Display name | Decision it informs | Accountable owner | Data owner | Status | Version | Effective date | Next review |
|---|---|---|---|---|---|---|---|---|
| [MET-001] | [Customer satisfaction] | [Where is service quality changing?] | [role] | [role] | [approved] | [v1.0] | [date] | [date] |
| [MET-002] | [First response time] | [Is the service promise adequately staffed?] | [role] | [role] | [approved] | [v1.0] | [date] | [date] |
| [MET-003] | [First-contact resolution] | [Which work is truly completed without repeat demand?] | [role] | [role] | [draft] | [v0.3] | [date] | [date] |
Allowed statuses: draft, in review, approved, deprecated. A metric used for performance management or external reporting must be approved.
3 — Blank metric definition record
Duplicate this entire section once per metric. Do not delete a field because it is inconvenient; write not applicable and say why.
Identity and decision
| Field | Definition |
|---|---|
| Metric ID | [stable ID, never reused] |
| Display name | [plain-language name] |
| Also known as | [vendor labels / legacy names / acronyms] |
| Business question | [the one question this metric helps answer] |
| Decision or action | [what changes when this moves] |
| Primary audience | [team lead / WFM / finance / executive / other] |
| Accountable owner | [role responsible for interpretation and action] |
| Data owner | [role responsible for implementation and quality] |
| Version and effective date | [v1.0 / YYYY-MM-DD] |
If the business question is vague — “how are we doing?” — the metric is not ready. Name the decision: add coverage, investigate a queue, change an article, coach a behavior, revise a promise, or stop an unsafe automation.
Exact computation
| Field | Specification |
|---|---|
| Plain-English definition | [one sentence a frontline lead can repeat] |
| Formula | [numerator ÷ denominator × unit, or exact aggregation] |
| Numerator | [included events and required conditions] |
| Denominator | [eligible population and required conditions] |
| Unit | [%, minutes, hours, currency, count, rate per 1,000] |
| Grain | [contact / ticket / conversation / customer / account / interval] |
| Aggregation | [sum / rate / weighted mean / median / p90 / other] |
| Reporting window | [calendar week / rolling 28 days / fiscal quarter] |
| Time basis | [calendar / business hours / staffed hours] |
| Time zone and calendar | [UTC / local / holidays / daylight-saving treatment] |
| Start event | [exact event and timestamp field] |
| Stop event | [exact event and timestamp field] |
| Pause rules | [pending customer / pending third party / no pauses] |
| Reopen and merge rules | [whether clocks resume, reset, or remain on original case] |
| Bot and automation rules | [included, excluded, or reported separately] |
| Missing and invalid data | [exclude / impute / unknown bucket / alert] |
| Rounding | [precision and when rounding occurs] |
Write the formula so an analyst who did not attend the meeting can implement it. “Resolved tickets divided by total tickets” is not enough until resolved, ticket, and total each have an event rule.
Population and segmentation
| Field | Specification |
|---|---|
| Included population | [channels, queues, regions, products, customer groups] |
| Excluded population | [spam, tests, internal cases, outages, duplicates, other] |
| Required segments | [channel / issue / tier / language / region / tenure] |
| Minimum sample | [minimum n before display or comparison] |
| Distribution view | [p50 + p90 / band / histogram / control limits] |
| Suppression rule | [privacy, fairness, or low-volume threshold] |
Do not compare blended numbers when the work is structurally different. Phone, chat, email, and persistent messaging use different clocks and capacity models. A metric that cannot be segmented by the operating unit it describes is usually a reporting artifact.
Source lineage and quality
| Field | Specification |
|---|---|
| System of record | [help desk / CCaaS / CRM / survey / finance] |
| Source objects | [tables, events, fields, survey items] |
| Transformation | [query / model / semantic-layer link] |
| Dashboard | [canonical report link] |
| Refresh cadence | [real time / hourly / daily / monthly] |
| Expected latency | [how stale the number may be] |
| Quality checks | [completeness, duplicates, impossible values, reconciliation] |
| Known data gaps | [missing channel, migration break, manual field, other] |
| Last reconciled | [date, sample size, reviewer, result] |
The calculation should survive a case-level audit. Keep a small reconciliation set of real tickets or contacts with the expected result written down; rerun it after workflow, vendor, schema, or query changes.
Interpretation, guardrails, and use
| Field | Decision |
|---|---|
| Healthy direction | [higher / lower / optimum band / context dependent] |
| Internal baseline | [value, period, population] |
| Target or operating range | [value, owner, period, reason] |
| External benchmark | [value, source, year, comparable segment, caveat] |
| Paired guardrail | [metric that exposes the cost of improvement] |
| Leading indicators | [signals expected to move first] |
| Known failure modes | [selection bias, mix shift, censoring, stale tags, other] |
| Gaming risk | [how a pressured team could improve the number without improving service] |
| Appropriate uses | [planning / team review / diagnosis / executive reporting] |
| Prohibited uses | [individual ranking / compensation / cross-channel comparison / other] |
| Escalation threshold | [condition, owner, response time] |
A benchmark is context, not a target. Record the source year, sample, segment, and definition beside it. If those are not comparable, label the figure directional. The benchmark library is a starting point, not permission to paste an industry average into a performance plan.
Approval
| Role | Name | Decision | Date |
|---|---|---|---|
| Business owner | [ ] | [approve / revise] | [ ] |
| Data owner | [ ] | [approve / revise] | [ ] |
| Frontline or workflow reviewer | [ ] | [approve / revise] | [ ] |
| Finance / people / legal reviewer, if affected | [ ] | [approve / not required] | [ ] |
4 — Reproduction and edge-case test
Complete this before approval and after every material change.
- Two people independently calculated the metric from the written record and matched
- A random case sample reconciles from dashboard to source event
- Boundary times were tested: period start/end, time-zone change, weekend, holiday, daylight-saving transition
- Reopened, merged, split, transferred, deleted, spam, test, and duplicate cases behave as specified
- Bot-only, bot-to-human, and human-only work is separated as specified
- Missing timestamps, missing survey answers, and invalid states land in a visible exception bucket
- Low-volume segments are suppressed or marked uncertain
- Historical results were compared before and after the change
- Every dashboard, export, QBR, and incentive using the old definition has an update owner
- The case-level test set and expected outputs are saved with the definition
Reconciliation record
| Test | Population / n | Expected | Actual | Difference | Owner | Result |
|---|---|---|---|---|---|---|
| Source-to-dashboard count | [ ] | [ ] | [ ] | [ ] | [ ] | [pass / fail] |
| Formula spot-check | [ ] | [ ] | [ ] | [ ] | [ ] | [pass / fail] |
| Edge-case suite | [ ] | [ ] | [ ] | [ ] | [ ] | [pass / fail] |
5 — Starter specifications for six common metrics
These are starting points, not universal definitions. Copy the relevant row into a full record and replace every assumption with your own operating decision. The support metrics cheat sheet explains where each number belongs.
Customer satisfaction (CSAT)
| Field | Starting specification |
|---|---|
| Question | What share of valid post-contact responses met the chosen satisfaction threshold? |
| Formula | Satisfied valid responses ÷ all valid responses × 100 |
| Must define | Survey question, scale, satisfied threshold, send event, response window, duplicate response rule, eligible contacts |
| Always segment | Channel, issue type, customer segment, resolved/reopened status |
| Pair with | Response rate, sample size or confidence interval, reopen rate, QA outcome |
| Do not use for | Ranking agents with small or non-random samples |
Publish the response count and rate beside the score. Use the CSAT confidence calculator to expose sampling uncertainty; it does not correct non-response bias.
First response time
| Field | Starting specification |
|---|---|
| Question | How long did customers wait for the first meaningful human response? |
| Formula | Time from eligible contact creation to first qualifying human reply |
| Must define | Business vs calendar clock, bot acknowledgement treatment, reopened cases, proactive messages, channels, pauses |
| Report | Median and p90, plus oldest unresponded work; not the mean alone |
| Pair with | First-response SLA attainment, abandonment for live channels, resolution and quality |
| Do not use for | Comparing channels with different promises as if they are one queue |
First-contact resolution (FCR)
| Field | Starting specification |
|---|---|
| Question | What share of eligible issues stayed solved without a repeat contact in the defined window? |
| Formula | Eligible issues with no qualifying repeat contact ÷ eligible issues × 100 |
| Must define | Contact vs issue grain, repeat window, same-issue matching, transfers, reopens, new-ticket duplicates, exclusions |
| Pair with | Reopen/repeat-contact rate, CSAT, QA, resolution time |
| Gaming risk | Closing early, relabeling repeat work, splitting channels, narrowing eligibility |
| Do not use for | Individual targets unless case mix and attribution are demonstrably fair |
FCR is easy to improve on paper. Review why it is the most gamed metric in support before attaching it to a target.
Average handle time (AHT)
| Field | Starting specification |
|---|---|
| Question | How much handling workload does a contact require for capacity planning? |
| Formula | Talk or active handling + hold + after-contact work ÷ handled contacts |
| Must define | Channel, concurrency, transfer treatment, after-contact work, short abandons, consult time |
| Segment by | Channel, queue, intent, complexity; use distributions for diagnosis |
| Pair with | FCR, QA, reopen rate, occupancy |
| Appropriate use | Forecasting and workflow investigation |
| Prohibited use | Standalone individual coaching or leaderboard |
Reopen rate
| Field | Starting specification |
|---|---|
| Question | What share of solved tickets returned because the customer still needed help? |
| Formula | Solved tickets with a substantive reopen inside [7/14] days ÷ eligible solved tickets × 100 |
| Must define | Reopen window, substantive reply, courtesy reply exclusion, auto-close behavior, merged/new-ticket repeat work |
| Pair with | FCR, repeat-contact rate, QA, resolution time |
| Review use | Mandatory QA stratum and process diagnosis |
| Gaming risk | Auto-closing, forcing new tickets, hiding the reopen action |
Cost per resolved contact
| Field | Starting specification |
|---|---|
| Question | What fully loaded cost did the operation incur for work that stayed resolved? |
| Formula | Included support operating cost ÷ qualifying resolved contacts |
| Cost scope | Compensation, benefits, contractors, tooling, AI usage, management, QA, facilities/overhead as agreed |
| Must define | Period, currencies, allocation rules, resolved denominator, reopens, bot/human split, shared-team cost |
| Pair with | Quality, reopen/repeat rate, CSAT, customer effort |
| Gaming risk | Omitting overhead, counting cheap failed contacts, shifting work outside support |
Use the cost-per-contact calculator to make the cost scope visible, then reconcile the result to finance. The real cost of a ticket explains why a cheap contact that returns is not cheap.
6 — Build a balanced metric portfolio
Do not fill the dictionary with every field the help desk exports. Start with the decisions the operation repeatedly makes, then select the smallest set that covers the system.
| Dimension | Decision | Candidate metric | Required counterweight |
|---|---|---|---|
| Demand | What is arriving and why? | Contact rate, volume, avoidable demand | Customer/product denominator, issue mix |
| Speed | Is the promise adequately staffed? | FRT p50/p90, SLA attainment, abandonment | Resolution, quality, oldest work |
| Resolution | Did the problem stay solved? | FCR, reopen, repeat contact | Case mix, customer signal |
| Quality | Was the work correct and safe? | QA outcome, critical failure rate | Calibration agreement, customer outcome |
| Customer | What did the customer experience? | CSAT, CES, complaints | Response rate, sample, behavior |
| Capacity and people | Can the team sustain the promise? | Workload, occupancy, shrinkage, attrition | Quality, absence, burnout signals |
| Cost | What does a durable outcome cost? | Cost per resolved contact, cost to serve | Quality, repeat work, customer value |
For each efficiency measure, write the guardrail on the same dashboard row. Faster pairs with solved. Cheaper pairs with correct. More automated pairs with confirmed outcome and reachable human help.
7 — Change log
Never overwrite the definition silently. Add one row for every change, including vendor migrations and “small” timestamp fixes.
| Version | Effective date | What changed | Why | Historical impact | Backfilled? | Approvers |
|---|---|---|---|---|---|---|
| [v1.0] | [date] | [initial approval] | [ ] | [none] | [n/a] | [ ] |
| [v1.1] | [date] | [exclude bot acknowledgements from FRT] | [customer promise required human reply] | [prior FRT not comparable] | [yes/no] | [ ] |
Material changes that require a new version
- Formula, numerator, denominator, grain, aggregation, or population changes
- A clock starts, stops, pauses, or resets differently
- Channel, queue, customer, bot, spam, test, transfer, merge, or reopen eligibility changes
- Survey question, scale, threshold, delivery timing, or response window changes
- Source system, event, field, vendor, semantic model, or query changes
- Allocation rules change for cost or staffing
- Historical data is backfilled, corrected, or reclassified
A target change belongs in the target history, not the formula. A display rename with no computational effect can be a minor version, but record it so readers can map old reports to new language.
8 — Publication and review checklist
- Plain-English definition appears beside the number or one click away
- Dashboard links to this definition record and shows its version/effective date
- Metric owner and data owner both approved it
- Target, benchmark, and actual are labeled as three different things
- External benchmark includes source, year, segment, definition caveat, and review date
- Sample size or eligible population is visible for rates and survey measures
- Required segments and distribution views are available
- Paired guardrail appears on the same review surface
- Prohibited uses are documented before the metric reaches performance management
- Reproduction test passed and the case-level test set is saved
- Change log, next review date, and deprecation plan are complete
- The metric appears in the support QBR outline only after these checks pass
9 — Quarterly review agenda
Run this as a 45-minute working review, not a presentation.
- Usage: Which decisions did each metric actually inform? Retire measures nobody used.
- Reconciliation: Did quality checks, source counts, and case samples pass?
- Behavior: Did a target create rushing, cherry-picking, premature closure, survey pressure, or work moved off-system?
- Comparability: Did mix, channel, product, survey, workflow, vendor, or source changes create a break?
- Coverage: Is an important customer, quality, people, or cost outcome missing while activity is over-measured?
- Change decision: Keep, revise, deprecate, or add — with an owner and effective date.
End with a signed change list. The dictionary is useful only if it governs the reports people actually act on.
If two dashboards show the same metric name with different numbers, do not average them and do not pick the prettier one. Stop, reconcile the population and event logic, approve one definition, and label the historical break. Agreement about what a number means is part of the operating system, not reporting housekeeping.
Continue exploring