/
/
See how much Pipedrive pipeline sits behind a Drip campaign
For marketers who want to know which subscribers of a Drip campaign have open Pipedrive deals, and how much value is behind them.
On this page
Connector
Connect Pipedrive, pick your AI tool and paste the prompt.
The problem
Pipeline totals that count the same deal twice
Marketing wants to know how much sales pipeline sits behind the people in a Drip email series. Answering means matching each subscriber to Pipedrive and adding up open deals without counting a deal twice or mixing currencies.
Without PopdockAI
- Export the campaign's subscribers
- Match each email to Pipedrive
- Find each organization's open deals
- Add values and double count shared deals
With PopdockAI
- The campaign's subscribers are read
- Each email is matched to a Pipedrive person
- Open deals are read once per organization, value per currency
- Association, not attribution, is stated, 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:** Show how much Pipedrive pipeline sits behind the subscribers of the Drip campaign matching `{campaign-name}`, checking at most `{max-results}` subscribers (default 100).
**Step 1: Find the campaign in Drip**
Call `drip-get-campaign` with `name.contains` set to `{campaign-name}`. If more than one campaign matches, list them (name, status, active-subscribers) and stop so the user can pick one. Note its `campaign-id`.
**Step 2: Its subscribers**
Call `drip-get-campaign-subscriber` with `campaign-id` set to that id and `max-records` set to `{max-results}` (100 if empty).
**Step 3: Carry each email into Pipedrive**
For each subscriber, call `pipedrive-get-person` with `email` set to the subscriber's `email`. Keep `open-deals`, `won-deals`, `organization-id`, `organization-name` and `owner-name`. For each distinct `organization-id` with open deals, call `pipedrive-get-deal` with `organization-id` set to it and `status` set to `open` to get deal values. Count each organization's deals once, even when several subscribers belong to it.
**Step 4: Report**
* Campaign name, status, subscribers checked.
* Match rate: how many were found in Pipedrive.
* People with open deals: email, Pipedrive name, organization, owner, open deal count.
* Open pipeline by organization: organization, deal titles, stage, total value per currency.
* People with won deals but no open ones (likely customers on the campaign).
* Do not add values in different currencies together.
**Rules & Guidelines:**
* `drip-*` tools are on the drip MCP server and `pipedrive-*` tools are on the pipedrive MCP server. If either set of tools is missing, stop and tell the user that both the drip and pipedrive servers must be connected.
* Match people across the two systems on email address only, compared case-insensitively with surrounding spaces trimmed. Never match on name alone.
* This shows association, not attribution. Say so in the report; Drip does not record which email caused a deal.
* This prompt is read-only. Do NOT call any write tool. On Drip that means: `drip-add-subscriber`, `drip-update-subscriber`, `drip-unsubscribe-subscriber`, `drip-add-subscriber-tag`, `drip-remove-subscriber-tag`, `drip-add-subscriber-to-campaign`, `drip-remove-subscriber-from-campaign`, `drip-remove-subscriber-from-all-campaigns`, `drip-start-subscriber-workflow`, `drip-remove-subscriber-from-workflow`, `drip-activate-campaign`, `drip-pause-campaign`, `drip-activate-workflow`, `drip-pause-workflow`. On Pipedrive that means: `pipedrive-add-person`, `pipedrive-update-person`, `pipedrive-add-organization`, `pipedrive-update-organization`, `pipedrive-add-deal`, `pipedrive-update-deal`, `pipedrive-add-lead`, `pipedrive-update-lead`, `pipedrive-add-activity`, `pipedrive-update-activity`, `pipedrive-add-note`, `pipedrive-update-note`.
**Validation:**
* If no campaign matches, list Drip campaigns from `drip-get-campaign` (name and status, up to 20) and stop.
* If no subscriber matches in Pipedrive, report the match rate of 0 and stop.
Who it's for
One answer, three teams that use it
Marketing managers
Show pipeline behind a campaign
Report open pipeline per organization and currency without overstating the campaign's effect.
How much open Pipedrive pipeline sits behind our Drip Trial nurture campaign?
Demand generation
See the match rate
Know how many subscribers are already in Pipedrive and how many have open deals.
What share of the Drip Webinar follow-up subscribers are in Pipedrive with open deals?
Revenue operations
Spot existing customers in a series
People with won deals but no open ones are listed, likely existing customers in a prospect series.
Which subscribers in the Drip Onboarding campaign look like existing Pipedrive customers?
How it works
What PopdockAI does when you ask
You name the Drip campaign and your AI assistant totals the Pipedrive pipeline behind its subscribers. It is read-only and honest that it shows association, not attribution.
01
Ask
You name the Drip campaign.
02
Read
It reads the campaign's subscribers.
03
Match
It looks up each email in Pipedrive and reads open deals once per organization.
04
Report
You get the match rate, pipeline by organization and likely existing customers.
What PopdockAI provides
The tools behind the answer
Ready made tools for Pipedrive and one secure connection to your AI tool. No code, no exports.
drip-get-campaign
drip-get-campaign-subscriber
pipedrive-get-person
pipedrive-get-deal
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
The real pipeline behind a Drip campaign
Related use cases
More ways to put this data to work
Add a Pipedrive organization's contacts to a Drip campaign
Ask your AI to put a Pipedrive organization's contacts into a Drip campaign and it enrolls only active subscribers not already in it, after you confirm.
Learn More
Tag won Pipedrive customers in Drip
Ask your AI to tag recent Pipedrive customers in Drip and it traces won deals to people, tagging only active subscribers without the tag after you confirm.
Learn More
Create Pipedrive leads from engaged Drip subscribers
Ask your AI to bring engaged Drip subscribers into Pipedrive and it skips people already there, then creates each person and a linked lead after you confirm.
Learn More
Add Pipedrive deal contacts to a Constant Contact list
Ask your AI to add the contacts on open deals in a Pipedrive stage to a Constant Contact list, and it skips unsubscribed people and creates contacts only after you confirm.
Learn More
Convert a Pipedrive lead to a deal
Ask your AI to convert a Pipedrive lead and it creates one deal with the lead's value, contacts and owner, combines its notes, and checks for a duplicate first.
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.