Connectors

/

Pipedrive

/

Find open Pipedrive deals with no Contivio calls
Report
Cross-Connector

Find open Pipedrive deals nobody has called

For sales managers and reps who want to see which open deals have had no Contivio calls lately, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Find open Pipedrive deals with no Contivio calls
Which of Sam Patel's open Pipedrive deals have had no Contivio calls in the last 30 days?
6 of Sam Patel's 14 open deals have had no calls in 30 days. - Northwind Traders renewal: 48,000, Negotiation, last call 14 Aug - Contoso expansion: 22,500, Proposal sent, no call on record - Fabrikam pilot: 9,800, Qualified, last call 2 Sep - Unresolved contacts: 2 deals with no unique person Want the full list of all 6 deals?
Pipedrive
Sample figures. Your results come from your own account.
pipedrive-get-user
pipedrive-get-deal
pipedrive-get-person
contivio-get-call
contivio-get-call-segment
contivio-get-activity

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Pipedrive

Pipedrive
Run it on your own Pipedrive data.

Connect Pipedrive, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Quiet deals go unnoticed across two systems

Deals sit in Pipedrive and calls sit in the phone system, so nobody sees which deals have gone silent. Checking each contact by hand is slow and deals stall.

Without PopdockAI

  • List open deals in Pipedrive
  • Look up each contact's phone number
  • Search the call log for each number
  • Lose track of which deals went quiet

With PopdockAI

  • Open deals and contact numbers are read for you
  • Calls are matched to contacts by phone number
  • Quiet deals are ranked by value with the last call date
  • Unresolved contacts are listed apart 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.

Prompt
**Objective:** For open Pipedrive deals owned by {owner-name} (optional, default all), find those whose contact person has had no Contivio call in the last {lookback-days} days (default 30).

**Step 1: Open deals (pipedrive server)**

If {owner-name} is given, call `pipedrive-get-user` with `name.contains` and take `user-id` (stop if not exactly one). Call `pipedrive-get-deal` with `status` = open and `owner-id` when known, `max-records` 50. Keep `deal-id`, `title`, `person-name`, `value`, `stage`.

**Step 2: Contact phone numbers (pipedrive server)**

For each deal call `pipedrive-get-person` with `name` = the deal's `person-name`. Skip deals with no unique person and list them as unresolved. Keep `phone`.

**Step 3: Calls (contivio server)**

Call `contivio-get-call` once with `start-time.from` = today minus the lookback, `max-records` 500. For each person, look for calls whose `from` or `to` matches their `phone` after stripping spaces, dashes and country code.

**Step 4: Report**

Table of deals with no calls (deal, value, stage, person, last call date if any), sorted by value. Then the unresolved list.

**Rules & Guidelines:**

* Contivio tools (`contivio-get-call`, `contivio-get-call-segment`, `contivio-get-activity`) come from the contivio server; Pipedrive tools come from the pipedrive server. Both servers must be connected; if a tool is missing, say which server is not connected and stop.
* Do NOT call any Pipedrive write tool (`pipedrive-add-note`, `pipedrive-add-activity`, `pipedrive-add-person`, `pipedrive-add-deal`, `pipedrive-add-lead`, `pipedrive-add-organization`, `pipedrive-update-person`, `pipedrive-update-activity`, `pipedrive-update-deal`, `pipedrive-update-lead`, `pipedrive-update-note`, `pipedrive-update-organization`). This prompt is read-only. Also do not change anything in Contivio.

**Validation:**

* If `contivio-get-call` returns the maximum records, warn that older calls in the window may be missing.
* If Contivio returns no calls at all, say so rather than listing every deal.

Who it's for

One answer, three teams that use it

Sales reps

Find your deals that need a call

See which of your open deals have had no calls lately, so you can pick up the phone before they go cold.

Which of my open Pipedrive deals have had no Contivio calls in the last 21 days?

Sales managers

Review pipeline activity

Check a rep's open deals for call activity and see the biggest quiet deals first, without opening each one.

Show Priya Shah's open deals with no Contivio calls in 30 days, sorted by value.

Revenue operations

Audit pipeline hygiene

Spot open deals with no phone contact and contacts that cannot be matched, to keep the pipeline honest.

List all open Pipedrive deals with no calls in the last 45 days, and any with unresolved contacts.

How it works

What PopdockAI does when you ask

You choose an owner and a look-back period, and your AI assistant compares Pipedrive deals with Contivio calls. It only reads and warns if the call results may be incomplete.

Ask

You give an optional owner and how many days to look back, which defaults to 30.

Your AI tool

Read

It reads the owner's open Pipedrive deals and finds each contact's phone number.

pipedrive-get-user
pipedrive-get-deal
pipedrive-get-person
contivio-get-call
contivio-get-call-segment
contivio-get-activity

Match

It reads the Contivio calls and matches them to contacts by phone number.

No items found.

Report

You get deals with no calls by value, then contacts it could not resolve.

Your AI tool

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.

get-data

pipedrive-get-user

Returns Pipedrive users with email, role, timezone, default currency and last login. Filter by name, email or active.
get-data

pipedrive-get-deal

Returns Pipedrive deals with stage, pipeline, value, probability, owner and expected close date. Filter by status, stage, owner, organization, value range, expected close date range or title.
get-data

pipedrive-get-person

Returns Pipedrive contacts with email, phone, job title, organization, owner and last activity date. Filter by name, email, city, organization or owner.
get-data

contivio-get-call

Returns Contivio call records with durations, results, direction, queue, agent and AI call summaries, filterable by date, agent, queue and customer.
get-data

contivio-get-call-segment

Returns the segments of Contivio calls (queue, agent and handling steps), filterable by call, for tracing a call end to end.
get-data

contivio-get-activity

Returns agent activity records from the Contivio connector, by type, channel and contact center, for a date window or agent.
Read only.Nothing in Pipedrive Changes

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.

How Popdock AI secures your data

The outcome

Chase the quiet deals before they stall

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation