Connectors

/

Mailchimp

/

Show Mailchimp engagement for the people on a Nutshell lead
Report
Cross-Connector

See Mailchimp engagement for everyone on a Nutshell lead

For sales reps who want to choose who to approach on a deal, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Show Mailchimp engagement for the people on a Nutshell lead
Who should I approach on the Northwind Traders Renewal 2027 lead? Check their Mailchimp engagement.
3 people are on Renewal 2027. 1 is do-not-email. - Dana Whitfield: subscribed, opened 7 of 12 campaigns, best engaged - Luis Ortega: subscribed, opened 1 of 12 - Mei Tan: unsubscribed, do not email - 1 name match is ambiguous and flagged for review Want the campaigns Dana opened most recently?
Mailchimp
Sample figures. Your results come from your own account.
nutshell-get-lead
nutshell-get-contact
mailchimp-get-list-member
mailchimp-get-campaign-recipient

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Mailchimp

Mailchimp
Run it on your own Mailchimp data.

Connect Mailchimp, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Picking who to approach on a lead blind

Deciding who on a lead to approach means checking each person in Mailchimp one at a time. Someone unsubscribed or bounced is easy to email by mistake, and the best engaged person is hard to spot.

Without PopdockAI

  • Open the lead and list its people
  • Copy each address into Mailchimp
  • Check status and engagement one at a time
  • Email someone who opted out by mistake

With PopdockAI

  • The lead's people and addresses are read
  • Each person is checked in Mailchimp
  • Unsubscribed or cleaned people are marked do not email
  • Ambiguous matches are flagged and nothing changes

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** For Nutshell lead number `{lead-number}`, report how each associated person engages with Mailchimp email.

**Step 1: Read the lead**

Call `nutshell-get-lead` (Nutshell server) with `number` set to `{lead-number}`. If nothing matches, say so and stop. Keep name, status, value, owner, due-time, last-contacted, and the `people` and `companies` values.

**Step 2: Resolve the people and their emails**

For each person, call `nutshell-get-contact` (Nutshell server), using `name` for the person's name, or `company-id` if the lead has a company id and the people cannot be matched by name. Collect each person's emails. If a person has no email, list them as unreachable and continue.

**Step 3: Look up each email in Mailchimp**

For each email call `mailchimp-get-list-member` with `email` (status, rating, average-open-rate, average-click-rate), then `mailchimp-get-campaign-recipient` with `email-address` (open-count, last-open-date). If `{campaign-id}` is given, also pass it as `campaign-id` to the recipient call to focus on that campaign. Compare emails case-insensitively. A person absent from Mailchimp is reported as such.

**Step 4: Report**

A table with one row per person: name, email, Mailchimp status, open-count, last-open-date, average-open-rate. Then lead context (status, value, due-time) and a recommendation of who on the lead to approach first and who should not be emailed (unsubscribed or cleaned).

**Rules & Guidelines:**

* `nutshell-get-lead` and `nutshell-get-contact` are on the Nutshell server; `mailchimp-get-list-member` and `mailchimp-get-campaign-recipient` are on the Mailchimp server.
* Read-only. Do not call `nutshell-update-lead`, `nutshell-add-activity`, `mailchimp-update-list-member` or any other write tool.

**Validation:**

* If the lead has no people, say so and stop.
* If the people value holds names only, match on name and flag ambiguous matches instead of guessing.

Who it's for

One answer, three teams that use it

Account executives

Approach the most engaged person

See engagement for everyone on a lead and start with the person who reads your emails.

Who on the Fabrikam Expansion lead in Nutshell engages most with our Mailchimp emails?

Sales development reps

Avoid emailing people who opted out

Unsubscribed or cleaned people are marked do not email before you write to anyone.

Is anyone on the Contoso Pilot lead unsubscribed in Mailchimp?

Sales managers

Coach reps on who to contact

Use engagement on each lead to guide reps toward the right person.

Check Mailchimp engagement for the people on the Northwind Traders Q2 lead.

How it works

What PopdockAI does when you ask

You name the Nutshell lead, and your AI assistant checks everyone on it in Mailchimp. It only reads.

01

Ask

You name the lead.

Your AI tool

02

Resolve

It reads the lead and finds its people and email addresses.

nutshell-get-lead
nutshell-get-contact

03

Look up

It checks each person in Mailchimp.

mailchimp-get-list-member
mailchimp-get-campaign-recipient

04

Report

It reports engagement and marks unsubscribed or cleaned people do-not-email.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Mailchimp and one secure connection to your AI tool. No code, no exports.

get-data

nutshell-get-lead

Returns Nutshell leads (deals) with status, value, confidence, close date, owner and source. Filter by status, owner and dates.
get-data

nutshell-get-contact

Returns Nutshell people (contacts) with their emails, phones and linked companies. Filter by name, email, owner and other fields.
get-data

mailchimp-get-list-member

Returns the members (subscribers) of Mailchimp audiences, with subscription status, tags and engagement rating. Filter by email address or status to look someone up.
get-data

mailchimp-get-campaign-recipient

Returns the members each Mailchimp campaign was sent to, with delivery status and how often each one opened it.
Read only.Nothing in Mailchimp Changes

This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.

How Popdock AI secures your data

The outcome

The right person to approach on every lead

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

One prompt template with infinite possibilities.

‍

Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.

Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

Try PopdockAI Free
See Documentation