/
/
Turn Mailchimp campaign clicks into a Capsule CRM follow-up list
For marketing teams who want to know which clickers are customers, who owns them and whether a deal is open, by asking their AI assistant.
On this page
Connector
Connect Mailchimp, pick your AI tool and paste the prompt.
The problem
Clicks that cool off before anyone follows up
A campaign report shows who clicked, but not which clickers are customers, who owns them or whether a deal is open. Looking up each email in Capsule CRM by hand takes so long that the interest has cooled by the time you finish.
Without PopdockAI
- Export clickers and links from the campaign
- Search Capsule CRM for each email
- Check owner, last contact and opportunities
- Sort the list into a follow up order yourself
With PopdockAI
- Clickers are gathered with click counts and links
- Each email is matched to Capsule CRM by email only
- Clickers with open deals come first, unknown people last
- Ambiguous matches are flagged and nothing is created
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For the Mailchimp campaign named `{campaign-name}`, list the people who clicked a link and show how each one maps to Capsule CRM, covering at most `{max-contacts}` people (default 50).
**Step 1: Identify the campaign**
Call `mailchimp-get-campaign` with `title.contains` set to `{campaign-name}`. If more than one campaign matches, list them (title, send-date, status, campaign-id) and stop. If none matches, say so and stop.
**Step 2: Collect the clickers**
Call `mailchimp-get-campaign-email-activity` with the `campaign-id` and `action` set to click. Group by `email-address`, keeping the click count and the distinct URLs clicked. Sort by click count, highest first, and keep the top `{max-contacts}` (default 50).
**Step 3: Carry each email across to Capsule CRM**
For each email, call `capsule-crm-get-party` with `email` set to that address.
* One match: record name, organization-name, owner-name, last-contacted-date, and call `capsule-crm-get-opportunity` with `party-name.contains` set to the party name, keeping only exact `party-name` matches and opportunities with no `closed-on-date`.
* No match: mark the person "not in Capsule CRM" and continue.
* Several matches: mark "ambiguous in Capsule CRM", list the party ids, and continue.
**Step 4: Report**
A table: email, clicks, URLs, Capsule name, organization, owner, last contacted, open opportunities (name, milestone-name, value). Put matched contacts with open opportunities first, then matched without, then not in Capsule CRM. Finish with counts for each group.
**Rules & Guidelines:**
* Tools whose names start with mailchimp are on the mailchimp MCP server; tools whose names start with capsule-crm are on the capsule-crm MCP server. If a tool from either server is not available, stop and say which server is not connected rather than working around it.
* Match records across the two systems on email address only, compared case-insensitively with surrounding spaces trimmed. Never match on name alone.
* This prompt is read-only. Do not call any write tool on either server: on Mailchimp `mailchimp-add-list-member`, `mailchimp-update-list-member`, `mailchimp-add-segment-member`, `mailchimp-add-customer`, `mailchimp-update-customer`, `mailchimp-update-order`, `mailchimp-update-product`, `mailchimp-start-automation`, `mailchimp-pause-automation`, `mailchimp-replicate-campaign`; on Capsule CRM `capsule-crm-add-party`, `capsule-crm-update-party`, `capsule-crm-add-note`, `capsule-crm-update-note`, `capsule-crm-add-task`, `capsule-crm-update-task`, `capsule-crm-add-opportunity`, `capsule-crm-update-opportunity`, `capsule-crm-add-case`, `capsule-crm-update-case`.
**Validation:**
* If the campaign has no click activity, report that and stop.
* Do not create contacts for people missing from Capsule CRM; just list them.Who it's for
One answer, three teams that use it
Marketing managers
Hand sales a ranked click list
Give sales clickers ordered by open opportunities, with owner and last contact, instead of a raw export.
Match the clickers of our Mailchimp Webinar Invite to Capsule CRM and show who has open opportunities.
Account managers
See which of your contacts clicked
Spot owned contacts who clicked, with the links they chose, as a reason to get in touch.
Which Capsule CRM contacts I own clicked the Mailchimp Product Update campaign?
Sales reps
Follow up while interest is warm
People with deals in progress come first, so your follow up starts where it matters most.
Show the top 30 clickers of the Mailchimp Contoso promo with their Capsule CRM owner and last contact date.
How it works
What PopdockAI does when you ask
You name the campaign and how many people to cover, and your AI assistant ranks the clickers by their Capsule CRM context. It only reads.
01
Ask
You name the campaign and how many people to cover.
02
Collect
It gathers clickers with their click counts and links.
03
Match
Each email is matched to Capsule CRM for owner, last contact and open opportunities.
04
Report
Clickers with open deals come first, people not in Capsule CRM last.
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-campaign
mailchimp-get-campaign-email-activity
capsule-crm-get-party
capsule-crm-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
Campaign clicks turned into a ranked follow up list
Related use cases
More ways to put this data to work
Mailchimp and Capsule CRM contact profile
Ask your AI for a contact profile and it combines Capsule CRM history, tasks and opportunities with Mailchimp audiences, clicks and orders, then flags what needs attention.
Learn More
Find Mailchimp top buyers with no Capsule CRM opportunity
Ask your AI to compare top Mailchimp store buyers with Capsule CRM and it splits them into not in the CRM, no open opportunity, and open opportunities.
Learn More
Log Mailchimp unsubscribes as Capsule CRM notes
Ask your AI to log recent Mailchimp unsubscribes in Capsule CRM and it adds a note to each matching contact, after you confirm, skipping any already noted.
Learn More
Find Mailchimp subscribers missing from Capsule CRM
Ask your AI to compare a Mailchimp audience with Capsule CRM and it lists subscribed members with no contact, highest rated first, without changing anything.
Learn More
Capture Mailchimp campaign clickers as Salesforce leads
Ask your AI to create Salesforce leads from a Mailchimp campaign's clickers and it drops existing contacts, leads and unsubscribes, then creates only what you confirm.
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.