# Delpha Data Quality Field Pack for Salesforce

## Delpha Data Quality — Overview

Delpha evaluates data quality across [six core dimensions](/delpha-for-salesforce/how-to-faq/delpha-data-quality/what-are-the-6-data-quality-dimensions.md). For every field monitored, Delpha adds a standard set of companion fields to the object to store these insights.

* Labels start with **“D”**.
* API names start with **delpha\_\_DDQ\_Quality**.

***

### 1. Delpha Data Quality Analysis (Core Dimensions)

Existing records are assessed on the six dimensions, with one dedicated field per dimension created on the target object. For each field you monitor (shown here as `{TargetedField}`), Delpha creates the following assessment fields plus an overall score:

* `delpha__DDQ_QualityTargetedFieldCompleteness__c` — **Boolean** — **Completeness**
* `delpha__DDQ_QualityTargetedFieldValidity__c` — **Picklist** *(Valid, Invalid, Unknown)* — **Validity**
* `delpha__DDQ_QualityTargetedFieldUniqueness__c` — **Number** *(count of occurrences in the org)* — **Uniqueness**
* `delpha__DDQ_QualityTargetedFieldConsistency__c` — **Boolean** — **Consistency**
* `delpha__DDQ_QualityTargetedFieldAccuracy__c` — **Picklist** *(Ok, No, Unknown)* — **Accuracy**
* `delpha__DDQ_QualityTargetedFieldTimeliness__c` — **String** — **Timeliness**
* `delpha__DDQ_QualityTargetedFieldScore__c` — **Number** — **Overall quality score for `{TargetedField}`**

***

### 2. Delpha Recommendations

To provide rich insights and flexible decision-making capabilities, Delpha utilizes a **structured JSON approach** to deliver its recommendations.

Instead of forcing a single suggested value into a standard text field, Delpha populates a dedicated JSON field. This allows the system to provide:

1. **Multiple Options:** An array of the top potential matches, allowing users to select the most accurate one.
2. **Rich Context:** Extensive metadata (like revenue, employee count, and registered addresses) so users can confidently verify the suggestion before applying it.

#### The Recommendation Fields

* `delpha__DDQ_QualityTargetedFieldNormalized__c` — Same type as `{TargetedField}` — The value after standard normalization.
* `delpha__DDQ_QualityTargetedFieldRecommendedScore__c` — **Number** — Confidence score for the recommendation
* `delpha__DDQ_QualityTargetedFieldRecommendedData__c` — **Long Text Area** (JSON) — The structured payload containing Delpha's recommended options and enrichment data.

#### Delpha Support fields &#x20;

* [`delpha__DDQ_QualityTargetedFieldRecommendedStatus__c` — **Picklist** — Current status / decision context](/delpha-for-salesforce/how-to-faq/delpha-data-quality/data-quality-recommended-status-full-reference-guide.md)
* `delpha__DDQ_QualityTargetedFieldLastUpdated__c` — **DateTime** — Last analysis timestamp
* `delpha__DDQ_QualityTargetedFieldPreviousStatus__c` — **Number** — Previous value of `…RecommendedStatus__c`

{% hint style="warning" %}
Delpha may add **small, field-specific adjustments** to improve fit:

* **Expanded picklists:** Certain targeted fields can include extra values beyond the defaults.
  * *Examples:* [**Accuracy** for email](/delpha-for-salesforce/how-to-faq/delpha-data-quality/what-are-the-data-quality-fields-for-contact-email.md) will add `Changed`.
* **Extra support fields:** Additional metadata can be stored to explain or audit decisions.
  * *Examples: for*[ ***Ultimate***](/delpha-for-salesforce/how-to-faq/delpha-ultimate-parent/what-are-the-delpha-ultimate-parent-fields.md)
    * `delpha__DDQ_QualityUltimateComments__c` (Text) — why a recommendation was made

These extensions are **optional**, scoped to specific targeted fields or use cases, and remain compatible with the core six-dimension model.&#x20;
{% endhint %}

***

### 3. Understanding the JSON Structure (Example: Legal ID)

When Delpha identifies potential recommendations (e.g., finding the correct SIRET number for a French company), it populates the `RecommendedData__c` field with a JSON array.

Each item in this array represents a potential match and includes a detailed `data` object. Here is a breakdown of the information available within the payload:

* **legal\_id & legal\_id\_type:** The actual recommended identifier (e.g., "08548006901136" / "FRA - SIRET").
* **score:** The confidence score of this specific match (e.g., 82).
* **status:** Identifies the record as a "Potential" match.
* **company\_type:** The legal structure (e.g., "SARL", "SAS").
* **employees\_nb & annual\_revenue:** Enrichment metrics showing company size and financial health.
* **address:** Full location details including coordinates, street, city, postal code, and country.
* **industry:** Industry classification codes.

#### Sample JSON Payload

JSON

