Independent and not affiliated with the FDA, MHRA, ISPE, PDA, or any agency. Get the appgoutham@madhadi.com
madhadi.comData Integrity & GxP Quality
Browse all topics → Articles Templates & Procedures Learning paths GlossaryScenariosToolsRegulatory ReferencesLearning PathsTopics About Start here
Template Plug-and-play starting point Quality Assurance

Template: Quality Metrics Trend Report

A plug-and-play quality metrics trend report: control-chart rules, complaint and deviation rates, CAPA and deviation aging and backlog, right-first-time, a management-review-ready summary, and an escalation log, with a filled specimen and the regulations it satisfies.

Document type: Template

Read and copy the template below into your own quality system. It is a generic starting point for your own internal use, provided as is, with no warranty; see the Terms and License. Adopting it does not by itself create compliance.

This is a ready-to-use quality metrics trend report. Replace every <<FILL: ...>> placeholder with your own specifics, set your document numbers and dates, attach your source charts, and route it through your normal review and approval. A worked filled specimen follows the template so you can see how a completed version reads. Verify each cited regulation against the current source before you rely on it.

Document control header

FieldEntry
Document titleQuality Metrics Trend Report
Document number<<FILL: REP-ID, e.g. QMR-2026-Q2>>
Reporting period<<FILL: from date>> to <<FILL: to date>>
Version<<FILL: version, e.g. 1.0>>
Site / scope<<FILL: site(s), area(s), product family in scope>>
Prepared by<<FILL: role, e.g. Quality Metrics Lead>>
Reviewed by<<FILL: role, e.g. Head of Quality Assurance>>
Distribution<<FILL: management review members, recipients>>

1. Purpose

This report presents the quality metrics for <<FILL: COMPANY NAME>> for the period above, with trend direction, control status, and the actions arising. The objective is to give management an honest, data-backed view of process and quality system health, surface adverse trends early, and drive decisions before a single point becomes a pattern.

2. Scope

This report covers the metrics in section 4 for the sites, products, and quality systems listed in the header. It draws on the deviation, complaint, CAPA, change control, and batch disposition systems for the period. It does not replace individual out-of-trend (OOT) investigations, which are governed by <<FILL: SOP-ID for OOT/OOS>>, nor the formal management review, which it feeds.

State the rules once, up front, so a reviewer sees that a “trend” is defined, not eyeballed. Apply the same rules every period.

ElementDefinition for this report
Baseline<<FILL: how the centerline / mean is set, e.g. trailing 12 months, or the validated/registered target>>
Control limits<<FILL: e.g. mean +/- 3 sigma for an individuals chart, or a fixed action limit>>
Alert (warning) limit<<FILL: e.g. mean +/- 2 sigma, or a defined warning threshold>>
RatesReported per a fixed denominator (per 1,000 units, per 100 batches, per million units) so periods are comparable
Rounding / convention<<FILL: decimal places, how partial periods are handled>>

3.1 Control-chart signal rules

A metric is flagged when any of the criteria below is met for the period. Adopt one published run-rule set (for example the Western Electric or Nelson rules) as your governing reference, state which set you use, and apply it unchanged each period. The criteria below describe the kinds of patterns that set should detect; replace them with the exact counts and limits from the standard you adopt.

  1. A single point that falls outside an action (control) limit.
  2. A short cluster of recent points repeatedly breaching the same warning (2 sigma) zone, where most of a small consecutive group lands beyond that zone.
  3. A run of recent points that mostly sit beyond the same 1 sigma zone on one side, signalling the process has moved toward a limit.
  4. A long enough sequence of points all on one side of the centerline to indicate a sustained shift in level.
  5. A steady run of points trending in one direction (all rising or all falling) that indicates drift.
  6. A point at or worse than a registered, validated, or regulatory limit, regardless of statistical status.

Any flagged metric gets a row in the escalation log (section 8) and, where required, an OOT investigation per <<FILL: SOP-ID>>.

4. Metrics dashboard

One row per metric. State the value, the comparison to last period and to the baseline, the control status, and the trend direction. Attach the source control chart for each metric as listed in section 9.

#MetricDefinition / denominatorThis periodLast periodBaseline / targetControl statusTrend
1Complaint rateComplaints per <<FILL: 1,000 / million units shipped>><<FILL>><<FILL>><<FILL>>In control / Alert / ActionUp / Down / Flat
2Confirmed complaint rateConfirmed (substantiated) complaints per <<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>>
3Deviation rateDeviations per <<FILL: 100 batches / 1,000 units>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>>
4Critical/major deviation rateCritical + major deviations per <<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>>
5Right first time (RFT)Batches with no deviation/rework, as % of batches disposed<<FILL: %>><<FILL>><<FILL>><<FILL>><<FILL>>
6OOS rateConfirmed OOS results per <<FILL: 1,000 tests>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>>
7CAPA on-time closureCAPAs closed on or before due date, as % closed<<FILL: %>><<FILL>><<FILL>><<FILL>><<FILL>>
8Recurrence / repeat deviationsDeviations linked to a prior same root cause, as % of total<<FILL: %>><<FILL>><<FILL>><<FILL>><<FILL>>

