See what a customer owes and whether they still engage

**Objective:** For the customer {customer-email}, combine their NetSuite billing position with their Constant Contact email engagement over the last {lookback-days} days (default 90).

**Step 1: Find the customer in NetSuite**

Call `netsuite-get-customer` with `email` = {customer-email}. If it returns more than one customer, list them and stop. If none, say the email is not a NetSuite customer and stop. Keep the internal-id, name and balance.

**Step 2: Get open billing**

Call `netsuite-get-invoice` with `customer-id` set to the customer internal-id and `unpaid-amount.min` = 0.01. Total the unpaid amounts.

**Step 3: Find the contact in Constant Contact**

Call `constant-contact-get-contact` with `email-address` = {customer-email}. Keep `contact-id` and `permission-to-send`. If nothing comes back, report the customer as present in NetSuite and absent from Constant Contact, then skip to the report.

**Step 4: Get engagement**

Call `constant-contact-get-contact-activity` with that `contact-id` and `created-date.from` set to the lookback start. Count opens, clicks, bounces and unsubscribes by `activity-type`.

**Step 5: Report**

One summary: customer name, NetSuite balance, open invoice count and total, permission-to-send, engagement counts, and the last engagement date. End with one sentence on whether the customer looks engaged or cold.

**Rules & Guidelines:**

* `netsuite-*` tools are on the netsuite server; `constant-contact-*` tools are on the constant-contact server. Both servers must be connected.
* This prompt is read-only. Never call any `netsuite-add-*` or `netsuite-update-*` tool, and never call `constant-contact-add-*`, `constant-contact-update-*` or `constant-contact-resend-campaign-to-non-openers`.
* Match the two systems on email address, case-insensitive. If a record has no email, report it as unmatched and continue.

**Validation:**

* If either side returns nothing, say which and still report the other side.
* If the NetSuite balance and the sum of open invoices disagree, show both figures.