Connectors

/

Nutshell

/

Rank open Nutshell leads by Constant Contact engagement
Report
Cross-Connector

Rank your open Nutshell leads by email engagement

For sales reps who want to know who is reading their marketing email, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Rank open Nutshell leads by Constant Contact engagement
Rank Priya Raman's open Nutshell leads by how much their contacts engage with our Constant Contact email.
6 open leads ranked. 2 are warm, 1 high-value lead has gone silent. - Warm: Contoso Ltd, Expansion, 8,200 USD, 5 clicks in 30 days - Warm: Fabrikam, Pilot, 3,500 USD, 3 opens - Silent: Northwind Traders, Renewal 2027, 14,000 USD, no opens in 60 days - Not in email marketing: Adventure Works contact Want the next step for each lead?
Nutshell
Sample figures. Your results come from your own account.
nutshell-get-lead
nutshell-get-contact
constant-contact-get-contact
constant-contact-get-campaign-open
constant-contact-get-campaign-click

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Nutshell

Nutshell
Run it on your own Nutshell data.

Connect Nutshell, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Follow-up goes to the wrong deals

Sellers cannot tell which people on their open deals read marketing email. Opens and clicks live in Constant Contact and deals in Nutshell, so follow-up goes to the wrong deals and engaged buyers are overlooked.

Without PopdockAI

  • List the people on each open lead
  • Look up each one in Constant Contact
  • Count opens and clicks by hand
  • Guess which deals are warm

With PopdockAI

  • Open leads and their people are read
  • Each person's opens and clicks are looked up
  • People are ranked, with warm and silent high value leads flagged
  • People not in email marketing are labelled, not scored zero

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 open Nutshell leads owned by `{owner}` (default: all owners), rank the people attached to them by Constant Contact email engagement over the last `{lookback-days}` days (default 60), so sellers know who is warm.

**Step 1: Get the open leads**

Call `nutshell-get-lead` (Nutshell server) with `status` set to open, `owner.contains` set to the owner if given, and `max-records` 20. Keep `id`, `name`, `value`, `anticipated-close-time` and `people`.

**Step 2: Get the people's emails**

For each person on the leads call `nutshell-get-contact` with `name` set to that person to get `emails`. Skip people with no email and list them as unreachable.

**Step 3: Look up engagement**

For each email call `constant-contact-get-contact` (Constant Contact server) with `email-address`. Then call `constant-contact-get-campaign-open` and `constant-contact-get-campaign-click` with the `contact-id` and `created-date.from` set to the start of the window. Count opens and clicks.

**Step 4: Report**

A table per lead: lead name, value, expected close, then each person with opens, clicks and last activity. Order leads by engagement, highest first. Finish with the three leads where engagement is high and a call is the obvious next step, and the three high-value leads with no engagement at all.

**Rules & Guidelines:**

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

**Validation:**

* A person not found in Constant Contact is reported as not in email marketing, not as zero engagement.
* If there are no open leads, say so and stop.

Who it's for

One answer, three teams that use it

Account executives

Follow up with engaged buyers first

See who on your deals is opening and clicking, so your next calls go to warm leads.

Rank my open Nutshell leads by Constant Contact opens and clicks.

Sales managers

Spot high value deals gone silent

Valuable leads with no email engagement are flagged as worth a direct call.

Which of Sam Patel's high value Nutshell leads have contacts who stopped opening our emails?

Marketing managers

Show which deals email is warming

Engagement ranked by deal shows marketing's reach into the active pipeline.

Which open Nutshell leads for Dana Lee have the most engaged contacts in Constant Contact?

How it works

What PopdockAI does when you ask

You name a Nutshell owner, and your AI assistant ranks the people on their open leads by Constant Contact engagement. It only reads.

01

Ask

You name the Nutshell owner.

Your AI tool

02

Gather

It reads their open leads and the people on them.

nutshell-get-lead
nutshell-get-contact

03

Look up

It finds each person's opens and clicks in Constant Contact.

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

04

Rank

It ranks by engagement and flags warm and silent high-value leads.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

nutshell-get-lead

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

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

Know which deals are warm and which went quiet

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