Report

Cross-Connector

See a contact's deals and email engagement before you call

For sales reps who want Salesforce opportunities and campaigns next to Constant Contact opens, clicks and opt-outs, by asking their AI assistant.

Constant Contact and Salesforce contact profile

What's the story with riley.chen@contoso.com in Salesforce and Constant Contact?

Riley Chen has an open opportunity, and her email hard bounced last week. - Opportunity: Contoso renewal, 48,000, Negotiation - Campaigns: responded to the Q3 Webinar - Email: hard bounce on 1 October Want the dated activity table?

Constant Contact

Sample figures. Your results come from your own account.

salesforce-get-contact

salesforce-get-lead

salesforce-get-opportunity

salesforce-get-campaign-member

constant-contact-get-contact

constant-contact-get-campaign-open

constant-contact-get-campaign-click

constant-contact-get-campaign-bounce

constant-contact-get-campaign-unsubscribe

constant-contact-get-campaign

On this page

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Constant Contact

Run it on your own Constant Contact data.

Connect Constant Contact, pick your AI tool and paste the prompt.

The problem

An opt-out on a key contact is easy to miss

Before a call a rep wants open opportunities and campaign history from Salesforce and email engagement from Constant Contact. Checking both takes time, and an unsubscribe or hard bounce on a key contact slips by.

Without PopdockAI

Look up the contact or lead in Salesforce
Check open opportunities and campaign history
Search Constant Contact for opens and clicks
Miss the hard bounce before the call

With PopdockAI

Every Salesforce contact or lead match is reported
Open opportunities and campaign responses are listed
Constant Contact activity comes as a dated table
Bounces and opt-outs that matter are flagged, 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:** Build a single view of the person with email address `{email}`: who they are in Salesforce, and how they have engaged with Constant Contact email over the last `{lookback-days}` days (default 90).

**Step 1: Find the person in Salesforce**

Call `salesforce-get-contact` with `email` = `{email}`. If no contact comes back, call `salesforce-get-lead` with `email` = `{email}`. If more than one record matches, list them (name, account or company, owner) and use all of them in the report. If neither returns anything, record the person as absent from Salesforce and continue to Step 3.

**Step 2: Add the Salesforce context**

For a contact, take `account-id` from the contact and call `salesforce-get-opportunity` with `account-id` and `closed` = false to list open opportunities. Then call `salesforce-get-campaign-member` with `email` = `{email}` to see which Salesforce campaigns they belong to and whether they responded.

**Step 3: Find the person in Constant Contact**

Call `constant-contact-get-contact` with `email-address` = `{email}`. Note `permission-to-send`, `tags` and `contact-id`. If no contact comes back, report the person as absent from Constant Contact and skip Step 4.

**Step 4: Read their email engagement**

With `contact-id` from Step 3 and `created-date.from` set to today minus the lookback window, call `constant-contact-get-campaign-open`, `constant-contact-get-campaign-click`, `constant-contact-get-campaign-bounce` and `constant-contact-get-campaign-unsubscribe`. To name the campaigns, call `constant-contact-get-campaign` with each distinct `campaign-id`.

**Step 5: Report**

* **Salesforce:** record type (contact or lead), name, title, account or company, owner, open opportunities (name, stage, amount, close date), campaign memberships.
* **Constant Contact:** permission to send, tags, and a table of engagement (date, campaign, event: open, click with link, bounce, unsubscribe), newest first.
* **Read:** one or two sentences on how engaged this person is and anything sales should know (for example an unsubscribe or hard bounce on someone with an open opportunity).

**Rules & Guidelines:**

* Tools named `salesforce-*` are on the salesforce server; tools named `constant-contact-*` are on the constant-contact server.
* This prompt is read-only. Do NOT call `salesforce-add-task`, `salesforce-update-contact`, `salesforce-update-lead`, `constant-contact-update-contact`, `constant-contact-add-contact-note` or any other add, update or resend tool.

**Validation:**

* Compare email addresses case-insensitively and ignore surrounding spaces.
* If the person exists in only one system, say so plainly and report what that system has.
* If neither system has the email, say so and stop.

Who it's for

One answer, three teams that use it

Account executives

Call with the full story

Open deals and recent clicks show what the person cares about right now.

Brief me on sam.patel@fabrikam.com from Salesforce and Constant Contact before my 2pm call.

Sales development reps

Avoid chasing someone who opted out

An unsubscribe or hard bounce is flagged before you write the next email.

Has priya@contoso.com unsubscribed in Constant Contact, and is she on any open Salesforce opportunity?

Marketing managers

See campaign history for one person

Salesforce campaign membership next to email activity shows what actually reached them.

Which Salesforce campaigns is dana@northwindtraders.com in, and what has she clicked in the last 60 days?

How it works

What PopdockAI does when you ask

You give an email address and your AI assistant reads the person from Salesforce and Constant Contact. It only reads.

Ask

You give an email address, and optionally a look-back period.

Your AI tool

CRM

It finds the Salesforce contact or lead with open opportunities and campaigns.

salesforce-get-contact

salesforce-get-lead

salesforce-get-opportunity

salesforce-get-campaign-member

It reads Constant Contact permission, tags and dated activity.

constant-contact-get-contact

constant-contact-get-campaign

constant-contact-get-campaign-open

constant-contact-get-campaign-click

constant-contact-get-campaign-bounce

constant-contact-get-campaign-unsubscribe

Report

You get a short read with anything sales should know, and nothing changed.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

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.

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.

get-data

constant-contact-get-contact

Returns Constant Contact contacts with their name, email, company, job title, phone, location, tags and email permission. Filter by email address or domain, last name, company, state, permission and created date.

get-data

constant-contact-get-campaign-open

Returns Constant Contact campaign opens with the device used. Filter by campaign, campaign activity, contact, email address or domain, device type and date.

get-data

constant-contact-get-campaign-click

Returns Constant Contact campaign clicks with the link clicked and the device used. Filter by campaign, campaign activity, contact, email address or domain, device type 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

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

Returns Constant Contact email campaigns with their status and headline counts: sends, opens, not opened, clicks, bounces, forwards and opt-outs. Filter by name, status, type and last sent date.

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

Deals and email engagement before every call

Related use cases

More ways to put this data to work

Capture Constant Contact campaign clickers as Salesforce leads

Ask your AI to turn a Constant Contact campaign's clickers into Salesforce leads and it drops existing contacts and leads, never invents data and creates after you confirm.

Learn More

Log Constant Contact campaign clicks as Salesforce tasks

Ask your AI to log Constant Contact clicks as Salesforce tasks and it matches each clicker, skips existing tasks and creates them after you confirm.

Learn More

Compare a Constant Contact campaign with its Salesforce campaign

Ask your AI to compare a Constant Contact campaign with its Salesforce campaign and it shows email stats next to members, responses and won value, with audience overlap.

Learn More

Find Constant Contact clickers missing from Salesforce

Ask your AI which Constant Contact clickers are missing from Salesforce and it checks each as a contact and lead, then enriches the unmatched with name, company and title.

Learn More

Audit Constant Contact bounces

Ask your AI to audit Constant Contact bounces and it finds repeat bouncers, misspelt domains and campaigns over 2 percent, with a remove and watch list.

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.