Study guide

9.2 Unified Profile Schema (Individual & Contact Points) & Resolution Troubleshooting

Salesforce Certified Data 360 Consultant formerly Data Cloud Consultant

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Solution Overview & Enterprise Value

1.1 Enterprise Customer 360 & Data Cloud Business Value 1.2 Architectural Foundation: Zero-Copy, Hyperforce, Lakehouse & Data Pipeline 1.3 Platform Terminology, Core Entities & Data Lifecycle Stages 1.4 Data 360's Foundational Role in Predictive & Generative AI

2 Chapter 2: Ethics, Privacy & Governance Fundamentals

2.1 Regulatory Compliance, Data Privacy & Ethics in Customer Data 2.2 Consent Management & Preference Enforcement in Data Cloud 2.3 Data Retention, Deletion, and Privacy Right-to-be-Forgotten (RTBF)

3 Chapter 3: Security, Permissions & Tenant Architecture

3.1 Standard Permission Sets, User Roles & Functional Access 3.2 Data Spaces Architecture, Resource Allocation & Tenant Isolation

4 Chapter 4: Administration, Monitoring & Lifecycle Management

4.1 Data Kits & Package Automation for Cross-Org Deployment 4.2 Auditing, Status Monitoring, Error Logs & Data Explorer 4.3 Sandboxes, Change Management & Metadata Deployment

5 Chapter 5: Ingestion Connectors & Source Integration

5.1 Standard Bundles & Salesforce CRM Connectors (Sales/Service/Marketing) 5.2 Cloud Storage (S3, GCS, Azure Blob) & Streaming Ingestion (Web/Mobile SDK, Ingestion API) 5.3 Zero-Copy Data Federation & Snowflake/BigQuery/Databricks Sharing

6 Chapter 6: Data Lake Objects (DLO) & Data Transformations

6.1 DLO Configuration, Primary Keys, Event Time & Data Stream Categories (Profile, Engagement, Other) 6.2 Streaming & Batch Data Transforms: Formula Fields, SQL Transforms & Data Prep Recipes

7 Chapter 7: Data Model Objects (DMO) & Canonical Harmonization

7.1 Customer 360 Canonical Data Model & Subject Areas 7.2 DLO-to-DMO Mapping Patterns, Cardinality & Custom DMO Design 7.3 Data Validation, Schema Maintenance & Field Mapping Best Practices

8 Chapter 8: Identity Resolution Architecture & Match Rules

8.1 Identity Resolution Concepts, Consolidation Rate & Graph Modeling 8.2 Match Rules & Match Criteria: Exact Match vs. Fuzzy Matching (Deterministic & Probabilistic) 8.3 Multi-Party Identification, Anonymous-to-Known Transitions & Contact Point Matching

9 Chapter 9: Reconciliation Rules & Unified Profile Governance

9.1 Reconciliation Rules: Most Frequent, Source Priority & Last Updated 9.2 Unified Profile Schema (Individual & Contact Points) & Resolution Troubleshooting

10 Chapter 10: Segment Architecture & Audience Design

10.1 Segmentation Canvas, Segment Types (Standard UI & Flow) & Query Processing 10.2 Direct vs. Related Attributes, Cardinality & 1:N Filtering Traps 10.3 Segment Schedule, Refresh Frequencies & Exclusion Logic 10.4 Segment Membership Analysis, Population Drift & Sizing Validation

11 Chapter 11: Calculated & Streaming Insights

11.1 Calculated Insights (CI) Architecture, SQL/Builder Syntax & Dimensions vs. Metrics 11.2 Streaming Insights (SI) Architecture, Windowing (Tumbling/Sliding) & Real-Time Signals 11.3 CI vs. SI Architectural Decision Matrix & Performance Optimization

12 Chapter 12: Data Enhancements, Sharing & Analysis

12.1 Referencing Data 360 Data from Other Systems: Enrichments, Related Lists, Data Graphs & APIs 12.2 Reports, Dashboards & Tableau Analysis on Data 360 Data 12.3 Applying Predictive & Generative AI Tooling to Customer Scenarios

