Connectors

/

Microsoft Dynamics 365 Sales

/

Flag undeliverable Dynamics 365 Sales contacts from Constant Contact
Report
Cross-Connector

Tell each salesperson which contacts can no longer be emailed

For sales teams who want Constant Contact bounces and unsubscribes matched to Dynamics 365 Sales contacts and leads, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Flag undeliverable Dynamics 365 Sales contacts from Constant Contact
Which of our Dynamics 365 Sales contacts bounced or unsubscribed in Constant Contact in the last 30 days?
18 bounces and unsubscribes in the last 30 days match 14 Dynamics 365 Sales records. - Sam Patel: 5 records, 2 permanent bounces - Jordan Lee: 4 records, all unsubscribes - Likely bad addresses: 3 permanent bounces need correcting in the CRM - Unmatched: 4 emails are not in Dynamics 365 Sales An unsubscribe is a marketing opt-out, not a ban on one-to-one email. Want the list by owner?
Microsoft Dynamics 365 Sales
Sample figures. Your results come from your own account.
constant-contact-get-campaign-bounce
constant-contact-get-campaign-unsubscribe
microsoft-dynamics-365-sales-get-contacts
microsoft-dynamics-365-sales-get-leads

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Microsoft Dynamics 365 Sales

Microsoft Dynamics 365 Sales
Run it on your own Microsoft Dynamics 365 Sales data.

Connect Microsoft Dynamics 365 Sales, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Salespeople keep emailing dead addresses and opt outs

When an email bounces or someone unsubscribes in Constant Contact, the salesperson who owns that person in Dynamics 365 Sales rarely hears about it. They keep emailing a dead address or someone who opted out, and the bad data stays in the CRM.

Without PopdockAI

  • Export bounce and unsubscribe reports
  • Search each email in Dynamics 365 Sales
  • Work out who owns each person
  • Leave dead addresses in the CRM

With PopdockAI

  • Every bounce and unsubscribe in the period is collected
  • Each email is matched to a contact or lead
  • The list is grouped by owner, permanent bounces called out
  • Truncated results are flagged, and nothing is changed

The prompt

Use this prompt

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

Prompt
**Objective:** Find people who bounced or unsubscribed in Constant Contact in the last `{lookback-days}` days (default 30) and report which Dynamics 365 Sales contacts and leads they are, grouped by owner. This is read-only.

**Step 1: Collect bounces and unsubscribes from Constant Contact**

With `created-date.from` set to today minus `{lookback-days}` days, call:

* `constant-contact-get-campaign-bounce` (keep bounce-type and created-date)
* `constant-contact-get-campaign-unsubscribe` (keep reason and created-date)

Use `max-records` 500 for each. Reduce to unique email addresses. If a person both bounced and unsubscribed, keep both facts.

**Step 2: Match each email in Dynamics 365 Sales**

For each email, call `dynamics-365-sales-get-contacts` with `email`, then `dynamics-365-sales-get-leads` with `email` if no contact matches. Keep owner, parent-customer (contacts) or company-name (leads).

**Step 3: Report**

1. Totals: bounces, unsubscribes, matched to a contact, matched to a lead, not in Dynamics.
2. One section per owner, with a table: name, company, email, contact or lead, what happened (bounce type or unsubscribe reason), and date.
3. People not in Dynamics: a count only, unless there are 20 or fewer, then list them.

Point out bounces of a permanent type (for example non-existent address) separately: those emails in Dynamics are likely wrong and need correcting.

**Rules & Guidelines:**

* constant-contact tools are on the constant-contact server; dynamics-365-sales tools are on the dynamics-365-sales server.
* Read-only. Do NOT call `dynamics-365-sales-update-contact`, `dynamics-365-sales-update-lead`, `dynamics-365-sales-create-task`, `dynamics-365-sales-create-note`, `constant-contact-update-contact` or any other create, update or add tool.
* An unsubscribe is a marketing opt-out. Say so in the report; it does not mean the person cannot be contacted one-to-one by their owner.

**Validation:**

* If there are no bounces or unsubscribes in the period, say so and stop.
* If 500 rows come back for either call, say the result was truncated.
* Match emails case-insensitively and trimmed of spaces.

Who it's for

One answer, three teams that use it

Sales reps

Stop emailing addresses that bounce

See which of your contacts bounced so you can find a working address.

Which of my Dynamics 365 Sales contacts bounced in Constant Contact this month?

CRM administrators

Fix bad email data in the CRM

Permanent bounces are called out as addresses that likely need correcting.

List permanent bounces from Constant Contact in the last 60 days matched to Dynamics 365 Sales contacts and leads.

Marketing operations

Share opt outs with sales

Unsubscribes grouped by owner tell each salesperson who opted out of marketing.

Who unsubscribed in Constant Contact in the last 30 days, grouped by Dynamics 365 Sales owner?

How it works

What PopdockAI does when you ask

You pick a lookback period and your AI assistant matches Constant Contact bounces and unsubscribes to Dynamics 365 Sales. It explains that an unsubscribe is a marketing opt out, not a ban on one to one contact.

01

Ask

You pick a lookback period, 30 days by default.

Your AI tool

02

Collect

It gathers every bounce and unsubscribe in Constant Contact.

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

03

Match

It matches each email to a Dynamics 365 Sales contact or lead.

microsoft-dynamics-365-sales-get-contacts
microsoft-dynamics-365-sales-get-leads

04

Report

You get the list grouped by owner, and nothing is changed.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Microsoft Dynamics 365 Sales and one secure connection to your AI tool. No code, no exports.

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

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

microsoft-dynamics-365-sales-get-contacts

Returns Dynamics 365 Sales contacts. Filter by full name, email, city, job title, state, parent customer, created date and status, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-leads

Returns Dynamics 365 Sales leads. Filter by created date, name, status, rating, owner, company name, email and lead source, and cap how many records come back.
Read only.Nothing in Microsoft Dynamics 365 Sales 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

Every salesperson knows who they can no longer 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