Connectors

/

DonorPerfect

/

Find DonorPerfect donors missing from a Mailchimp audience
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Find DonorPerfect donors missing from a Mailchimp audience
Which DonorPerfect donors are not in our Supporters audience in Mailchimp?
Checked 1,240 donors with an email, and 186 are not in the Supporters audience. - Missing: 186 donors, led by Contoso Foundation at 48,000 lifetime - Unsubscribed or cleaned: 92 donors - Subscribed or pending: 962 donors Want the full missing list ranked by giving?
DonorPerfect
Sample figures. Your results come from your own account.
mailchimp-get-list
donorperfect-get-donor
mailchimp-get-list-member

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

DonorPerfect

DonorPerfect
Run it on your own DonorPerfect data.

Connect DonorPerfect, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

02

Read

It reads DonorPerfect donors with an email.

donorperfect-get-donor

03

Check

It checks each one against the audience, ignoring case and spacing.

mailchimp-get-list
mailchimp-get-list-member

04

Report

You get missing donors ranked by giving, with nothing changed.

Your AI tool

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.

get-data

mailchimp-get-list

Returns Mailchimp lists (audiences) with member counts, open and click rates, and recent campaign activity.
get-data

donorperfect-get-donor

Returns donor records from DonorPerfect: names, salutations, contact details, donor type and status, and the codes used to segment them. The starting point for almost any DonorPerfect question.
get-data

mailchimp-get-list-member

Returns the members (subscribers) of Mailchimp audiences, with subscription status, tags and engagement rating. Filter by email address or status to look someone up.
Read only.Nothing in DonorPerfect Changes

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.

How Popdock AI secures your data

The outcome

Know which donors your newsletter misses

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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.

Try PopdockAI Free
See Documentation