Connectors

/

Rillet

/

Attribute Rillet revenue to a Constant Contact campaign
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Attribute Rillet revenue to a Constant Contact campaign
What revenue followed the Spring upgrade campaign in Constant Contact?
9 clickers are Rillet customers, with 64,200 USD invoiced or contracted within 60 days. - Largest: Fabrikam, new contract for 28,000 USD - Likely coming anyway: 3 customers on unchanged recurring invoices - Not customers: 41 clickers This is correlation in a time window, not proof. Want the row per customer?
Rillet
Sample figures. Your results come from your own account.
constant-contact-get-campaign
constant-contact-get-campaign-click
rillet-get-customer-emails
rillet-get-invoices
rillet-get-contracts

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Rillet

Rillet
Run it on your own Rillet data.

Connect Rillet, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

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

Your AI tool

02

Collect

It lists each clicker with first click date and links.

constant-contact-get-campaign
constant-contact-get-campaign-click

03

Match

It matches clickers to Rillet customers by exact email.

rillet-get-customer-emails

04

Report

You get invoices and new contracts in the window, per currency.

Your AI tool

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.

get-data

constant-contact-get-campaign

Returns Constant Contact email campaigns with their status and headline counts: sends, opens, not opened, clicks, bounces, forwards and opt-outs. Filter by name, status, type and last sent date.
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

rillet-get-customer-emails

Returns customer email addresses with their type and the customer's location from Rillet.
get-data

rillet-get-invoices

Returns customer invoices (number, customer, dates, status, totals, amount due) from Rillet.
get-data

rillet-get-contracts

Returns customer contracts (term, status, total value, invoicing) from Rillet.
Read only.Nothing in Rillet 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

Campaign revenue you can explain, not just claim

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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