Spend Analytics, Metrics, and Program Measurement
Spend analytics, metrics, and program measurement
This domain tests whether you can produce a number that survives a CFO's questions. Most program credibility problems are data problems: wrong denominator, stale certification, or double counting.
Build the data pipeline
Sources include accounts payable and ERP extracts, purchasing-card data, the supplier master, contract systems, and prime Tier 2 submissions. Then normalize supplier names and roll up to parent companies, map to a category taxonomy such as UNSPSC or your internal hierarchy, match each supplier to a certification record with an effective date, and classify spend as addressable or excluded.
The metrics that matter
- Diverse spend as a percentage of addressable spend - state the denominator every time.
- Supplier counts and new supplier additions per period.
- Inclusion rate - share of RFx events with at least one diverse bidder.
- Award rate - diverse awards divided by diverse bids; a low rate points to sourcing design or evaluation bias.
- Category penetration - where diverse spend is concentrated and where it is absent.
- Validated Tier 2 spend, reported separately.
- Program cost and cost per dollar influenced.
Worked example
A program reports 12% diverse spend on $500M total spend. Finance notes $80M is intercompany and $20M is taxes and fees, leaving $400M addressable, so the true rate is 15%. Separately, 40 diverse suppliers bid on 100 opportunities and won 12. Inclusion is strong in covered categories, but the diverse-bidder award rate of 30% trails the 45% overall rate - a signal worth investigating in evaluation scoring. Two actions follow: report on addressable spend, and audit scoring sheets in the low-conversion categories.
Data quality controls
Reconcile to the general ledger monthly, keep a certification expiry tracker, document exclusions in a written methodology, and version-control restatements so year-over-year comparisons stay honest.
Traps
- Using total revenue or total spend as the denominator.
- Counting the same dollars at Tier 1 and Tier 2 without disclosure.
- Reporting a supplier as diverse after its certificate lapsed.
- Tracking outreach activity instead of awards and spend.