Connectors

/

Wave

/

Wave overdue customers and recent Constant Contact campaigns
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Wave overdue customers and recent Constant Contact campaigns
Which Wave customers with at least 200 overdue got Constant Contact campaigns in the last 30 days?
3 of 5 overdue customers received campaigns while owing 200 or more. - Contoso: 640.00 USD overdue, 2 campaigns (Autumn Sale, 2026-10-12) - Fabrikam: 450.00 USD overdue, 1 campaign (Newsletter, 2026-10-20) - Northwind Traders: 300.00 USD overdue, 3 campaigns - Adventure Works: no email on file Want me to list all campaign dates for Contoso?
Wave
Sample figures. Your results come from your own account.
wave-get-customer
constant-contact-get-campaign-send
constant-contact-get-campaign

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

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.

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

Your AI tool

Collect

It lists Wave customers whose overdue amount meets your minimum.

wave-get-customer
constant-contact-get-campaign-send
constant-contact-get-campaign

Check

It reads the Constant Contact campaigns each customer received since the date.

No items found.

Report

It tables campaigns per customer and flags overlaps, missing emails and missing records.

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-campaign-send

Returns who each Constant Contact campaign was sent to. Filter by campaign, campaign activity, contact, email address or domain and date.
get-data

constant-contact-get-campaign

Returns Constant Contact email campaigns with their status and headline counts: sends, opens, not opened, clicks, bounces, forwards and opt-outs. Filter by name, status, type and last sent 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

Collections and marketing on the same page

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