Pipedrive logo

CRM integration

Pipedrive reporting & pipeline

Connect Pipedrive with API token credentials and report SMB pipeline performance.

What you can do with Pipedrive in Maven

Maven supports Pipedrive reporting through OAuth or API token credentials for organizations, people, deals, pipelines, and activities. Use Pipedrive beside acquisition and lifecycle sources to connect lead generation to pipeline movement.

What you can measure

86 Pipedrive metrics you can use consistently

Maven keeps Pipedrive numbers consistent across dashboards, reports, and answers so the team is not debating which spreadsheet is right.

Average CRM Activity Duration

Average scheduled duration in minutes for CRM activities with valid start and end times

CRM Activity-Contact Associations

Contact associations carried by CRM activity records

CRM Activity Count

Scheduled, logged, and cancelled CRM activities at native activity grain

CRM Activity-Deal Associations

Deal associations carried by CRM activity records

Cancelled CRM Activities

CRM activities marked cancelled

Logged CRM Activities

CRM activities marked logged/completed by the provider

Overdue CRM Activities

CRM activities marked overdue

Average CRM Product Unit Price

Average provider unit price across CRM deal-product lines

CRM Product Line Count

Product lines attached to CRM deals

Show all 86 metrics

CRM Product Quantity

Quantity of products attached to CRM deals

CRM Product Revenue

Extended deal-product line amount calculated as quantity times provider unit price

Average Days in Current Stage

Average number of days open deals have remained in their current pipeline stage

Avg Days to Close

Average days from creation to close

Avg Deal Size

Average CRM deal amount calculated from deal amount divided by deal count

Average Forecast Probability

Average CRM forecast probability across deals that provide a forecast probability

Avg Open Deal Age

Average age of currently-open deals in days (creation to today)

Average Stage Probability

Average pipeline-stage probability across represented CRM deals

Closed Deals

CRM deals whose stage outcome is won or lost

CRM Deal-Account Associations

CRM deal-to-account associations where native account IDs are available

CRM Deal Associations

CRM deal association rows or summary counts, summed per deal

CRM Deal-Contact Associations

CRM deal-to-contact associations where native contact IDs are available

Deal Amount

CRM deal amount for monetary CRM opportunities; FranConnect lead rows have no amount

Deal Count

CRM deals or franchise-sales leads at deal grain

Forecast Amount

Num Contacts

Stage Display Order

Weighted Pipeline

Pipeline amount weighted by stage probability

Win Rate

Closed-won deals divided by all closed deals

Won Deals

Deals marked closed-won at the CRM stage outcome

Deal-Account Associations

CRM deal-to-account associations where native account IDs are available

Deal Associations

CRM deal association rows or summary counts, summed per deal

Deal-Contact Associations

CRM deal-to-contact associations where native contact IDs are available

Average Lead Score

Average native lead score across CRM leads that provide a score

Converted Leads

CRM leads or contacts marked converted by native or inferred lifecycle evidence

Customer-Matched Leads

CRM leads or contacts that resolve to ecommerce customer identity

Lead Conversion Rate

Converted CRM leads divided by all CRM leads

Lead Count

CRM leads or contacts at lead/contact grain

Lead Customer Match Rate

CRM leads matched to ecommerce customers divided by all CRM leads

Lead Qualification Rate

Qualified CRM leads divided by all CRM leads

MQL Leads

CRM leads or contacts whose conformed lifecycle stage is marketing-qualified lead

MQL Rate

Marketing-qualified CRM leads divided by all CRM leads

Qualified Leads

CRM leads or contacts marked qualified by native or inferred lifecycle evidence

SQL Leads

CRM leads or contacts whose conformed lifecycle stage is sales-qualified lead

SQL Rate

Sales-qualified CRM leads divided by all CRM leads

CRM Current Stage Observations

Current-stage snapshot observations in the CRM stage history surface

CRM Stage Events

CRM stage/property history events plus current-stage observations

Snapshot Closed Amount

Cumulative closed deal amount as of the snapshot date.

Snapshot Deal Count

Deals in the stage as of the snapshot date.

Lost Deals (Snapshot)

Cumulative closed-lost deals as of each snapshot date

Open Pipeline Value

Open deal amount in the pipeline as of each snapshot date

Open Deals (Snapshot)

Open deals in the pipeline as of each snapshot date

Weighted Pipeline (Snapshot)

