See who gave in Bloomerang after your Constant Contact appeal

**Objective:** For the Constant Contact campaign {campaign}, find which contacts who opened or clicked it gave in Bloomerang within {attribution-days} days (default 30) of its last send, and total those gifts.

**Step 1: Find the campaign in Constant Contact**

Call `constant-contact-get-campaign` with `name` set to the campaign. If nothing comes back, retry with `name.contains`. If more than one campaign matches, list them (name, status, last-sent-date) and stop. If the campaign has no last-sent-date, say it has not been sent and stop. Keep campaign-id, last-sent-date, sends, opens and clicks.

**Step 2: Collect the engaged contacts**

Call `constant-contact-get-campaign-click` and `constant-contact-get-campaign-open` with `campaign-id`. Build one list of unique email addresses, marking each as Clicked or Opened only. If there are more than 200, process clickers first, and report how many were not checked.

**Step 3: Find each contact in Bloomerang**

For each email, call `bloomerang-get-email-address` with `value` set to it and take its account-id. If that is empty, try `bloomerang-get-constituent` with `primary-email`. If both are empty, count the contact as Not a Bloomerang constituent and continue.

**Step 4: Find their gifts**

For each account-id, call `bloomerang-get-transaction` with `date.from` set to the last-sent-date and `date.to` set to that date plus the attribution days. Skip refunded transactions. For each gift, call `bloomerang-get-designation` with `transaction-id` set to the transaction id to see the fund, appeal and campaign it went to.

**Step 5: Report**

1. Campaign: name, last sent date, sends, opens, clicks.
2. Funnel: engaged contacts, matched to Bloomerang, gave in the window, total given.
3. A table of gifts: constituent name, email, Clicked or Opened only, gift date, amount, fund, appeal, Bloomerang campaign.
4. One line noting that a gift after the email shows timing, not proof the email caused it.

**Rules & Guidelines:**

* Constant Contact tools: `constant-contact-get-campaign`, `constant-contact-get-campaign-click`, `constant-contact-get-campaign-open`. Bloomerang tools: `bloomerang-get-email-address`, `bloomerang-get-constituent`, `bloomerang-get-transaction`, `bloomerang-get-designation`.
* This prompt is read-only. Do not call `constant-contact-update-campaign`, `constant-contact-resend-campaign-to-non-openers`, `bloomerang-add-interaction`, `bloomerang-update-transaction` or `bloomerang-add-soft-credit`.
* Match emails case-insensitively after trimming spaces. Never match on name alone.
* The Bloomerang constituent `id` is the same number every other Bloomerang tool takes as `account-id`.
**Validation:**

* If no engaged contact matches a Bloomerang constituent, report the funnel with zeros and stop.
* If gifts went to a Bloomerang appeal or campaign that does not resemble the email campaign, still list them; do not guess which were prompted by the email.