/
/
Find Rillet billing emails that bounce in Constant Contact
For finance teams who want to know which Rillet customers' billing addresses bounced or unsubscribed, so invoices are not going unread.
On this page
Connector
Connect Rillet, pick your AI tool and paste the prompt.
The problem
Invoices go to billing addresses that have stopped working
When a customer's billing address in Rillet starts bouncing, invoices and reminders go unread and the balance quietly ages. Constant Contact already knows which addresses bounce, but nobody compares it with the addresses finance uses.
Without PopdockAI
- Export bounce and unsubscribe reports from Constant Contact
- Match them to Rillet customer emails by hand
- Look up each customer's balance and invoice settings
- Miss the dead address until the balance is old
With PopdockAI
- Bounces and unsubscribes collected for your look-back period
- Exact email matches only, never on name or domain
- Amount due, overdue status and invoice settings for each match
- Hard bounces first, and nothing changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find Rillet customers whose email address has bounced or unsubscribed in Constant Contact in the last `{lookback-days}` days (default 90), because invoices and payment reminders sent to that address are likely not being read.
**Step 1: Collect bad addresses from Constant Contact**
Call `constant-contact-get-campaign-bounce` (constant-contact server) with `created-date.from` set to today minus the lookback. Keep `email-address`, `bounce-type`, `created-date` and `contact-id`. Then call `constant-contact-get-campaign-unsubscribe` (constant-contact server) with the same date filter and keep `email-address`, `reason` and `created-date`. If an address appears more than once, keep its most recent event.
If both calls return nothing, report that no bounces or unsubscribes were found in the window and stop.
**Step 2: Match them to Rillet customers**
Call `rillet-get-customer-emails` (rillet server) once. It takes no filters, so match locally: an address matches when `email` equals the Constant Contact `email-address`, ignoring case and surrounding spaces. Never match on name or domain alone. Keep `customer-id`, `name`, `email-type` and `payment-terms` for each match.
Addresses with no Rillet match are marketing-only contacts. Count them but do not list them.
**Step 3: Add billing context**
Call `rillet-get-customers` (rillet server) and, for each matched `customer-id`, note `send-invoices-automatically` and `send-payment-reminders`. Call `rillet-get-invoices` (rillet server) and total `amount-due` per matched customer by `currency`, noting whether any invoice has `overdue` true.
**Step 4: Report**
A table sorted with hard bounces first, then by amount due descending:
| Customer | Customer ID | Email | Email type | Problem (bounce type or unsubscribe) | Event date | Sends invoices automatically | Amount due | Overdue |
Follow it with: the number of matched customers, how many of them have overdue invoices, and the count of unmatched addresses. Recommend confirming a new billing email with each customer that has a hard bounce and an overdue balance.
**Rules & Guidelines:**
* Tools starting constant-contact- are on the constant-contact server; tools starting rillet- are on the rillet server.
* An unsubscribe means the person opted out of marketing, not that the address is dead. Label it as such and do not treat it as an undeliverable address.
* This prompt is read-only. Do not call `rillet-update-customer`, `rillet-set-invoice-sent-status` or any other rillet-add-* or rillet-update-* tool, and do not call `constant-contact-update-contact`, `constant-contact-add-contact-note` or any other constant-contact-add-* or constant-contact-update-* tool.
**Validation:**
* If no bounced or unsubscribed address matches a Rillet customer, say so and stop after giving the counts.
* If one address belongs to several Rillet customers, list each customer on its own row.Who it's for
One answer, three teams that use it
Accounts receivable
Find invoices that are going unread
See which customers have a bouncing billing address and money overdue, so you can confirm a new one.
Which Rillet customers with overdue invoices have billing emails that hard bounced in Constant Contact?
Billing operations
Keep billing contacts current
Check bounces against billing emails on a regular cycle so dead addresses are caught early.
Check the last 30 days of Constant Contact bounces against our Rillet billing emails.
Email marketers
Tell finance about dead addresses
Hand finance a clear list of bouncing customer addresses, with unsubscribes labelled as opt-outs, not dead mailboxes.
Do any bounced or unsubscribed Constant Contact addresses belong to Rillet customers like Fabrikam?
How it works
What PopdockAI does when you ask
You pick a look-back period and your AI assistant matches Constant Contact bounces to Rillet billing emails. It recommends where to confirm a new address and changes nothing itself.
01
Ask
You pick a lookback period, 90 days by default.
02
Collect
It gathers addresses that bounced or unsubscribed in Constant Contact.
03
Match
It matches them exactly to Rillet customer emails and adds billing context.
04
Report
Hard bounces come first, with a recommendation where money is overdue.
What PopdockAI provides
The tools behind the answer
Ready made tools for Rillet and one secure connection to your AI tool. No code, no exports.
constant-contact-get-campaign-bounce
constant-contact-get-campaign-unsubscribe
rillet-get-customer-emails
rillet-get-customers
rillet-get-invoices
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
Fix dead billing addresses before balances age
Related use cases
More ways to put this data to work
Log Rillet billing status as a Constant Contact note
Ask your AI to log a Rillet customer's billing status in Constant Contact and it writes a short factual note on their contacts after you confirm.
Learn More
Find overdue Rillet customers by Constant Contact engagement
Ask your AI which overdue Rillet customers still engage with Constant Contact and it classes each one, recommending a call for the silent and unreachable.
Learn More
Attribute Rillet revenue to a Constant Contact campaign
Ask your AI what revenue followed a Constant Contact campaign and it matches clickers to Rillet customers and totals invoices and contracts in the window.
Learn More
Flag Rillet ARR at risk from Constant Contact disengagement
Ask your AI which Rillet customers have disengaged in Constant Contact and it classes each as opted out, silent, unreached or engaged, ranked by ARR.
Learn More
Add missing Rillet customers to a Constant Contact list
Ask your AI to add missing Rillet customers to a Constant Contact list and it adds only addresses not already there, after you confirm consent.
Learn More
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.