/
/
Find the donors your Mailchimp newsletter is missing
For nonprofit marketers who want to know which DonorPerfect donors are not in a Mailchimp audience, by asking their AI assistant.
On this page
Connector
Connect DonorPerfect, pick your AI tool and paste the prompt.
The problem
Donors with an email who never hear from you
Donors with an email in DonorPerfect should hear from you through Mailchimp, but nobody checks until a newsletter goes out light. Comparing the donor base with the audience by hand means checking each address one at a time.
Without PopdockAI
- Export donors with an email
- Export the Mailchimp audience
- Match addresses that differ in case or spacing
- Lose track of who unsubscribed
With PopdockAI
- Donors with an email are checked against the audience
- Addresses match regardless of case or spacing
- Donors are sorted into missing, opted out and subscribed
- Missing donors ranked by giving, nothing changed
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 who have an email address but are not in the Mailchimp audience `{list-name}`, limited to donors whose lifetime giving is at least `{min-gift-total}` (default 0).
**Step 1: Confirm the audience**
Call `mailchimp-get-list` with `name` set to `{list-name}`. If nothing matches, call it again with `name.contains` and list the candidates, then stop. Note the `list-id` and member count.
**Step 2: Read the donors**
Call `donorperfect-get-donor` with `gift-total.min` set to `{min-gift-total}` (omit the filter when it is 0 or blank) and `max-records` 200. Keep only donors with a non-empty `email`.
**Step 3: Check each donor in Mailchimp**
For each donor, call `mailchimp-get-list-member` with `email` set to the donor's `email` and `list-name` set to `{list-name}`. Sort the donors into three groups: not in the audience at all; in the audience but `unsubscribed` or `cleaned`; in the audience and `subscribed` or `pending`.
**Step 4: Report**
A table of donors missing from the audience (donor id, name, email, gift total, last contribution amount), sorted by gift total descending. Then a separate short table of donors who are in the audience but unsubscribed or cleaned. Finish with the counts of all three groups.
**Rules & Guidelines:**
* `donorperfect-get-donor` is on the donorperfect server. `mailchimp-get-list` and `mailchimp-get-list-member` are on the mailchimp server.
* This is read-only. Do NOT call `mailchimp-add-list-member`, `mailchimp-update-list-member` or `donorperfect-save-donor`. To add the missing donors, use the add-donors-to-audience prompt.
* Match emails case-insensitively after trimming spaces.
**Validation:**
* If the donor read hits its 200-record limit, say the result is partial and suggest a higher `{min-gift-total}`.
* If no donors have an email address, report that and stop.Who it's for
One answer, three teams that use it
Development marketers
Grow the audience with real donors
See which donors are not on the list, ranked by giving.
Which DonorPerfect donors over 1,000 lifetime are not in our Mailchimp Newsletter audience?
Donor database managers
Check list coverage
A three-way split shows missing, opted-out and subscribed donors.
How many DonorPerfect donors are missing, unsubscribed or subscribed in the Mailchimp Supporters audience?
Development directors
Make sure top donors get updates
Missing donors are ranked so the most important come first.
List our top 25 DonorPerfect donors who are not in Mailchimp at all.
How it works
What PopdockAI does when you ask
You name the Mailchimp audience and your AI assistant checks every DonorPerfect donor with an email against it. It only reads.
01
Ask
You name the Mailchimp audience and optionally a minimum lifetime giving.
02
Read
It reads DonorPerfect donors with an email.
03
Check
It checks each one against the audience, ignoring case and spacing.
04
Report
You get missing donors ranked by giving, with nothing changed.
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-list
donorperfect-get-donor
mailchimp-get-list-member
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
Know which donors your newsletter misses
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)
