See whether buyers on open HubSpot deals read your emails

**Objective:** For HubSpot deals in the stage {deal-stage-name} and pipeline {pipeline-name} (both optional; default all deals closing today or later), show how each deal's contact has engaged with Constant Contact email in the last {lookback-days} days (default 30).

**Step 1: Read the deals**

Call `hubspot-get-deals` with `deal-stage-name` set to {deal-stage-name} and `pipeline-name` set to {pipeline-name} when given. If neither is given, set `close-date.from` to today. Keep `deal-name`, `amount`, `deal-stage-name`, `close-date`, `deal-owner` and `contact-id`. If more than 50 deals come back, keep the 50 with the highest `amount` and say so.

**Step 2: Get each deal contact's email**

For each deal with a `contact-id`, call `hubspot-get-contacts` with `record-id` set to it and keep `email` and name. List deals with no contact or no email separately.

**Step 3: Read their email engagement**

For each email, call `constant-contact-get-contact` with `email-address` set to it and keep `permission-to-send`. Then call `constant-contact-get-contact-activity` with `email-address` set to it and `created-date.from` set to the date {lookback-days} days before today (YYYY-MM-DD). Count activity by `activity-type` and keep the latest `created-date` and `campaign-activity-name`.

**Step 4: Report**

A table per deal: deal, amount, stage, close date, owner, contact, email, permission to send, activity counts, last activity date and campaign. Then flag: deals whose contact had no email activity in the window, deals whose contact is unsubscribed, and deals whose contact is not in Constant Contact.

**Rules & Guidelines:**

* `hubspot-get-deals` and `hubspot-get-contacts` are on the HubSpot server. `constant-contact-get-contact` and `constant-contact-get-contact-activity` are on the Constant Contact server.
* This prompt is read-only. Do not call `hubspot-update-deal`, `hubspot-add-deal-note`, `hubspot-update-contact`, `constant-contact-update-contact` or any other add, update or resend tool on either server.

**Validation:**

* Match email addresses case-insensitively and trimmed.
* If no deals match, say so and stop.
* Show `activity-type` values exactly as Constant Contact returns them.