See what Drip campaign subscribers went on to buy

**Objective:** For the Drip email series campaign `{campaign}` (an ID or name), find which subscribers are Intacct customers and what those customers ordered and were invoiced since `{since-date}` (default: the campaign's created-date).

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

Call `drip-get-campaign` with `campaign-id` set to `{campaign}`. If nothing comes back, call it again with `name.contains` set to `{campaign}`. If more than one matches, list them (campaign-id, name, status, created-date) and stop. Keep campaign-id, name, status, created-date and active-subscribers.

**Step 2: List its subscribers**

Call `drip-get-campaign-subscriber` with `campaign-id` and `max-records` 500. If none come back, say the campaign has no subscribers and stop.

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

For each email, call `intacct-get-contact` with `email` set to it. If a contact is found, call `intacct-get-customer` with `customer-name` set to the contact's company-name and keep the customer-id. Subscribers with no contact, or whose contact has no customer, are unmatched; count them and continue.

**Step 4: What matched customers did next**

For each matched customer, call `intacct-get-order-entry-document` with `customer-id` and `document-date.from` set to the since date, and `intacct-get-invoice` with `customer-id` and `invoice-date.from` set to the same date.

**Step 5: Report**

1. Campaign: name, status, created-date, active-subscribers, the since date used.
2. Funnel: subscribers, matched to a customer, customers with an order or invoice since the date, total invoiced.
3. A table per customer: customer-name, customer-id, subscribers in the campaign, orders since, invoiced since, campaign-status of each subscriber.
4. A note that this shows correlation, not attribution: these customers may have bought without the campaign.

**Rules & Guidelines:**

* `drip-get-campaign` and `drip-get-campaign-subscriber` are on the drip server. `intacct-get-contact`, `intacct-get-customer`, `intacct-get-order-entry-document` and `intacct-get-invoice` are on the intacct server.
* This prompt is read-only. Do not call `drip-pause-campaign`, `drip-activate-campaign`, `drip-remove-subscriber-from-campaign`, `drip-add-subscriber-to-campaign`, `intacct-create-order-entry-document` or any other write tool on either server.

**Validation:**

* Count a customer once even when several of its people are in the campaign.
* If documents carry different currencies, total them per currency.
* If Drip returns more subscribers than were read, say the funnel is based on the first 500.