Probability-weighted open pipeline value as of each snapshot date

Won Deals (Snapshot)

Cumulative closed-won deals as of each snapshot date

Attributed Closed CRM Deals

Closed CRM deals with deterministic campaign attribution matched to paid delivery

Attributed CRM Deals

CRM deals with deterministic campaign attribution matched to paid delivery

Attributed Won CRM Deals

Won CRM deals with deterministic campaign attribution matched to paid delivery

Paid CRM Clicks

Paid-media clicks represented in the paid-to-CRM surface

Paid CRM Cost per Deal

Paid spend divided by attributed CRM deals

Paid CRM Cost per Won Deal

Paid spend divided by attributed won CRM deals

Deterministically Matched CRM Deals

Attributed deals backed by a deterministic identity match

Paid CRM Impressions

Paid-media impressions represented in the paid-to-CRM surface

Paid CRM Spend

Paid-media spend on campaign-day rows with CRM attribution coverage; group or filter by spend_currency

Attributed Closed Deals

Closed CRM deals with deterministic campaign attribution matched to paid delivery

Attributed Deals

CRM deals with deterministic campaign attribution matched to paid delivery

Attributed Won Deals

Won CRM deals with deterministic campaign attribution matched to paid delivery

Deterministically Matched Deals

Attributed deals backed by a deterministic identity match

Conversion Weight (First Touch)

Fractional conversion credit under the first-touch model by conversion touchpoint

Conversion Weight (Last Touch)

Fractional conversion credit under the last-touch model by conversion touchpoint

Conversion Weight (Linear)

Fractional conversion credit under the linear model by conversion touchpoint

Conversion Weight (Markov)

Fractional conversion credit under the data-driven Markov removal-effect model by conversion touchpoint

Conversion Weight (Position Based)

Fractional conversion credit under the position-based model by conversion touchpoint

Conversion Weight (Shapley)

Fractional conversion credit under the data-driven Shapley-value model by conversion touchpoint

Conversion Weight (Time Decay)

Fractional conversion credit under the time-decay model by conversion touchpoint

Conversion Events

Canonical conversion/lead events counted through normalized last-touch weights

Answered Interactions

Source-neutral interactions that were answered

Average Answered Interaction Duration

Average duration in seconds among answered interactions

Avg Session Duration (s)

Average session duration in seconds with each session counted once

First-Touch Events

Touchpoints that opened a session

Interaction Answer Rate

Share of represented interactions that were answered

Interactions

Source-neutral interactions represented as attribution touchpoints

Last-Touch Events

Touchpoints that closed a session

Missed Interactions

Phone interactions that were neither answered nor sent to voicemail

Total Interaction Duration

Total interaction duration in seconds

Touchpoints

Journey touchpoint events recorded before conversion credit allocation

Touchpoint Order

Voicemail Interactions

Source-neutral interactions that reached voicemail

Questions you can ask

Just ask Maven about Pipedrive

Maven’s agent answers in plain language with the right metric definitions applied automatically. These are real, verified questions it can run today.

What is our deal pipeline value by stage for deals created in the last 90 days?

Show closed deals by stage

Show average days to close by owner

Show average open deal age by owner

Show open pipeline by stage

Show won and lost deals in the latest pipeline snapshot by stage

Show closed amount by pipeline in the latest pipeline snapshot

How many ServiceTitan bookings did we get in the last 30 days?

Connection and sync

What Maven pulls from Pipedrive

You connect Pipedrive with API token and account ID from the Pipedrive account. Maven stores them encrypted. The first Pipedrive sync pulls the most recent 30 days so the workspace fills quickly. A follow-up backfill then adds older history, up to 12 months in total. After that, each scheduled sync re-reads the last 3 days, so late changes are picked up.

Business profile

Authoritative Pipedrive company, reporting timezone, currency, locale, and current-user context.

Fields: company name, company domain, source timezone, default currency, locale, current user name, current user email, account name

Users

Pipedrive sales users and owners.

Fields: user name, email, is active, is admin, user timezone, locale, created at, updated at, account name

Custom fields

Pipedrive custom-field definitions retained by entity type for governed extensibility.

Fields: entity type, field code, field name, field type, is custom, is deleted, options json, ui visibility json, important fields json, required fields json, and 3 more

Currencies

Currencies configured for the Pipedrive company.

