Loading
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: Outlier Unified Profiles

            You are here:

            1. Salesforce Help
            2. Docs
            3. Data 360

            Identity Resolution Calculated Insight: Outlier Unified Profiles

            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
            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
            Unified Individual - CP Summary
            Tip
            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
             
            Loading
            Salesforce Help | Article