Connectors

/

Constant Contact

/

Constant Contact and Shopify customer profile by email
Report
Cross-Connector

See a shopper's orders and email relationship in one view

For support teams who want Shopify orders and Constant Contact subscription status for a shopper, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Constant Contact and Shopify customer profile by email
A customer, jordan.lee@contoso.com, just emailed us. Pull her Shopify orders and Constant Contact status.
Jordan Lee is a repeat buyer with a consent mismatch. - Orders: 7 orders, 1,240 spent - Latest: order 1042, paid, unfulfilled - Consent: accepts marketing in Shopify, unsubscribed in Constant Contact Want the recent order details?
Constant Contact
Sample figures. Your results come from your own account.
shopify-get-customer
shopify-get-order
constant-contact-get-contact
constant-contact-get-contact-list-member
constant-contact-get-contact-activity

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

Shopify and Constant Contact disagree on consent

When a shopper writes in you want their Shopify orders next to their Constant Contact status and recent email activity. Checking both, and spotting that one system says they accept marketing while the other says they unsubscribed, takes several screens.

Without PopdockAI

  • Look up the shopper and orders in Shopify
  • Search Constant Contact for lists and activity
  • Compare consent settings by eye
  • Miss the mismatch until a complaint arrives

With PopdockAI

  • Orders, spend and marketing consent come from Shopify
  • Lists, tags, opens, clicks and bounces come from Constant Contact
  • Consent, name and phone mismatches are called out
  • Email is the only join, and nothing changes

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 for the shopper with email address `{email}`, combining their Shopify purchase history with their Constant Contact subscription and email engagement over the last `{lookback-days}` days (default 90).

**Step 1: Find the shopper in Shopify**

Call `shopify-get-customer` with `email` set to `{email}`. If nothing comes back, retry with `email.contains` set to `{email}` and keep only rows whose email equals it ignoring case. If more than one customer matches, list them (name, customer-id, created-at) and stop. If none matches, note "not a Shopify customer" and continue to Step 3.

**Step 2: Their Shopify orders**

Call `shopify-get-order` with `customer-id` from Step 1 and `created-at.from` set to `{lookback-days}` days before today. Capture order-number, created-at, total-price, financial-status and fulfillment-status. Take orders-count, total-spent, accepts-marketing and last-order-name from the Step 1 customer record.

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

Call `constant-contact-get-contact` with `email-address` set to `{email}` (same ignore-case retry with `email-address.contains` as Step 1). If no contact exists, report "not in Constant Contact" and skip to Step 5.

**Step 4: Their lists and engagement**

Using contact-id from Step 3, call `constant-contact-get-contact-list-member` for their list memberships and `constant-contact-get-contact-activity` with `created-date.from` set to `{lookback-days}` days before today. Count opens, clicks and bounces by activity-type and note the most recent campaign-activity-name.

**Step 5: Report**

* **Shopify:** customer-id, orders-count, total-spent, accepts-marketing, then a table of orders in the window (order-number, date, total, financial and fulfillment status).
* **Constant Contact:** contact-id, permission-to-send, tags, list names, then opens / clicks / bounces in the window and the last campaign they engaged with.
* **Mismatches:** call out accepts-marketing true in Shopify but unsubscribed in Constant Contact (or the reverse), and name or phone differences between the two records.

**Rules & Guidelines:**

* `shopify-get-customer` and `shopify-get-order` are on the shopify server. `constant-contact-get-contact`, `constant-contact-get-contact-list-member` and `constant-contact-get-contact-activity` are on the constant-contact server.
* Email address is the only join key. Never match on name alone.
* This prompt is read-only. Do NOT call `constant-contact-update-contact`, `constant-contact-add-contact`, `shopify-update-customer` or any other tool whose name starts with shopify-add-, shopify-update-, constant-contact-add-, constant-contact-update- or constant-contact-resend-.

**Validation:**

* If the shopper is in neither system, say so and stop.
* If a tool from one server is not available, report that the shopify or constant-contact MCP server is not connected rather than reporting the shopper as missing from it.

Who it's for

One answer, three teams that use it

Customer support agents

Answer shoppers with full context

Recent orders with payment and fulfillment status sit next to their email history.

Sam.patel@fabrikam.com is asking about an order. Show his Shopify orders and Constant Contact status.

Email marketers

Catch consent conflicts early

See when Shopify and Constant Contact disagree on consent before it becomes a complaint.

Does Shopify say priya@contoso.com accepts marketing while Constant Contact says she unsubscribed?

Store owners

Know your best customers by email too

Total spent and engagement together show who to thank and who has gone quiet.

How much has dana@northwindtraders.com spent in Shopify, and does she open our emails?

How it works

What PopdockAI does when you ask

You give an email address and your AI assistant builds one shopper profile from Shopify and Constant Contact. It only reads.

01

Ask

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

Your AI tool

02

Shop

It reads the Shopify customer's orders, spend and marketing consent.

shopify-get-customer
shopify-get-order

03

Email

It reads the Constant Contact contact's lists, tags, opens, clicks and bounces.

constant-contact-get-contact
constant-contact-get-contact-list-member
constant-contact-get-contact-activity

04

Report

You get one profile with mismatches called out, and nothing 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

shopify-get-customer

Returns Shopify customers with their account state, total spent and default address. Filter by name, email, tags, customer id, city, province, created date and total spent.
get-data

shopify-get-order

Returns Shopify orders with their financial status, fulfillment status and total. Filter by order number or name, customer, email, financial status, fulfillment status, created date and total price.
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.
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

Purchases and email relationship in one view

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