Pipedrive Metrics and Breakdowns
This page provides a comprehensive reference of all supported metrics and breakdowns available for Pipedrive data extraction through Adzviser.
Metrics
Deal metrics (computed from deal list data)
| Field Name | Description |
|---|---|
| Deals | Number of deals in the selected pipeline or reporting scope |
| Deal value | Monetary value of deal value in the account's reporting currency |
| Deal probability | Average configured win probability across the selected deals |
Lead metrics (computed from lead list data)
| Field Name | Description |
|---|---|
| Leads | Number of attributed lead events |
| Lead value | Monetary value of lead value in the account's reporting currency |
Breakdowns
These map to organization fields (resolved at processing time)
| Field Name | Description |
|---|---|
| Company ID | Company identifier |
| Company name | Name of the company |
| Company email | Email address stored for the related Pipedrive record |
| Company address | Address stored for the company |
| Company country | Country stored for the company |
Deal
| Field Name | Description |
|---|---|
| Deal ID | Deal identifier |
| Deal title | Human-readable title of the related deal content |
| Deal status | Current deal status |
| Deal currency | Currency used for the related Pipedrive amounts and budgets |
| Deal origin | Origin classification assigned to the deal |
| Deal origin ID | Deal origin identifier |
| Deal channel | Channel classification assigned to the deal |
| Deal channel ID | Deal channel identifier |
| Deal is deleted | Whether the deal is deleted |
| Deal visibility | Visibility classification assigned to the deal |
| Deal lost reason | Recorded reason associated with the deal's current outcome |
Lead
| Field Name | Description |
|---|---|
| Lead ID | Lead identifier |
| Lead title | Human-readable title of the related lead content |
| Lead currency | Currency used for the related Pipedrive amounts and budgets |
| Lead source name | Name of the lead source |
| Lead origin | Origin classification assigned to the lead |
| Lead origin ID | Lead origin identifier |
| Lead channel | Channel classification assigned to the lead |
| Lead channel ID | Lead channel identifier |
| Lead is archived | Whether the lead is archived |
| Lead was seen | Whether the lead was seen |
| Lead label IDs | Unique platform or external identifier associated with the lead |
| Lead visible to | Users or permission group allowed to view the lead |
| Lead CC email | Email address stored for the related Pipedrive record |
Related objects (foreign keys)
| Field Name | Description |
|---|---|
| Owner ID | Owner identifier |
| Creator ID | Creator identifier |
| Person ID | Person identifier |
| Organization ID | Organization identifier |
| Stage ID | Stage identifier |
| Pipeline ID | Pipeline identifier |
| Next Activity ID | Next Activity identifier |
Timestamps
| Field Name | Description |
|---|---|
| Added datetime | Calendar date associated with the added time event or record |
| Update datetime | Calendar date associated with the up time event or record |
| Stage change datetime | Calendar date associated with the stage change time event or record |
| Close datetime | Calendar date associated with the close time event or record |
| Won datetime | Calendar date associated with the won time event or record |
| Lost datetime | Calendar date associated with the lost time event or record |
| Local won date | Calendar date associated with the local won event or record |
| Local lost date | Calendar date associated with the local lost event or record |
| Local close date | Calendar date associated with the local close event or record |
| Expected close date | Calendar date associated with the expected close event or record |