Know which overdue Dynamics SL customers your emails can still reach

**Objective:** Find Dynamics SL customers whose current balance is at least `{min-balance}` (default 0.01) and report, for each, whether they can still be reached through Mailchimp email and how recently they engaged.

**Step 1: Read balances in Dynamics SL**

Call `dynamics-sl-get-customer-balances` with `current-balance.min` set to `{min-balance}` and `max-records` set to 200. Sort by current-balance descending. Note each customer's aged balances (age-balance-1 to age-balance-5) and average-days-to-pay.

**Step 2: Get each customer's email**

For each customer-id, call `dynamics-sl-get-customers` with `customer-id` set to it and take email-address and phone-number. Customers without an email are reported as not reachable by email.

**Step 3: Check reach in Mailchimp**

For each email, call `mailchimp-get-list-member` with `email` set to it. If none of the rows is subscribed, the customer is not reachable by Mailchimp email; note the status (unsubscribed, cleaned or absent). For subscribed contacts, call `mailchimp-get-campaign-email-activity` with `email-address` set to it and `activity-date.from` set to 90 days ago, and note the date of the last open or click.

**Step 4: Report**

A table sorted by current balance: customer-name, current-balance, oldest non-zero aged bucket, average-days-to-pay, email-address, Mailchimp status, last open or click date, phone-number. Then a short summary: how much of the total balance sits with customers who are subscribed and engaged, subscribed but silent for 90 days, unsubscribed or cleaned, and not in Mailchimp at all. Point out the unsubscribed, cleaned and silent ones as needing a call rather than an email.

**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-segment-member`, `mailchimp-add-list-member`, `mailchimp-update-list-member` or any other mailchimp write tool. To tag these customers, the user can run the `tag-past-due-customers` prompt.
* Match email addresses case-insensitively after trimming spaces.
* Pass `company` on the dynamics-sl tools only if the user named a company.

**Validation:**

* If `{min-balance}` is empty or not a number, use 0.01.
* If no customer has a balance at or above `{min-balance}`, say so and stop.
* If Step 1 returns exactly 200 rows, say the list was capped and suggest a higher `{min-balance}`.