Morrow CreekData Services
← Morrow Creek Data Journal

How to Use a Confusion Matrix to Evaluate a Business Classification Rule

Morrow Creek Data ServicesMorrow Creek Data Journal

A business rule often makes a quiet but consequential choice: send a record for review or let it pass. That could mean flagging a supplier record as a possible duplicate, routing a transaction for policy review, or identifying an account for outreach.

A confusion matrix is a decision ledger for that choice. It shows what the rule caught, what unnecessary work it created, and what important cases it missed.

Start by defining “positive” in business language. For a duplicate-review rule, for example: positive means the record truly requires manual duplicate review under the current policy. Positive does not mean desirable. It only names the condition the rule is trying to identify.

Build the matrix against a trusted reference

Test the rule on records with an independently reviewed, trusted reference label. The reference process must follow a documented policy as consistently as possible. A confusion matrix measures agreement with that process; it cannot fix an unclear policy or inconsistent reviews.

Also avoid testing only on records used to create or tune the rule. A rule can appear stronger on familiar cases than it will on new work.

For a binary rule, every tested record belongs in one of four cells. In the table below, rows are the actual reference status and columns are the rule result. State this convention whenever sharing a matrix, because software and publications sometimes reverse the axes.

Actual statusRule flags for reviewRule does not flag
Review truly neededTrue positiveFalse negative
Review not neededFalse positiveTrue negative

The labels matter less than their operational meaning:

  • True positives: records correctly sent for review.
  • False positives: records sent for unnecessary review or intervention.
  • False negatives: records that should have been reviewed but passed through.
  • True negatives: records correctly left alone.

Work through the counts before the percentages

Suppose a duplicate-review rule is tested on 1,000 supplier records that were independently reviewed under a documented policy. Eighty truly need review; 920 do not.

The rule flags 90 records. Of those, 72 truly need review and 18 do not. Among the 910 records it does not flag, 8 actually need review and 902 do not.

Actual statusRule flagsRule does not flagTotal
Review truly needed72880
Review not needed18902920
Total909101,000

This table describes the workflow more clearly than a single performance score. Ninety records enter the queue. Eighteen, or one in five, do not need to be there. Eight of the 80 records that deserved review were missed.

The familiar rates follow from those counts:

  • Precision: 80% (72 / 90). When the rule flags a record, how often is it right?
  • Recall: 90% (72 / 80). Of the records that truly needed action, how many did the rule catch?
  • False-positive rate: 1.96% (18 / 920). Of records that did not need action, how often did the rule flag them anyway?
  • Accuracy: 97.4% ((72 + 902) / 1,000). How often was the yes-or-no decision correct overall?

Accuracy sounds excellent here, but it is not the operating decision. The team still needs to decide whether its reviewers can absorb 90 cases, whether an 80% hit rate keeps the queue useful, and whether eight missed cases are acceptable.

Accuracy is especially weak as a headline measure when real cases are rare. If only 100 of 10,000 records need intervention, a rule that says “no intervention” every time is 99% accurate. It also has 0% recall and catches nothing.

Choose the measure that reflects the costly mistake

No universal score marks a business rule as good enough. The priority depends on what each error does downstream.

Favor recall when missed cases create the larger risk. This may apply where missed policy exceptions, eligibility issues, or high-priority accounts have serious consequences.

Favor precision or a low false-positive rate when unnecessary flags consume scarce reviewer time, interrupt ordinary customers, or trigger costly follow-up. Precision addresses the usefulness of the queue. False-positive rate addresses the burden imposed on records that should have been left alone. They are related, but their denominators differ.

Keep the counts beside the rates. A 2% false-positive rate among 100,000 ordinary records means about 2,000 unnecessary flags. The same rate among 500 records means 10. Small denominators also make rates unstable: one changed review can materially shift a percentage.

Evaluate the cutoff, not just the rule

If a rule produces a score or has an adjustable cutoff, create a separate confusion matrix for each candidate threshold. A stricter cutoff will generally flag fewer records. That often reduces both true positives and false positives, while increasing missed positives. A looser cutoff usually does the reverse.

The practical choice can be stated as an operating requirement: deploy at a cutoff only if recall meets the agreed minimum, the predicted-positive volume fits the review queue, and precision remains high enough for reviewers to work efficiently.

That is more useful than declaring that one statistic is good.

After the arithmetic, inspect the error rows. Sort false positives and false negatives by customer segment, product, region, source system, or rule condition. Repeated patterns can expose a stale field, a missing input, an ambiguous definition, or an exception that needs separate handling.

For a multi-category routing rule, use a square matrix instead. The diagonal shows correct routes; off-diagonal cells show where categories are confused. Focus first on the largest or most expensive error flows.

A confusion matrix does not tell you whether a rule is good in the abstract. It makes the tradeoff visible: the cases caught, the work created, and the cases still missed. That is the information needed to change the rule, change the workflow, or keep a person in the loop.

Have a dataset that needs to become usable?

Morrow Creek Data Services handles paid research, cleanup, verification, and structured delivery projects.

Start a data project