See which Constant Contact campaigns worked this quarter

**Objective:** Compare every campaign sent in the last `{lookback-days}` days (default 90) and show which performed best and worst.

**Step 1: Pull the sent campaigns**

Compute the start date as today minus `{lookback-days}` days (90 if blank). Call `constant-contact-get-campaign` with `last-sent-date.from` set to that date and `status` set to Done. If `{name-filter}` is given, also set `name.contains` to `{name-filter}`.

**Step 2: Calculate rates per campaign**

For each campaign use its sends, bounces, opens, clicks and opt-outs:

* delivered = sends - bounces
* open rate = opens / delivered
* click rate = clicks / delivered
* unsubscribe rate = opt-outs / delivered
* bounce rate = bounces / sends

Leave out campaigns with fewer than 50 sends from the ranking and list them separately, because their rates are noise.

**Step 3: Report**

1. A table sorted by open rate, highest first: name, last sent date, sends, open rate, click rate, unsubscribe rate, bounce rate.
2. The averages across all ranked campaigns.
3. The best and worst campaign by click rate, and any campaign whose unsubscribe or bounce rate is more than double the average, with one line each on why it stands out.
4. For the top and bottom campaign by open rate, call `constant-contact-get-campaign-activity` with its `campaign-id` and show the subject line, so the user can compare subjects.

**Rules & Guidelines:**

* This is read-only. Do not call `constant-contact-update-campaign`, `constant-contact-resend-campaign-to-non-openers` or any other add or update tool.
* Rates are percentages to one decimal place.

**Validation:**

* If no campaigns were sent in the period, say so and suggest a longer `{lookback-days}`.
* If only one campaign qualifies, report it alone and say no comparison is possible.