Rank Constant Contact clickers by where they stand in Business Central

**Objective:** For the Constant Contact campaign `{campaign-name}`, list everyone who clicked a link and show where each stands in Business Central: existing customer, known contact with or without an open opportunity, or unknown.

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

Call `constant-contact-get-campaign` with `name.contains` set to `{campaign-name}`. If more than one matches, list them with `name` and `last-sent-date` and stop. Keep `campaign-id`.

**Step 2: Collect the clickers**

Call `constant-contact-get-campaign-click` with `campaign-id`. Group by `email-address`, counting clicks and listing the distinct `link-url` values. Then call `constant-contact-get-contact` with `email-address` for each clicker to get `company-name` and `job-title`.

**Step 3: Place each clicker in Business Central**

1. Call `business-central-get-customer` with `email`. If found, mark the clicker as Customer.
2. Otherwise call `business-central-get-contact` with `email`. If found, keep `contact-number`, `company-name` and `salesperson-code`.
3. For each contact found, call `business-central-get-opportunity` with `contact-company-name` set to the contact's `company-name` and `closed` set to false. Keep `opportunity-number`, `description`, `status`, `estimated-value` and `salesperson-name`. Only count an opportunity whose `contact-number` matches the contact, or whose company matches when the contact number is empty.
4. If neither is found, mark the clicker as Unknown.

**Step 4: Report**

One table, ordered by click count: email, name, company, job title, clicks, links clicked, Business Central status (Customer, Contact with open opportunity, Contact without opportunity, Unknown), opportunity number and estimated value, salesperson.

End with the counts per status. Point out that Unknown and Contact without opportunity are the follow-up list, and that the `create-contacts-from-campaign-leads` prompt can add the Unknown ones to Business Central.

**Rules & Guidelines:**

* `constant-contact-get-campaign`, `constant-contact-get-campaign-click` and `constant-contact-get-contact` are on the constant-contact server; `business-central-get-customer`, `business-central-get-contact` and `business-central-get-opportunity` are on the business-central server.
* Read-only. Do NOT call `business-central-create-contact`, `business-central-create-opportunity`, `constant-contact-update-contact` or any other create, update or add tool.
* Pass `company` to Business Central tools only if the user names a company.

**Validation:**

* If nobody clicked, report the campaign's send and open counts and stop.
* Compare emails ignoring case. Company names may differ in punctuation or suffixes (Inc, Ltd); note a near match instead of silently accepting it.