Fields: currency code, currency name, symbol, decimal points, is custom, is default, account name

Organizations

Pipedrive organization/company records.

Fields: organization name, owner name, address, city, state, country, postal code, label IDs json, is deleted, custom fields, and 3 more

Persons

Pipedrive person/contact records with organization, owner, communication, and lifecycle context.

Fields: person name, first name, last name, organization name, owner name, primary email, emails json, primary phone, phones json, job title, and 15 more

Leads

Pipedrive Leads Inbox records, including active and archived leads.

Fields: lead title, value amount, currency, source name, origin, is archived, was seen, expected close date, label IDs json, custom fields, and 3 more

Pipelines

Pipedrive sales pipelines.

Fields: pipeline name, display order, is deal probability enabled, is deleted, created at, updated at, account name

Stages

Pipedrive ordered pipeline stages and configured probabilities.

Fields: stage name, display order, deal probability, is deal rot enabled, days to rotten, is deleted, created at, updated at, account name

Deals

Pipedrive current, archived, and recently deleted deal records.

Fields: deal title, status, value amount, currency, probability, lost reason, source origin, products count, activities count, done activities count, and 15 more

Activity types

Pipedrive standard and custom activity-type definitions.

Fields: activity type name, color, display order, is custom, is deleted, account name

Activities

Pipedrive tasks, calls, meetings, and other sales activities with entity relationships.

Fields: activity subject, activity type, due date, due time, duration minutes, is done, is busy, priority, location, city, and 8 more

Products

Pipedrive product catalog entities.

Fields: product name, product code, unit, tax percent, is linkable, is deleted, prices json, custom fields, created at, updated at, and 1 more

Deal products

Pipedrive product attachments at one line per deal-product relationship.

Fields: product name, product code, unit, quantity, unit price amount, currency, line amount, tax percent, discount, discount type, and 8 more

How it works

Connect Pipedrive to a client’s workspace

No SQL or warehouse setup. Connect the source, then build the client’s report by asking Claude or ChatGPT.

Step 1

Connect Pipedrive

In the client’s workspace, open Sources, add Pipedrive and choose the account to sync. If you don’t have access to the account, send the client a connect link where the platform supports one.

Step 2

Maven syncs and models the data

Maven pulls the client’s Pipedrive data (14 objects) and models it into documented tables. No SQL, warehouse or pipeline setup.

Step 3

Report, ask and automate

Build the client’s report or deck by asking Claude or ChatGPT through the MCP, set alerts on what matters, and publish to the client’s portal once you approve it.

Works well with

Report Pipedrive alongside the rest of your stack

FAQ

Pipedrive reporting questions

What Pipedrive metrics can I report on in Maven?

Maven exposes 86 governed Pipedrive metrics, including Average CRM Activity Duration, CRM Activity-Contact Associations, CRM Activity Count, CRM Activity-Deal Associations, Cancelled CRM Activities and Logged CRM Activities — each defined once so it means the same thing in every report.

What can I break Pipedrive performance down by?

You can break Pipedrive metrics down by Account, Activity Name, Activity Type Name, Status, Is All Day, Is Flagged, Is Overdue and Deal Name, and more.

Can I combine Pipedrive with other data sources?

Yes. Pipedrive sits in the same client workspace as sources like Google Ads, LinkedIn Ads, Google Analytics 4, Klaviyo and Shopify, so one report or question can use them together.

What Pipedrive data does Maven sync?

Maven syncs company identity, currency, timezone, locale, and reporting context, users and CRM owners, governed custom-field definitions, enabled currency catalog, organizations and CRM accounts and people, consent, lifecycle evidence, and custom fields, and more from Pipedrive.

How often does Pipedrive data sync to Maven?

Maven refreshes Pipedrive on a schedule after the source is connected, and shows each source’s last sync time in the client’s workspace, so you can check the data is current before a report goes out.

Is my Pipedrive data secure with Maven?

Yes. Maven encrypts integration credentials and tokens, scopes access to the workspace, and uses the connection only to sync the reporting data needed for governed analytics.

Start your 14-day trial

Set up your first client, build their report by asking Claude or ChatGPT, and publish it to their portal.

  • Free for 14 days, no credit card
  • Your first client workspace and portal
  • Every report template, ready to clone
Start a 14-day trial

Nothing is charged unless you subscribe.

Prefer a walkthrough? Book a demo on one of your own clients.