Connectors

/

Mailchimp

/

Mailchimp engagement for a Bloomerang donor
Report
Cross-Connector

See a donor's emails and gifts on one timeline

For fundraisers who want to know whether a donor reads your emails, across all their addresses, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Mailchimp engagement for a Bloomerang donor
How does donor Jordan Lee engage with our Mailchimp emails, and how does that line up with their giving?
Jordan Lee has 2 email addresses in Bloomerang. - Warning: the work address hard bounced on October 2 - Personal address: subscribed, 41 percent open rate - Activity: opened the Spring Appeal, then gave 250 two days later - Giving: 3 gifts totalling 600 in 90 days Gifts seem to follow email engagement. Want the full timeline?
Mailchimp
Sample figures. Your results come from your own account.
bloomerang-get-constituent
bloomerang-get-email-address
mailchimp-get-list-member
mailchimp-get-campaign-email-activity
mailchimp-get-campaign-unsubscribe
bloomerang-get-transaction

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Mailchimp

Mailchimp
Run it on your own Mailchimp data.

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

Try PopdockAI free

The problem

A donor's emails and gifts in two different systems

To know whether a donor reads your newsletters you need Mailchimp, and to see their gifts you need Bloomerang. A donor with several addresses makes it harder, because the bounce may sit on the address you did not check.

Without PopdockAI

  • Find the donor and their addresses in Bloomerang
  • Search Mailchimp for each address
  • Check status, opens, bounces and unsubscribes
  • Line up email activity with gifts by hand

With PopdockAI

  • The constituent is found, asking if several match
  • Every good address is checked in Mailchimp
  • Recent gifts are read and merged on one timeline
  • Unsubscribes and hard bounces show first, read only

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Show how the Bloomerang constituent `{constituent}` (a name or an email address) engages with Mailchimp email, next to their giving, over the last `{lookback-days}` days (default 90).

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

If `{constituent}` contains `@`, call `bloomerang-get-constituent` with `primary-email`; if that returns nothing, call `bloomerang-get-email-address` with `value` and then `bloomerang-get-constituent` with `id` set to the `account-id` it returns. Otherwise call `bloomerang-get-constituent` with `full-name.contains`. If more than one constituent matches, list them (id, full-name, primary-email, city) and stop.

**Step 2: Collect every email address**

Call `bloomerang-get-email-address` with `account-id` set to the constituent's id. Use every address that is not flagged bad.

**Step 3: Read Mailchimp for each address**

For each address call `mailchimp-get-list-member` with `email` (audience, status, rating, average-open-rate, average-click-rate, tags), then `mailchimp-get-campaign-email-activity` with `email-address` and `activity-date.from` set to today minus the lookback (opens, clicks and bounces), and `mailchimp-get-campaign-unsubscribe` with `email`. If an address is in no audience, say so and continue.

**Step 4: Read Bloomerang giving**

Call `bloomerang-get-transaction` with `account-id` and `date.from` set to the same start date.

**Step 5: Report**

A short profile (name, id, engagement-score, emails), a table of audience memberships with status and rates, a dated timeline merging email activity and gifts, and one sentence on whether gifts follow email engagement.

**Rules & Guidelines:**

* Tools starting mailchimp- are on the mailchimp server; tools starting bloomerang- are on the bloomerang server.
* Read-only. Do NOT call `mailchimp-add-list-member`, `mailchimp-update-list-member`, `bloomerang-add-interaction` or `bloomerang-add-note`.

**Validation:**

* If the constituent has no email address, report their giving only and say Mailchimp could not be checked.
* Match emails case-insensitively.
* If Mailchimp shows an unsubscribe or hard bounce, put it at the top of the report.

Who it's for

One answer, three teams that use it

Major gift officers

Know how a donor wants to hear from you

See whether a donor reads your email before deciding to call, write or email.

How does donor Priya Shah engage with our Mailchimp emails, and when did she last give?

Development coordinators

Find the address that bounced

Every address is checked, so a bounce or unsubscribe on a second address is not missed.

Check every email address for Bloomerang donor Tom Reyes in Mailchimp and flag any bounce.

Communications managers

See if appeals line up with gifts

The timeline shows whether gifts follow email activity for this donor.

Show a timeline of Mailchimp activity and Bloomerang gifts for sam.patel@contoso.com.

How it works

What PopdockAI does when you ask

You give the donor's name or email, and your AI assistant brings their email engagement and giving together. It only reads.

01

Ask

You give the donor's name or email.

Your AI tool

02

Find

It finds the constituent in Bloomerang and collects every address not flagged bad.

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

03

Read

Each address is checked in Mailchimp, and recent gifts are read.

mailchimp-get-list-member
mailchimp-get-campaign-email-activity
mailchimp-get-campaign-unsubscribe
bloomerang-get-transaction

04

Report

You get a profile, an audience table and a timeline of email and gifts.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Mailchimp 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

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.
get-data

mailchimp-get-campaign-email-activity

Returns each member's open, click and bounce events for Mailchimp campaigns, with timestamps and the URLs they clicked.
get-data

mailchimp-get-campaign-unsubscribe

Returns the members who unsubscribed from each Mailchimp campaign, with the date and the reason they gave.
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.
Read only.Nothing in Mailchimp 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

Email engagement and giving on one timeline

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