Connectors

/

Constant Contact

/

Constant Contact engagement for a Bloomerang donor
Report
Cross-Connector

See whether a donor is hearing from you, next to their giving

For fundraisers who want a Bloomerang donor's email engagement across every address they hold, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Constant Contact engagement for a Bloomerang donor
Is Jordan Lee from the Contoso Foundation reading our emails? Show it next to her giving in Bloomerang.
Jordan Lee is reachable on one of two addresses and opens most appeals. - jordan@contosofoundation.org: opened 5 of 6 campaigns - jlee@contoso.com: hard bounced, flagged bad in Bloomerang - Giving: 3 gifts in 90 days, 1,500 total Want the engagement by campaign?
Constant Contact
Sample figures. Your results come from your own account.
bloomerang-get-constituent
bloomerang-get-email-address
bloomerang-get-transaction
constant-contact-get-contact
constant-contact-get-contact-activity
constant-contact-get-campaign-bounce
constant-contact-get-campaign-unsubscribe

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Constant Contact

Constant Contact
Run it on your own Constant Contact data.

Connect Constant Contact, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Checking one donor address misses the others

Whether a donor reads your emails is in Constant Contact while their giving is in Bloomerang. Donors often have several addresses, so checking one misses bounces, unsubscribes and activity on the rest.

Without PopdockAI

  • Find the donor in Bloomerang
  • Copy each email address on the record
  • Search Constant Contact for every one
  • Line up engagement with giving by hand

With PopdockAI

  • The constituent is found, with every address and its bad flag
  • Each address is checked for permission and activity
  • Recent gifts are read without refunds
  • Conflicts are shown side by side, and nothing changes

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 the Bloomerang donor {donor}, show their Constant Contact email engagement and their Bloomerang giving over the last {lookback-days} days (default 90).

**Step 1: Find the donor in Bloomerang**

If the donor value contains @, call `bloomerang-get-constituent` with `primary-email` set to it; if that is empty, call `bloomerang-get-email-address` with `value` set to it and then `bloomerang-get-constituent` with `id` set to the returned account-id. If the value is all digits, call `bloomerang-get-constituent` with `account-number`. Otherwise call `bloomerang-get-constituent` with `full-name.contains`. If more than one constituent matches, list them (full name, account number, primary email) and stop. If none match, say so and stop.

**Step 2: Read the Bloomerang side**

Using the constituent's `id` as `account-id`:

* call `bloomerang-get-email-address` to collect every email address on the record, with its bad flag
* call `bloomerang-get-transaction` with `date.from` set to today minus the lookback days

**Step 3: Find the donor in Constant Contact**

For each email address, call `constant-contact-get-contact` with `email-address` set to it. If none of the addresses is in Constant Contact, report the Bloomerang side, say the donor is not in Constant Contact, and stop.

**Step 4: Read the Constant Contact activity**

For each matched contact-id, with `created-date.from` set to the same start date:

* call `constant-contact-get-contact-activity` for opens and clicks
* call `constant-contact-get-campaign-bounce` for bounces
* call `constant-contact-get-campaign-unsubscribe` for unsubscribes

**Step 5: Report**

1. Donor: full name, account number, status, engagement score.
2. Email reach: each address, whether it is in Constant Contact, permission-to-send, Bloomerang bad flag, any bounce (type and date), any unsubscribe (date and reason).
3. Engagement: opens and clicks by campaign-activity-name, with the most recent date of each.
4. Giving: each gift (date, amount, method) and the total, excluding refunded gifts.
5. One factual sentence connecting the two, such as opened 5 emails and gave twice. Do not claim one caused the other.

**Rules & Guidelines:**

* Bloomerang tools: `bloomerang-get-constituent`, `bloomerang-get-email-address`, `bloomerang-get-transaction`. Constant Contact tools: `constant-contact-get-contact`, `constant-contact-get-contact-activity`, `constant-contact-get-campaign-bounce`, `constant-contact-get-campaign-unsubscribe`.
* This prompt is read-only. Do not call `bloomerang-add-interaction`, `bloomerang-add-note`, `bloomerang-add-task`, `constant-contact-update-contact` or `constant-contact-add-contact-note`.
* 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:**

* No activity in the window is a valid result: report it as no opens or clicks, not as an error.
* If an address is flagged bad in Bloomerang but Constant Contact shows recent opens from it, report both facts side by side.

Who it's for

One answer, three teams that use it

Major gift officers

Prepare for a donor conversation

Giving and email engagement together tell you how connected a donor feels.

Is Sam Patel from Fabrikam opening our appeals in Constant Contact? Show his recent gifts too.

Development directors

Spot donors you cannot reach

Bounced or unsubscribed addresses on a valuable donor show up before an appeal goes out.

Check every email on Bloomerang account 10452 for bounces and unsubscribes in Constant Contact.

Database managers

Find records that disagree

A bad flag on an address that still opens email is shown so you can correct it.

Do any of Dana Whitfield's Bloomerang email addresses conflict with what Constant Contact shows?

How it works

What PopdockAI does when you ask

You name the donor and your AI assistant checks every address on the Bloomerang record in Constant Contact. It only reads.

01

Ask

You give the donor's name, email or account number.

Your AI tool

02

Donor

It finds the constituent and every address on the record, with recent gifts.

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

03

Email

It checks each address in Constant Contact for permission and activity.

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

04

Report

You get reach per address, engagement and giving, with nothing changed.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Constant Contact and one secure connection to your AI tool. No code, no exports.

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

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

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-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.
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-campaign-unsubscribe

Returns Constant Contact campaign unsubscribes with the reason given. Filter by campaign, campaign activity, contact, email address or domain, reason and date.
Read only.Nothing in Constant Contact 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 whether a donor is hearing from you

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