Review the number of matched contact points for each unified profile. A high number of matches per contact point, like profiles with hundreds of source records matched with the same email address, could indicate issues with data quality or source data. Use this calculated insight after creating unified profiles with an identity resolution ruleset.
Tip
- Use this calculated insight for multiple rulesets by creating a calculated insight for each Unified Data Model Object (DMO).
- To search for outlier profiles in Profile Explorer, use the Unified_Individual_Id from the calculated insight.
- Consider removing repeat values from your source data and ingesting data into Data 360 again.
- Consider filtering out repeat values using a formula field in Data Streams.
Unified Individual - CP Summary
Tip Modify the SQL in the example based on your data mappings.
SELECT
UnifiedIndividual__dlm.ssot__Id__c AS Unified_Individual_Id__c,
APPROX_COUNT_DISTINCT(IndividualIdentityLink__dlm.SourceRecordId__c) AS cnt_Lineage__c,
APPROX_COUNT_DISTINCT(ssot__Individual__dlm.ssot__FirstName__c) AS unq_FirstNames__c,
APPROX_COUNT_DISTINCT(UnifiedContactPointPhone__dlm.ssot__Id__c) AS unq_PhoneCPs__c,
APPROX_COUNT_DISTINCT(UnifiedContactPointEmail__dlm.ssot__Id__c) AS unq_EmailCPs__c,
APPROX_COUNT_DISTINCT(UnifiedContactPointAddress__dlm.ssot__Id__c) AS unq_AddressCPs__c,
APPROX_COUNT_DISTINCT(ssot__PartyIdentification__dlm.ssot__Id__c) AS unq_PartyIdentifiers__c
FROM UnifiedIndividual__dlm
LEFT JOIN IndividualIdentityLink__dlm ON IndividualIdentityLink__dlm.UnifiedRecordId__c = UnifiedIndividual__dlm.ssot__Id__c
LEFT JOIN UnifiedContactPointPhone__dlm ON UnifiedContactPointPhone__dlm.ssot__PartyId__c = UnifiedIndividual__dlm.ssot__Id__c
LEFT JOIN UnifiedContactPointEmail__dlm ON UnifiedContactPointEmail__dlm.ssot__PartyId__c = UnifiedIndividual__dlm.ssot__Id__c
LEFT JOIN UnifiedContactPointAddress__dlm ON UnifiedContactPointAddress__dlm.ssot__PartyId__c = UnifiedIndividual__dlm.ssot__Id__c
LEFT JOIN ssot__PartyIdentification__dlm ON ssot__PartyIdentification__dlm.ssot__PartyId__c = UnifiedIndividual__dlm.ssot__Id__c
LEFT JOIN ssot__Individual__dlm ON ssot__Individual__dlm.ssot__Id__c = IndividualIdentityLink__dlm.SourceRecordId__c
GROUP BY
Unified_Individual_Id__c