See which customers responded to a campaign and then ordered

**Objective:** For the Constant Contact campaign named `{campaign-name}`, list the engagement of the recipients who are Dynamics GP customers, alongside each customer's balance and sales. Use GP company `{company}` (empty means the default company).

**Step 1: Find the campaign in Constant Contact**

Call `constant-contact-get-campaign` with name.contains `{campaign-name}`. If more than one comes back, list them (name, status, last-sent-date) and stop. If its status is not Done, say it has not been sent and stop.

**Step 2: Collect the engagement in Constant Contact**

With the campaign-id, call `constant-contact-get-campaign-open`, `constant-contact-get-campaign-click`, `constant-contact-get-campaign-bounce` and `constant-contact-get-campaign-unsubscribe`. Build one row per email-address with the counts of opens and clicks, and whether it bounced or unsubscribed.

**Step 3: Carry the emails across to Dynamics GP**

Dynamics GP cannot filter customers by email, so call `dynamics-gp-get-rm-customer` once with inactive false, company `{company}` and customer-class `{customer-class}` when given, max-records 500. Build a lookup from every address in main-email-address (split on semicolons and commas, trimmed, lower case) to the customer. Match each engagement row against it. A recipient with no match is not a GP customer; count them but do not list them.

**Step 4: Add the account context from Dynamics GP**

For each matched customer who clicked, call `dynamics-gp-get-rm-sales-trx` with customer-id and document-date.from set to the campaign's last-sent-date, so the report shows any order placed after the email.

**Step 5: Report**

* Campaign name, last-sent-date, and the campaign totals from Step 1 (sends, opens, clicks, bounces, opt-outs)
* A table of matched customers: customer-id, customer-name, email, opened, clicked, bounced, unsubscribed, customer-balance, orders since send (count and total)
* Sort clickers with orders first, then clickers, then openers
* A short list of bounced customers with their GP phone-1 and contact-person, since their email on file needs fixing

**Rules & Guidelines:**

* Tools whose names start with dynamics-gp are on the dynamics-gp server; tools whose names start with constant-contact are on the constant-contact server.
* This prompt is read-only. Do NOT call `constant-contact-resend-campaign-to-non-openers`, `constant-contact-update-contact`, `dynamics-gp-rm-customer-note`, `dynamics-gp-rm-customer-address-email` or any other write tool on either server.

**Validation:**

* If the customer read was capped at 500, say that some recipients may be customers you could not match.
* If no recipient matches a GP customer, say so with the number of recipients checked.