Report

Cross-Connector

Find Salesforce records Mailchimp can no longer reach

For marketing teams who want Mailchimp unsubscribes and hard bounces matched to Salesforce records and campaigns, by asking their AI assistant.

Flag Salesforce contacts who unsubscribed or bounced in Mailchimp

Show me Salesforce contacts who unsubscribed or hard bounced in Mailchimp in the last 30 days.

38 people unsubscribed and 11 hard bounced in Mailchimp in the last 30 days. - Matched in Salesforce: 33, as contacts or leads with their owner - Still in campaigns: 19 remain members of Salesforce campaigns - Example: Sam Patel, Fabrikam Inc, unsubscribed from October Newsletter - Not in Salesforce: 16 Want both tables with the campaigns each person is still in?

Salesforce

Sample figures. Your results come from your own account.

mailchimp-get-campaign-unsubscribe

mailchimp-get-campaign-email-activity

mailchimp-get-campaign

salesforce-get-contact

salesforce-get-lead

salesforce-get-campaign-member

On this page

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Salesforce

Run it on your own Salesforce data.

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

The problem

Unreachable contacts still sitting in active campaigns

When someone unsubscribes or hard bounces in Mailchimp, their Salesforce record usually stays as it was and remains in active campaigns. Finding them means pulling two Mailchimp reports and searching every address in Salesforce contacts, leads and campaign members.

Without PopdockAI

Pull the unsubscribe report from Mailchimp
Pull the bounce report separately
Search each address in Salesforce contacts and leads
Check which campaigns still include each person

With PopdockAI

Unsubscribes and hard bounces are read with campaign and reason
Each address is matched to a Salesforce contact or lead and owner
Campaigns that still include the person are listed
Read only, so you decide what to clean up

The prompt

Use this prompt

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

Prompt

**Objective:** List everyone who unsubscribed from a Mailchimp campaign, or whose address hard-bounced, in the last `{lookback-days}` days (default 30), and show the matching Salesforce contact or lead so their records can be reviewed.

**Step 1: Collect unsubscribes**

Call `mailchimp-get-campaign-unsubscribe` with `unsubscribe-date.from` set to the date `{lookback-days}` days ago. Keep email, first-name, last-name, campaign-name, reason and unsubscribe-date.

**Step 2: Collect hard bounces**

Call `mailchimp-get-campaign-email-activity` with `action` set to bounce and `activity-date.from` set to the same date. Keep only rows whose bounce-type is hard. Use `mailchimp-get-campaign` with `campaign-id` for the campaign title.

**Step 3: Match in Salesforce**

For each unique email, call `salesforce-get-contact` with `email` set to that address, then `salesforce-get-lead` if no contact matches. For each match, call `salesforce-get-campaign-member` with `email` set to that address to show which Salesforce campaigns still include them.

**Step 4: Report**

Two tables, Unsubscribed and Hard bounced. Columns: email, name, Mailchimp campaign, date, reason or bounce type, Salesforce record (contact or lead, with id and owner, or "not in Salesforce"), and the Salesforce campaigns they are still a member of. End with the counts for each table and how many matched Salesforce.

**Rules & Guidelines:**

* `mailchimp-get-campaign-unsubscribe`, `mailchimp-get-campaign-email-activity` and `mailchimp-get-campaign` are on the mailchimp server. `salesforce-get-contact`, `salesforce-get-lead` and `salesforce-get-campaign-member` are on the salesforce server.
* This prompt is read-only. Do not call `salesforce-update-contact`, `salesforce-update-lead`, `mailchimp-update-list-member` or `mailchimp-add-list-member`. Report the records; do not change them.

**Validation:**

* Compare email addresses case-insensitively.
* A person who both unsubscribed and bounced appears in both tables.
* If both Mailchimp reads return nothing for the period, say so and stop.

Who it's for

One answer, three teams that use it

Marketing operations

Clean Salesforce campaigns with evidence

See exactly which records email no longer reaches and which campaigns still include them.

Which Salesforce contacts and leads hard bounced in Mailchimp in the last 60 days, and what campaigns are they still in?

Email marketers

Respect unsubscribes across systems

Make sure people who opted out in Mailchimp are not pulled back into the next Salesforce campaign.

List Salesforce records that unsubscribed in Mailchimp this quarter, with the campaign they left from.

Sales reps

Know which of your contacts went dark

Find out which of your contacts and leads can no longer be reached by email, with the owner shown.

Did any of the Contoso or Fabrikam contacts in Salesforce unsubscribe or bounce in Mailchimp last month?

How it works

What PopdockAI does when you ask

You choose a lookback period, and your AI assistant matches Mailchimp opt outs and hard bounces to Salesforce records. It reports what it finds and changes nothing.

Ask

You choose a lookback period, 30 days by default.

Your AI tool

Collect

It reads Mailchimp unsubscribes and hard bounces with the campaign and reason.

mailchimp-get-campaign-unsubscribe

mailchimp-get-campaign-email-activity

mailchimp-get-campaign

Match

It finds each email as a Salesforce contact or lead and lists their campaigns.

salesforce-get-contact

salesforce-get-lead

salesforce-get-campaign-member

Report

You get unsubscribed and hard bounced tables, with nothing changed.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

mailchimp-get-campaign-unsubscribe

Returns the members who unsubscribed from each Mailchimp campaign, with the date and the reason they gave.

get-data

mailchimp-get-campaign-email-activity

Returns each member's open, click and bounce events for Mailchimp campaigns, with timestamps and the URLs they clicked.

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

salesforce-get-contact

Returns Salesforce contacts with their account, title, department, email, phone, mailing address, owner and lead source. Filter by name, email, account, title, owner, lead source and mailing city or state.

get-data

salesforce-get-lead

Returns Salesforce leads with their company, status, source, owner, contact details, location and whether they are converted. Filter by name, company, email, status, lead source, owner, state, converted flag and created date.

get-data

salesforce-get-campaign-member

Returns the leads and contacts on Salesforce campaigns, with their member status and whether and when they responded. Filter by campaign, name, email, lead, contact, status and responded flag.

Read only.Nothing in Salesforce 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.

The outcome

Clean campaign lists, with the evidence in hand

Related use cases

More ways to put this data to work

Add Salesforce campaign members to a Mailchimp audience

Ask your AI to add Salesforce campaign members to a Mailchimp audience and it adds new people as pending for double opt-in, skips anyone already there, and writes only after you confirm.

Learn More

Capture a new Salesforce lead

Ask your AI to add a lead to Salesforce and it checks existing leads, contacts and accounts first, then creates the lead or updates the existing one only after you confirm.

Learn More

Create a Salesforce account with a contact

Ask your AI to create a Salesforce account with a contact and it checks for existing accounts, contacts and leads, then creates and links both only after you confirm.

Learn More

Create Salesforce leads from tagged Drip subscribers

Ask your AI to create Salesforce leads from tagged Drip subscribers and it skips anyone already a contact or lead, proposes the rest and creates them after you confirm.

Learn More

Log a Salesforce follow-up task

Ask your AI to log a Salesforce follow-up task and it finds the record and assignee, checks for a similar open task, and creates it only after you confirm.

Learn More

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.