Integrations
Pipedrive datasets and fields
The 14 datasets Maven lands from Pipedrive, every field in them, and how the connection syncs.
Maven lands 14 datasets from Pipedrive in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the Pipedrive integration page.
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.
Datasets#
Business profile#
Authoritative Pipedrive company, reporting timezone, currency, locale, and current-user context.
| Field | Type |
|---|---|
| company ID | Text |
| company name | Text |
| company domain | Text |
| source timezone | Text |
| default currency | Text |
| locale | Text |
| current user ID | Text |
| current user name | Text |
| current user email | Text |
| account ID | Text |
| account name | Text |
Users#
Pipedrive sales users and owners.
| Field | Type |
|---|---|
| pipedrive user ID | Text |
| user name | Text |
| Text | |
| is active | True/false |
| is admin | True/false |
| role ID | Text |
| user timezone | Text |
| locale | Text |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
Custom fields#
Pipedrive custom-field definitions retained by entity type for governed extensibility.
| Field | Type |
|---|---|
| entity type | Text |
| field code | Text |
| field name | Text |
| field type | Text |
| is custom | True/false |
| is deleted | True/false |
| options json | Text |
| ui visibility json | Text |
| important fields json | Text |
| required fields json | Text |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
Currencies#
Currencies configured for the Pipedrive company.
| Field | Type |
|---|---|
| currency code | Text |
| currency name | Text |
| symbol | Text |
| decimal points | Integer |
| is custom | True/false |
| is default | True/false |
| account ID | Text |
| account name | Text |
Organizations#
Pipedrive organization/company records.
| Field | Type |
|---|---|
| pipedrive organization ID | Text |
| organization name | Text |
| owner ID | Text |
| owner name | Text |
| address | Text |
| city | Text |
| state | Text |
| country | Text |
| postal code | Text |
| label IDs json | Text |
| is deleted | True/false |
| custom fields | Text |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
Persons#
Pipedrive person/contact records with organization, owner, communication, and lifecycle context.
| Field | Type |
|---|---|
| pipedrive person ID | Text |
| person name | Text |
| first name | Text |
| last name | Text |
| organization ID | Text |
| organization name | Text |
| owner ID | Text |
| owner name | Text |
| primary email | Text |
| emails json | Text |
| primary phone | Text |
| phones json | Text |
| job title | Text |
| marketing status | Text |
| doi status | Text |
| open deals count | Integer |
| closed deals count | Integer |
| won deals count | Integer |
| lost deals count | Integer |
| activities count | Integer |
| done activities count | Integer |
| undone activities count | Integer |
| label IDs json | Text |
| is deleted | True/false |
| custom fields | Text |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
Leads#
Pipedrive Leads Inbox records, including active and archived leads.
| Field | Type |
|---|---|
| pipedrive lead ID | Text |
| lead title | Text |
| owner ID | Text |
| creator ID | Text |
| person ID | Text |
| organization ID | Text |
| value amount | Number |
| currency | Text |
| source name | Text |
| origin | Text |
| origin ID | Text |
| channel ID | Text |
| channel detail ID | Text |
| is archived | True/false |
| was seen | True/false |
| expected close date | Date |
| label IDs json | Text |
| custom fields | Text |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
Pipelines#
Pipedrive sales pipelines.
| Field | Type |
|---|---|
| pipedrive pipeline ID | Text |
| pipeline name | Text |
| display order | Integer |
| is deal probability enabled | True/false |
| is deleted | True/false |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
Stages#
Pipedrive ordered pipeline stages and configured probabilities.
| Field | Type |
|---|---|
| pipedrive stage ID | Text |
| stage name | Text |
| pipeline ID | Text |
| display order | Integer |
| deal probability | Number |
| is deal rot enabled | True/false |
| days to rotten | Integer |
| is deleted | True/false |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
Deals#
Pipedrive current, archived, and recently deleted deal records.
| Field | Type |
|---|---|
| pipedrive deal ID | Text |
| deal title | Text |
| owner ID | Text |
| person ID | Text |
| organization ID | Text |
| pipeline ID | Text |
| stage ID | Text |
| status | Text |
| value amount | Number |
| currency | Text |
| probability | Number |
| lost reason | Text |
| source origin | Text |
| source origin ID | Text |
| source lead ID | Text |
| channel ID | Text |
| channel detail ID | Text |
| products count | Integer |
| activities count | Integer |
| done activities count | Integer |
| undone activities count | Integer |
| participants count | Integer |
| label IDs json | Text |
| is archived | True/false |
| is deleted | True/false |
| archive at | Timestamp |
| close at | Timestamp |
| won at | Timestamp |
| lost at | Timestamp |
| stage change at | Timestamp |
| expected close date | Date |
| custom fields | Text |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
Activity types#
Pipedrive standard and custom activity-type definitions.
| Field | Type |
|---|---|
| activity type key | Text |
| pipedrive activity type ID | Text |
| activity type name | Text |
| icon key | Text |
| color | Text |
| display order | Integer |
| is custom | True/false |
| is deleted | True/false |
| account ID | Text |
| account name | Text |
Activities#
Pipedrive tasks, calls, meetings, and other sales activities with entity relationships.
| Field | Type |
|---|---|
| pipedrive activity ID | Text |
| activity subject | Text |
| activity type | Text |
| owner ID | Text |
| deal ID | Text |
| lead ID | Text |
| person ID | Text |
| organization ID | Text |
| project ID | Text |
| due date | Date |
| due time | Text |
| duration minutes | Integer |
| is done | True/false |
| is busy | True/false |
| priority | Integer |
| location | Text |
| city | Text |
| state | Text |
| country | Text |
| participants json | Text |
| attendees json | Text |
| marked done at | Timestamp |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
Products#
Pipedrive product catalog entities.
| Field | Type |
|---|---|
| pipedrive product ID | Text |
| product name | Text |
| product code | Text |
| unit | Text |
| tax percent | Number |
| category ID | Text |
| owner ID | Text |
| is linkable | True/false |
| is deleted | True/false |
| prices json | Text |
| custom fields | Text |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |
Deal products#
Pipedrive product attachments at one line per deal-product relationship.
| Field | Type |
|---|---|
| pipedrive deal product ID | Text |
| deal ID | Text |
| product ID | Text |
| product variation ID | Text |
| product name | Text |
| product code | Text |
| unit | Text |
| quantity | Number |
| unit price amount | Number |
| currency | Text |
| line amount | Number |
| tax percent | Number |
| discount | Number |
| discount type | Text |
| is enabled | True/false |
| billing frequency | Text |
| billing frequency cycles | Integer |
| billing start date | Date |
| display order | Integer |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |
| account name | Text |