# How can I create custom reports on Duplicate

## How to Create a Custom Report on Duplicate Records in Delpha

If you're managing duplicate detection with Delpha, you may want to build detailed reports to analyze duplicate pairs by score, status, or specific field values. This guide walks you through creating a custom **Salesforce Report Type** using the **DDQ Duplicate Record** object.

### Step 1: Create the Custom Report Type

* **Primary Object**: `DDQ Duplicate Records (delpha__DDQ_DuplicateRecord__c)`
* **Display Label**: `DC_DuplicateRecord`
* **Description**: `Delpha – created for reporting on Duplicate Records`
* **Store in Category**: `Other Reports`
* **Availability**: `Deployed`

Once saved:

* Click **Edit Layout**
* Click the **+ Lookup Fields** button to add lookup fields to your report type

### Step 2: Add Lookup Fields

Select the fields relevant to your deduplication use case. You can add fields from:

* **Account / Person Account**:
  * `Account (delpha__Account__c)`
  * `Matched Account (delpha__Matched_Account__c)`
* **Contact**:
  * `Contact (delpha__Contact__c)`
  * `Matched Contact (delpha__Matched_Contact__c)`
* **Lead**:
  * `Lead (delpha__Lead__c)`
  * `Matched Lead (delpha__Matched_Lead__c)`
* **Lead vs Contact**:
  * `Lead (delpha__Lead__c)`
  * `Matched Contact (delpha__Matched_Contact__c)`
* **Case**:
  * `Case (delpha__Case__c)`
  * `Matched Case (delpha__Matched_Case__c)`

## Create and Customize Your Report

1. Go to the **Reports** tab
2. Click **New Report**
3. In the report type search, select `DC_DuplicateRecord`
4. Click **Start Report**

### Customize Your Report

#### **Filters (Examples):**

* Filter by object:\
  `DDQ Duplicate Record Name = Account`
* Filter by geography:\
  `Account:BillingCountry = France`\
  `Matched Account:BillingCountry = France`
* Filter by timeframe:\
  `Created Date = Last 30 days`
* Filter by status:\
  `Status = Potential`

#### **Columns to Include:**

* `Score`
* `Status`
* `Comment`
* `Processed`
* `Account: Name` and `Matched Account: Name`
* `Account: Website` and `Matched Account: Website`

{% hint style="warning" %}
Use side-by-side fields to compare records and quickly spot discrepancies.
{% endhint %}

### Summary

You now have a dynamic report to monitor duplicates, spot trends, and track how your deduplication strategy is performing. It’s a powerful way to make Delpha’s detection more transparent to your team.

{% hint style="info" %}
You can add <mark style="color:orange;">any field</mark> from the Record and Matched Record, even if they are not used in the [duplicate setting ](broken://pages/H4YOK9ZI8jmWkpu8b9SU)
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.delpha.io/delpha-for-salesforce/how-to-faq/delpha-duplicate/how-can-i-create-custom-reports-on-duplicate.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.