The end user was the blind spot.
The company, a US consumer paper-goods manufacturer, sells through distributors to end users. Distributor-level order data lived in the ERP. End-user-level contract, rebate, and consumption data lived in separate third-party databases, vast and messy. The two never talked. Senior analysts stitched them together by hand when a question came in — and every question routed through them.