Connectors

/

Bloomerang

/

Check Bloomerang major donor reach in Constant Contact
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Check Bloomerang major donor reach in Constant Contact
Which of our donors with a gift of 1,000 or more this year can Constant Contact reach?
86 donors gave a single gift of 1,000 or more in the last 365 days. - Engaged: 41 opened or clicked recently - Not engaging: 22, emailable but no opens - Unsubscribed: 7, including Contoso Foundation - Bouncing: 5, and not in Constant Contact: 8, no email: 3 Want the table for the unsubscribed group?
Bloomerang
Sample figures. Your results come from your own account.
bloomerang-get-transaction
bloomerang-get-constituent
bloomerang-get-email-address
constant-contact-get-contact
constant-contact-get-campaign-bounce
constant-contact-get-contact-activity

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Bloomerang

Bloomerang
Run it on your own Bloomerang data.

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

Try PopdockAI free

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.

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

Your AI tool

02

Find

It finds qualifying Bloomerang donors and totals their giving.

bloomerang-get-transaction
bloomerang-get-constituent
bloomerang-get-email-address

03

Check

It checks every address in Constant Contact for status and activity.

constant-contact-get-contact
constant-contact-get-campaign-bounce
constant-contact-get-contact-activity

04

Report

You get counts and a table per group, largest givers first.

Your AI tool

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.

get-data

bloomerang-get-transaction

Returns gift transactions from Bloomerang. Filter by date range, amount range, payment method, transaction number, or whether the gift has been refunded.
get-data

bloomerang-get-constituent

Returns constituents from Bloomerang: the donors, prospects and contacts in your database. Filter by full name, last name, account number, primary email, city, type or status, or fetch one by id.
get-data

bloomerang-get-email-address

Returns constituent email addresses from Bloomerang. Filter by address, type or primary flag, and include or exclude addresses flagged bad.
get-data

constant-contact-get-contact

Returns Constant Contact contacts with their name, email, company, job title, phone, location, tags and email permission. Filter by email address or domain, last name, company, state, permission and created date.
get-data

constant-contact-get-campaign-bounce

Returns Constant Contact campaign bounces with the bounce type. Filter by campaign, campaign activity, contact, email address or domain, bounce type and date.
get-data

constant-contact-get-contact-activity

Returns a Constant Contact contact's email activity timeline, such as opens, clicks and bounces. Filter by contact, email address, campaign activity, activity type and date.
Read only.Nothing in Bloomerang 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 major donors your emails reach

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