13 Chapter 13: Activation Targets & Outbound Activation

13.1 Activation Targets: Marketing Cloud, External Platforms, Cloud Storage & Data Spaces 13.2 Activation Configuration: Audience Mapping, Related Attributes & Payload Optimization 13.3 Activation Schedules, Publishing Cadence & Incremental vs. Full Refresh 13.4 Activation Troubleshooting: Error Logs, Rejection Reasons & Delivery Failures

14 Chapter 14: Real-Time Data Actions & Flow Automation

14.1 Data Action Targets & Webhook/Platform Event Architecture 14.2 Data Cloud-Triggered Flows & Real-Time Business Orchestration 14.3 End-to-End Enterprise Scenario Walkthrough: Ingestion to Closed-Loop Action

9.2 Unified Profile Schema (Individual & Contact Points) & Resolution Troubleshooting

Key Takeaways Explain This Topic AI

Identity Resolution rulesets automatically generate a dedicated system schema of Unified Data Model Objects (suffixed with __dlm), including UnifiedIndividual__dlm, unified contact point objects (Email, Phone, Address), and bridge objects like UnifiedLinkIndividual__dlm.

The UnifiedLinkIndividual__dlm bridge table maintains the relational mapping between every source record identifier (SourceRecordId__c) and its resolved cluster identifier (UnifiedRecordId__c), enabling downstream segmentation, Calculated Insights, and activation targets to traverse from source transactions to unified profiles.

Unlike UnifiedIndividual__dlm which flattens profile attributes into a single row per cluster, Unified Contact Points preserve a 1:N relational structure, retaining multiple distinct, deduplicated emails, phones, and addresses for a single unified individual.

Identity Resolution recalculates identity clusters via connected-component graph processing during batch runs; new incoming data can bridge previously distinct clusters (cluster merging), while updated or deleted records can sever links and divide clusters (cluster splitting).

Runaway over-grouping occurs when shared, dummy, or placeholder contact data (e.g., test@example.com , 999-999-9999) transitively merges thousands of distinct individuals into a giant super-cluster; consultants resolve this upstream by using Ingestion Formulas to set placeholder values to NULL, which the matching engine strictly ignores.

Last updated: September 2026

Unified Profile Schema (Individual & Contact Points) & Resolution Troubleshooting

When an Identity Resolution ruleset is deployed in Salesforce Data Cloud, the platform synthesizes a comprehensive semantic schema known as the Unified Profile Layer . This layer sits above the harmonized Data Model Objects (DMOs) and contains the consolidated representations of individuals, their contact points, and the relational bridges that trace data lineage back to source systems.

Designing, querying, and maintaining this unified layer requires a certified consultant to master the underlying schema architecture, understand how graph re-clustering behaves when source data changes, diagnose identity resolution anomalies, and implement upstream data hygiene governance to prevent catastrophic data corruption.

Architecture of Unified Data Model Objects (Unified DMOs)

Deploying an Identity Resolution ruleset automatically generates a specialized family of system-managed Data Model Objects. These objects are designated with the standard Data Cloud physical object suffix __dlm (Data Lake Model / Data Model Object) and prefixed with Unified . ┌─────────────────────────────────────────────────────────────────────────┐

  • │ HARMONIZED CANONICAL DMOs │
  • │ Individual__dlm, ContactPointEmail__dlm, ContactPointPhone__dlm │
  • └────────────────────────────────────┬────────────────────────────────────┘
  • │ Identity Resolution Ruleset Execution
  • ▼
  • ┌─────────────────────────────────────────────────────────────────────────┐
  • │ THE UNIFIED DMO SCHEMA │
  • │ │
  • │ ┌───────────────────────────────────────────────────────────────────┐ │
  • │ │ UnifiedIndividual__dlm (1:1 Master Profile) │ │
  • │ │ - UnifiedRecordId__c (Primary Key / Cluster GUID) │ │
  • │ │ - Reconciled Attributes: FirstName, LastName, BirthDate, etc. │ │
  • │ └──────────────────┬─────────────────────────────┬──────────────────┘ │
  • │ │ 1:N │ 1:N │
  • │ ▼ ▼ │
  • │ ┌─────────────────────────────────────┐ ┌──────────────────────────┐ │
  • │ │ UnifiedContactPointEmail__dlm │ │ UnifiedLinkIndividual │ │
  • │ │ - Multiple deduplicated emails │ │ - SourceRecordId__c │ │
  • │ │ - UnifiedRecordId__c (Foreign Key) │ │ - UnifiedRecordId__c │ │
  • │ └─────────────────────────────────────┘ └──────────────────────────┘ │
  • └─────────────────────────────────────────────────────────────────────────┘
  • The Core Unified Entities

