Connectors

/

Constant Contact

/

Capture Constant Contact campaign clickers as Salesforce leads
Write
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Capture Constant Contact campaign clickers as Salesforce leads
Create Salesforce leads from everyone who clicked our October Product Update email in Constant Contact.
31 people clicked, and 9 are new to Salesforce. - Ready: 7 leads with name and company, such as Jordan Lee at Contoso - Missing details: 2 people have no company, so they are held back - Lead source: Constant Contact Shall I create the 7 leads?
Constant Contact
Sample figures. Your results come from your own account.
constant-contact-get-campaign
constant-contact-get-campaign-click
constant-contact-get-contact
salesforce-get-contact
salesforce-get-lead
salesforce-add-lead

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

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.

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

Your AI tool

02

Collect

It gathers the unique clickers and their details.

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

03

Check

It drops anyone already a Salesforce contact or lead.

salesforce-get-contact
salesforce-get-lead

04

Confirm

You review the leads, then they are created after a fresh duplicate check.

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

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

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

salesforce-add-lead

Creates a Salesforce lead with name, company, title, email, phone, industry, status and lead source.
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

Every interested clicker becomes one real lead

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