Add or remove rows so the dashboard matches your registered metric set. Keep every row tied to a definition and a denominator.

5. Complaint and deviation rate analysis

For each adverse or flagged rate, give the number, the rate, the signal rule it tripped (if any), and the leading contributors. Do not report a raw count without the rate; a rising count on rising volume can still be a falling rate.

ItemEntry
Complaints received (count)<<FILL>>
Units shipped (denominator)<<FILL>>
Complaint rate (per <<FILL>>)<<FILL>>
Top complaint categories<<FILL: e.g. appearance, packaging, efficacy, with counts>>
Deviations opened (count)<<FILL>>
By severity (critical / major / minor)<<FILL>>
Deviation rate (per <<FILL>>)<<FILL>>
Top deviation themes<<FILL: e.g. human error, equipment, environmental, with counts>>
Signal rules tripped<<FILL: none, or which rule(s) and on which metric>>

6. CAPA and deviation aging and backlog

Aging is the early-warning metric inspectors look at first; a healthy rate with a growing backlog of overdue records is still a quality system in trouble. Report open inventory by age band, not just averages.

6.1 Deviation aging

Status / age bandCount this periodCount last period
Open, within target age (<<FILL: e.g. <=30 days>>)<<FILL>><<FILL>>
Open, <<FILL: 31-60 days>><<FILL>><<FILL>>
Open, <<FILL: 61-90 days>><<FILL>><<FILL>>
Open, overdue (<<FILL: >90 days or > target>>)<<FILL>><<FILL>>
Total open (backlog)<<FILL>><<FILL>>
Closed this period<<FILL>><<FILL>>

6.2 CAPA aging

Status / age bandCount this periodCount last period
Open, within target<<FILL>><<FILL>>
Open, overdue<<FILL>><<FILL>>
Extensions granted this period<<FILL>><<FILL>>
CAPA on-time closure rate<<FILL: %>><<FILL>>
CAPA effectiveness checks due<<FILL>><<FILL>>
Effectiveness checks failed (reopened)<<FILL>><<FILL>>

State whether backlog is growing or shrinking and the action for any band that grew. A rising overdue count with extensions masking it is itself a finding to escalate.

7. Right first time and process health

ItemEntry
Batches disposed in period<<FILL>>
Batches with at least one deviation or rework<<FILL>>
Right first time (RFT)<<FILL: %>>
RFT trend vs baseline<<FILL: up / down / flat, with the signal rule if tripped>>
Rejected / scrapped batches<<FILL: count and %>>
Rework / reprocessing events<<FILL>>
Recurrence rate (repeat root cause)<<FILL: %>>

RFT falling while the deviation rate looks flat usually means deviations are concentrating in fewer batches; call that out rather than averaging it away.

8. Escalation log

Every flagged metric and every adverse trend gets a row, from detection through to the decision and owner. This log is the evidence that signals were acted on, not just plotted.

#Metric / trendSignal rule trippedSeverityAction / decisionOwnerDue dateStatus
<<FILL: 1>><<FILL: e.g. deviation rate>><<FILL: e.g. rule 4, 8-point shift>><<FILL: High / Med / Low>><<FILL: OOT raised / CAPA-#### opened / monitor>><<FILL>><<FILL>>Open / Closed
<<FILL: 2>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>>

9. Management-review-ready summary

One page management can act on. State the verdict plainly, then the few things needing a decision. This section is what feeds the formal management review per <<FILL: SOP-ID for management review>>.

ItemEntry
Overall verdict<<FILL: quality system state of control: in control / watch / action needed>>
Metrics in control<<FILL: count of N>>
Metrics in alert<<FILL: list>>
Metrics in action / out of trend<<FILL: list>>
Adverse trends needing a decision<<FILL: short list>>
Resources / decisions requested<<FILL: what management must approve, e.g. headcount, system fix, hold>>
Prior-period actions: status<<FILL: closed / open, with overdue called out>>
Recommendation<<FILL: one or two clear recommendations>>

10. Acceptance criteria

This report is complete and fit for management review when all of the following are true:

  • Every metric has a stated definition, denominator, and baseline, and is plotted with control and alert limits.
  • The signal rules in section 3.1 were applied consistently, and every flagged metric appears in the escalation log.
  • Rates, not raw counts alone, are reported, so periods are comparable across changing volume.
  • Aging and backlog are shown by age band, with growth and any masking extensions called out.
  • The management summary states a clear verdict and the decisions requested, and prior-period actions are tracked to closure.

