One profile of a person across HubSpot and Mailchimp

**Objective:** Build a single profile of the person with email `{email}` from HubSpot and Mailchimp, including their Mailchimp email activity over the last `{lookback-days}` days (default 90 if blank).

**Step 1: Find the person in HubSpot**

Call `hubspot-get-contacts` with `email` set to `{email}`. Note `record-id`, name, `company-name`, `company-id`, `lifecycle-stage`, `lead-status`, `contact-owner` and `last-activity-date`. If more than one contact comes back, list them and use all of them in the steps below. If none comes back, say the person is not in HubSpot and continue with Step 3.

**Step 2: HubSpot context**

* Call `hubspot-get-contact-subscriptions` with `recipient-email` set to `{email}` to get their HubSpot email subscription statuses.
* If the contact has a `company-id`, call `hubspot-get-deals` with `company-id` set to it and list deals whose `deal-stage-name` is not a closed stage.
* Call `hubspot-get-tickets` with `contact-id` set to the contact's `record-id` and list tickets that are not closed.

**Step 3: Find the person in Mailchimp**

* Call `mailchimp-get-list-member` with `email` set to `{email}`. Note each audience (`list-name`), `status`, `tags`, `rating`, `average-open-rate` and `average-click-rate`.
* Call `mailchimp-get-customer` with `email` set to `{email}`. Note `orders-count`, `total-spent` and `opt-in-status`.
* Call `mailchimp-get-campaign-email-activity` with `email-address` set to `{email}` and `activity-date.from` set to today minus the lookback. Group the results by `campaign-id` and `action`.

If nothing comes back from any Mailchimp call, say the person is not in Mailchimp.

**Step 4: Report**

A short profile with three sections: HubSpot (owner, lifecycle, company, open deals, open tickets, subscription statuses), Mailchimp (audiences with status, store customer totals, opens and clicks by campaign), and Discrepancies. Under Discrepancies list every place the two systems disagree. For example: subscribed in Mailchimp but unsubscribed in HubSpot (or the reverse), a store customer in Mailchimp who is not a customer lifecycle stage in HubSpot, or a name that differs.

**Rules & Guidelines:**

* Tools starting hubspot- are on the HubSpot server; tools starting mailchimp- are on the Mailchimp server.
* Match on email address only, compared case-insensitively with surrounding spaces trimmed. Never match on name alone.
* This prompt is read-only. Do not call `hubspot-add-contact`, `hubspot-update-contact`, `hubspot-add-contact-note`, `hubspot-add-company`, `hubspot-update-company`, `hubspot-add-company-note`, `hubspot-add-deal`, `hubspot-update-deal`, `hubspot-add-deal-note`, `hubspot-add-ticket`, `hubspot-update-ticket` or `hubspot-add-ticket-note` on HubSpot, and do not call `mailchimp-add-list-member`, `mailchimp-update-list-member`, `mailchimp-add-customer`, `mailchimp-update-customer`, `mailchimp-add-segment-member`, `mailchimp-start-automation`, `mailchimp-pause-automation`, `mailchimp-replicate-campaign`, `mailchimp-update-product` or `mailchimp-update-order` on Mailchimp.

**Validation:**

* If the person is in neither system, say so in one line and stop.
* If the person is in only one system, report that side in full and state plainly that they are missing from the other.
* Do not guess a reason for a discrepancy; report the two values side by side.