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.
CRM integration
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
Maven keeps Pipedrive numbers consistent across dashboards, reports, and answers so the team is not debating which spreadsheet is right.
Average scheduled duration in minutes for CRM activities with valid start and end times
Contact associations carried by CRM activity records
Scheduled, logged, and cancelled CRM activities at native activity grain
Deal associations carried by CRM activity records
CRM activities marked cancelled
CRM activities marked logged/completed by the provider
CRM activities marked overdue
Average provider unit price across CRM deal-product lines
Product lines attached to CRM deals
Quantity of products attached to CRM deals
Extended deal-product line amount calculated as quantity times provider unit price
Average number of days open deals have remained in their current pipeline stage
Average days from creation to close
Average CRM deal amount calculated from deal amount divided by deal count
Average CRM forecast probability across deals that provide a forecast probability
Average age of currently-open deals in days (creation to today)
Average pipeline-stage probability across represented CRM deals
CRM deals whose stage outcome is won or lost
CRM deal-to-account associations where native account IDs are available
CRM deal association rows or summary counts, summed per deal
CRM deal-to-contact associations where native contact IDs are available
CRM deal amount for monetary CRM opportunities; FranConnect lead rows have no amount
CRM deals or franchise-sales leads at deal grain
Pipeline amount weighted by stage probability
Closed-won deals divided by all closed deals
Deals marked closed-won at the CRM stage outcome
CRM deal-to-account associations where native account IDs are available
CRM deal association rows or summary counts, summed per deal
CRM deal-to-contact associations where native contact IDs are available
Average native lead score across CRM leads that provide a score
CRM leads or contacts marked converted by native or inferred lifecycle evidence
CRM leads or contacts that resolve to ecommerce customer identity
Converted CRM leads divided by all CRM leads
CRM leads or contacts at lead/contact grain
CRM leads matched to ecommerce customers divided by all CRM leads
Qualified CRM leads divided by all CRM leads
CRM leads or contacts whose conformed lifecycle stage is marketing-qualified lead
Marketing-qualified CRM leads divided by all CRM leads
CRM leads or contacts marked qualified by native or inferred lifecycle evidence
CRM leads or contacts whose conformed lifecycle stage is sales-qualified lead
Sales-qualified CRM leads divided by all CRM leads
Current-stage snapshot observations in the CRM stage history surface
CRM stage/property history events plus current-stage observations
Cumulative closed deal amount as of the snapshot date.
Deals in the stage as of the snapshot date.
Cumulative closed-lost deals as of each snapshot date
Open deal amount in the pipeline as of each snapshot date
Open deals in the pipeline as of each snapshot date
Probability-weighted open pipeline value as of each snapshot date
Cumulative closed-won deals as of each snapshot date
Closed CRM deals with deterministic campaign attribution matched to paid delivery
CRM deals with deterministic campaign attribution matched to paid delivery
Won CRM deals with deterministic campaign attribution matched to paid delivery
Paid-media clicks represented in the paid-to-CRM surface
Paid spend divided by attributed CRM deals
Paid spend divided by attributed won CRM deals
Attributed deals backed by a deterministic identity match
Paid-media impressions represented in the paid-to-CRM surface
Paid-media spend on campaign-day rows with CRM attribution coverage; group or filter by spend_currency
Closed CRM deals with deterministic campaign attribution matched to paid delivery
CRM deals with deterministic campaign attribution matched to paid delivery
Won CRM deals with deterministic campaign attribution matched to paid delivery
Attributed deals backed by a deterministic identity match
Fractional conversion credit under the first-touch model by conversion touchpoint
Fractional conversion credit under the last-touch model by conversion touchpoint
Fractional conversion credit under the linear model by conversion touchpoint
Fractional conversion credit under the data-driven Markov removal-effect model by conversion touchpoint
Fractional conversion credit under the position-based model by conversion touchpoint
Fractional conversion credit under the data-driven Shapley-value model by conversion touchpoint
Fractional conversion credit under the time-decay model by conversion touchpoint
Canonical conversion/lead events counted through normalized last-touch weights
Source-neutral interactions that were answered
Average duration in seconds among answered interactions
Average session duration in seconds with each session counted once
Touchpoints that opened a session
Share of represented interactions that were answered
Source-neutral interactions represented as attribution touchpoints
Touchpoints that closed a session
Phone interactions that were neither answered nor sent to voicemail
Total interaction duration in seconds
Journey touchpoint events recorded before conversion credit allocation
Source-neutral interactions that reached voicemail
Questions you can ask
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
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.
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
Pipedrive sales users and owners.
Fields: user name, email, is active, is admin, user timezone, locale, created at, updated at, account name
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 configured for the Pipedrive company.
Fields: currency code, currency name, symbol, decimal points, is custom, is default, account name
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
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
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
Pipedrive sales pipelines.
Fields: pipeline name, display order, is deal probability enabled, is deleted, created at, updated at, account name
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
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
Pipedrive standard and custom activity-type definitions.
Fields: activity type name, color, display order, is custom, is deleted, account name
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
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
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
No SQL or warehouse setup. Connect the source, then build the client’s report by asking Claude or ChatGPT.
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.
Maven pulls the client’s Pipedrive data (14 objects) and models it into documented tables. No SQL, warehouse or pipeline setup.
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
FAQ
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.
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.
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.
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.
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.
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.
Set up your first client, build their report by asking Claude or ChatGPT, and publish it to their portal.
Nothing is charged unless you subscribe.