---
schema_version: "1"
id: 3236326e9d138b1340e8c2e07072ae23f7ea829379ef32bfb8acc2f986460098
title: "Data Quality Calculated Insight: Summary by Source"
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_resolution_troubleshooting_ci_summary_by_source.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_resolution_troubleshooting_ci_summary_by_source.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 77c376c8c5a79c29e11539eafbfacf187aeb7fce4ce4fdbe9fcf31b71fc3517b
description: 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.
products:
  - Data 360
release: "264"
---
# 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](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/images/icon_tip.png)

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](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/images/icon_example.png)

DQ Source - Summary by Source

![Tip](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/images/icon_tip.png)

Tip Modify the SQL in the example based on your data mappings.

```sql
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
```