Outbound List Hygiene Checklist Before Export

Use this checklist before handing a prospect list to a client, CRM workflow or campaign owner. Confirm account fit, relevant people, required evidence and the destination's behaviour; email availability alone is not list readiness.

You may need a bounded retrieval or an internal staging file to perform the review. Keep that working dataset separate from the approved list released for the next action.

State the audience, channel, required fields and owner. Define what counts as a duplicate and how unresolved records will be handled. A named-account campaign and a contact-volume campaign can need different identity and coverage rules.

The ICP framework provides the account criteria. The list-building workflow connects the brief to a reviewed delivery.

• Activity: does the company itself operate in the intended market?
• Business model: does it meet the actual use case rather than only a broad industry label?
• Scale: are employee or revenue criteria being interpreted as intended?
• Location: is the relevant field company location, person location or territory?
• Exclusions: are existing customers, owned accounts and agreed disqualifiers handled?

Research specialist requirements such as installed technology or facility footprint separately when necessary. A firmographic proxy does not prove those facts.

• Confirm the person's identity and intended company.
• Preserve the full title and meaningful region, product or segment qualifiers.
• Review the responsibility the campaign targets instead of treating seniority as budget authority.
• Distinguish the business owner, evaluator and other relevant stakeholders.
• Retain unresolved company or role conflicts for research.

An inactive profile, an old domain registration or a familiar title is not by itself proof that a contact is stale or current. Use evidence relevant to the actual person and task.

• Define which fields the intended channel actually needs.
• Keep missing values and uncertain outcomes explicit.
• Preserve the source and observation date when supplied.
• Separate available email or phone fields from independent validation results.
• Retain any validation method, time and limitations.
• Avoid inventing a value or treating a naming pattern as a verified address.

A count preview cannot perform this review. Dievio's free previews show matching contact records without full contact details. Retrieve a bounded set to inspect actual values, and choose review coverage that reflects the audience's variation and the consequence of a mistake.

If known LinkedIn profile URLs can resolve a specific gap, profile lookup may return available matching fields. It does not guarantee a fresh mailbox check or current employment. The enrichment workflow guide develops the separate retrieval task.

• Apply the declared person and account identity rules.
• Review ambiguous matches rather than merging by name or domain alone.
• Deduplicate companies separately when reporting account coverage.
• Apply relevant preferences, suppression and campaign exclusions.
• Confirm existing account or contact ownership before assigning a new action.
• Preserve exclusion reasons so another import does not revive the same problem.

Several people at one company may be intentional stakeholders rather than duplicates. A valid record outside the current campaign can remain useful without being activated now.

Start with the prospect list CSV template if the team has no agreed headers. For an existing export, keep the original file and run the checks on a copy.

1. Map the CSV columns. Match the sender or CRM fields to the right source columns. For example, map Work Email to the email field and Company Domain to the company domain field. Check a preview row before downloading.
2. Clean the email column. Download the cleaned list and keep the review output for duplicate or malformed rows. A syntactically valid address still needs a separate deliverability check if the campaign requires one.
3. Audit the final list. Review missing mapped fields, duplicate emails and email formats. If one company should appear only once, check domain counts separately in the working sheet. The audit is a report. Apply any required removals to the working file, then recheck it.

For a quick check, use a small copy with two valid addresses, one repeated address and one malformed value. The cleaned email list should contain two unique valid-looking addresses. Keep the original rows when the team needs company, title or consent fields for review.

Map source columns to the destination's current fields. Preserve original identifiers and raw values where transformations are required. Keep the list version, source and approving owner traceable.

• Check phone and identifier formatting, including values that should remain text.
• Test empty values and whether they clear or leave existing fields unchanged.
• Confirm company text and account relationships are handled appropriately.
• Verify that reviewed CRM values are not overwritten unintentionally.
• Check duplicate handling, ownership and suppression in the resulting records.
• Confirm that import does not automatically activate an unapproved sequence.

A successful import is one technical outcome, not proof of contact quality or campaign eligibility. Preserve failures and uncertain writes so recovery can target the failed stage.

Do not equate a smaller list with higher quality or a complete file with greater certainty. Prioritise from relevant evidence and follow-up capacity, not an unexplained completeness score.

Use contact search for the intended audience, then keep the review and handoff in the team's operating workflow. Revisit the checklist when the audience, channel, destination or material evidence changes.