Find engaged Mailchimp subscribers sales has never heard of

**Objective:** From the Mailchimp audience `{list-name}`, find subscribed members with a rating of at least `{min-rating}` (default 4) who do not exist in Business Central as a customer or a contact. Use the Business Central company `{company}`; if it is empty, omit the `company` filter.

**Step 1: Engaged subscribers**

Call `mailchimp-get-list-member` with `list-name` set to `{list-name}`, `status` set to subscribed and `rating.min` set to the minimum rating. Keep email, full-name, rating, average-open-rate, average-click-rate, tags and sign-up-date.

**Step 2: Check Business Central**

For each email, call `business-central-get-customer` with `email` set to it. If none is found, call `business-central-get-contact` with `email` set to it. Classify the member as Customer, Contact or Not in Business Central.

**Step 3: Report**

Counts per class, then a table of the Not in Business Central members: email, full-name, rating, average-open-rate, average-click-rate, tags, sign-up-date, sorted by rating then average-click-rate, highest first. For the Contact class, add a short table of email, contact-number, company-name and salesperson-code so sales can see who already owns them.

**Rules & Guidelines:**

* `mailchimp-get-list-member` is on the mailchimp server. `business-central-get-customer` and `business-central-get-contact` are on the business-central server.
* This prompt is read-only. Do NOT call `business-central-create-contact`, `business-central-create-customer` or `mailchimp-update-list-member`. If the user then asks to create the contacts, confirm the list and the job title to use first, because `business-central-create-contact` requires both display-name and job-title.

**Validation:**

* If the audience name matches more than one list, list the matches and stop.
* If no members meet the rating, say so and suggest a lower `min-rating`.
* Match emails case-insensitively after trimming spaces.