<pre class="language-json"><code class="lang-json">[
<strong>// Recommended data, with the higher confidence score //
</strong>  {
    "score": 65,
    "status": "Potential",
    "sources": [
      {
        "data": {
          "creation_date": "2020-01-09",
          "legal_id": "88052440000012",
          "legal_id_type": "FRA - SIRET",
          "date": {
            "birth_date": null,
            "closing_date": null,
            "creation_date": "2020-01-09",
            "label": "Date"
          },
          "company_type": {
            "legal_type_code": "5710",
            "legal_id_type_label": null,
            "legal_type": "SAS, société par actions simplifiée",
            "value": "SAS"
          },
          "source": "https://annuaire-entreprises.data.gouv.fr/entreprise/88052440000012",
          "employees_nb": {
            "range": "1-10",
            "max": 9,
            "min": 6,
            "value": 9,
            "label": "EmployeesNb"
          },
          "annual_revenue": null,
          "address": {
            "coordinates": [
              48.844019,
              2.332676
            ],
            "location": "3 AVENUE VAVIN, PARIS, 75006, France",
            "country_code": "FR",
            "country": "France",
            "postal_code": "75006",
            "state": "",
            "city": "PARIS",
            "full_street": "3 AVENUE VAVIN",
            "street": "AVENUE VAVIN",
            "street_number": "3",
            "place_name": null,
            "label": "LegalAddress"
          },
          "website": null,
          "industry": {
            "type": null,
            "description": null,
            "value": "5820",
            "label": "LegalIndustry"
          },
          "account_name": "DELPHA",
          "source_path": [
            {
              "name": "Name"
            }
          ],
          "score": 0.6521739130434783
        },
        "timestamp": "2026-04-29 10:31:40",
        "score": 65,
        "source": "Assessment"
      }
    ],
    "legal_id": "88052440000012",
    "legal_id_type": "FRA - SIRET"
  },
<strong>// Beginning of option 2, with lower confidence score //
</strong>  {
    "score": 39,
    "status": "Potential",
    "sources": [
      {
        "data": {
          "creation_date": "2004-11-17",
          "legal_id": "48011298600017",
          "legal_id_type": "FRA - SIRET",
          "date": {
            "birth_date": null,
            "closing_date": null,
            "creation_date": "2004-11-17",
            "label": "Date"
          },
          "company_type": {
            "legal_type_code": "6540",
            "legal_id_type_label": null,
            "legal_type": "Société civile immobilière",
            "value": "SCI"
          },
          "source": "https://annuaire-entreprises.data.gouv.fr/entreprise/48011298600017",
          "employees_nb": null,
          "annual_revenue": null,
          "address": {
            "coordinates": [
              14.456555,
              -60.835542
            ],
            "location": "CZ MR ARSENE AURORE CAP FONDS REPOS, SAINTE-ANNE, 97227, France",
            "country_code": "FR",
            "country": "France",
            "postal_code": "97227",
            "state": "",
            "city": "SAINTE-ANNE",
            "full_street": "CZ MR ARSENE AURORE CAP FONDS REPOS",
            "street": "CZ MR ARSENE AURORE CAP FONDS REPOS",
            "street_number": null,
            "place_name": null,
            "label": "LegalAddress"
          },
          "website": null,
          "industry": {
            "type": null,
            "description": null,
            "value": "6810",
            "label": "LegalIndustry"
          },
          "account_name": "DELPHA",
          "source_path": [
            {
              "name": "Name"
            }
          ],
          "score": 0.39134782608695656
        },
        "timestamp": "2026-04-29 10:31:40",
        "score": 39,
        "source": "Assessment"
      }
    ],
    "legal_id": "48011298600017",
    "legal_id_type": "FRA - SIRET"
  }
]
</code></pre>

{% hint style="info" %}
By utilizing this structured JSON payload, the [Delpha Score Meter displays multiple recommendation options directly within the Salesforce UI](/delpha-for-salesforce/delpha-apps/delpha-score-meter.md). \
When a user clicks on a data quality alert in the Score Meter, instead of seeing just one suggested fix, they are presented with a prioritized list of the top potential matches. Each option displays its associated confidence score alongside rich contextual data, empowering the user to compare the choices and confidently select the exact right value to apply to the record.
{% endhint %}

## Beyond Quality: Delpha Engagement Metrics

While the core Data Quality Field Pack focuses on the health and accuracy of your records (assessing the six dimensions of data quality), Delpha also generates a companion set of Engagement Metrics.

These calculated fields—such as `D Email Count`, `D Call Count`, and `D Opportunity Count`—automatically measure the actual activity and sales momentum happening on your Leads, Contacts, and Accounts. By combining Data Quality scores with these Engagement Metrics, your sales and support teams get a complete, 360-degree view of a record's value directly within Salesforce.

👉 [Read the guide on Delpha Engagement Metrics here](/delpha-for-salesforce/how-to-faq/delpha-data-quality/delpha-engagement-metrics.md) to see the complete list of available calculated fields.


---

# 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-data-quality/delpha-data-quality-field-pack-for-salesforce.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.
