Delpha Data Quality Field Pack for Salesforce

Understand Delpha's data quality data model. Learn how Delpha stores its six core data quality dimensions and uses a structured JSON payload to deliver multi-option recommendations and data insights.

Delpha Data Quality — Overview

Delpha evaluates data quality across six core dimensions. 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

• delpha__DDQ_QualityTargetedFieldRecommendedStatus__c — Picklist — Current status / decision context

• delpha__DDQ_QualityTargetedFieldLastUpdated__c — DateTime — Last analysis timestamp

• delpha__DDQ_QualityTargetedFieldPreviousStatus__c — Number — Previous value of …RecommendedStatus__c

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 will add Changed.

• Extra support fields: Additional metadata can be stored to explain or audit decisions.

  • Examples: for Ultimate

    • 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.

---

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

[
// Recommended data, with the higher confidence score //
  {
    "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"
  },
// Beginning of option 2, with lower confidence score //
  {
    "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"
  }
]

By utilizing this structured JSON payload, the Delpha Score Meter displays multiple recommendation options directly within the Salesforce UI. 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.

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 to see the complete list of available calculated fields.