Connectors

/

Constant Contact

/

Match Constant Contact campaign clickers to Nutshell
Report
Cross-Connector

Turn campaign clickers into a Nutshell call list

For marketers and sales reps who want campaign clicks matched to CRM deals, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Match Constant Contact campaign clickers to Nutshell
Who clicked the October Product News campaign, and which of them have open leads in Nutshell?
27 people clicked October Product News. 6 have open Nutshell leads. - Dana Whitfield, Northwind Traders: Renewal 2027, 14,000 USD - Luis Ortega, Contoso Ltd: Expansion, 8,200 USD - Mei Tan, Fabrikam: Pilot, 3,500 USD - 9 clickers are not in Nutshell Want the owners of these leads, or the list of clickers missing from the CRM?
Constant Contact
Sample figures. Your results come from your own account.
constant-contact-get-campaign
constant-contact-get-campaign-click
nutshell-get-contact
nutshell-get-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

The warmest clickers never get a call

After a campaign, the people who clicked sit in a Constant Contact report. Nobody matches them to Nutshell contacts and open leads, so warm prospects are not called and clickers missing from the CRM are lost.

Without PopdockAI

  • Open the click report in Constant Contact
  • Search Nutshell for each clicker
  • Check their open leads by hand
  • Miss clickers who are not in the CRM

With PopdockAI

  • The people who clicked are listed
  • Ambiguous campaign names stop the run and ask
  • Matches to Nutshell people are by email, never by name
  • Open leads and missing clickers are reported, read-only

The prompt

Use this prompt

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

Prompt
**Objective:** For the Constant Contact campaign named `{campaign-name}`, find the people who clicked and show which ones are Nutshell contacts with open leads, up to `{max-clickers}` clickers (default 20).

**Step 1: Find the campaign**

Call `constant-contact-get-campaign` (Constant Contact server) with `name.contains` set to the campaign name. If more than one matches, list them and stop. Keep `campaign-id`, `last-sent-date`, `sends`, `opens` and `clicks`.

**Step 2: Get the clickers**

Call `constant-contact-get-campaign-click` with `campaign-id` and `max-records` set to the clicker limit. Keep `email-address`, first and last name and `contact-id`. De-duplicate by address.

**Step 3: Match to Nutshell**

For each clicker call `nutshell-get-contact` (Nutshell server) with `name.contains` set to the last name, then keep only the contact whose emails field contains the clicker's address. Keep `id`, `owner`, `job-title` and `number-of-leads`. For matches with open leads call `nutshell-get-lead` with `status` open and `person-id` set to the contact id.

**Step 4: Report**

Campaign headline numbers (sends, opens, clicks). Then a table of clickers who are Nutshell contacts: name, title, owner, open leads with value. Then a list of clickers not in Nutshell, as candidates to add. Close with the follow-ups that look most worth a call.

**Rules & Guidelines:**

* Nutshell tools (`nutshell-*`) are on the Nutshell server; `constant-contact-*` tools are on the Constant Contact server.
* Read-only. Never call `nutshell-add-person`, `nutshell-add-activity` or `constant-contact-add-contact-note`.

**Validation:**

* Match on email address, not name alone.
* If the campaign has no clicks, report that and stop.

Who it's for

One answer, three teams that use it

Sales reps

Call clickers with open leads first

Matched clickers with live leads tell you where to start the day.

Which clickers on our Spring Offer campaign have open leads in Nutshell?

Marketing managers

See who is missing from the CRM

Clickers not in Nutshell are listed, ready to be added by your team.

Who clicked our September Newsletter but is not in Nutshell at all?

Sales managers

Hand out warm leads quickly

One list shows which open leads just showed interest by email.

List open Nutshell leads whose contacts clicked our Fabrikam Case Study email.

How it works

What PopdockAI does when you ask

You name a campaign and your AI assistant matches its clickers to Nutshell people and their open leads. It only reads.

01

Ask

You name the Constant Contact campaign.

Your AI tool

02

Gather

It lists the people who clicked and stops if the campaign is ambiguous.

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

03

Match

It finds Nutshell people by email and their open leads.

nutshell-get-contact
nutshell-get-lead

04

Report

It lists matched clickers with their leads and clickers missing from the CRM.

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

nutshell-get-contact

Returns Nutshell people (contacts) with their emails, phones and linked companies. Filter by name, email, owner and other fields.
get-data

nutshell-get-lead

Returns Nutshell leads (deals) with status, value, confidence, close date, owner and source. Filter by status, owner and dates.
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 call list that starts with live deals

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