11. References

21 CFR 211.180(e) (annual review of records and trends) and 211.192 (investigation of discrepancies and failures). ICH Q10, Pharmaceutical Quality System (management review, performance monitoring, and continual improvement). ICH Q9, Quality Risk Management (risk-based prioritization of signals and actions). EU GMP Chapter 1 (Pharmaceutical Quality System) and the Product Quality Review under Chapter 1. FDA Guidance for Industry, Submission of Quality Metrics Data (for the standard metric definitions, e.g. RFT, where adopted).

Confirm the current version and clause numbers of each reference before issue.

12. Revision history

VersionDateAuthorSummary of change
<<FILL: 1.0>><<FILL: date>><<FILL: author>>Initial issue.

13. Approvals

RoleNameSignatureDate
Prepared by<<FILL>>
Reviewed by (QA)<<FILL>>
Approved by (Quality Head)<<FILL>>

Filled specimen

The following shows the dashboard, aging, and summary completed for an example sterile fill-finish site for one quarter, so you can see the level of detail an inspector expects. The company and numbers are illustrative; replace them with your own.

Reporting period: 01 April 2026 to 30 June 2026. Scope: sterile fill-finish, Site B, all commercial products.

#MetricThis periodLast periodBaseline / targetStatusTrend
1Complaint rate (per million units)3.12.93.0 (12-mo mean)In controlFlat
2Deviation rate (per 100 batches)413330 (target)ActionUp
3Critical/major deviation rate (per 100 batches)645AlertUp
4Right first time88%93%92%ActionDown
5OOS rate (per 1,000 tests)1.21.31.4In controlFlat
6CAPA on-time closure79%91%90%ActionDown
7Recurrence (repeat root cause)22%12%<=10%ActionUp

Aging, deviations: 18 open within 30 days, 9 open 31 to 60 days, 11 open 61 to 90 days, 14 overdue (>90 days). Total backlog 52, up from 31 last period. CAPA: 6 overdue, 4 extensions granted, 2 effectiveness checks failed and reopened.

Management summary verdict: action needed. The deviation rate tripped rule 4 (an 8-point upward shift), RFT tripped a 6-point downward drift, and recurrence doubled, all pointing to the same theme: aseptic-process interventions on Line 3 after a vendor stopper change. CAPA on-time closure fell as the backlog grew and extensions piled up. Decision requested: approve a focused CAPA on the Line 3 stopper-feed interventions, add one investigator to clear the >90-day backlog, and hold the next two campaigns to a tightened intervention limit.

Escalation #Metric / trendSignal ruleAction / decisionOwnerStatus
1Deviation rateRule 4, 8-point shiftOOT raised, CAPA-2026-0218 opened on Line 3 stopper feedMfg Ops LeadOpen
2Right first time6-point downward driftLinked to CAPA-2026-0218; interim intervention limit appliedProduction MgrOpen
3Deviation backlog (>90 days)Backlog grew 31 to 52+1 investigator approved; weekly burn-down reviewQA InvestigationsOpen
4Recurrence rateAbove 10% targetRoot-cause depth review of repeat themes commissionedQA ManagerOpen

In this example the metrics did not just go in a table; the report tied three flagged metrics to one root-cause theme, showed the backlog growing behind a healthy-looking closure rate, and gave management two or three concrete decisions to make. That sequence, signal to theme to decision with an owner, is exactly what a reviewer is expected to see.

Common inspection findings this report prevents

  • Metrics plotted but never assessed against defined limits, so a clear shift or drift was never flagged.
  • Raw counts reported with no rate, so a trend was hidden by changing production volume.
  • A healthy on-time closure rate published while the overdue backlog quietly grew, masked by serial extensions.
  • Adverse trends shown in the report with no action, owner, or escalation recorded against them.
  • Recurrence and repeat root causes not tracked, so the same problem recurred without anyone connecting it.
  • The report produced but never presented to or acted on by management review.
  • Different definitions or denominators used period to period, making the trend meaningless.

How to adapt this report

  1. Set your document number, period, scope, and distribution in the header.
  2. Replace the metric rows in section 4 with your registered metric set, each with its own definition and denominator.
  3. Adopt one set of control-chart signal rules in section 3.1 and apply it every period without changing it mid-stream.
  4. Set your real age bands and targets in section 6 to match your deviation and CAPA SOPs.
  5. Point the cross-references in sections 2, 3.1, and 9 to your real OOT/OOS, deviation, and management review procedures.
  6. Confirm every regulation in section 11 against the current published version before issue.
Use madhadi.com as an app Full screen, works offline, one tap from your home screen.