pattern // dataPRODUCTION

Golden Record Inside SFMC — Constrained Architecture

A pragmatic consolidation layer inside SFMC when enterprise CRM/MDM capabilities are unavailable.

Context Pack →Open Workspace →
Trust & provenancePRODUCTION
Evidence tierPRODUCTIONOfficial sources0Other sources0Last verifiedNot recorded

Evidence tier describes my hands-on relationship with the content. Official sources describe platform contracts/documentation. Production observations should not automatically be treated as official limits.

Problem

Multiple brands/sources can create overlapping identities, inconsistent keys, permission ambiguity and duplicated customer records.

Approach

Define a canonical identity rule, source precedence, permission model, engagement facts and repeatable consolidation queries/DEs. Document that this is an application-level workaround, not enterprise MDM.

Tradeoffs

SFMC is not an MDM platform

Identity resolution logic becomes custom code/queries

Governance and lineage must be explicit