See email engagement at your open NetSuite opportunities

**Objective:** For up to {max-opportunities} NetSuite opportunities (default 20) with projected total of at least {min-projected-total} (default 0), report whether the company contacts are opening and clicking Constant Contact email.

**Step 1: Read opportunities**

Call `netsuite-get-opportunity` with `projected-total.min` = {min-projected-total} and `max-records` = {max-opportunities}. Keep the title, company and projected total.

**Step 2: Find the people**

For each opportunity, call `netsuite-get-contact` and keep the email addresses of contacts at that company. If no email is found, mark the opportunity as no contact email.

**Step 3: Check engagement**

For each email, call `constant-contact-get-contact` with `email-address`, then `constant-contact-get-contact-activity` with the `contact-id`. Count opens and clicks and find the latest activity date.

**Step 4: Report**

A table ordered by projected total: opportunity, company, contacts found, in Constant Contact, opens, clicks, latest activity. Flag high-value opportunities with no engagement as needing a personal follow-up.

**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 an opportunity yields no contacts, report it and continue.
* If the opportunity read returns nothing, say so and stop.