/
/
See which campaign readers paid their FreshBooks invoices
For marketing teams who want to connect Constant Contact opens and clicks to FreshBooks payments, just by asking their AI assistant.
On this page
Connector
Connect FreshBooks, pick your AI tool and paste the prompt.
The problem
Nobody can say if a campaign led to payments
Opens and clicks live in Constant Contact and payments live in FreshBooks. Matching people and totaling what they paid after the send takes so long that the answer is usually a guess.
Without PopdockAI
- Export openers and clickers from Constant Contact
- Match each email to a FreshBooks client
- Total payments after the send date
- Mix currencies in the total
With PopdockAI
- The campaign's openers and clickers are collected
- Each email is matched to a FreshBooks client
- Payments in your window are totaled per currency
- Framed as timing, not proof, 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:** For the Constant Contact campaign `{campaign-name}`, find which clients of the FreshBooks company `{company}` engaged with it and total the payments they made in the `{window-days}` days after the campaign was last sent (default 30).
**Step 1: Find the campaign (Constant Contact)**
Call `constant-contact-get-campaign` with `name.contains` set to `{campaign-name}`. If more than one campaign matches, list them and stop. Keep `campaign-id`, `last-sent-date`, `sends`, `opens` and `clicks`. Then call `constant-contact-get-campaign-activity` with `campaign-id` and keep the `campaign-activity-id`.
**Step 2: Find who engaged**
Call `constant-contact-get-campaign-click` and `constant-contact-get-campaign-open` with `campaign-id`. Collect the distinct `email-address` values and mark each as clicked or opened only.
**Step 3: Match to clients (FreshBooks)**
For each email, call `freshbooks-get-client` with `company` set to `{company}` and `email` set to that address. Emails with no client are not customers; count them and move on.
**Step 4: Read payments (FreshBooks)**
For each matched client call `freshbooks-get-payment` with `client-id` set to the client `id`, `date.from` set to the campaign `last-sent-date` and `date.to` set to that date plus `{window-days}` days. Total `amount` per client.
**Step 5: Report**
The campaign sends, opens and clicks; how many engaged emails are clients; a table of matched clients with engagement type and payments in the window; the total received. State clearly that this shows timing, not proof the campaign caused the payment.
**Rules & Guidelines:**
* FreshBooks tools (server `freshbooks`): `freshbooks-get-client`, `freshbooks-get-payment`. Constant Contact tools (server `constant-contact`): `constant-contact-get-campaign`, `constant-contact-get-campaign-activity`, `constant-contact-get-campaign-click`, `constant-contact-get-campaign-open`.
* This prompt is read-only. Never call any add, update, delete, send or mark tool on either server, and never call `constant-contact-resend-campaign-to-non-openers`.
* Match on email address only, case-insensitive. Payments in different currencies must be totalled separately.
**Validation:**
* If the campaign has no `last-sent-date`, say it has not been sent and stop.
* If the window runs past today, say it is incomplete.
* If no engaged emails match a client, report that and stop.Who it's for
One answer, three teams that use it
Email marketers
Show what happened after a send
See which openers and clickers paid in the weeks after, without overclaiming.
Which openers of our October Reminder campaign in Constant Contact paid FreshBooks invoices within 14 days?
Finance managers
Check reminder campaigns
Total what engaged contacts paid after a payment reminder campaign, by currency.
How much did clients who clicked the Constant Contact Overdue Notice pay in FreshBooks in the next 30 days?
Marketing managers
Compare campaigns by payments that followed
Get campaign counts and matched payments to compare sends over time.
Show payments from FreshBooks clients who opened the Constant Contact Summer Offer campaign within 21 days.
How it works
What PopdockAI does when you ask
You name the campaign, company and window, and your AI assistant matches engaged contacts to payments. It reports only and never resends the campaign.
01
Ask
You name the campaign, the FreshBooks company and how many days to measure.
02
Find
It locates the Constant Contact campaign and collects who opened or clicked.
03
Match
It matches each email to a FreshBooks client and totals their payments in the window.
04
Report
You get the campaign counts, a table of matched clients and the total received.
What PopdockAI provides
The tools behind the answer
Ready made tools for FreshBooks and one secure connection to your AI tool. No code, no exports.
constant-contact-get-campaign
constant-contact-get-campaign-activity
constant-contact-get-campaign-click
constant-contact-get-campaign-open
freshbooks-get-client
freshbooks-get-payment
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
Which engaged contacts paid after the campaign
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)
