Explore with AI
ChatGPTClaudeGeminiPerplexity
Pipedrive
§ Connector · Popular
Pipedrive

Connect Pipedrive to your Definite lakehouse in minutes.

Native sync with row-level security, CDC where supported, and hourly-or-faster freshness. Query it with SQL, build dashboards, or ask Fi.

Have multiple Pipedrive accounts? Analytics across multiple Pipedrive accounts →

§ What you get

Everything Pipedrive exposes, modeled and queryable.

Pipedrive provides comprehensive CRM data through multiple endpoints. Below are the key objects available for sales analytics and business intelligence.

Sync cadence
Hourly or faster
CDC
Native where supported
Auth
Standard
Row-level security
Yes

Tables & streams

12 objects
Activity

Tasks, calls, and meetings linked to deals and contacts; used to measure rep productivity, touch patterns, and engagement cadence.

salesengagement
Currency

Reference list of supported currencies; enables multi-currency normalization in revenue reporting.

revenue_finance
Deal

Represents sales opportunities; core to revenue analytics such as pipeline coverage, win rate, forecast accuracy, and sales cycle time.

revenue_financesales
Deal Product (Line Item)

Associates products with deals including quantities and prices; supports product mix, revenue by SKU, and unit economics reporting.

revenue_financeproduct
Deal Stage Movement

Time-stamped stage-change events for deals; enables funnel conversion, stage duration/aging, and velocity analyses.

salesrevenue_finance
Note

Freeform notes attached to deals, persons, or organizations; useful for note count metrics and qualitative insights.

salesengagement
Organization

Accounts/companies associated with persons and deals; supports account segmentation, account-level pipeline, and revenue by account.

customersales
Person

Individual contacts linked to deals and activities; enables lead tracking, segmentation, and engagement analysis.

customersales
Pipeline

Sales process containers that group deals; enables segmentation and forecasting by pipeline.

salesoperations
Product

Catalog of sellable items used in deals; dimension for revenue by product, pricing analysis, and product performance.

revenue_financeproduct
Stage

Discrete steps within a pipeline; key dimension for stage-level conversion, counts, and aging analysis.

salesoperations
User

Sales reps and owners; dimension for attributing activity and deal performance, quota tracking, and benchmarking.

salesoperations
Requirements

Requires a Pipedrive account to connect.

Analyze with Fi

Operational data, performance metrics, and business insights.

Domainssales
§ How it works

Three steps. One afternoon.

01
Connect

Authenticate Pipedrive in a few clicks. OAuth, API key, or IAM role — we handle secrets and rotation.

definite connect pipedrive
02
Sync

We pull every stream into your lakehouse. CDC where the API supports it; full + incremental otherwise. Hourly-or-faster, row-level secure.

→ pipedrive.raw (synced hourly)
03
Query

SQL, dashboards, or ask Fi in plain English. Your Pipedrive data lives next to every other source — ready to join.

SELECT * FROM pipedrive.*
*
Don't see yours?
Any API becomes a Definite connector in minutes.

Build your own with the Definite SDK, or ask us — we add new connectors every week.

Request a connector
§ Combine with your stack

Pair Pipedrive with the rest of your data.

Cross-source joins, one governed semantic layer, AI answers across everything.

Your answer engine
is one afternoon away.

Book a 30-minute call. We'll build your first dashboard on the call — or you can stop paying us.