Connectors

/

Constant Contact

/

Constant Contact campaign clickers with open Wave invoices
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Constant Contact campaign clickers with open Wave invoices
Who clicked the October Product Update campaign in Constant Contact, and do any of them have unpaid invoices in Wave for Northwind Traders?
12 people clicked the campaign, and 3 of them have unpaid invoices in Wave. - Dana Whitfield: 2 clicks, outstanding 1,450.00 USD, overdue 600.00 USD, invoices INV-1042 and INV-1051 - Priya Shah: 1 click, outstanding 320.00 USD, invoice INV-1060 - Tom Reyes: 3 clicks, nothing outstanding - Not a Wave customer: 4 contacts Want the full table of all 12 clickers?
Constant Contact
Sample figures. Your results come from your own account.
constant-contact-get-campaign-click
wave-get-customer
wave-get-invoice

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

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.

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

Your AI tool

Check

It reads the clicks grouped by email, then looks each person up in Wave for balances and unpaid invoices.

constant-contact-get-campaign-click
wave-get-customer
wave-get-invoice

Report

You get a table of clickers with what each owes, and contacts that are not Wave customers listed apart.

No items found.

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

Returns Constant Contact campaign clicks with the link clicked and the device used. Filter by campaign, campaign activity, contact, email address or domain, device type and date.
get-data

wave-get-customer

Returns customers from Wave. Wave connector tool; filter by the parameters it offers.
get-data

wave-get-invoice

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

Follow up with the full picture in view

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