Deduplicate a company lead export without treating DNS as mailbox proof

Description and use

This workflow explains how to use Lead List Cleaner to deduplicate company leads from exports, preserving original identifiers and tracking check status.

Problem

Spreadsheet exports can list multiple contacts for a single company, making it hard to identify unique company leads and avoid duplicate enrichment.

Outcome

The workflow reduces duplicate company leads, provides transparent check status, and allows reversible import into CRM while preserving original data for audit.

Workflow

• 1. Preserve raw row identifiers in a staging table before processing.
• 2. Run Lead List Cleaner with selected checks (dedupe and score).
• 3. Store check state, score, and rejection reasons beside each record.
• 4. Apply score cutoff only when scoring was executed.
• 5. Write cleaned leads to a staging destination before merging into CRM.
• 6. Review rejected and duplicate rows separately, retaining explanations.

Evidence

Lead List Cleaner normalizes heterogeneous lead rows and can run deduplication, email checks, domain checks and scoring.

Source

Preserve the raw row identifier in your own staging table before processing.

Source

Disabled checks must remain distinguishable from completed negative checks.

Source