Connectors

/

Salesforce

/

Rank Salesforce leads by Constant Contact engagement
Report
Cross-Connector

Call the Salesforce leads who are opening your emails first

For sales reps with long lead lists who want them ranked by recent Constant Contact opens and clicks, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Rank Salesforce leads by Constant Contact engagement
Rank my open Salesforce leads by how they engaged with our Constant Contact emails in the last 30 days.
Of 50 open leads, 18 engaged with your emails in the last 30 days. - Top: Jordan Lee, Contoso, 4 clicks and 9 opens, clicked the pricing page - Second: Sam Patel, Fabrikam Inc, 3 clicks on the case study - Not engaged: 27 - Not in Constant Contact: 5 Want the ranked table and a follow-up idea for each of the top five?
Salesforce
Sample figures. Your results come from your own account.
salesforce-get-lead
constant-contact-get-campaign-open
constant-contact-get-campaign-click
constant-contact-get-contact

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Salesforce

Salesforce
Run it on your own Salesforce data.

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

Try PopdockAI free

The problem

The warmest leads wait their turn in a long list

Reps with dozens of open Salesforce leads cannot easily tell who is warming up. The signal is in Constant Contact opens and clicks, but checking each lead there takes longer than calling down the list.

Without PopdockAI

  • Work through leads in date order
  • Look up each lead in Constant Contact
  • Read their opens and clicks campaign by campaign
  • Call the warm leads last

With PopdockAI

  • Open, unconverted leads with an email are read for you
  • Opens and clicks are scored, a click worth three opens
  • Leads are ranked with the top link clicked
  • Read only, with a warning about inflated opens

The prompt

Use this prompt

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

Prompt
**Objective:** Rank the open (unconverted) Salesforce leads owned by `{owner}` (default: all owners) by their Constant Contact email engagement over the last `{lookback-days}` days (default 30), checking at most `{max-leads}` leads (default 50).

**Step 1: Read open leads in Salesforce**

Call `salesforce-get-lead` with `converted` = false, plus `owner.contains` = `{owner}` if it is set. Keep leads that have an `email`, up to the limit, newest `created-date` first.

**Step 2: Read each lead's engagement in Constant Contact**

For each lead's email, with `created-date.from` set to today minus the lookback window, call `constant-contact-get-campaign-open` and `constant-contact-get-campaign-click` with `email-address` = the lead's email. Count opens and clicks and note the links clicked. If `constant-contact-get-contact` with `email-address` returns no contact, mark the lead as not in Constant Contact.

**Step 3: Score and rank**

Score each lead as clicks x 3 + opens. Drop leads with a score of zero from the ranking but count them.

**Step 4: Report**

A ranked table: lead name, company, status, owner, opens, clicks, last engagement date, top link clicked. Then counts: leads checked, engaged, not engaged, not in Constant Contact. Suggest the top five for follow-up in one sentence each, based on what they clicked.

**Rules & Guidelines:**

* Tools named `salesforce-*` are on the salesforce server; tools named `constant-contact-*` are on the constant-contact server.
* This prompt is read-only. Do NOT call `salesforce-update-lead`, `salesforce-add-task` or any other add or update tool on either server.

**Validation:**

* Compare email addresses case-insensitively and ignore surrounding spaces.
* If no open leads match the owner, say so and stop.
* Opens can be inflated by mail privacy features; say so if a lead has opens but no clicks across many campaigns.

Who it's for

One answer, three teams that use it

Sales development reps

Start the day with the warmest leads

Get a ranked call list based on who opened and clicked recently, with follow up ideas for the top five.

Which of my Salesforce leads clicked our Constant Contact emails most in the last two weeks?

Sales managers

Point the team at engaged prospects

Rank a rep's open leads by engagement so time goes to the people showing interest.

Rank Jordan Lee's open Salesforce leads by Constant Contact engagement over the last 45 days.

Email marketers

Show sales who your emails are warming

Turn email engagement into a ranked list sales can act on, without exporting reports.

Score our 100 newest Salesforce leads on Constant Contact opens and clicks from the last 30 days.

How it works

What PopdockAI does when you ask

You optionally pick an owner and a period, and your AI assistant ranks your open leads by email engagement. Nothing is changed in Salesforce or Constant Contact.

01

Ask

You optionally name an owner, a look-back period and how many leads to check.

Your AI tool

02

Read

It reads open, unconverted Salesforce leads with an email.

salesforce-get-lead

03

Score

It counts each lead's Constant Contact opens and clicks, a click worth three opens.

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

04

Report

You get a ranked table and follow-up ideas for the top five, with nothing changed.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

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

Call the engaged leads first

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