/
/
Rank OnePageCRM deals by Mailchimp engagement
For sales reps who want to know which open deals are warm, just by asking their AI assistant.
On this page
Connector
Connect OnePageCRM, pick your AI tool and paste the prompt.
The problem
Follow-up goes to the loudest deal, not the warmest
Reps cannot tell which open deals have contacts reading their email. Without that, follow-up goes to whoever is loudest in the pipeline rather than to the deals that are warm.
Without PopdockAI
- List open deals and their contacts
- Look up each email in Mailchimp
- Check open and click rates by hand
- Email someone who unsubscribed
With PopdockAI
- Open deals and each contact email are read
- Mailchimp status, open and click rates are looked up
- Deals are ranked by amount with a suggested next step
- Unsubscribed contacts are marked do-not-email, nothing invented
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Show how the CRM contacts attached to deals at stage `{stage}` (default: all open deals) engaged with Mailchimp campaigns, so a rep knows which deals are warm.
**Step 1: Read the deals (onepagecrm server)**
Call `onepagecrm-get-deal` with `stage` set to `{stage}` when given, `status` pending otherwise, and `max-records` 100. Keep `id`, `name`, `amount`, `contact-id`, `contact-name`, `expected-close-date`.
**Step 2: Get each deal's contact email (onepagecrm server)**
For each distinct `contact-id`, call `onepagecrm-get-contact` with `id` set to that value and take its `email`. A deal whose contact has no email is reported as "no email, cannot be matched".
**Step 3: Find engagement (mailchimp server)**
For each email, call `mailchimp-get-list-member` with `email` set to that address and read `status`, `average-open-rate`, `average-click-rate` and `last-changed-date`. When `{campaign-name}` is given, also call `mailchimp-get-campaign-open` with `campaign-name` set to it and match the email on the `email` field of the opens. Clicks are only reported per campaign link, so call `mailchimp-get-campaign-click` only to give campaign totals and say they are not per person. If the address is not on any list, report the contact as "not in Mailchimp".
**Step 4: Report**
A table sorted by `amount` descending: deal, amount, contact, Mailchimp status, open rate, click rate, opened the named campaign (yes, no, n/a), and a one-line suggestion (follow up now, nurture, unsubscribed so do not email). Finish with the total pipeline value in each suggestion bucket.
**Rules & Guidelines:**
* `onepagecrm-get-deal` and `onepagecrm-get-contact` are on the onepagecrm server; `mailchimp-get-list-member`, `mailchimp-get-campaign-open` and `mailchimp-get-campaign-click` are on the mailchimp server.
* Read-only. Do NOT call any onepagecrm write tool (`onepagecrm-add-contact`, `onepagecrm-update-contact`, `onepagecrm-delete-contact`, `onepagecrm-add-note`, `onepagecrm-add-deal`, `onepagecrm-update-deal`, `onepagecrm-add-action`, `onepagecrm-add-call`, `onepagecrm-add-meeting`) and do NOT call any mailchimp write tool (`mailchimp-add-list-member`, `mailchimp-update-list-member`, `mailchimp-add-customer`, `mailchimp-add-segment-member`, `mailchimp-start-automation`, `mailchimp-pause-automation`).
**Validation:**
* Match emails ignoring case. If a contact appears on several lists, report the best open rate and name the list.
* Never invent rates; show "unknown" when the field is empty.Who it's for
One answer, three teams that use it
Sales reps
Follow up where interest is real
Deals with engaged contacts get a follow up now suggestion, so your calls land.
Rank my open OnePageCRM deals by how their contacts engage with Mailchimp.
Sales managers
Check a campaign reached live deals
See which deal contacts opened a named campaign and which did not.
Which open Negotiation stage deals in OnePageCRM have contacts who opened the Autumn Offer campaign?
Marketing managers
Avoid emailing opted out contacts
Unsubscribed deal contacts are marked do-not-email, so sales and marketing stay aligned.
Which contacts on open OnePageCRM deals are unsubscribed in Mailchimp?
How it works
What PopdockAI does when you ask
You optionally give a stage and a campaign, and your AI assistant ranks open OnePageCRM deals by Mailchimp engagement. It only reads.
01
Ask
You give a stage and optionally a campaign name.
02
Read
It reads the open deals and each contact email from OnePageCRM.
03
Look up
It finds each address in Mailchimp for status, open and click rates.
04
Report
You get deals ranked by amount with a suggested next step.
What PopdockAI provides
The tools behind the answer
Ready made tools for OnePageCRM and one secure connection to your AI tool. No code, no exports.
onepagecrm-get-deal
onepagecrm-get-contact
mailchimp-get-list-member
mailchimp-get-campaign-open
mailchimp-get-campaign-click
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
Follow-up on the warmest deals
Related use cases
More ways to put this data to work
Find OnePageCRM contacts missing from a Mailchimp audience
Ask your AI which OnePageCRM contacts are missing from a Mailchimp audience, who is on it but unsubscribed and who has no email, read-only.
Learn More
Reconcile OnePageCRM contacts with Mailchimp members
Ask your AI to match OnePageCRM contacts to Mailchimp members by email and report only the name, status and tag disagreements with a suggested fix.
Learn More
Build a OnePageCRM contact brief
Ask your AI for a brief on any OnePageCRM contact and get their deals, next actions and recent touches with talking points, all read-only.
Learn More
Review a OnePageCRM company account
Ask your AI to review a OnePageCRM company with its contacts, deals, won and pending totals, risks and recent notes, read-only.
Learn More
Find OnePageCRM contacts missing from Constant Contact
Ask your AI which OnePageCRM contacts are missing from Constant Contact or lack permission to send, read-only and matched on email.
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.