# Pipedrive datasets and fields

> The 14 datasets Maven lands from Pipedrive, every field in them, and how the connection syncs.

Source: https://mavendata.ai/docs/integrations/pipedrive

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](https://mavendata.ai/integrations/pipedrive).

## 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 |
| email | 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 |
