---
schema_version: "1"
id: 7822fa03046dffa62ee257e1a4163943bef6133dab7465ed7ae8139df6fb8226
title: "Identity Resolution Calculated Insight: Consolidation Rates for Unified Profiles"
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_consolidation_rate.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_resolution_troubleshooting_ci_consolidation_rate.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 9efef1a9ec5645423ce9b812d9e21aabd99ab9f32dbe9e4b484032206b975b4d
description: Review the consolidation rate of matched profiles for each data source. Data sources with duplicate profiles are expected to have higher consolidation rates than data sources with many unique profiles. Use this calculated insight after creating unified profiles with an identity resolution ruleset.
products:
  - Data 360
release: "264"
---
# Identity Resolution Calculated Insight: Consolidation Rates for Unified Profiles

Review the consolidation rate of matched profiles for each data source. Data sources with duplicate profiles are expected to have higher consolidation rates than data sources with many unique profiles. Use this calculated insight after creating unified profiles with 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 An unexpectedly high consolidation rate could be a sign of data source quality issues.

![Identity Resolution - 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)

Identity Resolution - 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
 IndividualIdentityLink__dlm.ssot__DataSourceId__c as DataSourceId__c,
 IndividualIdentityLink__dlm.ssot__DataSourceObjectId__c as DataSourceObjectId__c,
 APPROX_COUNT_DISTINCT(IndividualIdentityLink__dlm.UnifiedRecordId__c) AS unq_Unified_Individuals__c,
 COUNT(IndividualIdentityLink__dlm.SourceRecordId__c) AS cnt_Source_Records__c,
 (1 - APPROX_COUNT_DISTINCT(IndividualIdentityLink__dlm.UnifiedRecordId__c)/COUNT(IndividualIdentityLink__dlm.SourceRecordId__c))*100 as per_consolidation_rate__c
FROM IndividualIdentityLink__dlm
GROUP BY 
 DataSourceId__c,
 DataSourceObjectId__c
```