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 An unexpectedly high consolidation rate could be a sign of data source quality
issues.
Identity Resolution - Summary by Source
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