UnifiedIndividual__dlm :

Cardinality : Exactly one record per identity cluster (1:1).

Primary Key : UnifiedRecordId__c (a globally unique, system-generated identifier representing the cluster).

Content : Contains the single surviving attribute value for each field mapped from the source Individual__dlm , as dictated by the configured reconciliation rules (e.g., single surviving FirstName , LastName , BillingCity ).

Unified Contact Points ( UnifiedContactPointEmail__dlm , UnifiedContactPointPhone__dlm , UnifiedContactPointAddress__dlm ) :

Cardinality : One-to-many (1:N) relative to UnifiedIndividual__dlm .

Crucial Architectural Concept : While UnifiedIndividual flattens profile attributes into a single row, Unified Contact Points are NOT flattened into a single value . A customer legitimately possesses multiple email addresses (personal, work, school) and multiple phone numbers.

Contact Point Deduplication : Within an identity cluster, Data Cloud deduplicates identical contact point values. If Source Record A and Source Record B both contain sarah.smith@example.com , only a single row for sarah.smith@example.com is written to UnifiedContactPointEmail__dlm . However, if Record A has sarah@work.com and Record B has sarah@personal.com , both distinct rows are preserved under the same UnifiedRecordId__c .

UnifiedLinkIndividual__dlm (and UnifiedLinkContactPoint bridge objects) :

Cardinality : Many-to-one (N:1) mapping from source records to unified records.

Role : The indispensable lineage bridge table connecting source record identifiers to the unified identity cluster.

Comparison: Unified Individual vs. Unified Contact Points

  • Schema Dimension UnifiedIndividual__dlm UnifiedContactPoint*__dlm
  • Relational Cardinality 1:1 per resolved identity cluster 1:N per resolved identity cluster

Attribute Resolution Flattens conflicts via Reconciliation Rules Deduplicates identical values; retains distinct values

  • Record Count Equal to the number of resolved clusters Proportional to the number of distinct contact points
  • Primary Identifier UnifiedRecordId__c System-generated Contact Point ID
  • Foreign Key Anchor N/A (Root entity) UnifiedRecordId__c links to Unified Individual

Activation Role Powers direct profile attributes in payloads Powers addressable endpoints (email recipients, SMS targets)

The UnifiedLink Bridge Object: Architecture and Relational Traversal

The UnifiedLinkIndividual__dlm object is the architectural backbone of Data Cloud's Customer 360 data model. Without this bridge, downstream services would be unable to connect operational transactions (orders, website clicks, service cases) to unified customer profiles.

Schema Anatomy of UnifiedLinkIndividual__dlm

Field API Name Data Type Operational Purpose

UnifiedRecordId__c Text / ID The unique identifier of the resolved cluster in UnifiedIndividual__dlm .

SourceRecordId__c Text / ID The native primary key of the contributing record from the source Individual__dlm (e.g., SFDC_CRM_0035000000abcdeAAA ).

SourceRecordType__c Text Identifies the source DMO entity type (typically Individual ).

CreatedDate DateTime Timestamp when the linkage was formed by the Identity Resolution engine.

