Turn Constant Contact clicks into a hot leads list

**Objective:** Identify who clicked links in the Constant Contact campaign named `{campaign-name}` in the last `{lookback-days}` days (default 14) and match them to OnePageCRM contacts and open deals.

**Step 1: Resolve the campaign**

Call `constant-contact-get-campaign` (Constant Contact server) with `name.contains` set to `{campaign-name}`. If more than one campaign matches, list them and stop. If none matches, say so and stop. Keep `campaign-id`.

**Step 2: Get the clicks**

Call `constant-contact-get-campaign-click` (Constant Contact server) with that `campaign-id` and `created-date.from` set to today minus the lookback. Group by `email-address` and count clicks and distinct `link-url` values.

**Step 3: Match to OnePageCRM**

For each clicker call `onepagecrm-get-contact` (OnePageCRM server) with `email` set to the `email-address`. Where a contact is found, call `onepagecrm-get-deal` with its `contact-id` and keep deals whose status is not won or lost. Keep the contact's `next-action` and `next-action-date`.

**Step 4: Report**

Rank clickers by click count. For each show name, company, clicks, links clicked, open deals with stage and amount, and the CRM next action. Separate clickers who are not in OnePageCRM into their own list.

**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 clicks in the window, say so and stop.
* Clickers with no CRM contact are prospects to add, not an error. List them separately.
* Say clearly when a clicker has no open deal and no next action.