How to Configure ZeroBounce for Email Validation

ZeroBounce is an email validation service that improves deliverability by validating email addresses. This guide walks you through the steps to integrate ZeroBounce into ACE.

Please Note:

The configuration below represents the best practice for defining SQL criteria, ETL logic, and workflow steps for use with ZeroBounce validation.  

Import/Export Process Overview

• Create a SQL report to export eligible email addresses for validation.

• Send the report to ZeroBounce via a job task using your API key.

• Receive the results file from ZeroBounce.

• Import results into ACE using ETL profiles that apply custom logic with JavaScript.

Prerequisites

• ZeroBounce API Key – Obtain this from your ZeroBounce account.

Step 1: File Manager Setup

• Create a ZeroBounce folder.

• Add Subfolders:

  • Export (for files sent to ZeroBounce)

    • Processed

  • Import (for results returned from ZeroBounce)

    • Processed

Step 2: Configure the ZeroBounce Vendor

1. Navigate to Setup → Vendors → Enrichment → New.

2. Enter values:

   1. Label: ZeroBounce

   2. Identifier: ZeroBounce

   3. Enrichment Provider ID: Select Template.

3. In the Export section, select the Export folder.

4. In the Import section, select the Import folder.

5. Save.

Step 3: Create a SQL Report

Use SQL Designer to create a report of eligible email addresses to scrub.

Example SQL: This query pulls primary, active, or new email addresses tied to accounts with a positive balance. It excludes addresses that have already been scrubbed by ZeroBounce or are already opted into email tracking. The result is a clean list of unscreened addresses eligible for validation, capped at 50 records for testing or volume control.

SELECT demographic_email.email_address
FROM demographic_email
JOIN debt ON debt.debt_id = demographic_email.debt_id
LEFT OUTER JOIN enrichment_meta_data_email
  ON enrichment_meta_data_email.demographic_email_id = demographic_email.demographic_email_id
  AND enrichment_meta_data_email.enrichment_vendor_id = (Your Vendor ID)
WHERE
  debt.current_balance > 0
  AND demographic_email.demographic_type = 'PRIMARY'
  AND demographic_email.status IN ('ACTIVE', 'NEW')
  AND demographic_email.els_opt_in_date IS NULL
  AND enrichment_meta_data_email.enrichment_meta_data_email_id IS NULL
LIMIT 50;

Step 4: Create Three ETL Import Profiles

You will need three ETL profiles, each with custom columns defined in the ETL Pro Logic editor using JavaScript.

All three ETL Profiles will use the “Email Addresses” load method.

Please Note:

Each ETL profile requires specific custom column mappings and JavaScript logic.

For detailed examples and scripts, see the companion guide: ZeroBounce ETL Profile Guide.

ZeroBounce Enrichment Invalids

• Marks invalid email addresses and prevents them from being loaded.

• Required mapped fields:

  • Email Address, Status (Enrichment Meta Data), Active, Status (Email Address), Enrichment Vendor, Customer Account Number, Demographic Email ID, Misc 5, Enrichment Date

• For more configuration details, refer to ETL Profile 1 – ZeroBounce Enrichment Invalids

ZeroBounce Enrichment Did You Mean

• Processes records where ZeroBounce suggests a corrected address.

• Skips records without suggestions.

• Required mapped fields:

  • Status, Email Address, Active, Enrichment Vendor, Customer Account Number, Demographic Email ID, Misc 5 (corrected email), Enrichment Date

• For more configuration details, refer to ETL Profile 2 – ZeroBounce Enrichment Did You Mean

ZeroBounce Enrichment Complete

• Marks each email as processed (valid or invalid).

• Required mapped fields:

  • Email Address, Status, Active, Enrichment Vendor, Customer Account Number, Demographic Email ID, Misc 5, Enrichment Date

• For more configuration details, refer to ETL Profile 3 – ZeroBounce Enrichment Complete

Step 5: Create and Configure a Job

Set up a job with tasks in the following order:

Resources

For more information, see the following related articles:

• About File Manager

• Handling Custom Columns in ETL Profiles

• ZeroBounce ETL Profile Guide

• About Jobs