Connectors

/

Pipedrive

/

Pipedrive organization Constant Contact engagement
Report
Cross-Connector

See how an account engages with your Constant Contact email

For account managers who want to know how people at a Pipedrive organization open and click Constant Contact email before a renewal call.

Try PopdockAI free
Get a live demo
Pipedrive organization Constant Contact engagement
How have people at Northwind Traders engaged with our Constant Contact emails in the last 90 days?
4 of 6 people at Northwind Traders are reachable in Constant Contact. - Most engaged: Dana Whitfield, 11 opens and 4 clicks - Unsubscribed: Sam Patel, on 2 September - Not reachable: 2 people not in Constant Contact - Open deal: Northwind expansion, 30,000 Want the row for each person?
Pipedrive
Sample figures. Your results come from your own account.
pipedrive-get-organization
pipedrive-get-person
pipedrive-get-deal
constant-contact-get-contact
constant-contact-get-contact-activity
constant-contact-get-campaign-unsubscribe

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Pipedrive

Pipedrive
Run it on your own Pipedrive data.

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

Try PopdockAI free

The problem

Who at the account still reads your email

Before an account review you want to know who at the organization still reads your emails, but Pipedrive holds deals and people while Constant Contact holds engagement. Looking up every person one at a time rarely happens.

Without PopdockAI

  • List the organization's people in Pipedrive
  • Search each email in Constant Contact
  • Count opens, clicks and unsubscribes by hand
  • Walk in not knowing who has gone quiet

With PopdockAI

  • The organization's people and open deals are read
  • Each email is found in Constant Contact
  • Opens, clicks, unsubscribes and last activity are counted
  • People not reachable by email are listed, and nothing is changed

The prompt

Use this prompt

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

Prompt
**Objective:** Summarise how the people at the Pipedrive organization `{organization}` have engaged with Constant Contact email over the last `{lookback-days}` days (default 90), next to the organization's open deals. Use it before an account review or renewal call.

**Step 1: Find the organization and its people (Pipedrive)**

Call `pipedrive-get-organization` with `name` set to `{organization}`, and if nothing comes back, with `name.contains`. If more than one matches, list them with city and country and stop. Then call `pipedrive-get-person` with the `organization-id`, and `pipedrive-get-deal` with the `organization-id` and `status` set to open.

**Step 2: Find each person in Constant Contact**

For each person with an email, call `constant-contact-get-contact` with `email-address`. People without an email, or not found, are listed as "not reachable by email".

**Step 3: Read engagement (Constant Contact)**

For each contact found, with `created-date.from` set to today minus `{lookback-days}` days (default 90):

* `constant-contact-get-contact-activity` with `contact-id`, counting opens and clicks.
* `constant-contact-get-campaign-unsubscribe` with `contact-id`.

**Step 4: Report**

1. The organization: name, owner, open deals (title, stage, value, expected close date).
2. A table per person: name, job title, email status (permission-to-send or unsubscribed), opens, clicks, last activity date.
3. The most engaged person and anyone who unsubscribed in the window.
4. A one-line read on the account's email engagement, based only on the data above.

**Rules & Guidelines:**

* `pipedrive-get-organization`, `pipedrive-get-person` and `pipedrive-get-deal` are on the pipedrive server. The `constant-contact-get-*` tools are on the constant-contact server.
* This prompt is read-only. Do NOT call `pipedrive-add-note`, `pipedrive-add-activity`, `pipedrive-update-organization` or any Constant Contact add or update tool.

**Validation:**

* If the organization has no people, report the deals and stop.
* If no person is in Constant Contact, say so plainly rather than reporting zero engagement.

Who it's for

One answer, three teams that use it

Account managers

Prepare for a renewal call

See who at the account opens your email and who has unsubscribed, next to the open deals.

How has Contoso engaged with our Constant Contact emails over the last 60 days?

Account executives

Find your most engaged contact

The most engaged person at the account is named, a good first call for a new opportunity.

Who at Fabrikam is most engaged with our Constant Contact email?

Marketing managers

Spot opt-outs at key accounts

Anyone at the organization who unsubscribed is listed, so sales knows email will not reach them.

Has anyone at Northwind Traders unsubscribed from our Constant Contact emails this year?

How it works

What PopdockAI does when you ask

You name the organization and a look-back, and your AI assistant checks each person's Constant Contact engagement. If nobody is in Constant Contact it says so rather than reporting zero.

01

Ask

You name the organization, and optionally a lookback period.

Your AI tool

02

Read

It reads the organization's people and open deals in Pipedrive.

pipedrive-get-organization
pipedrive-get-person
pipedrive-get-deal

03

Check

It finds each person in Constant Contact and counts opens, clicks and unsubscribes.

constant-contact-get-contact
constant-contact-get-contact-activity
constant-contact-get-campaign-unsubscribe

04

Report

You get a row per person, the most engaged contact and any opt-outs.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

pipedrive-get-organization

Returns Pipedrive organizations with address, industry, size, owner and open and won deal counts. Filter by name, city, state, country, industry or owner.
get-data

pipedrive-get-person

Returns Pipedrive contacts with email, phone, job title, organization, owner and last activity date. Filter by name, email, city, organization or owner.
get-data

pipedrive-get-deal

Returns Pipedrive deals with stage, pipeline, value, probability, owner and expected close date. Filter by status, stage, owner, organization, value range, expected close date range or title.
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-contact-activity

Returns a Constant Contact contact's email activity timeline, such as opens, clicks and bounces. Filter by contact, email address, campaign activity, activity type and date.
get-data

constant-contact-get-campaign-unsubscribe

Returns Constant Contact campaign unsubscribes with the reason given. Filter by campaign, campaign activity, contact, email address or domain, reason and date.
Read only.Nothing in Pipedrive 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 who at the account is engaged

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