I am trying to get a list of the email addresses that were filtered out when I sent an email message.

Esther Pomeleo-Fowler

Question

There were 1,032 that were "unusable" , but I want to see them.  What report do I run in order to see these Filtered addresses?

Response

You can obtain a list of the filtered-out constituents by running a Query.

To run the Query:

1.     Data Management - Query

2.     Create a New Query

3.     Query Builder Tab

4.     Add Group Clause button

Find the group that you targeted in your email.  Include the constituents in this group that fit the criteria for why an email is filtered out. (You can see the description back on the Deliveries page: Recipients who do not accept email, have hard-bounced, are deceased or have inactive contact records. This filter also can include recipients that have some other problem with their contact record such as an invalid email address & Recipients who have already received this message)

Build the Query:

Field Type: Email / Field: Accept Email - Add Field clause - equals false

Add an open parenthesis to the left of the Query builder on that line you just created

Change the “OR” on that line to read “AND”

Field Type: Email / Field: Email Status - Add field clause - equals Bad (Soft Bounce)

Change the “AND” to read “OR”

Field Type: Email / Field: Email Status - Add field clause - equals Bad (Hard Bounce)

Field Type: System / Field: Active Status - Add field clause - Removed

Add closed parenthesis to the end of the last line

Your Query should look like this now:

a member of the 'xxxx email list' group

AND (Accept Email equals false

OR Email Status equals Bad (Soft Bounce)

OR Email Status equals Bad (Hard Bounce)

OR System Active Status equals Removed)



Save Query

Run Query

From here, you can just view the names, or you can click the "Use Query" icon (a thumbs-up) and create a mail merge file or a group of those names.