/
/
See what Rillet revenue followed a Constant Contact campaign
For marketers who want to know which campaign clickers are Rillet customers and what was invoiced or contracted after their click.
On this page
Connector
Connect Rillet, pick your AI tool and paste the prompt.
The problem
Nobody can say what revenue a campaign really drove
Campaign clicks sit in Constant Contact while the invoices and contracts that might follow sit in Rillet. Lining them up by email and date, and separating new revenue from billing that was coming anyway, is a job most teams skip.
Without PopdockAI
- Export campaign clickers from Constant Contact
- Match each one to a Rillet customer by hand
- Pull invoices and contracts dated after each click
- Count routine recurring billing as a campaign win
With PopdockAI
- Every clicker listed with first click date and links
- Clickers matched to Rillet customers by exact email
- Invoices and new contracts in the window totalled per currency
- Unchanged recurring billing called out, not counted
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 Constant Contact campaign named `{campaign-name}`, find which clickers are Rillet customers and what was invoiced or contracted for them within `{attribution-days}` days (default 60) of their click.
**Step 1: Identify the campaign**
Call `constant-contact-get-campaign` (constant-contact server) with `name.contains` set to `{campaign-name}`. If several campaigns match, list them with `name`, `campaign-id` and `last-sent-date` and ask which one to use. If none match, say so and stop. Note the campaign's `sends`, `opens` and `clicks`.
**Step 2: Collect the clickers**
Call `constant-contact-get-campaign-click` (constant-contact server) with `campaign-id`. Keep each `email-address` with its earliest click `created-date` and the `link-url` values clicked. If there are no clicks, report the campaign totals and stop.
**Step 3: Match clickers to Rillet customers**
Call `rillet-get-customer-emails` (rillet server) once and match `email` to each clicker's `email-address` exactly, ignoring case and surrounding spaces. Clickers with no match are prospects; count them.
**Step 4: Find what followed**
Call `rillet-get-invoices` (rillet server) and keep invoices for the matched `customer-id` values whose `invoice-date` falls on or after the click date and within the attribution window. Call `rillet-get-contracts` (rillet server) with `customer-id` for each matched customer and keep contracts whose `start-date` falls in the same window.
**Step 5: Report**
* Campaign summary: name, last sent, sends, opens, clicks.
* Clickers: total, matched to Rillet customers, unmatched prospects.
* A table per matched customer: customer, email, click date, links clicked, invoices in window (count and total by currency), new contracts in window (name, start date, total value, currency).
* A closing line with the total invoiced and contracted in the window by currency.
**Rules & Guidelines:**
* Tools starting constant-contact- are on the constant-contact server; tools starting rillet- are on the rillet server.
* State clearly that this is correlation within a time window, not proof the campaign caused the revenue. Existing recurring invoices will appear too; call out customers whose invoice pattern looks unchanged.
* This prompt is read-only. Do not call `constant-contact-resend-campaign-to-non-openers`, `constant-contact-update-campaign` or any other constant-contact-add-* or constant-contact-update-* tool, and do not call any rillet-add-* or rillet-update-* tool.
**Validation:**
* If no clicker matches a Rillet customer, report the prospect count and stop.
* Never add amounts in different currencies.Who it's for
One answer, three teams that use it
Campaign managers
Show what a campaign was followed by
See the invoices and contracts that came after the clicks, so your campaign review rests on real billing.
What Rillet invoices and contracts followed clicks on our Renewal reminder campaign within 30 days?
Marketing leaders
Report revenue influence honestly
Routine recurring billing is called out instead of counted, so the number you present holds up to questions.
How much new Rillet revenue followed the Q3 upsell campaign in Constant Contact, excluding normal renewals?
Revenue operations
Tie marketing clicks to the ledger
Clickers are matched to Rillet customers by exact email and totals are kept per currency, ready for a pipeline review.
Match clickers from the Fabrikam webinar invite to Rillet customers and total their invoices since.
How it works
What PopdockAI does when you ask
You name the campaign and your AI assistant lines up its clickers with Rillet revenue in the window that followed. It only reads, and it is clear that this is correlation, not proof.
01
Ask
You name the campaign, and optionally an attribution window.
02
Collect
It lists each clicker with first click date and links.
03
Match
It matches clickers to Rillet customers by exact email.
04
Report
You get invoices and new contracts in the window, per currency.
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
constant-contact-get-campaign-click
rillet-get-customer-emails
rillet-get-invoices
rillet-get-contracts
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
Campaign revenue you can explain, not just claim
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)
