---
title: "Querying for Bounced Messages by Delivered Date"
slug: "querying-for-bounced-messages-by-delivered-date"
status: "new"
updated: 2026-06-18T22:10:26Z
published: 2026-06-18T22:10:26Z
canonical: "knowledge.technolutions.net/querying-for-bounced-messages-by-delivered-date"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://knowledge.technolutions.net/llms.txt
> Use this file to discover all available pages before exploring further.

# Querying for Bounced Messages by Delivered Date

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](/docs/suitcase-import) ID and paste it in **Database → Suitcase Import** to import a pre-made example query:

```SuitcaseID
06e0c357-893d-46a6-93ed-6ddf17d4da20:slate-admissions-showcase
```

> [!NOTE]
> 💡 Tip
> 
> Find this query and other importable examples in the [Admissions Showcase environment](/v1/docs/showcase-environments).

## 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.

![](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/Querying for Bounced Messages by Delivered Date.png)

## Building the query

### Creating the query

1. Go to **Queries / Reports**.
2. Select **New Query**.
3. 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
4. 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.

1. Select **Subquery Export**.
2. Configure the following settings:
  - **Name:** Messages Status (Bounce)
  - **Type:** Dependent subquery
  - **Output:** Rank
  - **Row Offset:** 1
3. In the subquery, create a join to **Messages**.
4. Select **Export**, then select **Messages Status**.
5. Select **Filter**, then configure **Messages / Status:** IN Bounce.
6. Select **Save**.
7. 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

1. Select **Subquery Filter**.
2. Configure the following settings:
  - **Name:** Has a Bounced Message
  - **Type:** Dependent subquery
  - **Aggregate:** Exists
3. Create a join to **Messages**.
4. Select **Filter**, then configure **Messages / Status:** IN Bounce.
5. Select **Save**.

#### On a specific delivered date

1. Select **Subquery Filter** again.
2. Configure the following settings:
  - **Name:** On a specific Delivered Date
  - **Type:** Dependent subquery
  - **Aggregate:** Exists
3. Create a join to **Messages**.
4. Select **Filter**, then configure **Messages / Delivered Date:** the delivered date to review.
5. Select **Save**.

#### Email address exists

Add a subquery filter that requires **Person Email** to exist.

> [!NOTE]
> 💡 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

1. Select **Subquery Sort**.
2. Configure the following settings:
  - **Sort Order:** Ascending
  - **Type:** Dependent subquery
  - **Output:** Rank
  - **Row Offset:** 1
3. In the subquery, create a join to **Messages**.
4. Select **Export**, then select **Messages Delivered Date**.
5. Select **Filter**, then configure **Messages / Status:** IN Bounce.
6. 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.