Know how a customer engages and how they pay

**Objective:** Build a marketing and billing profile of the Intacct customer `{customer}` (a customer ID or name), showing how its people engage in Drip next to how the account bills and pays.

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

Call `intacct-get-customer` with `customer-id` set to `{customer}`. If nothing comes back, call it again with `customer-name.contains` set to `{customer}`. If more than one customer matches, list them (customer-id, customer-name, city, status) and stop. Keep customer-id, customer-name, email, status, term, credit-limit, total-due and last-invoice-date.

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

Call `intacct-get-contact` with `company-name` set to the customer-name from Step 1. Take every non-blank email from those contacts, plus the customer's own email from Step 1. Compare emails case-insensitively, ignoring surrounding spaces, and drop duplicates. If there are no emails at all, say the customer cannot be matched to Drip, give the Intacct half of the report, and stop.

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

For each email, call `drip-get-subscriber` with `email` set to it, then `drip-get-campaign-subscriber` with `email` set to it. An email with no subscriber is Not in Drip; record it and continue with the next one.

**Step 4: Billing context**

Call `intacct-get-invoice` with `customer-id` and `invoice-date.from` set to 12 months before today, and `intacct-get-ar-payment` with `customer-id` and `receipt-date.from` set to the same date.

**Step 5: Report**

1. Header: customer-name, customer-id, status, term, credit-limit, total-due, last-invoice-date.
2. People table: email, Intacct contact name, Drip status, lead-score, tags, Drip lifetime-value, campaigns (campaign-name and campaign-status).
3. Billing: invoiced in the last 12 months, paid in the last 12 months, open invoice count, oldest open due-date.
4. One or two sentences on what stands out, for example an overdue balance while contacts are active in campaigns, or the only billing contact being unsubscribed.

**Rules & Guidelines:**

* `intacct-get-customer`, `intacct-get-contact`, `intacct-get-invoice` and `intacct-get-ar-payment` are on the intacct server. `drip-get-subscriber` and `drip-get-campaign-subscriber` are on the drip server.
* This prompt is read-only. Do not call `drip-add-subscriber`, `drip-update-subscriber`, `drip-add-subscriber-tag`, `drip-add-subscriber-to-campaign`, `drip-unsubscribe-subscriber`, `intacct-update-customer`, `intacct-update-contact` or any other create, update, add, remove, start, activate, pause or unsubscribe tool on either server.

**Validation:**

* If either server returns an error, say which server failed and report what the other one returned.
* Drip lifetime-value and Intacct invoiced totals measure different things. Show both side by side and do not try to reconcile them.