Give finance and marketing the same view of a Sage Intacct customer

**Objective:** Build a combined finance and marketing profile of the Intacct customer `{customer}`, looking back `{lookback-days}` days of Mailchimp activity (default 90), across all Mailchimp audiences unless `{audience}` names one.

**Step 1: Find the customer in Intacct**

Call `intacct-get-customer` filtered by `customer-id` = `{customer}`. If nothing comes back, call it again with `customer-name.contains` = `{customer}`. If more than one customer matches, list them (customer-id, customer-name, city, status) and stop. If none match, say so and stop.

Record `customer-id`, `customer-name`, `email`, `status`, `term`, `credit-limit` and `total-due`.

**Step 2: Collect the customer's email addresses**

Start with the customer's `email`. Then call `intacct-get-contact` filtered by `company-name` = the customer-name and add each contact's `email`. Remove duplicates. If there are no email addresses at all, report the Intacct half of the profile, say the customer cannot be matched to Mailchimp without an email address, and stop.

**Step 3: Look each email up in Mailchimp**

For each email address:

1. Call `mailchimp-get-list-member` filtered by `email` (and `list-name` = `{audience}` if given). Record each audience's `list-name`, `status`, `tags`, `rating`, `average-open-rate`, `average-click-rate` and `unsubscribe-reason`.
2. Call `mailchimp-get-campaign-email-activity` filtered by `email-address`, with `activity-date.from` set to today minus the lookback. Count opens, clicks and bounces, and note the most recent of each.
3. Call `mailchimp-get-campaign-unsubscribe` filtered by `email` to find any campaign the address unsubscribed from, with the reason.
4. Call `mailchimp-get-customer` filtered by `email` for e-commerce `orders-count` and `total-spent`.

An address with no rows in any of these is "not in Mailchimp". Report it that way and continue with the next address.

**Step 4: Open receivables in Intacct**

Call `intacct-get-invoice` filtered by `customer-id` with `total-due.min` = 0.01. Record each invoice's `invoice-number`, `invoice-date`, `due-date` and `total-due`, and mark the ones past their due date.

**Step 5: Report**

1. A header: customer-name, customer-id, Intacct status, term, credit limit, total due, overdue total.
2. A table with one row per email address: email, source (customer record or contact name), Mailchimp audience, status, rating, open rate, click rate, opens / clicks / bounces in the lookback, last activity date, unsubscribe reason.
3. Store spend from Mailchimp, if any.
4. Two or three plain observations, for example an overdue customer whose only address is unsubscribed or cleaned, or a high-spend store customer with no Intacct contact.

**Rules & Guidelines:**

* `intacct-get-customer`, `intacct-get-contact` and `intacct-get-invoice` are on the intacct server. Every tool whose name starts with mailchimp is on the mailchimp 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.
* This prompt is read-only. Do NOT call `mailchimp-add-list-member`, `mailchimp-update-list-member`, `mailchimp-add-segment-member`, `intacct-update-customer` or `intacct-update-contact`, or any other create, update, add, start or pause tool on either server.

**Validation:**

* If a Mailchimp call fails because the mailchimp server is not connected, say so plainly and still report the Intacct half.
* Do not treat a missing Mailchimp record as an error. Many customers are simply not on a mailing list.