Know a customer's billing and email engagement before renewal

**Objective:** Build a single view of the person with email address `{email-address}`: who they are as a Rillet customer (balance, overdue invoices, ARR) and how they engage with Constant Contact email, looking back `{lookback-days}` days (default 90).

**Step 1: Find the Rillet customer**

Call `rillet-get-customer-emails` (rillet server). It takes no filters, so read the result and keep the rows whose `email` equals `{email-address}`, ignoring case and surrounding spaces. Note each matching `customer-id` and customer `name`. If more than one customer shares the email, keep them all and say so in the report. If none matches, record "not a Rillet customer" and skip to Step 3.

**Step 2: Read the billing position**

Call `rillet-get-invoices` (rillet server) and keep rows whose `customer-id` is one from Step 1. Report the open invoices (`amount-due` above 0), flag those where `overdue` is true, and total the amount due by `currency`. Never add amounts in different currencies together.

Call `rillet-get-arr-waterfall` (rillet server) with `customer-id` for each customer from Step 1. Report the most recent `year-month`, its `arr`, `status` and `currency`, and the direction of change over the last three months available.

**Step 3: Read the Constant Contact side**

Call `constant-contact-get-contact` (constant-contact server) with `email-address` set to `{email-address}`. If nothing comes back, record "not in Constant Contact" and go to Step 4.

Otherwise take its `contact-id` and, with `created-date.from` set to today minus the lookback, call `constant-contact-get-contact-activity`, `constant-contact-get-campaign-open`, `constant-contact-get-campaign-click`, `constant-contact-get-campaign-bounce` and `constant-contact-get-campaign-unsubscribe` (all constant-contact server), each filtered by `contact-id`. Call `constant-contact-get-contact-list-member` with `contact-id` to show which lists they belong to, and `constant-contact-get-contact-note` with `contact-id` for any notes.

**Step 4: Report**

* **Identity:** name, company, job title, permission-to-send, and the Rillet customer name(s) and id(s).
* **Billing (Rillet):** open invoices as a table (invoice number, invoice date, due date, amount due, currency, overdue), totals by currency, latest ARR and trend.
* **Engagement (Constant Contact):** counts of sends, opens, clicks, bounces and unsubscribes in the window, the most recent open or click date, list memberships, and the latest note.
* **Read-across:** one or two sentences connecting the two, for example "overdue and has not opened an email in 60 days" or "healthy ARR, highly engaged".

**Rules & Guidelines:**

* Tools starting rillet- are on the rillet server; tools starting constant-contact- are on the constant-contact server. Both must be connected.
* This prompt is read-only. Do not call any rillet-add-*, rillet-update-*, `rillet-apply-credit-memo`, `rillet-unapply-credit-memo` or `rillet-set-invoice-sent-status` tool, and do not call `constant-contact-add-contact`, `constant-contact-update-contact`, `constant-contact-add-contact-note` or any other constant-contact-add-* or constant-contact-update-* tool.

**Validation:**

* If the email is in neither system, say so and stop.
* If it is in only one system, report that side in full and state plainly that the other system has no record for this email.
* If the Rillet customer name and the Constant Contact company name clearly differ, show both and do not pick one.