Pipedrive Metrics and Breakdowns
This page provides a comprehensive reference of all supported metrics and breakdowns available for Pipedrive data extraction through Adzviser.
Reports include non-archived deals (excluding deleted deals) and non-archived leads created within the requested date range. Daily reports group by creation date. Statuses and values reflect the records when fetched; they are not historical snapshots or counts of events that occurred during the period.
Deal metrics and deal-specific breakdowns select the Deals report. Lead metrics and lead-specific breakdowns select the Leads report. Company fields, owner/creator/person/organization IDs, Next Activity ID, Added datetime, Update datetime, and Expected close date apply to either selected report. A request containing only shared breakdowns defaults to Deals; include a lead metric or Lead ID to select Leads. Looker Studio and Power BI require separate requests when both reports are selected.
Metrics
Deal metrics (computed from deal list data)
| Field Name | Description |
|---|---|
| Deals | Number of deal records in the report group |
| Deal value | Sum of deal values in their original currencies, with no currency conversion. Include Deal currency to keep currencies in separate groups. |
| Deal probability | Average explicit deal probability, excluding records without a probability. A configured zero is included; no stage-probability fallback is applied. |
Lead metrics (computed from lead list data)
| Field Name | Description |
|---|---|
| Leads | Number of lead records in the report group |
| Lead value | Sum of lead value amounts in their original currencies, with no currency conversion. Include Lead currency to keep currencies in separate groups. |
Breakdowns
Contact email (deals and leads)
| Field Name | Description |
|---|---|
| Person email | Email address of the person linked to the deal or lead. Uses the primary non-empty address, or the first non-empty address if no primary is marked. Blank when the linked person is missing, inaccessible, or has no email. |
Person email applies to either selected report, alongside the shared fields listed above. It works even when no organization is linked. Each person contributes one email value; multiple addresses do not duplicate deals, leads, or metric totals.
For customer contact addresses, request Person email. Organization Smart Bcc email and Lead CC email are Pipedrive addresses used to log email conversations.
Linked company / organization (deals and leads)
Company details come from the organization linked to each deal or lead. Missing or inaccessible organizations produce blank detail fields; the linked organization ID is retained when available.
| Field Name | Description |
|---|---|
| Company ID | Company identifier |
| Company name | Name of the company |
| Organization Smart Bcc email | The organization's Pipedrive address for logging emails. Blank when no organization is linked or the address is unavailable. Applies to both Deals and Leads. |
| Company address | Address stored for the company |
| Company country | Country stored for the company |
Existing requests using Company email remain supported with the original column name and logging-address meaning. Field discovery now lists Organization Smart Bcc email instead. To retrieve a customer's contact address, replace Company email with Person email in the request.
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 of the deal's value |
| 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. Deleted deals are excluded from the current reporting scope. |
| 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 of the lead's value |
| 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. Archived leads are excluded from the current reporting scope. |
| Lead was seen | Whether the lead was seen |
| Lead label IDs | List of lead label IDs, serialized as a JSON array in one report cell |
| Lead visible to | Users or permission group allowed to view the lead |
| Lead CC email | Pipedrive Bcc address for logging emails against the lead; not a contact's email address |
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 | Deal stage identifier (Deals only) |
| Pipeline ID | Deal pipeline identifier (Deals only) |
| Next Activity ID | Next Activity identifier |
Timestamps
| Field Name | Description |
|---|---|
| Added datetime | Creation timestamp (deals and leads); used to select records for the requested date range |
| Update datetime | Last update timestamp (deals and leads) |
| Stage change datetime | Last stage change timestamp (Deals only) |
| Close datetime | Closing timestamp (Deals only) |
| Won datetime | Won timestamp (Deals only) |
| Lost datetime | Lost timestamp (Deals only) |
| Local won date | Local date the deal was won (Deals only) |
| Local lost date | Local date the deal was lost (Deals only) |
| Local close date | Local closing date (Deals only) |
| Expected close date | Expected closing date (deals and leads) |