/
/
Make sure every big Mailchimp store buyer has a Salesforce owner
For sales teams who want to see their top store customers' Salesforce account, owner and open pipeline, by asking their AI assistant.
On this page
Connector
Connect Mailchimp, pick your AI tool and paste the prompt.
The problem
Big store buyers with no account owner
Your biggest Mailchimp store buyers may be invisible to sales in Salesforce, or sitting there only as a lead. Checking means searching each email in contacts and leads, then opening the account for its owner and pipeline.
Without PopdockAI
- Export top store customers from Mailchimp
- Search Salesforce contacts, then leads, for each email
- Open each account for owner and opportunities
- Lose track of spenders with no record
With PopdockAI
- Top store customers are looked up by email, contact first
- Contacts show account, owner and open opportunities
- Unmanaged spenders and lead only matches are called out
- Email matches only, 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:** List the Mailchimp e-commerce customers who have spent at least `{min-total-spent}` (default 1000), up to `{max-records}` customers (default 25), and enrich each one with their Salesforce contact, account and open pipeline.
**Step 1: Top customers in Mailchimp**
Call `mailchimp-get-customer` with `total-spent.min` set to `{min-total-spent}` and `max-records` set to `{max-records}`. Sort by total-spent, highest first. Keep email, first-name, last-name, company, total-spent and orders-count.
**Step 2: Match in Salesforce**
For each customer, call `salesforce-get-contact` with `email` set to the customer's email. If no contact matches, call `salesforce-get-lead` with `email` set to the same address. If the contact has an account-id, call `salesforce-get-account` with `account-id` and `salesforce-get-opportunity` with `account-id` and `closed` set to false.
**Step 3: Report**
A table with one row per customer: name, email, Mailchimp total spent and orders, Salesforce record (contact, lead or none), account name and owner, number and value of open opportunities. Then call out separately: high spenders with no Salesforce record, and high spenders who are only a lead.
**Rules & Guidelines:**
* `mailchimp-get-customer` is on the mailchimp server. `salesforce-get-contact`, `salesforce-get-lead`, `salesforce-get-account` and `salesforce-get-opportunity` are on the salesforce server.
* This prompt is read-only. Do not call `salesforce-add-lead`, `salesforce-add-contact`, `salesforce-add-opportunity` or `mailchimp-update-customer`.
**Validation:**
* Match on email only. A Mailchimp company that looks like a Salesforce account name is not a match without the email.
* Mailchimp spend is in the store's currency; show it as returned and do not convert it.
* If no customer meets the threshold, say so and suggest a lower `{min-total-spent}`.Who it's for
One answer, three teams that use it
Account executives
Know which big buyers are yours
See each top store customer with account, owner and open pipeline, so you know where to engage.
Show our top 20 Mailchimp store customers with their Salesforce account owner and open opportunities.
Sales managers
Find spenders with no owner
High spenders with no Salesforce record or only a lead are called out, ready to assign.
Which Mailchimp store customers who spent over 5,000 have no Salesforce contact or are only a lead?
Revenue operations
Check CRM coverage of top customers
Confirm your best store buyers are represented in Salesforce, matched by email and never by a lookalike company name.
How many of our top 50 Mailchimp store customers have a Salesforce contact with an open opportunity?
How it works
What PopdockAI does when you ask
You set a minimum spend and how many customers, and your AI assistant looks each one up in Salesforce. It only reads and reports.
01
Ask
You set a minimum spend and how many customers to return.
02
Match
It looks up each customer's email in Salesforce, contact first, then lead.
03
Enrich
For contacts it reads the account, owner and open opportunities.
04
Report
You get a table plus high spenders with no record or only a lead.
What PopdockAI provides
The tools behind the answer
Ready made tools for Mailchimp and one secure connection to your AI tool. No code, no exports.
mailchimp-get-customer
salesforce-get-contact
salesforce-get-lead
salesforce-get-account
salesforce-get-opportunity
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
No high spender left unmanaged
Related use cases
More ways to put this data to work
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.

.webp)
