Deduplicate a company lead export without treating DNS as mailbox proof

说明与用途

该工作流程说明了如何使用 Lead List Cleaner 从导出中去重公司线索，保留原始标识符并跟踪检查状态。

问题

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

结果

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

工作流

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

证据

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

来源

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

来源

Disabled checks must remain distinguishable from completed negative checks.

来源