This is the case of the missing golden record, the fifth and final file in our Data Detectives series, and it’s one of the oldest mysteries in data.

The evidence

  • The same customer appears across CRM, billing and support under variant names, with no common identifier
  • Hierarchies and relationships go unmanaged
  • Acquisition and growth added systems faster than the foundations could keep pace

The usual suspects

The CRM, the integration layer, data entry and the last merger all take turns in the frame, and each has a decent alibi. The CRM holds a perfectly good record. So do billing and support.

The root cause is that there is no mastered view, so each system holds its own version of the customer and nothing decides which one is right.

A lead worth following

Cooke Aquaculture was founded in 1985 and has grown from a single salmon farm into the largest private family-owned seafood company in the world. Its growth has been fueled by mergers and acquisitions, a model that also brings complex data challenges. Each enterprise it onboarded came with diverse systems, and over the years that left it with duplicate, siloed and disjointed data. Progress slowed, and gaining insight across its locations and companies became harder.

Cooke asked Amplifi how best to approach master data management. Trust was built from the start with a complimentary assessment that emphasized MDM best practices, including appointing a dedicated product owner and preparing for effective data governance. Cooke acted on that advice, appointing an MDM product owner as its first step, and later returned for an advisory engagement.

It chose Semarchy xDM for its flexibility and scalability, and Amplifi helped the team understand how to use shared attributes across the Product, Customer and Vendor domains. Consultants also provided hands-on support to configure the platform for Cooke’s most pressing needs, including resolving duplicate customer addresses and streamlining how data is onboarded during mergers. Over several months, Amplifi trained the product owner in the platform’s capabilities and in data governance best practice. Cooke’s Senior Data Governance Specialist said the consultants shortened the team’s learning curve and guided it toward self-sufficiency.

The result was three data domains unified on one consolidated platform, and a foundation Cooke describes as strong enough to minimize risk and keep its data efforts aligned with business goals. Read the full Cooke case study.

Look at the order of events: a product owner and governance preparation came first, and the platform came after. The golden record isn’t really a technology outcome. It’s the result of someone owning the question of which version is right.

Your first lines of inquiry

The usual way to lose this case is to try to master everything at once. Three moves to avoid that:

  1. Pick one suspect who keeps appearing under different names. Choose the one entity that hurts most, whether customer, product or supplier, and prove the approach there before extending it across domains.
  2. Decide who has the final word. Agree the matching rules, and who decides when two records conflict, before configuring anything.
  3. Check the paperwork after every merger. After an acquisition, treat “integrated” as a statement about data rather than branding. Until the customer and product records are reconciled, you have merged logos, not businesses.

Case closed

This is the last file in the series, and the conclusion is the same as it was in the first four. The symptoms differ, whether a missing return, a stalled pilot, a rogue report, a conflicting number or a customer who appears three times. The cause underneath is the foundations.

Our guide, Data Detectives: The Case of Trusted Data Foundations, follows all five cases from incident to root cause, with three practical moves for each and a self-check to test the strength of your own evidence.

Download the guide

If you’d like help working out where your own records stand, our Data Capability Assessment measures your data capabilities across six core areas and shows how ready your organization is to deliver on its data and AI ambitions. You get an evidence-based baseline, clear recommendations and a prioritized action plan, not a slide deck.

Learn more about the Data Capability Assessment

Or talk to a data expert about finding your golden record.