You are here:
Data Quality Calculated Insight: Contact Points Per Individual
Review the number of contact points for each source record to find outliers. Outliers can help you identify issues with your source data or data mappings. Use this calculated insight after data ingestion, but before creating an identity resolution ruleset.
DQ Source - Individual - CP Summary
Tip Modify the SQL in the example based on your data mappings.
SELECT
ssot__Individual__dlm.ssot__Id__c AS Individual_Id__c,
APPROX_COUNT_DISTINCT( ssot__ContactPointEmail__dlm.ssot__Id__c ) AS unq_Email_CPs__c,
APPROX_COUNT_DISTINCT( ssot__ContactPointPhone__dlm.ssot__Id__c ) AS unq_Phone_CPs__c,
APPROX_COUNT_DISTINCT( ssot__ContactPointAddress__dlm.ssot__Id__c ) AS unq_Address_CPs__c,
APPROX_COUNT_DISTINCT( ssot__PartyIdentification__dlm.ssot__Id__c ) AS unq_Party_Identifiers__c,
APPROX_COUNT_DISTINCT( ssot__Device__dlm.ssot__Id__c ) AS unq_Devices__c
FROM ssot__Individual__dlm
LEFT JOIN ssot__ContactPointEmail__dlm ON ssot__ContactPointEmail__dlm.ssot__PartyId__c = ssot__Individual__dlm.ssot__Id__c
LEFT JOIN ssot__ContactPointPhone__dlm ON ssot__ContactPointPhone__dlm.ssot__PartyId__c = ssot__Individual__dlm.ssot__Id__c
LEFT JOIN ssot__ContactPointAddress__dlm ON ssot__ContactPointAddress__dlm.ssot__PartyId__c = ssot__Individual__dlm.ssot__Id__c
LEFT JOIN ssot__PartyIdentification__dlm ON ssot__PartyIdentification__dlm.ssot__PartyId__c = ssot__Individual__dlm.ssot__Id__c
LEFT JOIN ssot__ContactPointApp__dlm ON ssot__ContactPointApp__dlm.ssot__PartyId__c = ssot__Individual__dlm.ssot__Id__c
LEFT JOIN ssot__Device__dlm ON ssot__Device__dlm.ssot__Id__c = ssot__ContactPointApp__dlm.ssot__DeviceId__c
GROUP BY
Individual_Id__c
Did this article solve your issue?
Let us know so we can improve!
