Connectors

/

Constant Contact

/

Trace Constant Contact campaign engagers to Attio deals
Report
Cross-Connector

Trace Constant Contact campaign engagers to Attio deals

For sales teams who want to act on campaign interest, by asking their AI assistant which people who clicked or opened are on open deals.

Try PopdockAI free
Get a live demo
Trace Constant Contact campaign engagers to Attio deals
Who clicked or opened the October Newsletter, and which of them are on open deals in Attio? Show the top 20.
12 people engaged with October Newsletter, and 4 are on open deals worth 310,000 in total. - Dana Whitfield, Northwind Traders: Renewal 2026, Negotiation, 180,000, owner Sam Patel - Luis Ortega, Contoso: Pilot, Proposal, 90,000, owner Alex Kim - Not in Attio: 3 people - No open deal: 5 people Want the full ranked table?
Constant Contact
Sample figures. Your results come from your own account.
constant-contact-get-campaign
constant-contact-get-campaign-click
constant-contact-get-campaign-open
attio-get-record-people
attio-get-record-deals

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

Hot signals go cold before reaching account owners

A campaign gets clicks and opens, but nobody tells account owners which of those people sit on open deals in Attio. Matching a click list to the CRM takes too long, so the signals go cold.

Without PopdockAI

  • Export clickers and openers from Constant Contact
  • Find each person in Attio
  • Look up their company's open deals
  • Pass the list on after interest fades

With PopdockAI

  • Clickers are collected, openers added if there is room
  • Each email is matched exactly to an Attio person
  • Open deals show stage, value and owner
  • People ranked by deal value, all deals listed, nothing 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:** For the Constant Contact campaign whose name contains {campaign-name}, find the people who clicked or opened it and show which of them are linked to open deals in Attio, up to {max-people} people (default 20).

**Step 1: Find the campaign**

Call `constant-contact-get-campaign` (Constant Contact server) with `name.contains` set to {campaign-name}. If more than one matches, list them with last sent date and stop. If none match, say so and stop.

**Step 2: Get the engaged contacts**

Call `constant-contact-get-campaign-click` with the campaign id as `campaign-id`, limited to {max-people} records. If fewer than {max-people} people come back, also call `constant-contact-get-campaign-open` for the same campaign and add the new people. Keep each person's email address, name and what they did (click link or open).

**Step 3: Find them in Attio**

For each email address, call `attio-get-record-people` (Attio server) with `email-addresses` set to it. Note the person's company and record id. If no match, mark "not in Attio".

**Step 4: Find their deals**

For each person found, call `attio-get-record-deals` filtered by the associated company, or by `record-id` if that is accepted. Keep deals that are not closed. Report stage, value and owner.

**Step 5: Report**

Rank people by deal value, highest first. Columns: name, company, action taken, link clicked if any, deal name, stage, value, owner. Then list the people who engaged but are not in Attio, and the people with no open deal.

**Rules & Guidelines:**

* Constant Contact tools are on the Constant Contact server; Attio tools are on the Attio server.
* Read-only. Do not call `attio-add-company`, `attio-update-company`, `attio-upsert-company`, `attio-delete-company`, `attio-add-person`, `attio-update-person`, `attio-upsert-person`, `attio-delete-person`, `attio-add-deal`, `attio-update-deal` and `attio-delete-deal`, or `constant-contact-add-contact`, `constant-contact-update-contact`, `constant-contact-add-contact-note`, `constant-contact-add-contact-tag`, `constant-contact-update-contact-tag`, `constant-contact-add-contact-list`, `constant-contact-update-contact-list`, `constant-contact-add-campaign`, `constant-contact-update-campaign` and `constant-contact-resend-campaign-to-non-openers`.

**Validation:**

* Match on exact email address only.
* If a person's company has several open deals, list all of them rather than guessing which is relevant.

Who it's for

One answer, three teams that use it

Account executives

See which deals just showed interest

Engagers on your open deals tell you who to call while interest is fresh.

Which people who clicked our Pricing Update email are on open deals in Attio?

Sales managers

Rank campaign interest by deal value

The biggest deals with fresh engagement rise to the top.

Rank the top 30 engagers on our Contoso Summit invite by Attio deal value.

Marketing managers

Find engagers the CRM does not know

People who engaged but are not in Attio are listed separately.

Who opened our Q4 Newsletter but is not in Attio?

How it works

What PopdockAI does when you ask

You name a campaign and your AI assistant traces its engagers to open Attio deals, ranked by value. It only reads.

01

Ask

You name the campaign and how many people to include.

Your AI tool

02

Collect

It finds the campaign and the people who clicked or opened.

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

03

Match

It finds each person in Attio and their open deals.

attio-get-record-people
attio-get-record-deals

04

Report

You get people ranked by deal value, plus those not in Attio.

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

attio-get-record-people

Returns people from Attio CRM. Read-only; filter by the fields the tool offers.
get-data

attio-get-record-deals

Returns deals from Attio CRM. Read-only; filter by the fields the tool offers.
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

Engagers on open deals, ranked by value

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