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.

Источник