/
/
See how much of your best Shopify spend your emails reach
For marketers who want to know which high-spending Shopify customers are missing, unsubscribed or quiet in Constant Contact, by asking their AI assistant.
On this page
Connector
Connect Shopify, pick your AI tool and paste the prompt.
The problem
Your best customers may not be hearing from you at all
Your highest-spending Shopify customers are the ones you most want reading your emails, yet some were never added to Constant Contact, some unsubscribed and some went quiet. Without checking, you cannot see how much spend sits outside your reach.
Without PopdockAI
- Export top Shopify customers by lifetime spend
- Search Constant Contact for each email
- Check subscription status and recent activity by hand
- Total the spend you cannot reach in a spreadsheet
With PopdockAI
- Up to 100 Shopify customers above your threshold are read
- Each email and its activity is looked up in Constant Contact
- Customers are sorted into missing, unsubscribed, quiet or engaged
- Failed lookups are reported as failed, 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.
**Objective:** Take every Shopify customer who has spent at least `{min-total-spent}` and show whether Constant Contact can reach them, and whether they have opened or clicked anything in the last `{lookback-days}` days (default 90).
**Step 1: Get the top customers**
Call `shopify-get-customer` with `total-spent.min` set to `{min-total-spent}` and `max-records` 100. Skip any customer with a blank email. If 100 come back, say the review covers the first 100 only and suggest a higher threshold.
**Step 2: Look each one up in Constant Contact**
For each customer, call `constant-contact-get-contact` with `email-address` set to their email. If found, call `constant-contact-get-contact-activity` with `contact-id` from that result and `created-date.from` set to `{lookback-days}` days before today.
**Step 3: Sort them into groups**
* **Not in Constant Contact** - no contact with that email.
* **Unsubscribed** - permission-to-send is unsubscribed.
* **Subscribed, quiet** - subscribed but no opens or clicks in the window.
* **Engaged** - at least one open or click in the window.
**Step 4: Report**
A count per group, then one table per group: name, email, total-spent, orders-count, accepts-marketing (from Shopify), permission-to-send and last activity date (from Constant Contact). End with the total spend sitting in the first two groups.
**Rules & Guidelines:**
* `shopify-get-customer` is on the shopify server. `constant-contact-get-contact` and `constant-contact-get-contact-activity` are on the constant-contact server.
* Match on email only, ignoring case.
* This prompt is read-only. To add the missing customers, use the `sync-new-customers-to-constant-contact` prompt instead. Do NOT call `constant-contact-add-contact`, `constant-contact-update-contact` or any other tool whose name starts with shopify-add-, shopify-update-, constant-contact-add-, constant-contact-update- or constant-contact-resend-.
**Validation:**
* If no customer meets the threshold, say so and stop.
* Report a Constant Contact lookup that errors as "lookup failed", never as "Not in Constant Contact".Who it's for
One answer, three teams that use it
Email marketers
Find top buyers missing from your list
See exactly which high spenders are not in Constant Contact or have gone quiet, so you know who to win back.
Which Shopify customers with over 1,500 in lifetime spend are missing from Constant Contact or unsubscribed?
Retention managers
Spot valuable customers going quiet
Subscribed customers who stopped opening are grouped separately, ready for a re-engagement plan.
Of our Shopify customers who spent over 3,000, who has not opened a Constant Contact email in the last 120 days?
Marketing directors
Size the gap in your email program
A total of the spend sitting outside your reach makes the case for list growth or re-permission work.
How much lifetime spend from Shopify customers above 1,000 is outside our Constant Contact email reach?
How it works
What PopdockAI does when you ask
You set a spend threshold, and your AI assistant checks each top customer in Constant Contact. It only reads both systems and totals the spend outside your email reach.
01
Ask
You set a lifetime spend threshold and optionally a look-back, 90 days by default.
02
Read
It reads up to 100 Shopify customers above the threshold.
03
Check
It looks up each email and their activity in Constant Contact.
04
Report
You get a table per group and the total spend outside your email reach.
What PopdockAI provides
The tools behind the answer
Ready made tools for Shopify and one secure connection to your AI tool. No code, no exports.
shopify-get-customer
constant-contact-get-contact
constant-contact-get-contact-activity
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.
The outcome
A clear view of the spend your emails cannot reach
Related use cases
More ways to put this data to work
Add missing Shopify customers to a Constant Contact list
Ask your AI to add missing Shopify customers to Constant Contact and it finds opted-in buyers not already there, skips anyone who unsubscribed and adds them after you confirm.
Learn More
Log Shopify refunds as Constant Contact notes
Ask your AI to log Shopify refunds in Constant Contact and it matches each refund to a contact, skips ones already noted and adds notes after you confirm.
Learn More
Attribute Shopify orders to a Constant Contact campaign
Ask your AI whether a Constant Contact campaign drove sales and it matches each clicker to Shopify orders placed after their first click, with revenue and conversion.
Learn More
Add missing Shopify customers to a Mailchimp audience
Ask your AI to add missing Shopify customers to Mailchimp and it checks each against the audience and unsubscribe history, then adds the rest after you confirm.
Learn More
Add missing Shopify customers to Drip
Ask your AI to add missing Shopify customers to Drip and it finds opted-in buyers Drip does not have, adds them with your tag after you confirm and checks each one.
Learn More
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.