/
/
Judge a campaign on email and pipeline results side by side
For marketing teams who want Mailchimp performance and Salesforce pipeline for one campaign in one view, by asking their AI assistant.
On this page
Connector
Connect Mailchimp, pick your AI tool and paste the prompt.
The problem
One campaign, two reports and a spreadsheet
Email results sit in Mailchimp while members, responses and pipeline sit in Salesforce, so judging one campaign takes two reports and a spreadsheet. It is also hard to tell how many Salesforce members were ever sent the email.
Without PopdockAI
- Pull the Mailchimp report for opens and clicks
- Pull the Salesforce campaign for members and pipeline
- Match member emails to recipients by hand
- Mix up store revenue and opportunity revenue
With PopdockAI
- Email results and pipeline are read side by side
- Up to 200 member emails are checked against recipients
- E-commerce and opportunity revenue stay apart
- The matched names are shown 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:** Compare the Mailchimp campaign and the Salesforce campaign named like `{campaign-name}`, showing email performance from Mailchimp beside members, responses and pipeline from Salesforce.
**Step 1: Mailchimp side**
Call `mailchimp-get-report` with `campaign-title.contains` set to `{campaign-name}`. If more than one matches, list them with their send-date and stop so the user can choose. Keep emails-sent, unique-opens, open-rate, clicks-total, click-rate, unsubscribed, hard-bounces and total-revenue.
**Step 2: Salesforce side**
Call `salesforce-get-campaign` with `name.contains` set to `{campaign-name}`. If more than one matches, list them and stop. Keep status, start-date, end-date, leads, responses, opportunities, won-opportunities-value, budgeted-cost and actual-cost. Then call `salesforce-get-campaign-member` with that `campaign-id` to count members and how many are marked responded.
**Step 3: Cross-check the audience**
Take up to 200 member emails from the Salesforce campaign and check each with `mailchimp-get-campaign-recipient` using the Mailchimp `campaign-id` and `email-address`. Count how many Salesforce members were sent the Mailchimp email and how many opened it.
**Step 4: Report**
A two-column table, Mailchimp and Salesforce, with one row per measure. Then the overlap: Salesforce members sent the email, of those how many opened, and Salesforce members who were never sent it. Finish with two or three plain observations, for example a high open rate but no responses recorded in Salesforce.
**Rules & Guidelines:**
* `mailchimp-get-report` and `mailchimp-get-campaign-recipient` are on the mailchimp server. `salesforce-get-campaign` and `salesforce-get-campaign-member` are on the salesforce server.
* This prompt is read-only. Do not call `salesforce-update-campaign`, `salesforce-add-campaign` or `mailchimp-replicate-campaign`.
**Validation:**
* Campaign names are matched by eye; state the exact names used on each side so the user can confirm they are the same campaign.
* If either side has no match, report the side that does exist and say the other is missing.
* Note that Mailchimp revenue is e-commerce revenue and Salesforce won value is opportunity revenue; do not add them together.Who it's for
One answer, three teams that use it
Campaign managers
Judge a campaign on everything it did
See sends, opens and clicks beside members, responses and won value, without building the comparison yourself.
Compare the November Product Launch campaign in Mailchimp with the matching Salesforce campaign.
Marketing operations
Find members who never got the email
Check Salesforce members against Mailchimp recipients to spot people who were added to the campaign but never sent it.
How many members of the Salesforce Partner Summit campaign were actually sent the Mailchimp invite?
Marketing leaders
Link email effort to pipeline
See opportunities and won value next to email results, so budget conversations rest on both.
Show me email results and pipeline side by side for our Contoso ABM campaign in Mailchimp and Salesforce.
How it works
What PopdockAI does when you ask
You give the campaign name, and your AI assistant reads both sides and cross checks the members. It only reads, and shows which names it matched.
01
Ask
You give the campaign name.
02
Read
It reads the Mailchimp report and the Salesforce campaign's members, responses and pipeline.
03
Cross check
It checks up to 200 Salesforce member emails against Mailchimp recipients.
04
Report
You get a side by side table and a few plain observations.
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-report
salesforce-get-campaign
salesforce-get-campaign-member
mailchimp-get-campaign-recipient
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
Email and pipeline results in one view
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)