How Queries and Downstream Engines Traverse the Bridge

Operational data streams (such as e-commerce orders, loyalty transactions, or email clicks) are ingested and mapped to Engagement DMOs (e.g., SalesOrder__dlm ). These engagement records link to the source Individual__dlm via foreign keys like IndividualId__c .

When a marketer builds a segment or a data engineer writes a Calculated Insight on UnifiedIndividual , Data Cloud automatically leverages UnifiedLinkIndividual__dlm to execute the necessary underlying joins behind the scenes: /* Logical query path executed internally by Data Cloud */

  • SELECT
  • u.UnifiedRecordId__c,
  • u.FirstName__c,
  • u.LastName__c,
  • SUM(o.OrderTotalAmount__c) AS UnifiedLifetimeSpend
  • FROM UnifiedIndividual__dlm u
  • JOIN UnifiedLinkIndividual__dlm link
  • ON u.UnifiedRecordId__c = link.UnifiedRecordId__c
  • JOIN Individual__dlm ind
  • ON link.SourceRecordId__c = ind.Id__c
  • JOIN SalesOrder__dlm o
  • ON ind.Id__c = o.SoldToCustomerId__c
  • GROUP BY u.UnifiedRecordId__c, u.FirstName__c, u.LastName__c
  • Activation Traversal

When activating a segment to an external activation target (e.g., Meta Ads, Google Customer Match, Amazon S3, or Salesforce Core CRM):

The segment audience is evaluated at the UnifiedIndividual level.

When the activation payload is compiled, the activation engine traverses UnifiedLinkIndividual__dlm to retrieve the original source CRM Contact IDs or Marketing Cloud Subscriber Keys required by the downstream destination.

Identity Resolution Lifecycle & Re-Clustering Dynamics

Identity Resolution in Data Cloud does not execute synchronously on record creation. Instead, it operates as an asynchronous batch calculation engine scheduled to run at regular intervals (typically once every 24 hours, or triggered manually via the UI/API).

Connected-Component Graph Modeling

Data Cloud represents customer identity as an undirected graph :

Nodes : Source individual records and contact point records.

Edges : Matches established between records by configured Match Rules.

Clusters : The connected components of the graph. Any group of nodes connected directly or indirectly by edges constitutes a single Unified Individual profile. SCENARIO A: STABLE SEPARATE CLUSTERS

  • Cluster 1: [CRM Contact A] ──(Phone Match)── [POS Customer B] ==> Unified Profile 1
  • Cluster 2: [Web User C] ──(Email Match)── [Marketing Sub D] ==> Unified Profile 2
  • SCENARIO B: CLUSTER MERGING (Inbound Record E arrives with CRM A's Phone and Web C's Email)
  • [CRM Contact A] ──────(Phone Match)────── [Record E]
  • │ │ (Email Match)
  • [POS Customer B] [Web User C] ───(Email)─── [Marketing Sub D]

==> All 5 records now form ONE connected component: Unified Profile 1 & 2 MERGE into Unified Profile 3!

Profile Re-Clustering: Merging vs. Splitting

Because Identity Resolution recalculates the global connected components on each execution cycle, customer profiles are dynamic:

Cluster Merging (Transitive Linkage) :

Occurs when a new or updated record introduces an edge connecting two previously disjoint clusters.

In the diagram above, Record E matches both Cluster 1 (via phone) and Cluster 2 (via email). On the next ruleset run, Cluster 1 and Cluster 2 collapse into a single unified profile.

Cluster Splitting :

Occurs when an existing record is deleted, or when an attribute (such as an email or phone number) is modified in a source system, severing the bridging edge.

If the severed edge was the sole path connecting two sub-graphs, the unified profile splits into two distinct Unified Individual profiles on the next ruleset run.

Caution

