Connectors

/

DonorPerfect

/

Find DonorPerfect donors missing from Drip
Report
Cross-Connector

See which DonorPerfect donors Drip is not reaching

For nonprofit marketers who want a ranked list of donors with no Drip subscriber record, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Find DonorPerfect donors missing from Drip
Check 200 DonorPerfect donors in Texas who have given over 500 and tell me who is missing from Drip.
Checked 200 donors in Texas: 152 are in Drip and 48 are missing. - Missing: 48 donors, led by Fabrikam Inc at 9,400 - Unsubscribed in Drip: 11 donors, kept apart, not gaps - Last contribution: Fabrikam Inc gave 1,200 on 2026-05-20 Want the full table of missing donors?
DonorPerfect
Sample figures. Your results come from your own account.
donorperfect-get-donor
drip-get-subscriber

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

Gaps and opt-outs look the same in a donor export

Donors with an email in DonorPerfect should hear from you in Drip, but nobody knows how many slipped through. Checking means exporting donors and searching Drip for each address, and deliberate opt-outs get confused with real gaps.

Without PopdockAI

  • Export donors by gift total or state
  • Search Drip for each email
  • Mix up opt-outs with missing donors
  • Chase people who said no

With PopdockAI

  • Donors with an email are looked up in Drip
  • Missing donors are sorted by gift total
  • Unsubscribed people are listed apart, not as gaps
  • Counts of checked, found and missing, nothing written

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 subscribers in Drip, limited to donors whose gift total is at least `{gift-total-min}` (default 0) and, if given, who are in state `{state}` (default all states). Check at most `{max-donors}` donors (default 50).

**Step 1: List the donors**

Call `donorperfect-get-donor` with `gift-total.min` set to the minimum, `state` set to `{state}` when it is supplied, and `max-records` set to the limit. Drop donors with a blank email.

**Step 2: Check each donor in Drip**

For each remaining donor, call `drip-get-subscriber` with `email` set to the donor's email. A donor with no result is missing from Drip.

**Step 3: Report**

A table of the missing donors: donor-id, name, organization name, email, gift total, last contribution amount, sorted by gift total, highest first. Under it, one line with the counts: donors checked, donors found in Drip, donors missing.

**Rules & Guidelines:**

* `donorperfect-get-donor` is on the donorperfect server. `drip-get-subscriber` is on the drip server.
* This prompt is read-only. Do not call `drip-add-subscriber` to fill the gap; suggest the `enroll-donors-in-drip-campaign` prompt instead. Do not call any DonorPerfect save tool.
* Compare emails ignoring case and surrounding spaces.

**Validation:**

* If no donor matches the filters, say so and stop.
* A Drip subscriber whose status is unsubscribed is not missing. List those separately as "in Drip but unsubscribed" rather than as gaps.

Who it's for

One answer, three teams that use it

Development marketers

Find donors missing from Drip

True gaps are listed by gift total with their organisation and last gift.

Check 300 DonorPerfect donors over 250 and tell me who is not in Drip.

Donor database managers

Separate gaps from opt-outs

Unsubscribed people are kept apart, so nobody chases them.

Which DonorPerfect donors in Florida are unsubscribed in Drip rather than missing?

Development directors

Size the reach gap

Counts show how much of the donor base email is reaching.

What share of DonorPerfect donors over 1,000 are in Drip?

How it works

What PopdockAI does when you ask

You set a gift total and how many to check, and your AI assistant finds DonorPerfect donors Drip is not reaching. It only reads.

01

Ask

You set a minimum gift total, an optional state and how many donors to check.

Your AI tool

02

Read

It reads DonorPerfect donors with an email.

donorperfect-get-donor

03

Check

It looks each one up in Drip, ignoring case and spaces.

drip-get-subscriber

04

Report

You get missing donors by gift total, with unsubscribed people listed apart.

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

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

drip-get-subscriber

Returns Drip people (subscribers) with name, email, location, tags, status, GDPR consent, lead score and lifetime value. Filter by exact email, email domain, tag, status, country, minimum lead score, minimum lifetime value or date added.
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

A ranked list of donors email is not reaching

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