Connectors

/

Wave

/

Wave customers with balances who unsubscribed from Constant Contact
Report
Cross-Connector

Find customers who owe money and unsubscribed from email

For finance teams who want to know which Wave customers with balances opted out of Constant Contact, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Wave customers with balances who unsubscribed from Constant Contact
Which customers in our Wave company Fabrikam Holdings owe us more than 100 and are unsubscribed from Constant Contact?
2 of 7 customers with balances over 100 have unsubscribed from Constant Contact. - Contoso: 640.00 USD, unsubscribed 2026-08-14, reason too many emails - Northwind Traders: 310.00 USD, unsubscribed 2026-09-02 - Not a contact: Adventure Works, no email on file for one more - Subscribed: 3 customers Want me to list the invoices to remind them about directly?
Wave
Sample figures. Your results come from your own account.
wave-get-customer
constant-contact-get-contact
constant-contact-get-campaign-unsubscribe

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Wave

Wave
Run it on your own Wave data.

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

Try PopdockAI free

The problem

Customers who opted out never see your reminders

Reminders sent through Constant Contact skip anyone who unsubscribed, and nobody checks who owes money. Finding them means matching Wave balances to Constant Contact status email by email.

Without PopdockAI

  • List Wave customers with outstanding balances
  • Search each email in Constant Contact
  • Open each unsubscribe record for the reason and date
  • Notice too late that reminders never arrived

With PopdockAI

  • Customers above your balance threshold are listed from Wave
  • Each email is checked in Constant Contact
  • Unsubscribe reason and date are shown
  • Direct invoice reminders are recommended and nothing is sent

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 Wave company `{company}`, list customers with an outstanding balance of at least `{min-outstanding}` (default 1) who are not subscribed in Constant Contact.

**Step 1: Customers with balances (wave-ai server)**

Call `wave-get-customer` with `company` = `{company}` and `outstanding-amount.min` = `{min-outstanding}`. Keep `name`, `email`, `outstanding-amount`, `overdue-amount`, `currency-code`.

**Step 2: Subscription state (constant-contact server)**

For each customer email call `constant-contact-get-contact` with `email-address` = that email and read `permission-to-send`. For contacts that are not subscribed also call `constant-contact-get-campaign-unsubscribe` with `email-address` = that email and keep `reason` and `created-date`.

**Step 3: Report**

Table: customer, email, balance and currency, Constant Contact status (subscribed, unsubscribed, not a contact), unsubscribe date and reason. Recommend a direct invoice reminder from Wave for the unsubscribed ones; do not suggest marketing email.

**Rules & Guidelines:**

* `wave-get-customer` is on wave-ai; `constant-contact-get-contact` and `constant-contact-get-campaign-unsubscribe` are on constant-contact.
* Read-only. Do NOT call `wave-add-customer`, `wave-update-customer`, `wave-delete-customer`, `wave-add-invoice`, `wave-update-invoice`, `wave-delete-invoice`, `wave-send-invoice`, `wave-add-invoice-payment` or any other Wave write tool, or `constant-contact-add-contact`, `constant-contact-update-contact`, `constant-contact-add-campaign`, `constant-contact-resend-campaign-to-non-openers` or any other Constant Contact write tool.

**Validation:**

* If no customer has a balance, say so and stop.
* If a customer has no email, list them as "no email on file".

Who it's for

One answer, three teams that use it

Accounts receivable

Send reminders by a channel that works

Know who cannot receive marketing email so you send invoice reminders directly instead.

List Wave customers owing over 50 who are unsubscribed in Constant Contact, company Northwind Traders.

Finance managers

See how much is stuck behind opt outs

Size the balance held by customers who unsubscribed so you can plan collections.

How much do unsubscribed Constant Contact contacts owe us in Wave for Fabrikam Holdings?

Email marketers

Keep promotions away from people who owe

Know which customers opted out and owe money so campaigns and collections do not collide.

Which Wave customers with a balance are not subscribed in Constant Contact, and why did they unsubscribe?

How it works

What PopdockAI does when you ask

You give the Wave company and your AI assistant reads Wave, then Constant Contact. It only reads, and it never suggests marketing email to unsubscribed people.

Ask

You give the Wave company and optionally a minimum balance.

Your AI tool

Collect

It lists Wave customers with an outstanding balance at or above that amount.

wave-get-customer
constant-contact-get-contact
constant-contact-get-campaign-unsubscribe

Check

It looks up each email in Constant Contact and reads the unsubscribe reason and date.

No items found.

Report

It tables status per customer and recommends direct invoice reminders for the unsubscribed.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

wave-get-customer

Returns customers from Wave. Wave connector tool; filter by the parameters it offers.
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-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 Wave 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

Reminders that reach the people who owe

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation