/
/
Know which major Bloomerang donors Constant Contact actually reaches
For fundraising leaders who want to see which top donors are engaged, unsubscribed, bouncing or missing from Constant Contact, by asking their AI.
On this page
Connector
Connect Bloomerang, pick your AI tool and paste the prompt.
The problem
Your largest donors may not be getting your emails
Your largest donors should be reachable by email, but some unsubscribed, some bounce and some were never added to Constant Contact. Finding out means checking each major donor's addresses one by one and whether they open anything.
Without PopdockAI
- List major donors in Bloomerang
- Check every address in Constant Contact
- Look for bounces and unsubscribes
- Guess who is actually reading
With PopdockAI
- Qualifying donors are found and their giving totalled
- Every address on each record is checked in Constant Contact
- Each donor lands in one group, engaged to no email
- Groups are sorted by total given, and nothing is changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For Bloomerang donors with at least one gift of {min-amount} or more in the last {lookback-days} days (default 365), report whether Constant Contact can reach them and whether they are engaging.
**Step 1: Find the donors in Bloomerang**
Call `bloomerang-get-transaction` with `amount.min` and `date.from` set to today minus the lookback days. Skip refunded transactions. Group by account-id and total each donor's gifts in the window. For each account-id, call `bloomerang-get-constituent` with `id` for full name, account number, status and engagement score, and `bloomerang-get-email-address` with `account-id` for every address and its bad flag.
**Step 2: Check each address in Constant Contact**
For each email, call `constant-contact-get-contact` with `email-address`. If found, keep permission-to-send and contact-id, then with `created-date.from` set to the same start date call `constant-contact-get-campaign-bounce` and `constant-contact-get-contact-activity` with `contact-id`.
**Step 3: Classify each donor**
Use the best of the donor's addresses:
* Engaged: can be emailed and has opens or clicks in the window
* Not engaging: can be emailed, no opens or clicks
* Unsubscribed: permission-to-send is unsubscribed on every matched address
* Bouncing: every matched address has bounced, or is flagged bad in Bloomerang
* Not in Constant Contact: has an email in Bloomerang that Constant Contact does not have
* No email: no email address in Bloomerang
**Step 4: Report**
Counts per group, then one table per group: full name, account number, total given in the window, email, most recent open or click date. Sort each table by total given, largest first. Close with one line noting that donors Not in Constant Contact can be added with the sync-donors-to-constant-contact prompt.
**Rules & Guidelines:**
* Bloomerang tools: `bloomerang-get-transaction`, `bloomerang-get-constituent`, `bloomerang-get-email-address`. Constant Contact tools: `constant-contact-get-contact`, `constant-contact-get-campaign-bounce`, `constant-contact-get-contact-activity`.
* This prompt is read-only. Do not call `constant-contact-add-contact`, `constant-contact-update-contact`, `bloomerang-add-task` or `bloomerang-add-interaction`.
* The minimum applies to single gifts, not to a donor's total. Say so in the report.
* Match emails case-insensitively after trimming spaces. Never match on name alone.
* The Bloomerang constituent `id` is the same number every other Bloomerang tool takes as `account-id`.
**Validation:**
* If no gifts meet the minimum, say so and stop.
* If more than 100 donors qualify, process the largest givers first and report how many were not checked.Who it's for
One answer, three teams that use it
Executive directors
Know who needs a personal touch
Donors who are unsubscribed, bouncing or missing need a call instead of an email.
Which donors who gave 2,500 or more this year can we not reach through Constant Contact?
Communications managers
Fix bouncing addresses
Bouncing donors are grouped, so you can update addresses before the next appeal.
Which major Bloomerang donors have bouncing addresses in Constant Contact?
Major gift officers
See who is engaging
Engaged and not engaging groups show which donors read your emails.
Of donors with a 1,000 gift in the last 18 months, who engages with our Constant Contact emails?
How it works
What PopdockAI does when you ask
You set a minimum gift and a look-back period, and your AI assistant checks how well Constant Contact reaches your major Bloomerang donors. It matches on email, never name.
01
Ask
You set a minimum single gift and a look-back period.
02
Find
It finds qualifying Bloomerang donors and totals their giving.
03
Check
It checks every address in Constant Contact for status and activity.
04
Report
You get counts and a table per group, largest givers first.
What PopdockAI provides
The tools behind the answer
Ready made tools for Bloomerang and one secure connection to your AI tool. No code, no exports.
bloomerang-get-transaction
bloomerang-get-constituent
bloomerang-get-email-address
constant-contact-get-contact
constant-contact-get-campaign-bounce
constant-contact-get-contact-activity
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 major donors your emails reach
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)
