Connectors

/

Constant Contact

/

Find Constant Contact clickers missing from Salesforce
Report
Cross-Connector

Find new prospects among your Constant Contact clickers

For marketers who want campaign clickers who are not in Salesforce handed to sales, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Find Constant Contact clickers missing from Salesforce
Which clickers on our Fall Launch email in Constant Contact aren't in Salesforce?
Of 50 clickers checked, 12 are not in Salesforce. - Jordan Lee, Contoso, IT Director, clicked pricing 3 times - Alex Morgan, Fabrikam, Operations Manager - Unchecked: 18 clickers beyond the limit of 50 Want the full table of 12 new prospects?
Constant Contact
Sample figures. Your results come from your own account.
constant-contact-get-campaign
constant-contact-get-campaign-click
salesforce-get-contact
salesforce-get-lead
constant-contact-get-contact

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Constant Contact

Constant Contact
Run it on your own Constant Contact data.

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

Try PopdockAI free

The problem

New interest never reaches sales

Some of the people clicking your Constant Contact campaigns are new to you, but you only find out by checking each email against Salesforce contacts and leads. For a large campaign that takes an afternoon, so it gets skipped.

Without PopdockAI

  • Export clickers from Constant Contact
  • Search Salesforce contacts for each email
  • Search Salesforce leads for the rest
  • Skip it when the campaign is large

With PopdockAI

  • Unique clickers are gathered, most clicks first
  • Each is checked as a Salesforce contact, then a lead
  • Unmatched people get name, company, title and links clicked
  • Unchecked people are counted, 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:** Find everyone who clicked a link in the Constant Contact campaign `{campaign-name}` and has no matching contact or lead in Salesforce, checking at most `{max-people}` people (default 50).

**Step 1: Identify the campaign in Constant Contact**

Call `constant-contact-get-campaign` with `name.contains` = `{campaign-name}`. If it matches more than one campaign, list them (name, last sent date, status) and stop so the user can choose. If none match, say so and stop.

**Step 2: Get the clickers**

Call `constant-contact-get-campaign-click` with the campaign's `campaign-id`. Reduce to distinct `email-address` values, keeping the number of clicks and the links clicked per person. Keep at most the limit, most clicks first.

**Step 3: Check each person in Salesforce**

For each email, call `salesforce-get-contact` with `email`. If nothing comes back, call `salesforce-get-lead` with `email`. A person is matched if either returns a record.

**Step 4: Enrich the unmatched**

For each unmatched email, call `constant-contact-get-contact` with `email-address` to pick up first name, last name, company name, job title and permission to send.

**Step 5: Report**

A table of unmatched people: email, name, company, job title, clicks, links clicked. Then a one-line count: clickers checked, matched as contacts, matched as leads, unmatched.

**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-add-lead`, `salesforce-add-contact` or any other add or update tool. Suggest the `create-leads-from-campaign-clickers` prompt if the user wants leads created.

**Validation:**

* Compare email addresses case-insensitively and ignore surrounding spaces.
* If the campaign has no clicks, say so and stop.
* If more clickers exist than the limit, say how many were not checked.

Who it's for

One answer, three teams that use it

Marketing managers

Hand sales genuinely new names

The unmatched clickers are new interest, enriched and ready to pass on.

Which clickers on our Pricing Update email in Constant Contact are not in Salesforce? Check 100.

Sales development reps

Find prospects worth a first call

Company, title and the links someone clicked tell you what to open with.

Show me new prospects from our Contoso Summit invite clickers, with their company and title.

Sales operations

See how much interest the CRM misses

A count of unmatched clickers shows how much campaign interest is not reaching Salesforce.

How many of the people who clicked our Q3 Newsletter are neither contacts nor leads in Salesforce?

How it works

What PopdockAI does when you ask

You name the campaign and your AI assistant checks each clicker against Salesforce contacts and leads. It only reads, and nothing is created.

01

Ask

You name the campaign, and optionally how many people to check.

Your AI tool

02

Collect

It gathers the unique clickers, most clicks first.

constant-contact-get-campaign
constant-contact-get-campaign-click

03

Check

It looks up each email as a Salesforce contact, then as a lead.

salesforce-get-contact
salesforce-get-lead

04

Report

You get the unmatched people with company, title and links clicked.

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

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.
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

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

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.
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.

How Popdock AI secures your data

The outcome

A clean list of new prospects from every campaign

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