Dynamic Unified IDs Because clusters can merge and split over time, UnifiedRecordId__c values are system-generated and dynamic . If two clusters merge, one of the original UnifiedRecordIds will be retired and a master UnifiedRecordId will represent the merged cluster. Enterprise applications should never treat UnifiedRecordId as an immutable external identifier; external integrations should always rely on source system keys resolved through UnifiedLinkIndividual__dlm .

Loading diagram... Unified DMO Schema Architecture, UnifiedLink Bridge, and Downstream Consumption

Diagnosing and Troubleshooting Identity Resolution Issues

When managing enterprise customer data, Identity Resolution rulesets can produce unexpected outcomes. A certified consultant must be proficient in inspecting ruleset run history, interpreting diagnostic metrics, identifying root causes, and implementing remediation protocols.

The Consolidation Rate Metric

The primary health metric for Identity Resolution is the Consolidation Rate . It quantifies the degree to which source records have been merged into unified profiles: Consolidation Rate = 1 − ( Total Unified Records / Total Source Records ) = ( Total Source Records − Total Unified Records ) / Total Source Records \text{Consolidation Rate} = 1 - (\text{Total Unified Records} / \text{Total Source Records}) = (\text{Total Source Records} - \text{Total Unified Records}) / \text{Total Source Records} Consolidation Rate = 1 − ( Total Unified Records / Total Source Records ) = ( Total Source Records − Total Unified Records ) / Total Source Records

Interpretation :

If 1,000,000 source records produce 750,000 unified profiles: Consolidation Rate = 1 - (750,000 / 1,000,000) = 25%.

In typical enterprise B2C environments with multi-channel touchpoints (CRM, E-Commerce, POS, Mobile), a healthy consolidation rate generally ranges between 10% and 35% .

Anomaly Detection: Metric Shift Signatures

Diagnostic Metric Shift Underlying Condition Root Cause Analysis

Sudden, Massive Spike in Consolidation Rate (e.g., jumps from 20% to 75% overnight) Runaway Clustering / Over-Grouping Shared dummy contact data (e.g., test@example.com , 999-999-9999 ) or overly loose fuzzy match rules transitively merged thousands of distinct customers into a single super-cluster.

Sudden Drop in Consolidation Rate (e.g., drops from 25% to 2% overnight) Under-Grouping / Fragmentation A data pipeline failure caused contact point fields to ingest as null, an unmapped source field broke match rule evaluation, or formatting changes prevented exact string matching.

Explosion in Match Pair Count (e.g., match pairs exceed source records by 10x) Combinatorial Explosion A high-cardinality placeholder value (e.g., a default store phone number) matched thousands of records together, generating millions of pairwise graph permutations (N * (N-1) / 2).

Gradual Upward Consolidation Drift Normal Business Convergence Customers naturally interact across more digital channels over time, gradually providing overlapping identifiers that link accounts.

The Over-Grouping Catastrophe: Root Causes & The Snowball Effect

Over-grouping (also known as runaway merging or catastrophic clustering) is the most dangerous failure mode in Identity Resolution. If 50,000 distinct consumers are merged into a single unified profile, sensitive transactional histories are commingled, segmentation criteria become corrupted, and privacy compliance (GDPR/CCPA) is compromised.

The Four Culprits of Over-Grouping

Placeholder & Dummy Email Addresses :

Cashiers or web users entering placeholder emails when a real email is optional or unknown: test@test.com , guest@store.com , noemail@domain.com , customer@retailer.com , admin@company.com .

Because Identity Resolution applies deterministic exact matching on normalized email, every customer who ever checked out with test@test.com is linked into the same cluster.

Default & Shared Phone Numbers :

In-store POS terminals where cashiers input the retail store's own phone number ( 555-1212 ) or generic dummy strings ( 999-999-9999 , 123-456-7890 , 000-000-0000 ) to bypass mandatory checkout prompts.

Household Sharing (Spousal / Family Aliases) :

Spouses or family members sharing a single home landline or a joint email address ( smithfamily@gmail.com ). If a match rule links on email alone without validating first name, separate human beings are collapsed into one profile.

Overly Permissive Fuzzy Match Rules :

