/
/
Turn Constant Contact clickers into Salesforce leads, once
For sales and marketing teams who want campaign clickers created as Salesforce leads with real details, by asking their AI assistant.
On this page
Connector
Connect Constant Contact, pick your AI tool and paste the prompt.
The problem
Campaign clickers never make it into Salesforce
Clickers from a Constant Contact campaign are worth a follow-up, but only if they reach Salesforce as leads, and only once. Checking each person against contacts and leads and typing in their details means many never make it.
Without PopdockAI
- Export the click report from Constant Contact
- Search Salesforce contacts and leads for each person
- Fill in names, companies and titles by hand
- Skip the job when the list gets long
With PopdockAI
- Unique clickers are collected with their details
- Existing Salesforce contacts and leads are dropped
- People missing a last name or company are set aside, never invented
- Leads are created after you confirm, with a fresh duplicate check
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Create a Salesforce lead for each person who clicked the Constant Contact campaign `{campaign-name}` and is not already a contact or lead in Salesforce, with lead source `{lead-source}` (default "Constant Contact").
**Step 1: Identify the campaign in Constant Contact**
Call `constant-contact-get-campaign` with `name.contains` = `{campaign-name}`. If it matches more than one, list them and stop so the user can choose. If none match, say so and stop.
**Step 2: Get the clickers and their details**
Call `constant-contact-get-campaign-click` with the campaign's `campaign-id` and reduce to distinct `email-address` values. For each, call `constant-contact-get-contact` with `email-address` to get first name, last name, company name, job title and phone number.
**Step 3: Remove people Salesforce already has**
For each email, call `salesforce-get-contact` with `email`, then `salesforce-get-lead` with `email`. Drop anyone either returns.
**Step 4: Confirm before writing**
Show the user a table of the leads you intend to create: email, first name, last name, company, title, phone. A Salesforce lead needs a last name and a company. Put anyone missing either in a separate "cannot create" table with the reason, and do not invent values for them. Ask the user to confirm the list. Do not continue without an explicit yes.
**Step 5: Create the leads**
For each confirmed person, call `salesforce-add-lead` with `email`, `first-name`, `last-name`, `company`, `title`, `phone` and `lead-source` = `{lead-source}` (or "Constant Contact" if blank). Record the returned `id`.
**Step 6: Report**
A table: email, name, company, result (created with Salesforce id, or the error). Then counts: clickers, already in Salesforce, created, failed, could not create.
**Rules & Guidelines:**
* Tools named `constant-contact-*` are on the constant-contact server; tools named `salesforce-*` are on the salesforce server.
* The only write tool this prompt may call is `salesforce-add-lead`, on the salesforce server, and only after the user confirms in Step 4.
* Do NOT call `salesforce-add-contact`, `salesforce-update-lead`, `salesforce-update-contact` or any Constant Contact add or update tool.
**Validation:**
* Compare email addresses case-insensitively and ignore surrounding spaces.
* Re-check `salesforce-get-lead` for an email immediately before creating it if the confirmation step took a while, so a lead is never created twice.
* If one create fails, report it and carry on with the rest.Who it's for
One answer, three teams that use it
Sales development reps
Follow up while interest is fresh
Get a campaign's clickers into Salesforce the same day, ready to call, without building the list yourself.
Turn the clickers from our Spring Pricing email in Constant Contact into Salesforce leads with lead source Email.
Marketing managers
Hand sales real leads, not a spreadsheet
Campaign interest reaches the CRM as proper leads, so it shows up in reports and gets worked.
How many people who clicked our Q2 Newsletter in Constant Contact are not in Salesforce yet?
Sales operations
Keep Salesforce free of duplicate leads
Existing contacts and leads are dropped and rechecked before creation, so nobody is entered twice.
Create Salesforce leads from the Fabrikam webinar invite clickers in Constant Contact, but skip anyone already a contact.
How it works
What PopdockAI does when you ask
You name the campaign and your AI assistant gathers its clickers and checks Salesforce for each one. Leads are created only after you confirm, and no missing values are made up.
01
Ask
You name the campaign, and optionally a lead source.
02
Collect
It gathers the unique clickers and their details.
03
Check
It drops anyone already a Salesforce contact or lead.
04
Confirm
You review the leads, then they are created after a fresh duplicate check.
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.
constant-contact-get-campaign
constant-contact-get-campaign-click
constant-contact-get-contact
salesforce-get-contact
salesforce-get-lead
salesforce-add-lead
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
Every interested clicker becomes one real lead
Related use cases
More ways to put this data to work
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.

.webp)
