Loading
Ongoing maintenance for Salesforce HelpRead More
About Salesforce Data 360
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Identity Resolution Calculated Insight: Consolidation Rates for Unified Profiles

            You are here:

            1. Salesforce Help
            2. Docs
            3. Data 360

            Identity Resolution Calculated Insight: Consolidation Rates for Unified Profiles

            Review the consolidation rate of matched profiles for each data source. Data sources with duplicate profiles are expected to have higher consolidation rates than data sources with many unique profiles. Use this calculated insight after creating unified profiles with an identity resolution ruleset.

            Tip
            Tip An unexpectedly high consolidation rate could be a sign of data source quality issues.
            Identity Resolution - Summary by Source
            Identity Resolution - Summary by Source
            Tip
            Tip Modify the SQL in the example based on your data mappings. 
            SELECT
 IndividualIdentityLink__dlm.ssot__DataSourceId__c as DataSourceId__c,
 IndividualIdentityLink__dlm.ssot__DataSourceObjectId__c as DataSourceObjectId__c,
 APPROX_COUNT_DISTINCT(IndividualIdentityLink__dlm.UnifiedRecordId__c) AS unq_Unified_Individuals__c,
 COUNT(IndividualIdentityLink__dlm.SourceRecordId__c) AS cnt_Source_Records__c,
 (1 - APPROX_COUNT_DISTINCT(IndividualIdentityLink__dlm.UnifiedRecordId__c)/COUNT(IndividualIdentityLink__dlm.SourceRecordId__c))*100 as per_consolidation_rate__c
FROM IndividualIdentityLink__dlm
GROUP BY 
 DataSourceId__c,
 DataSourceObjectId__c
             
            Loading
            Salesforce Help | Article