Connectors

/

Constant Contact

/

Constant Contact engagement for a OnePageCRM contact
Report
Cross-Connector

See a contact email engagement beside their deals

For sales reps who want Constant Contact activity and OnePageCRM deals in one answer, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Constant Contact engagement for a OnePageCRM contact
How has dana@northwindtraders.com engaged with our Constant Contact campaigns in the last 90 days, and what deals does she have in OnePageCRM?
Dana opened 6 campaigns and clicked 3 links in the last 90 days, and has one open deal. - Most clicked: Spring warehouse offer, 2 clicks - Opt-out: none, permission to send is granted - Deal: Warehouse rollout, Proposal, 18,500, expected close 30 June Want the campaign by campaign breakdown?
Constant Contact
Sample figures. Your results come from your own account.
onepagecrm-get-contact
constant-contact-get-contact
constant-contact-get-campaign-open
constant-contact-get-campaign-click
constant-contact-get-campaign-unsubscribe
constant-contact-get-campaign-bounce
onepagecrm-get-deal
onepagecrm-get-action
onepagecrm-get-action-stream
onepagecrm-get-note
constant-contact-get-campaign
constant-contact-get-contact-list-member
constant-contact-get-contact-list

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

Email engagement never sits beside the pipeline

To see how a contact reads your email a rep checks Constant Contact, then opens OnePageCRM for their deals. Opens, clicks and opt-outs never sit beside the pipeline, so a rep can chase someone who already opted out.

Without PopdockAI

  • Search Constant Contact for the contact
  • Count opens and clicks from campaign reports
  • Open OnePageCRM for deals and next action
  • Miss an opt-out against an open deal

With PopdockAI

  • The person is found in OnePageCRM, then in Constant Contact
  • Opens and clicks are counted over your lookback
  • Unsubscribes and bounces show date and reason
  • Opt-outs against open deals are flagged, 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:** Build a combined engagement and pipeline view for the OnePageCRM contact with email `{contact-email}`, looking back `{lookback-days}` days (default 90).

**Step 1: Find the contact in OnePageCRM**

Call `onepagecrm-get-contact` (OnePageCRM server) with `email` set to `{contact-email}`. If more than one contact matches, list them and stop. If none matches, say so and stop. Keep `id`, `first-name`, `last-name`, `company-name`, `status`, `next-action`, `next-action-date` and `total-pending-amount`.

**Step 2: Find the same person in Constant Contact**

Call `constant-contact-get-contact` (Constant Contact server) with `email-address` set to the email from Step 1. If nothing comes back, report the person as in OnePageCRM but not in Constant Contact, then go to Step 4 with an empty engagement section. Otherwise keep `contact-id`, `permission-to-send` and `tags`.

**Step 3: Pull campaign engagement**

Using that Constant Contact `contact-id` and `created-date.from` set to today minus the lookback, call `constant-contact-get-campaign-open`, `constant-contact-get-campaign-click`, `constant-contact-get-campaign-unsubscribe` and `constant-contact-get-campaign-bounce` (all Constant Contact server). Count opens and clicks per `campaign-id`, and note any unsubscribe or bounce with its date and reason.

**Step 4: Add the CRM context**

Call `onepagecrm-get-deal` with `contact-id` set to the OnePageCRM id from Step 1, and list each deal's name, stage, status, amount and expected close date.

**Step 5: Report**

Give a short profile, a table of campaigns with opens and clicks, any unsubscribe or bounce, the open deals and the CRM next action. End with one sentence on whether the contact looks engaged and whether the CRM and the email data agree.

**Rules & Guidelines:**

* Tools on the OnePageCRM server: `onepagecrm-get-contact`, `onepagecrm-get-deal`, `onepagecrm-get-action`, `onepagecrm-get-action-stream`, `onepagecrm-get-note`. Tools on the Constant Contact server: `constant-contact-get-contact`, `constant-contact-get-campaign`, `constant-contact-get-campaign-open`, `constant-contact-get-campaign-click`, `constant-contact-get-campaign-unsubscribe`, `constant-contact-get-campaign-bounce`, `constant-contact-get-contact-list-member`, `constant-contact-get-contact-list`.
* This prompt is read-only. Do not call any add, update, delete or resend tool on either server (for example `onepagecrm-add-note`, `onepagecrm-update-contact`, `onepagecrm-delete-contact`, `constant-contact-add-contact`, `constant-contact-update-contact`, `constant-contact-resend-campaign-to-non-openers`).
* The join between the systems is the email address. Compare it case-insensitively and ignore surrounding spaces.

**Validation:**

* If either system returns nothing for the contact, say which one and continue with what exists.
* If `permission-to-send` shows the contact has opted out but a CRM deal or next action is open, flag it as a conflict.

Who it's for

One answer, three teams that use it

Sales reps

Follow up with the right tone

Knowing what a contact opened and clicked tells you what to talk about.

What has sam@fabrikam.com clicked in our Constant Contact emails, and what is his next action in OnePageCRM?

Sales managers

Catch opt-outs on live deals

An unsubscribe against an open deal is flagged before anyone sends another email.

Has priya@contoso.com unsubscribed in Constant Contact while she has an open deal in OnePageCRM?

Founders

Check a key relationship quickly

One question shows how engaged an important contact is and where the deal stands.

How engaged is dana@northwindtraders.com with our emails over the last 60 days, and what deals is she on?

How it works

What PopdockAI does when you ask

You give a contact email and your AI assistant sets their Constant Contact engagement beside their OnePageCRM deals. It only reads.

01

Ask

You give the contact email and a lookback in days.

Your AI tool

02

Find

It finds the person in OnePageCRM and then in Constant Contact.

onepagecrm-get-contact
constant-contact-get-contact

03

Pull

It counts campaign opens and clicks and notes any unsubscribe or bounce.

constant-contact-get-campaign
constant-contact-get-campaign-open
constant-contact-get-campaign-click
constant-contact-get-campaign-unsubscribe
constant-contact-get-campaign-bounce

04

Report

You see engagement beside deals, with opt-out conflicts flagged.

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

onepagecrm-get-contact

Returns contacts from OnePageCRM, with name, company, email, phone, owner and next action. Filter to find one contact or a group.
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.
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.
get-data

constant-contact-get-campaign-bounce

Returns Constant Contact campaign bounces with the bounce type. Filter by campaign, campaign activity, contact, email address or domain, bounce type and date.
get-data

onepagecrm-get-deal

Returns deals from OnePageCRM, with their stage, status, amount, expected close date, owner and linked contact or company. Filter by stage, status or date.
get-data

onepagecrm-get-action

Returns actions (tasks and follow-ups) from OnePageCRM, with the contact, assignee, due date and status.
get-data

onepagecrm-get-action-stream

Returns the OnePageCRM action stream, the contacts with their next action and its due date, so you can see what is due and what is lapsed.
get-data

onepagecrm-get-note

Returns notes saved against OnePageCRM contacts, with the author, date and text.
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-contact-list-member

Returns the members of Constant Contact contact lists with their email permission. Filter by list name or ID, contact, email address and permission.
get-data

constant-contact-get-contact-list

Returns Constant Contact contact lists with their description, active member count and favorite flag. Filter by name, member count and favorite.
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

Engagement and deals for one person, together

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