/
/
Fix bad donor emails before the next appeal
For donor data teams who want Mailchimp bounces traced back to DonorPerfect records, ranked by giving, by asking their AI assistant.
On this page
Connector
Connect DonorPerfect, pick your AI tool and paste the prompt.
The problem
A major donor misses the appeal because of a bad address
Bouncing emails in Mailchimp usually mean a wrong address in DonorPerfect, but nobody connects them until a major donor misses an appeal. Finding which donor holds each bad address, and where, means searching record by record.
Without PopdockAI
- Export bounces from Mailchimp
- Search DonorPerfect for each address
- Check additional address records too
- Fix small donors before big ones
With PopdockAI
- Bounces are grouped by email with type and count
- Each address is found on a donor or additional address
- Hard and repeated soft bounces are ranked by giving
- Single soft bounces are left out, read-only
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find DonorPerfect donors whose email address bounced in Mailchimp campaigns over the last `{lookback-days}` days (default 30), so staff can correct or remove the address in DonorPerfect.
**Step 1: Read the bounces**
Call `mailchimp-get-campaign-email-activity` with `action` set to bounce and `activity-date.from` set to `{lookback-days}` days before today. Group by email, keeping the latest bounce date, its `bounce-type` (hard or soft) and how many campaigns bounced.
**Step 2: Match to donors**
For each email, call `donorperfect-get-donor` with `email`, then `donorperfect-get-address` with `email` to catch addresses held on an additional address record. Note which record holds the email (main donor record or an address id and its address type).
**Step 3: Add giving context**
For each matched donor, use `gift-total`, `year-to-date` and `last-contribution-amount` from the donor record.
**Step 4: Report**
Two tables: hard bounces first, then soft bounces that bounced in two or more campaigns. Columns: donor id, name, email, where the email is held, bounce type, latest bounce date, bounce count, gift total, year to date, last contribution amount. Sort by gift total descending, so the most valuable donors with a bad address come first. Finish with the count of bouncing emails that matched no donor.
**Rules & Guidelines:**
* `mailchimp-get-campaign-email-activity` is on the mailchimp server. `donorperfect-get-donor` and `donorperfect-get-address` are on the donorperfect server.
* This is read-only. Do NOT call `donorperfect-save-address`, `donorperfect-save-donor`, `donorperfect-set-flag` or `mailchimp-update-list-member`.
* A single soft bounce is usually temporary: leave it out of the report.
**Validation:**
* If there are no bounces in the window, say so and stop.
* If no bouncing email matches a donor, report the count and stop.Who it's for
One answer, three teams that use it
Donor database managers
Know where each bad address lives
See whether it is on the main record or an additional address.
Which DonorPerfect records hold emails that hard bounced in Mailchimp this month?
Major gift officers
Make sure top donors get appeals
Bounces are ranked by lifetime giving so the biggest donors come first.
Do any donors over 10,000 lifetime have bouncing Mailchimp emails?
Development operations
Clean data before an appeal
Run it ahead of each send to correct addresses in time.
List DonorPerfect donors with repeated soft bounces in Mailchimp over the last 90 days.
How it works
What PopdockAI does when you ask
You choose a lookback and your AI assistant matches Mailchimp bounces to DonorPerfect records. It only reads, so staff decide what to correct.
01
Ask
You choose a lookback period, 30 days by default.
02
Read
It reads Mailchimp bounces grouped by email with type and count.
03
Match
It finds each address on a DonorPerfect donor or additional address record.
04
Report
You get hard and repeated soft bounces ranked by lifetime giving.
What PopdockAI provides
The tools behind the answer
Ready made tools for DonorPerfect and one secure connection to your AI tool. No code, no exports.
mailchimp-get-campaign-email-activity
donorperfect-get-donor
donorperfect-get-address
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
Your most valuable bad addresses fixed first
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
