Connectors

/

Mailchimp

/

Link Mailchimp campaign openers to Attio deals
Report
Cross-Connector

Turn campaign openers into a sales follow up list

For marketing teams who want to hand sales the repeat openers of a Mailchimp campaign, with their Attio company and deals, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Link Mailchimp campaign openers to Attio deals
Which people opened our October product launch campaign in Mailchimp at least 3 times, and do they have deals in Attio?
9 people opened the October Product Launch campaign 3 or more times, and 6 of them are in Attio. - Top opener: Dana Whitfield, Northwind Traders, 7 opens, last interaction 12 Oct - Deal in play: Northwind Traders, Proposal stage, 18000 - No deal yet: Contoso, 2 openers - Not in Attio: 3 openers, listed with their emails Want me to lower the minimum opens to widen the list?
Mailchimp
Sample figures. Your results come from your own account.
mailchimp-get-campaign
mailchimp-get-campaign-open
attio-get-record-people
attio-get-record-deals

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

Opener lists handed to sales with no CRM context

After a campaign, marketing hands sales a list of openers, but nobody checks who is already in Attio or has a deal open. Sales chases cold names or misses warm ones because the report and the CRM live apart.

Without PopdockAI

  • Export repeat openers from the campaign report
  • Search Attio for each email
  • Look up company, last interaction and deals
  • Guess which names are worth a call

With PopdockAI

  • The campaign is confirmed and repeat openers are read
  • Each opener is matched to Attio by email
  • Company, last interaction and deals are shown together
  • Openers not in Attio are listed and nothing is created

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 the Mailchimp campaign `{campaign-id}`, take the people who opened it at least `{min-opens}` times (default 2) and show which of them are in Attio and what deals their companies have, so sales can follow up on warm interest.

**Step 1: Confirm the campaign**

Call `mailchimp-get-campaign` (Mailchimp) with `campaign-id` set to `{campaign-id}`. Keep `title`, `subject`, `send-date`, `open-rate`. If it does not exist, stop.

**Step 2: Read the openers**

Call `mailchimp-get-campaign-open` (Mailchimp) with `campaign-id` set to `{campaign-id}` and `opens.min` set to `{min-opens}`. Keep `email`, `first-name`, `last-name` and `opens`. If none, say so and stop.

**Step 3: Match to Attio**

For each email, call `attio-get-record-people` (Attio) with `email-addresses.contains` set to the email. Keep `name`, `job-title`, `company` and `last-interaction`. Then call `attio-get-record-deals` (Attio) with `associated-company.contains` set to the company and keep `deal-name`, `deal-stage`, `deal-value`, `deal-owner`.

**Step 4: Report**

Table ordered by opens: person, company, opens, last Attio interaction, deals. Add a second list of openers not found in Attio, with their emails. Finish with the campaign title and how many openers matched.

**Rules & Guidelines:**

* Tools whose names start with attio are on the Attio server. Tools whose names start with mailchimp are on the Mailchimp server. Both servers must be connected; if a tool from either is missing, say which server is not connected and stop.
* The join key between the two systems is the email address. Compare it case-insensitively and trimmed. Attio people can hold several emails, so match against any of them.
* Do not call any write tool on either server: `attio-add-company`, `attio-add-person`, `attio-add-deal`, `attio-update-company`, `attio-update-person`, `attio-update-deal`, `attio-upsert-company`, `attio-upsert-person`, `attio-delete-company`, `attio-delete-person`, `attio-delete-deal` (Attio), `mailchimp-add-list-member`, `mailchimp-update-list-member`, `mailchimp-add-customer`, `mailchimp-update-customer`, `mailchimp-add-segment-member`, `mailchimp-update-order`, `mailchimp-update-product`, `mailchimp-start-automation`, `mailchimp-pause-automation`, `mailchimp-replicate-campaign` (Mailchimp).

**Validation:**

* An opener in Attio with no deals is reported as "no deal yet".
* If the campaign has no openers at the threshold, suggest lowering the minimum opens rather than guessing.

Who it's for

One answer, three teams that use it

Campaign managers

Hand sales a list worth working

Give sales repeat openers with their company and deal context instead of a bare email export.

Which people opened our Mailchimp webinar recap at least 2 times, and what deals do they have in Attio?

Account executives

See which deal contacts are reading

Spot people on your open deals who keep opening campaigns, a cue to follow up while interest is high.

Did anyone on my Attio deals open the Mailchimp Pricing Update campaign 3 or more times?

CRM managers

Find engaged people missing from Attio

Openers with no Attio record are listed separately, so gaps are clear rather than guessed.

List repeat openers of our Mailchimp Customer News campaign who are not in Attio.

How it works

What PopdockAI does when you ask

You name the campaign and a minimum number of opens, and your AI assistant brings in the Attio context for each opener. It only reads.

01

Ask

You name a Mailchimp campaign and the minimum number of opens.

Your AI tool

02

Confirm

It checks the campaign exists and reads the people who opened it that often.

mailchimp-get-campaign
mailchimp-get-campaign-open

03

Match

It finds each opener in Attio by email and pulls their company, last interaction and deals.

attio-get-record-people
attio-get-record-deals

04

Report

You get a table ordered by opens, plus a list of openers not found in Attio.

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

mailchimp-get-campaign

Returns Mailchimp email campaigns with their status, audience, send date and headline results. Filter by status or send date to find drafts, scheduled sends or recent campaigns.
get-data

mailchimp-get-campaign-open

Returns the members who opened each Mailchimp campaign and how many times they opened it.
get-data

attio-get-record-people

Returns people from Attio CRM. Read-only; filter by the fields the tool offers.
get-data

attio-get-record-deals

Returns deals from Attio CRM. Read-only; filter by the fields the tool offers.
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

Warm openers ranked with deal context

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