How to Build a Single Source of Truth for Enterprise Customer Data and Deliver a True 360 Customer View

Intergalactic Data Labs
โ
โ
13 min read
Updated October 2026
A single source of truth for customer data is an agreed definition of customer, one resolved ID for each real customer, and rules for which source wins each attribute. The 360 customer view is what you build on top of it. Most programs fail on meaning and ownership, not on storage, so start with definitions and hierarchies before tools.
Layer | What it is | Who usually owns it | Typical tools |
|---|---|---|---|
Shared definitions | What counts as a customer, account, active | Data governance with business leads | Semantic model, glossary, ontology |
Resolved ID | One stable ID per real customer | Data platform team | MDM, CDP, warehouse matcher |
Golden record | Best value for each attribute | Data stewards | MDM survivorship, warehouse rules |
Hierarchies | Legal, commercial, billing trees | Finance and sales ops | MDM, graph, D-U-N-S or LEI data |
360 view | Records plus orders, tickets, usage | Each consuming team | BI, CRM, CDP, AI agents |
This guide covers how to design and run the customer foundation. For background, see the master data management glossary and the MDM versus semantic unification decision guide.
What does single source of truth mean for customer data?
It means every team uses the same customer definitions and the same resolved IDs, even when the data sits in many systems. It does not mean one database. Your CRM, ERP, billing system, and warehouse can all keep copies, as long as they point to the same ID and follow the same rules.
Three terms get mixed up. A single source of truth is the operating model of definitions, IDs, and rules. A golden record is the reconciled version of one entity. Informatica describes customer 360 as a shared, single view of your customer across the organization, which is the layer people actually use.
Keeping the layers apart prevents scoping mistakes. Teams that need shared definitions sometimes buy a marketing CDP. Teams that need entity resolution sometimes build another dashboard. Name the layer you are missing before you pick a product.
Why do companies still lack one view of the customer?
Most companies have centralized data but not meaning. Sales counts a customer as an account with an open opportunity. Finance counts a legal entity that receives invoices. Support counts a contract with an active entitlement. All three are reasonable, and all three disagree.
Semantic Arts traces client 360 trouble in banking to weak legal entity identification and semantically incompatible data silos, where each system uses its own identifiers. The same article calls customer a trigger word that fuels internal disputes. Deduplication and centralization alone did not fix it.
Identity tools can stitch records together. Stitching does not say whether the result is a billing entity, a legal parent, or a buying group. Until identity and meaning are both settled, the warehouse holds clean data that teams still read differently.
Where should the customer golden record live?
Put the resolved customer ID wherever your most demanding consumer needs approval and write-back. If finance and compliance need steward-approved records pushed to CRM and ERP, that points to MDM. If marketing activation dominates, a CDP may be enough. If analytics and AI dominate, the warehouse is a strong home.
Home | Strength | Documented limit | Fits when |
|---|---|---|---|
MDM platform | Stewardship, survivorship, write-back | Heavier rollout and licensing | Finance, compliance, ERP need approved records |
Packaged CDP | Fast person-level profiles for activation | B2B depth varies by vendor | Marketing and personalization lead |
Warehouse-native | Golden record next to analytics and AI | Few built-in steward workflows | Data team owns the model end to end |
CRM as master | Sales already lives there | Mirrors one team's definition | Small companies with one go-to-market system |
MDM platforms
MDM products manage golden records with match, merge, survivorship, and steward review. Ownership in this market shifted recently.
Salesforce completed its Informatica acquisition in November 2025 and plans MDM on Data 360. SAP completed its Reltio acquisition on May 7, 2026 and is integrating it into SAP Business Data Cloud, while keeping a standalone offering. Check how each roadmap affects you if your CRM or ERP comes from a different vendor.
Customer data platforms
CDPs build person-level profiles for audiences and activation. Twilio Segment's identity graph merges each customer's history into a single profile using IDs such as emails and device IDs, and it models user to account links through Group calls.
Adobe Real-Time Customer Profile treats B2B accounts as supporting entities that are only used for batch segmentation. Amperity Stitch scores record pairs with a machine learning classifier and assigns an Amperity ID to each cluster.
Salesforce Data 360 uses identity resolution rulesets with match rules and reconciliation rules to build unified profiles for individuals, accounts, or households. The unified profile does not change source data or connected systems. That is useful for safety, but it means corrections still need a path back to the system of record.
Warehouse-native identity
The warehouse-native pattern keeps the golden record next to analytics. Hightouch documents deterministic identity resolution that runs directly in your data warehouse and writes a golden record table chosen by survivorship rules. Open-source matchers such as Splink and Zingg fit here too, and the enterprise entity resolution guide compares them with commercial engines.
How do you model B2B customer hierarchies?
Model hierarchies as typed relationships, not as a single parent column. A large customer can be a legal parent with subsidiaries, several billing entities, and a buying group that spans countries. Sales rolls revenue up the commercial tree, while finance rolls it up the legal tree. One flattened column cannot serve both.
External identifiers anchor the legal tree. GLEIF Level 2 data records each entity's direct and ultimate accounting consolidating parent. The LEI itself is a 20-character code under ISO 17442. For companies without an LEI, D-U-N-S linkage gives a global ultimate, domestic ultimate, and parent for each site.
Keep commercial and service hierarchies as your own data, because no registry knows your territories or support contracts. Give every relationship a type, a source, and a valid-from date. That lets you replay last quarter's structure after an acquisition instead of overwriting it. Graph models handle these competing trees well because each relationship is its own record.
How do you build a customer single source of truth step by step?
Build it in narrow phases that each deliver a trusted answer. Start with one entity and one business question, such as revenue by account across sales and finance. Each phase should end with a number that two teams previously disputed and now agree on.
Step 1. Write the definitions down
List the core entities, usually person, account, legal entity, contract, and location. Write down what customer and active customer mean for each team, and note where they differ. Choose one shared definition where you can. Where teams need different meanings, give each a distinct name instead of forcing one word to mean three things.
Step 2. Inventory sources and identifiers
Catalog every system that creates or edits customer records. For each, record its native ID, its strong identifiers such as tax IDs, domains, and emails, which attributes it owns, and how often it updates. This inventory shows where matching will be easy and where it will be guesswork.
Step 3. Set match and survivorship rules by risk
Decide how records are compared and which source wins each attribute. Base thresholds on the cost of a wrong merge. Credit and compliance consumers should match conservatively and send borderline pairs to stewards. The entity mastering guide covers survivorship design and stable ID handling in depth.
Step 4. Encode the model
Turn definitions into a semantic model that tools can read. Rules like active customer means an open contract in the last 12 months belong in one governed place, not in each dashboard. A semantic layer or ontology works here, as long as BI tools, notebooks, and AI agents can all query it.
Step 5. Activate the view where work happens
Push resolved IDs and hierarchies back into CRM, billing, and support tools, and expose them to analytics and agents. Reverse ETL is common for this step. Fivetran announced a deal to acquire Census, a reverse ETL and data activation company, on May 1, 2025. Every new consumer will expose quality problems, so add them one at a time.
Step 6. Monitor it like a product
Run matching continuously, not as a migration. Track duplicate rate, link coverage, false merges from steward reviews, hierarchy coverage for top accounts, and attribute freshness. Name an owner for disputed merges and give them a queue. A foundation without an owner drifts back into silos within a few quarters.
What should the customer golden record include?
A golden record should carry enough context for someone to act on it without opening the source systems. That means identity, relationships, and provenance. Behavioral history usually lives in linked tables rather than inside the record itself.
Group | Example fields | Why it matters |
|---|---|---|
Identity | Resolved ID, legal name, trade names, domain | Anchors joins across systems |
Source keys | CRM ID, ERP account, billing ID | Lets every system find its record |
External IDs | LEI, D-U-N-S, tax number | Anchors the legal hierarchy |
Relationships | Typed parent, billing, partner links | Supports different rollups |
Provenance | Source, timestamp, winning rule | Makes every value explainable |
Confidence | Match score, steward decision | Lets consumers filter by risk |
Provenance is the field group teams most often skip. Without it, nobody can explain why a value won, and auditors notice. Record it when the rule runs, because rebuilding it later is rarely possible.
Why does a customer 360 view break over time?
It breaks because the business changes faster than the rules. Acquisitions add parents, divestitures split entities, and new products bring new definitions of customer. A golden record built on last quarter's hierarchy can be wrong this quarter without any pipeline failing.
New systems add new identifiers. A product-led motion may count users, while enterprise sales counts signed contracts. Point-to-point mappings between systems break whenever either side changes schema or meaning. A shared model in the middle limits the blast radius to one mapping per source.
Personal data adds legal pressure. GDPR Article 5 requires personal data to be accurate and, where necessary, kept up to date, and the controller must be able to demonstrate compliance. A 360 view that copies personal data into many tools without lineage makes both harder.
How does a single source of truth help AI agents?
Agents need the same IDs and definitions people need, and they are less forgiving. An agent asked for an account's open tickets must know which subsidiaries belong to the account. If the hierarchy is flat or the ID is unstable, the agent returns a confident but partial answer.
Research on text-to-SQL shows the effect of explicit meaning. A 2026 study found that adding explicit business semantics raised accuracy by 17 to 23 points across three frontier models. Resolved customer IDs and typed hierarchies are part of that semantic context. The ontology and AI analytics guide shows how a model gives agents that grounding.
Who should own the customer model?
Your company should own it. Customer definitions, match rules, hierarchies, and survivorship logic are institutional knowledge that took years to agree on. Keep them in open, exportable formats on infrastructure you control, so a vendor change does not erase that agreement.
Inside the company, give definitions to a business owner and IDs to the data platform team. Galaxy works with teams to build this kind of semantic foundation and entity resolution on the stack they already run, using internal tooling. It builds in the open with Filament and plans to open source more of that tooling.
Frequently asked questions
What is a single source of truth for customer data?
It is the agreed authority for who your customers are and what the business means by customer. In practice it combines shared definitions, a resolved customer ID, survivorship rules, and lineage. It is an operating model with an owner and rules, not one database table. Many systems can keep their own copies as long as they reference the same ID and definitions.
What is the difference between a golden record and a 360 customer view?
A golden record is the reconciled version of one entity, such as one company or one person, after matching and survivorship. A 360 customer view is the wider picture built around that record, adding contracts, orders, tickets, usage, and relationships from many systems. The golden record answers who the customer is. The 360 view answers what the business knows about them.
Should a CDP or an MDM platform own the customer golden record?
A CDP fits when the main consumers are marketing and personalization and the customer is mostly a person. MDM fits when finance, sales, and compliance need approved records with stewardship and write-back to CRM and ERP. Many enterprises run both, with MDM or a warehouse matcher issuing the ID and the CDP consuming it for activation.
Can the warehouse be the single source of truth for customers?
Yes, and this pattern has grown. Hightouch documents deterministic identity resolution that runs in the customer's warehouse and writes a golden record table there. The warehouse then feeds BI, AI workloads, and operational tools through reverse ETL. The gap is stewardship, since warehouse pipelines rarely include approval queues for disputed merges, so plan for that separately.
How do you handle parent and subsidiary relationships in customer 360?
Model hierarchies as typed relationships instead of a single parent column. Keep legal, commercial, billing, and service hierarchies apart, because each team rolls up differently. External identifiers help anchor the legal tree. GLEIF Level 2 data records direct and ultimate accounting parents, and D-U-N-S linkage records global and domestic ultimates for companies that have those identifiers.
What should a customer golden record contain?
At minimum a stable resolved ID, the source IDs it was built from, legal and trade names, domains, tax or registry identifiers, and typed hierarchy links. Each surviving attribute should carry its source, timestamp, and the rule that picked it. Without that provenance, nobody can explain a value to an auditor, a sales leader, or an AI agent.
Why do customer 360 projects fail?
Most fail because teams unify records without agreeing what a customer is. Sales, finance, and support each keep local definitions, so the merged view gets reinterpreted downstream. Other common causes include one-time matching that drifts, flattened hierarchies, missing lineage, and no named owner for disputed merges. The technology is rarely the main reason a program stalls.
How should match rules differ by use case?
Set thresholds by the cost of a wrong merge. Finance, credit, and compliance use cases should match conservatively and send borderline pairs to stewards. Marketing audiences can tolerate looser matching because a false merge costs less. Running one threshold for every consumer usually means someone is either overmerged or undermerged, so many teams publish different confidence tiers.
Does GDPR affect a customer 360 program?
Yes, for personal data about people. GDPR Article 5 requires personal data to be accurate and kept up to date, and Article 5(2) makes the controller responsible for demonstrating compliance. A 360 view that copies personal data everywhere without lineage makes both duties harder. Attribute-level provenance and a clear system of record for corrections help.
How do you measure whether the single source of truth is working?
Track duplicate rate within each source, the share of records linked to a resolved ID, the false merge rate from steward reviews, hierarchy coverage for top accounts, and attribute freshness. Pair those with a business check, such as whether sales and finance now report the same revenue for the same account. If those numbers disagree, the foundation is not trusted yet.
More articles
Questions
Answered
FAQ
What does Galaxy do?
What is Filament?
What is enterprise context management?
What does working with Galaxy look like?
How do you handle security and compliance?
Why does Galaxy build in the open?
Company
Copyright ยฉ 2026 Galaxy. All rights reserved.