Configuring fuzzy matching on First Name and Last Name combined with broad geographic criteria (e.g., Matching on City and State without Street Address or Postal Code), causing common names (e.g., "John Smith in Chicago") to collapse hundreds of distinct individuals.

The Snowball Effect (Transitive Graph Poisoning)

Over-grouping rarely remains isolated to the dummy record itself. It cascades exponentially through the graph: 1. Customer 1 (Alice) enters test@example.com and Alice's real Mobile Phone (555-0001).

2. Customer 2 (Bob) enters test@example.com and Bob's real Home Phone (555-0002).

──► Alice and Bob MERGE into Cluster A via test@example.com.

3. Customer 3 (Charlie) shares a Home Phone with Bob (555-0002) and enters Charlie's real Email.

──► Charlie MERGES into Cluster A via Home Phone (555-0002).

4. Customer 4 (David) shares David's real Email with Charlie...

──► THE ENTIRE DATABASE MERGES TRANSITIVELY INTO A SINGLE SUPER-CLUSTER!

Enterprise Upstream Data Hygiene & Consultant Governance

The fundamental architectural principle for Data Cloud identity management is:

Important

The Golden Rule of Identity Resolution Cleanse and nullify dummy data UPSTREAM during ingestion. Never attempt to fix dirty data using loose reconciliation rules or downstream segment filters. Once a dummy record creates a graph edge in Identity Resolution, the damage is already done.

1. Ingestion Formula Nullification: The Primary Defense

In Salesforce Data Cloud, the Identity Resolution matching engine strictly ignores NULL values . A null value in Record A will never match with a null value in Record B.

Consultants should implement Ingestion Formula Fields directly on incoming Data Streams to detect known dummy, placeholder, or invalid strings and convert them to NULL before they land in the Data Lake Object (DLO): /* Ingestion Formula: Cleansing Email on Web Ingestion Data Stream */

  • IF(
  • LOWER(TRIM(source.RawEmail__c)) IN (
  • 'test@test.com',
  • 'test@example.com',
  • 'none@none.com',
  • 'guest@retailer.com',
  • 'noemail@domain.com',
  • 'admin@admin.com'
  • )
  • OR source.RawEmail__c LIKE '%@example.com'
  • OR NOT(source.RawEmail__c LIKE '%@%.%'),
  • NULL,
  • LOWER(TRIM(source.RawEmail__c))
  • ) /* Ingestion Formula: Cleansing Phone Numbers on POS Data Stream */
  • IF(
  • SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(source.RawPhone__c, '(', ''), ')', ''), '-', ''), ' ', '') IN (
  • '0000000000',
  • '9999999999',
  • '1234567890',
  • '5555555555'
  • ),
  • NULL,
  • SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(source.RawPhone__c, '(', ''), ')', ''), '-', ''), ' ', '')
  • )
  • 2. Compound Match Rule Architecture for Household Disambiguation

To prevent spouses or household members sharing contact points from accidentally merging, consultants must configure compound match rules rather than single-attribute rules:

Weak Rule (Causes Over-Grouping) : Exact Normalized Email alone.

Robust Compound Rule : Exact Normalized Email AND Fuzzy First Name (High Precision) .

Phone Disambiguation Rule : Exact E.164 Phone AND Exact Normalized Last Name .

3. Pre-Production Governance & Testing Protocol

Before deploying rulesets to production, consultants must follow a structured validation methodology:

Sandbox / Data Space Testing : Test rulesets in an isolated non-production Data Space using a representative data sample.

Run History Inspection : Execute the ruleset and inspect the Consolidation Rate, Unified Record count, and Match Pair count.

Match Pair Outlier Analysis : If any single cluster contains an abnormal number of records (e.g., > 20 records in a B2C model), immediately inspect the contributing source records to identify the shared bridging attribute.

Audit Drift Monitoring : Establish ongoing governance by logging weekly consolidation rates to catch new dummy data patterns before they infect downstream activations.