See what Mailchimp clickers bought in Sage Intacct

**Objective:** For the Mailchimp campaign `{campaign}`, find the recipients who clicked, match them to Intacct customers, and report the sales orders and invoices those customers had in the `{days-after}` days after the send date (default 30).

**Step 1: Find the campaign in Mailchimp**

Call `mailchimp-get-campaign` filtered by `campaign-id` = `{campaign}`. If nothing comes back, call it with `title.contains` = `{campaign}`. If more than one matches, list them (campaign-id, title, send-date, status) and stop. If the campaign has not been sent, say so and stop.

Record `campaign-id`, `title`, `send-date`, `number-of-recipients`, `open-rate` and `click-rate`.

**Step 2: Collect the clickers**

Call `mailchimp-get-campaign-email-activity` filtered by `campaign-id` and `action` = click. Collect the distinct `email-address` values and each one's click count. If nobody clicked, report the campaign headline numbers and stop.

**Step 3: Match clickers to Intacct customers**

For each email, call `intacct-get-contact` filtered by `email`, take `company-name`, and call `intacct-get-customer` filtered by `customer-name` with it. Several emails can resolve to the same customer; group them. Emails with no match go in an "unmatched" count.

**Step 4: What followed in Intacct**

For each matched customer, with the window running from the send date to the send date plus the days after:

1. Call `intacct-get-order-entry-document` filtered by `customer-id`, `document-date.from` and `document-date.to`. Record `transaction-type`, `document-number`, `document-date` and `total`.
2. Call `intacct-get-invoice` filtered by `customer-id`, `invoice-date.from` and `invoice-date.to`. Record `invoice-number`, `invoice-date` and `total-amount`.

**Step 5: Report**

1. Campaign: title, send date, recipients, open rate, click rate.
2. Clickers: total, matched to Intacct, unmatched.
3. A table per matched customer: customer-name, customer-id, clicking emails, number of orders and invoices in the window, invoiced total.
4. Grand total invoiced in the window by customers who clicked.

State plainly that this shows what clickers went on to buy, not that the campaign caused it.

**Rules & Guidelines:**

* `mailchimp-get-campaign` and `mailchimp-get-campaign-email-activity` are on the mailchimp server. `intacct-get-contact`, `intacct-get-customer`, `intacct-get-order-entry-document` and `intacct-get-invoice` are on the intacct server.
* Match email addresses case-insensitively and after trimming spaces. If an Intacct email field holds several addresses separated by commas or semicolons, treat each one as a separate address.
* Intacct `intacct-get-customer` has no email filter. To go from an email to an Intacct customer, call `intacct-get-contact` filtered by `email`, take its `company-name`, then call `intacct-get-customer` filtered by `customer-name` with that value.
* Do not add orders and invoices together; an order and the invoice it became would be counted twice. Report the invoiced total as the money figure.
* This prompt is read-only. Do NOT call `mailchimp-replicate-campaign`, `mailchimp-add-segment-member`, `intacct-create-order-entry-document` or `intacct-update-order-entry-document`, or any other create, update or add tool on either server.

**Validation:**

* If there are more than 100 clickers, match the 100 with the most clicks and say how many were left out.
* If the window runs past today, cut it off at today and say so.