Inconsistent customer records
A customer changes their address on the website. The CRM keeps the old one, billing sends invoices there and shipping uses a third. Support sees three versions.
- Why it happens
- Each system stores its own copy, with no agreed owner and no synchronisation.
- What it costs
- Misdelivered goods, failed collections and staff time spent reconciling.
- How we approach it
- Define a system of record per attribute, publish changes as events, apply validation and deduplication, and reconcile periodically with reports on drift.
- What to measure
- Mismatch rate between systems, time to propagate changes and manual corrections.