You can query for people with email messages that bounced on a specific delivered date. This helps you monitor deliverability issues, find records with invalid or outdated email addresses, and decide when to use another contact method.
Try a Slate example 💼
Copy this Suitcase ID and paste it in Database → Suitcase Import to import a pre-made example query:
06e0c357-893d-46a6-93ed-6ddf17d4da20:slate-admissions-showcase💡 Tip
Find this query and other importable examples in the Admissions Showcase environment.
Reviewing bounced messages
Use this query when you want to review bounced email activity from a specific send date. The example returns each person's reference ID, name, email address, bounced message status, bounce detail, subject, and delivered date.
This review can help you clean contact data, identify communication patterns, and follow up with records through another available channel.
Building the query
Creating the query
Go to Queries / Reports.
Select New Query.
Configure the following settings:
Name: Bounced messages by delivered date
Folder: Select the folder where the query should be saved.
Type: Configurable Joins
Base: Person
Select Save.
Adding person exports
Add exports similar to these so the results identify the record and the email address that needs review:
Person Reference ID
Person First
Person Last
Person Email
Adding subquery exports for bounced message details
The subquery exports return details from a related message with a bounced status. The example uses Rank output with Row Offset: 1 so one bounced message value appears on each person row.
Select Subquery Export.
Configure the following settings:
Name: Messages Status (Bounce)
Type: Dependent subquery
Output: Rank
Row Offset: 1
In the subquery, create a join to Messages.
Select Export, then select Messages Status.
Select Filter, then configure Messages / Status: IN Bounce.
Select Save.
Repeat the same subquery export pattern for the following message exports:
Messages Status Detail (Bounce): Messages Status Detail
Messages Subject (Bounce): Messages Subject
Messages Delivered Date (Bounce): Messages Delivered Date
Adding subquery filters
The filters limit the results to people who have bounced message activity, message activity on the delivered date you are reviewing, and a populated email address.
Has a bounced message
Select Subquery Filter.
Configure the following settings:
Name: Has a Bounced Message
Type: Dependent subquery
Aggregate: Exists
Create a join to Messages.
Select Filter, then configure Messages / Status: IN Bounce.
Select Save.
On a specific delivered date
Select Subquery Filter again.
Configure the following settings:
Name: On a specific Delivered Date
Type: Dependent subquery
Aggregate: Exists
Create a join to Messages.
Select Filter, then configure Messages / Delivered Date: the delivered date to review.
Select Save.
Email address exists
Add a subquery filter that requires Person Email to exist.
💡 You might also consider filtering for bounced status and delivered date in the same subquery filter, so that both conditions apply to the same message.
Sorting the results
Select Subquery Sort.
Configure the following settings:
Sort Order: Ascending
Type: Dependent subquery
Output: Rank
Row Offset: 1
In the subquery, create a join to Messages.
Select Export, then select Messages Delivered Date.
Select Filter, then configure Messages / Status: IN Bounce.
Select Save.
Reviewing the results
Run the query and review the bounced status detail, subject, and delivered date. Use the results to correct invalid email addresses, suppress addresses that should no longer receive messages, or identify records that need outreach through another contact method.