Connectors

/

Constant Contact

/

Constant Contact and Dynamics 365 Sales contact profile
Report
Cross-Connector

Know a contact's deals, cases and email engagement before you call

For sales reps who want Dynamics 365 Sales pipeline and Constant Contact engagement for one person, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Constant Contact and Dynamics 365 Sales contact profile
What do we know about alex.morgan@fabrikam.com in Dynamics 365 Sales and Constant Contact?
Alex Morgan is a Fabrikam contact with an open deal and steady email engagement. - Pipeline: Fabrikam expansion, 64,000, closing November - Cases: 1 open support case - Email: opened 5 of the last 6 campaigns - Difference: title is VP Operations in Dynamics and Ops Director in Constant Contact Want the full activity history?
Constant Contact
Sample figures. Your results come from your own account.
microsoft-dynamics-365-sales-get-contacts
microsoft-dynamics-365-sales-get-leads
microsoft-dynamics-365-sales-get-opportunities
microsoft-dynamics-365-sales-get-incidents
constant-contact-get-contact
constant-contact-get-contact-list-member
constant-contact-get-contact-activity
constant-contact-get-campaign-unsubscribe
constant-contact-get-campaign-bounce
constant-contact-get-contact-note

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

No time to check two systems before every call

Before a call you want to know about open deals and cases in Dynamics 365 Sales and whether the person still reads your emails in Constant Contact. Gathering that from two systems, and noticing where they disagree, takes time you rarely have.

Without PopdockAI

  • Look up the contact or lead in Dynamics 365 Sales
  • Check the account's opportunities and cases
  • Search Constant Contact for lists and activity
  • Miss that the title or company differs

With PopdockAI

  • The contact or lead is found with open opportunities and cases
  • Constant Contact lists, activity, opt-outs and notes are added
  • Differing names, titles and phones show both values
  • Watch-outs are flagged 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:** Build a single profile of the person with email `{email}` from Dynamics 365 Sales and Constant Contact, covering the last `{lookback-days}` days of email activity (default 90). This is read-only.

**Step 1: Find them in Dynamics 365 Sales**

Call `dynamics-365-sales-get-contacts` with `email` set to `{email}`. If that returns nothing, call `dynamics-365-sales-get-leads` with `email`. If both are empty, note "not in Dynamics 365 Sales" and go to Step 3.

**Step 2: Their account in Dynamics 365 Sales**

If they are a contact with a parent-customer, call:

* `dynamics-365-sales-get-opportunities` with `potential-customer` set to the parent-customer, for open opportunities (topic, sales-stage, est-revenue, est-close-date, owner)
* `dynamics-365-sales-get-incidents` with `customer` set to the parent-customer, for open cases (case-number, case-title, priority, status)

If they are a lead, report the lead's status, rating, lead-source and owner instead.

**Step 3: Find them in Constant Contact**

Call `constant-contact-get-contact` with `email-address` set to `{email}`. If nothing comes back, note "not in Constant Contact" and go to Step 4.

With the `contact-id` from that result:

* `constant-contact-get-contact-list-member` with `contact-id`, for their lists
* `constant-contact-get-contact-activity` with `contact-id` and `created-date.from` set to today minus `{lookback-days}` days
* `constant-contact-get-campaign-unsubscribe` and `constant-contact-get-campaign-bounce` with `contact-id`, with no date limit
* `constant-contact-get-contact-note` with `contact-id`

**Step 4: Report**

* **Who:** name, job title, company, phone, and where each value came from. If the two systems disagree on any of them, show both.
* **In Dynamics 365 Sales:** contact or lead, owner, open opportunities with total est-revenue, open cases.
* **In Constant Contact:** permission-to-send, lists, tags, activity in the period grouped by activity-type with dates, any bounce or unsubscribe with its date and reason, and notes.
* **Watch-outs:** for example, unsubscribed but with an open opportunity, or bouncing but still the account's primary contact.

**Rules & Guidelines:**

* dynamics-365-sales tools are on the dynamics-365-sales server; constant-contact tools are on the constant-contact server.
* Read-only. Do NOT call `constant-contact-add-contact-note`, `constant-contact-update-contact`, `dynamics-365-sales-create-note`, `dynamics-365-sales-update-contact` or any other create, update or add tool.

**Validation:**

* If `{email}` is in neither system, say so and stop.
* If more than one Dynamics contact has this email, list them, report it as a duplicate, and use the first only for Step 2, saying so.

Who it's for

One answer, three teams that use it

Account executives

Know the deals before you dial

Open opportunities and cases arrive with email engagement, so you start the call informed.

Brief me on priya.shah@contoso.com from Dynamics 365 Sales and Constant Contact.

Customer success managers

Spot unhappy accounts early

Open cases next to falling email engagement show who needs attention.

Does sam@fabrikam.com have open cases in Dynamics 365 Sales, and has he unsubscribed in Constant Contact?

Sales operations

Find records the two systems disagree on

Mismatched titles, companies and duplicates in Dynamics are called out for clean up.

Compare what Dynamics 365 Sales and Constant Contact hold for dana@northwindtraders.com and show differences.

How it works

What PopdockAI does when you ask

You give an email address and your AI assistant builds one profile from Dynamics 365 Sales and Constant Contact. It only reads.

01

Ask

You give an email address, and optionally a look-back period.

Your AI tool

02

CRM

It finds the contact or lead in Dynamics 365 Sales with open opportunities and cases.

microsoft-dynamics-365-sales-get-contacts
microsoft-dynamics-365-sales-get-leads
microsoft-dynamics-365-sales-get-opportunities
microsoft-dynamics-365-sales-get-incidents

03

Email

It reads their Constant Contact lists, activity, bounces, unsubscribes and notes.

constant-contact-get-contact
constant-contact-get-contact-list-member
constant-contact-get-contact-activity
constant-contact-get-campaign-unsubscribe
constant-contact-get-campaign-bounce
constant-contact-get-contact-note

04

Report

You get one profile with differences and watch-outs, and nothing is changed.

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

microsoft-dynamics-365-sales-get-contacts

Returns Dynamics 365 Sales contacts. Filter by full name, email, city, job title, state, parent customer, created date and status, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-leads

Returns Dynamics 365 Sales leads. Filter by created date, name, status, rating, owner, company name, email and lead source, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-opportunities

Returns Dynamics 365 Sales opportunities. Filter by owner, status, sales stage, probability, estimated close date, topic, potential customer and estimated revenue, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-incidents

Returns Dynamics 365 Sales cases. Filter by case title, status, customer, priority, owner, case type, created date and case number, and cap how many records come back.
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-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-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.
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

constant-contact-get-contact-note

Returns the notes logged against Constant Contact contacts. Filter by contact, email address, company name and created date.
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

Walk into every call fully briefed

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