/
/
See which campaign clickers owe you money before you call
For sales teams who want to follow up Constant Contact clickers with their Wave balances and unpaid invoices in view, just by asking their AI assistant.
On this page
Connector
Connect Constant Contact, pick your AI tool and paste the prompt.
The problem
Warm leads get called without knowing what they owe
To follow up a campaign you export the clickers from Constant Contact, then look each one up in Wave to see balances and unpaid invoices. Skip a lookup and a lead with an overdue invoice gets a sales call that goes badly.
Without PopdockAI
- Export the clickers from Constant Contact
- Search Wave for each person one at a time
- Open each customer to find unpaid invoices
- Miss people whose names do not match exactly
With PopdockAI
- Clickers are grouped by email and each is looked up in Wave
- Balances and unpaid invoices appear beside each contact
- Contacts with no Wave customer are listed apart
- Read-only, with no currency mixing in totals
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For campaign `{campaign-id}` and Wave company `{company}`, find the contacts who clicked and show what each owes in Wave, so sales can follow up the warm ones (up to {max-records} clicks, default 50).
**Step 1: Clicks (constant-contact server)**
Call `constant-contact-get-campaign-click` with `campaign-id` = `{campaign-id}` and `max-records` = `{max-records}`. Keep `email-address`, `first-name`, `last-name`, `link-url` and `created-date`. Group by email.
**Step 2: Wave balances (wave-ai server)**
For each distinct email call `wave-get-customer` with `company` = `{company}` and `email` = that email. Keep `name`, `outstanding-amount`, `overdue-amount`, `currency-code`. If a customer is found, also call `wave-get-invoice` with `company` = `{company}`, `customer-name` = that name and `amount-due.min` = 0.01 to list unpaid invoices (`invoice-number`, `due-date`, `amount-due`, `status`).
**Step 3: Report**
Table: contact, clicks, links clicked, Wave customer name, outstanding, overdue, unpaid invoice numbers. Separate contacts with no Wave customer under "not a Wave customer".
**Rules & Guidelines:**
* `constant-contact-get-campaign-click` is on constant-contact; `wave-get-customer` and `wave-get-invoice` are on wave-ai.
* 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.
* Do not mix currencies in totals.
**Validation:**
* If there are no clicks, say so and stop.
* If `customer-name` matches more than one customer, list them and do not guess.Who it's for
One answer, three teams that use it
Sales reps
Call warm leads with context
See which clickers owe money before you dial, so you can lead with the right conversation instead of walking into an overdue invoice.
Which people clicked the Spring Sale campaign in Constant Contact and what do they owe in Wave for Contoso Ltd?
Account managers
Spot customers with overdue balances
Check whether customers who engaged with a campaign are behind on payments, so you can raise it with care.
For the Q4 Renewals campaign, show me the clickers who have overdue invoices in Wave.
Marketing managers
Keep campaign follow up sensible
See which engaged contacts have unpaid invoices so promotional follow up is coordinated with sales.
Take the first 100 clicks on the Holiday Offer campaign and tell me which clickers have outstanding Wave balances.
How it works
What PopdockAI does when you ask
You name the campaign and the Wave company, and your AI assistant does the lookups in both systems. It only reads, and lists ambiguous name matches rather than guessing.
Ask
You name a Constant Contact campaign and a Wave company.
Check
It reads the clicks grouped by email, then looks each person up in Wave for balances and unpaid invoices.
Report
You get a table of clickers with what each owes, and contacts that are not Wave customers listed apart.
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.
constant-contact-get-campaign-click
wave-get-customer
wave-get-invoice
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
Follow up with the full picture in view
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)
