See which campaign clickers are already in your Pipedrive pipeline

**Objective:** For the Constant Contact campaign `{campaign-name}`, find who clicked and show where each of them stands in the Pipedrive sales pipeline. Check at most `{max-records}` clicks (default 200).

**Step 1: Find the campaign (Constant Contact)**

Call `constant-contact-get-campaign` with `name` set to `{campaign-name}`, and if nothing comes back, with `name.contains`. If more than one campaign matches, list name, status and last-sent-date and stop.

**Step 2: Read the clicks (Constant Contact)**

Call `constant-contact-get-campaign-click` with the `campaign-id` and `max-records` set to `{max-records}` (default 200). Group by `email-address`: count clicks and keep the distinct `link-url` values.

**Step 3: Match each clicker in Pipedrive**

For each email, call `pipedrive-get-person` with `email`. If no person comes back, the clicker is not in Pipedrive.

**Step 4: Read their pipeline (Pipedrive)**

For each matched person:

* If they have an `organization-id`, call `pipedrive-get-deal` with it and `status` set to open.
* Call `pipedrive-get-lead` with `person-id` and `archived` set to false.

**Step 5: Report**

Four groups, each a table with name, email, organization, click count and links clicked:

1. Clicked and has an open deal (add deal title, stage and value).
2. Clicked and has an open lead only (add lead title).
3. Clicked, known in Pipedrive, no open deal or lead.
4. Clicked, not in Pipedrive at all.

Finish with the totals for each group.

**Rules & Guidelines:**

* `constant-contact-get-campaign` and `constant-contact-get-campaign-click` are on the constant-contact server. `pipedrive-get-person`, `pipedrive-get-deal` and `pipedrive-get-lead` are on the pipedrive server.
* This prompt is read-only. Do NOT call `pipedrive-add-lead`, `pipedrive-add-person`, `pipedrive-add-activity` or any other add or update tool on either server. If the user wants follow-up created, point them to the schedule-follow-ups-for-campaign-clickers or create-pipedrive-leads-from-campaign-clicks prompts.

**Validation:**

* If the campaign has no clicks, say so and stop.
* Deals are found through the person's organization, so an organization deal may belong to a colleague. Show the deal's `person-name` so the user can see whose it is.