/
/
See what email your overdue Wave customers still receive
For finance teams who want to know whether customers who owe money are still getting Constant Contact campaigns.
On this page
Connector
Connect Wave, pick your AI tool and paste the prompt.
The problem
Collections and promotions collide
A customer who owes money can still get a promotional campaign, because nobody compares the overdue list with the send history. Doing it by hand means checking each customer's emails one at a time.
Without PopdockAI
- List overdue customers in Wave
- Look up each customer in Constant Contact
- Open each send history by date
- Find the overlap by cross-checking lists
With PopdockAI
- Overdue customers above your threshold are listed from Wave
- Campaigns received since your date are read for each one
- Overlaps with large balances are flagged
- Currencies are never added and nothing is changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For the Wave company `{company}`, find customers whose overdue amount is at least `{min-overdue}` (default 1) and show what marketing email they received from Constant Contact since `{since-date}` (YYYY-MM-DD, default 30 days ago).
**Step 1: Overdue customers (wave-ai server)**
Call `wave-get-customer` with `company` = `{company}` and `overdue-amount.min` = `{min-overdue}`. Keep `name`, `email`, `overdue-amount`, `currency-code`.
**Step 2: Campaign sends (constant-contact server)**
For each customer with an email, call `constant-contact-get-campaign-send` with `email-address` = that email and `created-date.from` = `{since-date}`. Keep `campaign-id`, `campaign-activity-id` and `created-date`. Then call `constant-contact-get-campaign` with `campaign-id` to get the campaign `name`.
**Step 3: Report**
Table per customer: name, overdue amount and currency, number of campaigns received, campaign names with dates. Flag customers who got campaigns while owing a large balance, and customers with no email or no Constant Contact record.
**Rules & Guidelines:**
* `wave-get-customer` is on wave-ai; the `constant-contact-get-campaign-send` and `constant-contact-get-campaign` tools are on constant-contact.
* Never add up amounts across currencies.
* 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 is overdue, say so and stop.
* If a customer email returns no sends, report "no campaigns in the period" rather than an error.Who it's for
One answer, three teams that use it
Collections teams
Avoid chasing and promoting at once
See which overdue customers are also receiving campaigns before you make a collections call.
Show campaigns sent since 1 October to Wave customers who are overdue by more than 100, company Fabrikam Holdings.
Email marketers
Hold campaigns for customers who owe
Find overdue customers on your lists so you can pause promotions to them.
Which of our overdue Wave customers received the Autumn Sale campaign in Constant Contact?
Finance managers
Spot customers with a large balance still being sold to
Review high overdue balances alongside recent campaign sends to coordinate with marketing.
List customers overdue 1,000 or more in Wave and what Constant Contact campaigns they got in the last 30 days.
How it works
What PopdockAI does when you ask
You set the amount and date and your AI assistant reads Wave, then Constant Contact. It only reads, and it reports no campaigns rather than an error when there are none.
Ask
You give the Wave company, a minimum overdue amount and a start date.
Collect
It lists Wave customers whose overdue amount meets your minimum.
Check
It reads the Constant Contact campaigns each customer received since the date.
Report
It tables campaigns per customer and flags overlaps, missing emails and missing records.
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.
wave-get-customer
constant-contact-get-campaign-send
constant-contact-get-campaign
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
Collections and marketing on the same page
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)
