Connectors

/

Salesforce

/

Flag Salesforce contacts who unsubscribed or bounced in Constant Contact
Report
Cross-Connector

Tell Salesforce owners which contacts opted out or bounced

For sales teams who keep emailing people who opted out or bounced in Constant Contact, and want owners told, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Flag Salesforce contacts who unsubscribed or bounced in Constant Contact
Which of our Salesforce contacts unsubscribed or bounced in Constant Contact in the last 30 days?
41 addresses unsubscribed or bounced, and 26 match Salesforce records. - Unsubscribed: 14, 3 on accounts with open opportunities - Bounced: 12, of which 4 look temporary, such as a full mailbox - Example: Jordan Lee at Contoso Ltd, owner Sam Patel, open deal - Not in Salesforce: 15 Want both tables sorted by owner?
Salesforce
Sample figures. Your results come from your own account.
constant-contact-get-campaign-unsubscribe
constant-contact-get-campaign-bounce
salesforce-get-contact
salesforce-get-lead
salesforce-get-opportunity

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Salesforce

Salesforce
Run it on your own Salesforce data.

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

Try PopdockAI free

The problem

Owners still emailing people who opted out or bounced

Salesforce owners keep emailing contacts who unsubscribed or bounced in Constant Contact, because nothing tells them. Matching every opt out and bounce to a Salesforce record and owner by hand is slow enough that it rarely happens.

Without PopdockAI

  • Export unsubscribes and bounces from each campaign
  • Search Salesforce for each address
  • Work out the owner and any open deals
  • Owners keep sending to people who said no

With PopdockAI

  • Every unsubscribe and bounce in the period is collected
  • Each address is matched to a Salesforce contact or lead and owner
  • Accounts with open opportunities are flagged first
  • Read only, and temporary bounces are labelled

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 every Salesforce contact or lead who unsubscribed from, or had a bounce on, Constant Contact email in the last `{lookback-days}` days (default 30), so the record owner knows the address is opted out or bad.

**Step 1: Read opt-outs and bounces in Constant Contact**

With `created-date.from` set to today minus the lookback window, call `constant-contact-get-campaign-unsubscribe` and `constant-contact-get-campaign-bounce`. Reduce to distinct `email-address` values, keeping for each the latest event, its date, the unsubscribe `reason` or the `bounce-type`, and the `campaign-id`.

**Step 2: Match each address in Salesforce**

For each email, call `salesforce-get-contact` with `email`. If nothing comes back, call `salesforce-get-lead` with `email`. Addresses that match neither are out of scope; count them but do not list them.

**Step 3: Add commercial context**

For each matched contact, call `salesforce-get-opportunity` with its `account-id` and `closed` = false, and note whether the account has open opportunities.

**Step 4: Report**

Two tables, unsubscribes and bounces, each with: email, Salesforce record type, name, account or company, owner, event date, reason or bounce type, open opportunities (yes/no). Sort each by owner. Flag rows with open opportunities first. End with counts: events read, matched in Salesforce, not in Salesforce.

**Rules & Guidelines:**

* Tools named `constant-contact-*` are on the constant-contact server; tools named `salesforce-*` are on the salesforce server.
* This prompt is read-only. Do NOT call `salesforce-update-contact`, `salesforce-update-lead`, `salesforce-add-task`, `constant-contact-update-contact` or any other add or update tool. An unsubscribe is a consent signal; do not try to change it.

**Validation:**

* Compare email addresses case-insensitively and ignore surrounding spaces.
* If there are no unsubscribes or bounces in the window, say so and stop.
* If a bounce type looks temporary (a soft or mailbox-full bounce), label it as such rather than calling the address bad.

Who it's for

One answer, three teams that use it

Account executives

Stop emailing people who said no

See which of your contacts unsubscribed or bounced, starting with accounts that have live deals.

Which of my Salesforce contacts unsubscribed from Constant Contact emails in the last 60 days?

Sales managers

Protect live deals from bad outreach

Find opt outs and bounces on accounts with open opportunities, grouped by owner.

List Constant Contact bounces and unsubscribes from the last 30 days on Salesforce accounts with open deals, by owner.

Marketing operations

Share consent signals with sales

Give sales a clear table of opt outs and bounces without changing any record yourself.

Match last quarter's Constant Contact unsubscribes and bounces to Salesforce contacts and leads.

How it works

What PopdockAI does when you ask

You pick a look-back period, and your AI assistant matches Constant Contact opt outs and bounces to Salesforce records and their owners. Nothing is updated in either system.

01

Ask

You pick a look-back period, 30 days by default.

Your AI tool

02

Collect

It gathers every unsubscribe and bounce in Constant Contact.

constant-contact-get-campaign-unsubscribe
constant-contact-get-campaign-bounce

03

Match

It finds each email as a Salesforce contact or lead and checks for open opportunities.

salesforce-get-contact
salesforce-get-lead
salesforce-get-opportunity

04

Report

You get unsubscribe and bounce tables by owner, 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

constant-contact-get-campaign-unsubscribe

Returns Constant Contact campaign unsubscribes with the reason given. Filter by campaign, campaign activity, contact, email address or domain, reason and date.
get-data

constant-contact-get-campaign-bounce

Returns Constant Contact campaign bounces with the bounce type. Filter by campaign, campaign activity, contact, email address or domain, bounce type and date.
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-opportunity

Returns Salesforce opportunities with their account, stage, amount, probability, close date, next step, owner and whether they are closed or won. Filter by name, account, stage, owner, amount, close date and closed and won flags.
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.

How Popdock AI secures your data

The outcome

Owners know who opted out before the next email

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