See who at an account opens and clicks your emails

**Objective:** Show how the people at the Dynamics 365 Sales account `{account-name}` have engaged with Constant Contact email over the last `{lookback-days}` days (default 90). This is read-only.

**Step 1: Find the account in Dynamics 365 Sales**

Call `dynamics-365-sales-get-accounts` with `account-name` set to `{account-name}`. If nothing comes back, retry with `account-name.contains`. If more than one account matches, list them with account-number, city and owner, and stop.

**Step 2: Get its contacts**

Call `dynamics-365-sales-get-contacts` with `parent-customer` set to the account-name from Step 1. Keep contacts that have an email. If none do, report that the account has no contacts with an email address and stop.

**Step 3: Carry each email into Constant Contact**

For each email, call `constant-contact-get-contact` with `email-address` set to it. If nothing comes back, mark the person "not in Constant Contact" and move on.

For each match, take its `contact-id` and, with `created-date.from` set to today minus `{lookback-days}` days, call:

* `constant-contact-get-campaign-send` (emails received)
* `constant-contact-get-campaign-open`
* `constant-contact-get-campaign-click`
* `constant-contact-get-campaign-bounce`
* `constant-contact-get-campaign-unsubscribe`

Also call `constant-contact-get-contact-list-member` with `contact-id` to list the lists they are on.

**Step 4: Report**

1. A header: account name, owner, industry, number of contacts, how many are in Constant Contact.
2. A table, one row per contact: name, job title, email, lists, sends, opens, clicks, last activity date, and a flag for bounced or unsubscribed.
3. The links clicked most often across the account (link-url and count), top 5.
4. People at the account who are not in Constant Contact.
5. One line on the account's overall engagement: who is engaged, who has gone quiet, and who can no longer be emailed.

**Rules & Guidelines:**

* `dynamics-365-sales-get-accounts` and `dynamics-365-sales-get-contacts` are on the dynamics-365-sales server. Every constant-contact tool is on the constant-contact server.
* Read-only. Do NOT call `constant-contact-add-contact`, `constant-contact-update-contact`, `dynamics-365-sales-create-task`, `dynamics-365-sales-create-note` or any other create, update or add tool.
* Match emails case-insensitively.

**Validation:**

* If a contact has sends but no opens, report zero opens rather than leaving the cell blank.
* If a Constant Contact call fails for one contact, show "not checked" in that row and continue.