Know whether email reaches a Dynamics SL customer

**Objective:** Show how Dynamics SL customer `{customer}` engages with Mailchimp email over the last `{lookback-days}` days (default 90), next to their account position in Dynamics SL.

**Step 1: Find the customer in Dynamics SL**

Call `dynamics-sl-get-customers` 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, email-address) and stop so the user can pick one. If the customer has no email-address, report that Dynamics SL holds no email for them and stop.

**Step 2: Read the account position**

Call `dynamics-sl-get-customer-balances` with the customer-id for current-balance, credit-limit, the aged balances and last-invoice-date. Call `dynamics-sl-get-sales-orders` with the customer-id and `order-date.from` set to the start of the lookback window for recent orders.

**Step 3: Carry the email across to Mailchimp**

Take email-address from Step 1. If it holds several addresses separated by `;` or `,`, use each one. For each address call `mailchimp-get-list-member` with `email` set to it, to see every audience the contact is in and their status, tags, rating and average open and click rates. Then call `mailchimp-get-campaign-email-activity` with `email-address` set to it and `activity-date.from` set to the start of the lookback window, and `mailchimp-get-campaign-unsubscribe` with `email` set to it.

If the address is in no Mailchimp audience, report the customer as present in Dynamics SL and absent from Mailchimp, and still give the Dynamics SL account position.

**Step 4: Report**

* Customer: customer-id, customer-name, email-address, status
* Account: current balance, credit limit, oldest non-zero aged bucket, last invoice date, orders in the window with their totals
* Mailchimp: one line per audience with status, tags, rating, average open rate, average click rate
* Activity in the window: counts of opens, clicks and bounces, the last 5 events with campaign and date, and any clicked URLs
* Any unsubscribe, with the date, campaign and reason
* One sentence on whether email is a working channel for this customer

**Rules & Guidelines:**

* Tools whose names start with mailchimp- are on the mailchimp server; tools whose names start with dynamics-sl- are on the dynamics-sl server. If either set is missing from your tool list, stop and say which server is not connected.
* This prompt is read-only. Do not call `mailchimp-add-list-member`, `mailchimp-update-list-member`, `mailchimp-add-segment-member`, `mailchimp-add-customer`, `mailchimp-update-customer`, `mailchimp-start-automation`, `mailchimp-pause-automation`, `mailchimp-replicate-campaign`, `mailchimp-update-order` or `mailchimp-update-product`.
* Match email addresses case-insensitively after trimming spaces.
* Pass `company` on the dynamics-sl tools only if the user named a company.

**Validation:**

* If `{lookback-days}` is empty or not a number, use 90.
* If Mailchimp returns the contact but no activity in the window, say so plainly rather than reporting zero rates as engagement.
* If the Mailchimp contact's name differs from the Dynamics SL customer-name, show both and note it; the email match still stands.