Connectors

/

Constant Contact

/

Reconcile Constant Contact contacts with Bloomerang constituents
Report
Cross-Connector

Find where Constant Contact and Bloomerang disagree

For data and fundraising operations teams who want contacts checked against Bloomerang constituents by email, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Constant Contact contacts with Bloomerang constituents
Reconcile our Donors list in Constant Contact with Bloomerang constituents.
Of 480 contacts, 37 have no constituent and 22 disagree. - No constituent: 37 contacts - Bad address still mailed: 4, such as jordan@contoso.com - Different phone: 11 - Shared email: 2 addresses on several accounts Want the list of proposed fixes?
Constant Contact
Sample figures. Your results come from your own account.
constant-contact-get-contact-list-member
constant-contact-get-contact
bloomerang-get-email-address
bloomerang-get-constituent

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

Bad donor addresses are still being mailed

Over time Constant Contact and Bloomerang drift apart: contacts with no constituent, names and phones that differ, and addresses Bloomerang knows are bad still being mailed. Comparing them contact by contact is slow, so it rarely happens.

Without PopdockAI

  • Export a list from Constant Contact
  • Search Bloomerang for each email
  • Check every address on the constituent
  • Compare names and phones by eye

With PopdockAI

  • Each email is matched using every address on a constituent
  • Contacts with no constituent are listed
  • Shared emails are flagged without picking one
  • Name, phone, employer and email status are compared, nothing 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:** Compare Constant Contact contacts (members of the contact list {list-name}, or all contacts if no list is given) against Bloomerang constituents, matching on email address. Report who is in Constant Contact but not Bloomerang, and where matched records disagree. Check at most {max-records} contacts (default 200).

**Step 1: Read the Constant Contact contacts**

If a list name was given, call `constant-contact-get-contact-list-member` with `list-name` set to it. If nothing comes back, retry with `list-name.contains`; if that matches more than one list, show the list names and stop. If no list was given, call `constant-contact-get-contact`. Pass `max-records` either way. Keep each contact's email-address, first-name, last-name, contact-id and permission-to-send, plus phone-number and company-name when the contact read returns them.

**Step 2: Find each contact in Bloomerang**

For each email-address, call `bloomerang-get-email-address` with `value` set to it. If a record comes back, take its account-id and call `bloomerang-get-constituent` with `id` set to that account-id. If no email record comes back, try `bloomerang-get-constituent` with `primary-email` set to the email. If both come back empty, mark the contact as In Constant Contact only and continue. If the email belongs to more than one account-id, mark it Shared email, list the accounts, and do not pick one.

**Step 3: Compare the matched records**

For each match, compare:

* first-name and last-name against the constituent's first-name and last-name
* phone-number against primary-phone (compare digits only)
* company-name against employer
* the Bloomerang email record's bad flag: a bad email that Constant Contact can still send to (permission-to-send is not unsubscribed) is a difference
* a contact unsubscribed in Constant Contact whose constituent status is Active (report it, it is not an error)

Blank on one side and filled on the other counts as a difference. Blank on both sides does not.

**Step 4: Report**

1. Counts: contacts checked, matched, In Constant Contact only, Shared email, matched with differences.
2. A table of In Constant Contact only contacts: email, first name, last name.
3. A table of differences: email, field, Constant Contact value, Bloomerang value, Bloomerang account-id.
4. One line stating this check runs from the Constant Contact side, so Bloomerang constituents who are not in Constant Contact are not listed.

**Rules & Guidelines:**

* Constant Contact tools: `constant-contact-get-contact`, `constant-contact-get-contact-list-member`. Bloomerang tools: `bloomerang-get-email-address`, `bloomerang-get-constituent`.
* This prompt is read-only. Do not call `constant-contact-add-contact`, `constant-contact-update-contact`, `bloomerang-add-constituent`, `bloomerang-update-constituent`, `bloomerang-add-email-address` or `bloomerang-update-email-address`. If the user asks for fixes, list the proposed changes and stop.
* 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 Constant Contact returns no contacts, say so and stop.
* If a Bloomerang call fails partway through, report the contacts already checked and say how many were not.

Who it's for

One answer, three teams that use it

Donor database managers

Find mismatches without exports

Names, phones, employers and email status are compared for you.

Reconcile our Monthly Donors list in Constant Contact with Bloomerang.

Development operations

Stop mailing bad addresses

Addresses Bloomerang marks bad but that can still receive mail are called out.

Which Constant Contact contacts have an email Bloomerang marks as bad?

Data analysts

Spot contacts with no donor record

Contacts with no constituent are listed for review.

Check up to 500 Constant Contact contacts against Bloomerang and list those with no constituent.

How it works

What PopdockAI does when you ask

You name a list and your AI assistant matches its contacts to Bloomerang constituents and compares the details. It only reads and lists proposed fixes.

01

Ask

You name a list, or check all contacts up to a limit.

Your AI tool

02

Match

It matches each email to Bloomerang using every address on a constituent.

constant-contact-get-contact-list-member
constant-contact-get-contact
bloomerang-get-email-address
bloomerang-get-constituent

03

Compare

It compares name, phone, employer and email status on matches.

No items found.

04

Report

You get mismatches and proposed fixes, 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

constant-contact-get-contact-list-member

Returns the members of Constant Contact contact lists with their email permission. Filter by list name or ID, contact, email address and permission.
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

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

A clean-up list for your email and donor systems

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