Stop emailing people who have opted out of live deals

**Objective:** Find Constant Contact unsubscribes and bounces from the last `{lookback-days}` days (default 30), optionally for campaign `{campaign-id}`, and show which of those people have open deals or pending actions in OnePageCRM.

**Step 1: Get the opt-outs**

Call `constant-contact-get-campaign-unsubscribe` and `constant-contact-get-campaign-bounce` (Constant Contact server) with `created-date.from` set to today minus the lookback, and with `campaign-id` set when `{campaign-id}` is given. Combine the results by `email-address`, keeping the reason or bounce type and the date.

**Step 2: Look each person up in OnePageCRM**

For each email call `onepagecrm-get-contact` (OnePageCRM server) with `email` set to it. For contacts found, call `onepagecrm-get-deal` with the contact's `id` as `contact-id`, and `onepagecrm-get-action` with the same `contact-id`. Keep open deals and pending actions only.

**Step 3: Report**

Give a table of people who are in OnePageCRM with an open deal or pending action: name, company, why they opted out or bounced, date, deal stage and amount, and the action due. Add counts for people with nothing open and people not in OnePageCRM. Suggest, in words only, what the owner should do next, such as phone instead of email or correct the address.

**Rules & Guidelines:**

* Tools on the OnePageCRM server: `onepagecrm-get-contact`, `onepagecrm-get-deal`, `onepagecrm-get-action`, `onepagecrm-get-action-stream`, `onepagecrm-get-note`. Tools on the Constant Contact server: `constant-contact-get-contact`, `constant-contact-get-campaign`, `constant-contact-get-campaign-open`, `constant-contact-get-campaign-click`, `constant-contact-get-campaign-unsubscribe`, `constant-contact-get-campaign-bounce`, `constant-contact-get-contact-list-member`, `constant-contact-get-contact-list`.
* This prompt is read-only. Do not call any add, update, delete or resend tool on either server (for example `onepagecrm-add-note`, `onepagecrm-update-contact`, `onepagecrm-delete-contact`, `constant-contact-add-contact`, `constant-contact-update-contact`, `constant-contact-resend-campaign-to-non-openers`).
* The join between the systems is the email address. Compare it case-insensitively and ignore surrounding spaces.

**Validation:**

* If there are no unsubscribes or bounces in the window, say so and stop.
* Do not recommend emailing anyone who unsubscribed.
* Mark hard bounces as a data quality problem in OnePageCRM rather than a lost lead.