/
/
Find store customers to consider for donor outreach
For fundraising teams who want online store buyers who are not yet constituents, with marketing consent clear, by asking their AI assistant.
On this page
Connector
Connect Mailchimp, pick your AI tool and paste the prompt.
The problem
Store buyers your donor database has never seen
People who buy from your online store are good candidates for giving, but their details sit in the Mailchimp store, not in Bloomerang. Working out who is new means comparing emails with constituents by hand and checking marketing consent.
Without PopdockAI
- Export store customers and their spend
- Search Bloomerang for each email
- Note name differences on matches
- Check who agreed to marketing email
With PopdockAI
- Store customers are read with orders, spend and opt in
- Each email is looked up in Bloomerang
- Missing customers are listed by spend, name mismatches apart
- Consent is made clear and no constituents are created
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** List e-commerce customers from the stores connected to Mailchimp who have spent at least `{min-total-spent}` (default 0) and have no constituent in Bloomerang, so they can be considered for donor outreach.
**Step 1: Read the store customers**
Call `mailchimp-get-customer` with `total-spent.min` set to `{min-total-spent}` (leave it out if blank) and a high `max-records`. Keep first-name, last-name, email, company, city, country, orders-count, total-spent and opt-in-status.
**Step 2: Look each one up in Bloomerang**
For each customer with an email call `bloomerang-get-email-address` with `value` set to the email. If it returns an `account-id`, the customer is already a constituent; call `bloomerang-get-constituent` with `id` to confirm the name. If nothing comes back, the customer is not in Bloomerang.
**Step 3: Report**
Two tables. First, customers not in Bloomerang sorted by total-spent: name, email, company, city, orders-count, total-spent, opt-in-status. Second, customers already in Bloomerang whose name differs from the constituent's. End with counts read, already constituents and not constituents.
**Rules & Guidelines:**
* `mailchimp-get-customer` is on the mailchimp server; `bloomerang-get-email-address` and `bloomerang-get-constituent` are on the bloomerang server.
* Read-only. Do NOT call `bloomerang-add-constituent` or `bloomerang-add-email-address`. If the user then asks to create constituents, confirm the list with them first and create one at a time.
* Point out customers whose opt-in-status is false: they have not agreed to marketing email.
**Validation:**
* If no store customers come back, call `mailchimp-get-store` to show whether any store is connected, and stop.
* Match emails case-insensitively.Who it's for
One answer, three teams that use it
Development officers
Find new prospects among buyers
Store customers missing from Bloomerang are ranked by spend, a ready list to consider for outreach.
Which Mailchimp store customers who spent over 250 are not Bloomerang constituents?
Database managers
Fix names that do not match
Customers already in Bloomerang under a different name are listed separately for review.
Show Mailchimp store customers who are in Bloomerang but under a different name.
Communications managers
Respect consent in outreach
Anyone who has not opted in to marketing is pointed out before you plan contact.
List our Mailchimp store buyers missing from Bloomerang and tell me which have opted in to marketing.
How it works
What PopdockAI does when you ask
You optionally set a minimum spend, and your AI assistant checks your store customers against Bloomerang. It only reads.
01
Ask
You optionally set a minimum amount spent.
02
Read
It reads store customers from Mailchimp with orders, spend and opt-in status.
03
Check
Each email is looked up in Bloomerang.
04
Report
You get customers not in Bloomerang by spend, plus name mismatches.
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.
mailchimp-get-customer
bloomerang-get-email-address
bloomerang-get-constituent
mailchimp-get-store
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
A ranked list of store buyers to consider
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)
