Data Identity Resolution is the process of matching and merging records from multiple data sources to create a unified and accurate customer profile. It is a cornerstone of Salesforce Data Cloud, enabling the creation of Customer 360 Profiles by eliminating redundancies and resolving data conflicts.
Below are the steps/details that can be followed to consolidate and transform data from different sources into comprehensive view of customer and accounts.
1. Collect and Map Data
- Ingest data from diverse systems, such as CRMs, marketing platforms, e-commerce sites, and external vendors.
- Use Data Mapper to align source fields (e.g., name, email, phone) with the Customer 360 Data Model.
- Ensure that unique identifiers, such as email addresses, customer IDs, or phone numbers, are included for accurate matching.
- Tools Used: Data Mapper, ETL tools (e.g., MuleSoft, Informatica).
- Key Point: Establish clear mapping rules to avoid mismatches and missed connections.
2. Define Matching Rules
- Configure deterministic (exact match) and probabilistic (fuzzy match) rules to identify records referring to the same individual
- Combine rules for multi-criteria matching, such as email + phone number or name + city.
- Tools Used: Salesforce Identity Resolution Engine, rule-based algorithms.
- Key Point: Balance rule strictness to avoid false positives (wrong merges) or false negatives (missed matches).
3. Match and Link Records
- Execute the matching process across ingested data by comparing records using defined rules.
- Merge matched records into a single profile while retaining distinct attributes as needed.
- Tools Used: Identity Resolution Engine, Data Lake Objects (DLOs).
- Key Point: Always retain original data for auditability and future improvements to matching logic.
4. Handle Conflicts and Data Variations
- Resolve inconsistencies in matched records by Conflict Resolution Rules: Define priorities for conflicting data (e.g., prefer the most recent or trusted source) and Standardization: Normalize fields (e.g., format phone numbers or addresses) to reduce ambiguity.
- Maintain an audit trail of changes for transparency.
- Tools Used: Apex logic for conflict resolution, custom transformation scripts.
- Key Point: Use automated workflows to minimize manual intervention while ensuring accuracy.
5. Enrich Unified Profiles
- Add missing data or enhance profiles with external data sources
- Use calculated insights to derive metrics such as engagement scores or customer lifetime value.
- Tools Used: Salesforce Einstein Analytics, third-party enrichment providers.
- Key Point: Ensure enriched data aligns with privacy regulations like GDPR or CCPA.
6. Validate and Monitor Identity Resolution
- Perform quality checks to verify the accuracy and completeness of resolved profiles by validating confidence scores for probabilistic matches and validating merged records for anomalies.
- Use monitoring tools to track the resolution process and identify issues such as unmatched records or duplicate profiles.
- Tools Used: Data Monitoring Dashboard, validation scripts.
- Key Point: Implement logging and reporting mechanisms to improve future resolution efforts.
7. Store and Leverage Resolved Profiles
- Save unified profiles in the Customer 360 Data Model, making them accessible across Salesforce applications.
- Enable downstream processes like personalized marketing, automation, and analytics to leverage the unified data.
- Tools Used: Customer 360 Data Model, Salesforce Marketing Cloud, Tableau.
- Key Point: Optimize storage and access to support scalability and real-time use cases.
Creating a unified customer identity by integrating data from different systems is a crucial step in ensuring data accuracy and enhancing customer relationship management. This process not only helps in identifying and merging duplicate records but also ensures that the most reliable data is used to enable personalized experiences, enhances decision-making, and driving business success.
