You are here:
Data Quality Calculated Insight: Summary by Source
Review the number of unique contact points per data source. The number of unique contact points is the number of source records consolidated in identity resolution. Use this calculated insight after data ingestion, but before creating an identity resolution ruleset.
Tip
- If you’re matching on the Device DMO and Advertiser Id field add additional JOINS to the Contact Point App object to your calculated insight.
- If any contact point columns return 0, review your mappings to the Individual DMO for the data source in Data Streams.
DQ Source - Summary by Source
Tip Modify the SQL in the example based on your data mappings.
SELECT
ssot__Individual__dlm.ssot__DataSourceId__c AS DataSourceId__c,
ssot__Individual__dlm.ssot__DataSourceObjectId__c AS DataSourceObjectId__c,
APPROX_COUNT_DISTINCT(ssot__Individual__dlm.ssot__Id__c) AS unq_Individuals__c,
APPROX_COUNT_DISTINCT(ssot__ContactPointPhone__dlm.ssot__Id__c) AS unq_PhoneCPs__c,
APPROX_COUNT_DISTINCT(ssot__ContactPointEmail__dlm.ssot__Id__c) AS unq_EmailCPs__c,
APPROX_COUNT_DISTINCT(ssot__ContactPointAddress__dlm.ssot__Id__c) AS unq_AddressCPs__c,
APPROX_COUNT_DISTINCT(ssot__PartyIdentification__dlm.ssot__Id__c) AS unq_PartyIdentifiers__c
FROM ssot__Individual__dlm
LEFT JOIN ssot__ContactPointPhone__dlm
ON ssot__ContactPointPhone__dlm.ssot__PartyId__c = ssot__Individual__dlm.ssot__Id__c
LEFT JOIN ssot__ContactPointEmail__dlm
ON ssot__ContactPointEmail__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
GROUP BY
DataSourceId__c,
DataSourceObjectId__c
Did this article solve your issue?
Let us know so we can improve!
