Find the customers your Mailchimp audience misses

**Objective:** Compare active Dynamics SL customers against the Mailchimp audience `{audience}` and report which customers are missing, unsubscribed or cleaned, optionally limited to customer class `{customer-class}` and state `{state}`.

**Step 1: Confirm the audience in Mailchimp**

Call `mailchimp-get-list` with `name` set to `{audience}`; if nothing matches, retry with `name.contains`. If more than one audience matches, list them with number-of-members and stop. Keep the list-id and name.

**Step 2: Read the Dynamics SL customers**

Call `dynamics-sl-get-customers` with `status` set to active, `customer-class-id` set to `{customer-class}` if given, `state` set to `{state}` if given, and `max-records` set to 500. Set aside any customer with a blank email-address; they cannot be compared.

**Step 3: Check each email in Mailchimp**

For each customer email, call `mailchimp-get-list-member` with `email` set to it and `list-name` set to the audience name from Step 1. Classify each customer as:

* **In audience** - a row with status subscribed
* **Pending** - status pending
* **Unsubscribed** - status unsubscribed (include unsubscribe-reason)
* **Cleaned** - status cleaned, meaning the address bounced
* **Missing** - no row in this audience

**Step 4: Report**

Start with counts per class and the number of customers with no email. Then a table of Missing customers (customer-id, customer-name, email-address, city, state, salesperson-id), then Unsubscribed and Cleaned customers in their own tables. Keep In audience as a count only.

**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` or any other mailchimp write tool. To add the missing customers, the user can run the `add-customers-to-audience` prompt.
* Match email addresses case-insensitively after trimming spaces. If a Dynamics SL email-address holds several addresses, treat the customer as present if any one of them is in the audience.
* Pass `company` on the dynamics-sl tools only if the user named a company.

**Validation:**

* If Step 2 returns exactly 500 customers, say the result was capped and suggest narrowing by `{customer-class}` or `{state}`.
* If an email-address is not a valid address (no `@`), list the customer under no email rather than Missing.
* If every customer comes back Missing, check that the audience name is right before reporting.