--- title: "Pipedrive data warehouse table groups" slug: "pipedrive-data-warehouse-table-groups" description: "Explore the complete Supermetrics data warehouse table groups for Pipedrive. See all the tables and the fields included in them." updated: 2026-03-05T14:11:40Z published: 2026-03-05T14:11:40Z canonical: "docs.supermetrics.com/pipedrive-data-warehouse-table-groups" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt > Use this file to discover all available pages before exploring further. # Pipedrive data warehouse table groups Search fields ### Table: LEAD | \| added_date \| \| --- \| \| \\| Display name \\| Added date \\| \\| --- \\| --- \\| \\| Description \\| Date of when the record was added \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Added date \| \| Description \| Date of when the record was added \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | --- | | added_date | | \| Display name \| Added date \| \| --- \| --- \| \| Description \| Date of when the record was added \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Added date | | Description | Date of when the record was added | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| added_datetime \| \| --- \| \| \\| Display name \\| Added datetime \\| \\| --- \\| --- \\| \\| Description \\| Datetime of when the record was added \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Added datetime \| \| Description \| Datetime of when the record was added \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | added_datetime | | \| Display name \| Added datetime \| \| --- \| --- \| \| Description \| Datetime of when the record was added \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Display name | Added datetime | | Description | Datetime of when the record was added | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| company_country \| \| --- \| \| \\| Display name \\| Company country \\| \\| --- \\| --- \\| \\| Description \\| Country of the company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Company country \| \| Description \| Country of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | company_country | | \| Display name \| Company country \| \| --- \| --- \| \| Description \| Country of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Company country | | Description | Country of the company | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| company_domain \| \| --- \| \| \\| Display name \\| Company domain \\| \\| --- \\| --- \\| \\| Description \\| Domain of the company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Company domain \| \| Description \| Domain of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | company_domain | | \| Display name \| Company domain \| \| --- \| --- \| \| Description \| Domain of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Company domain | | Description | Domain of the company | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| company_id \| \| --- \| \| \\| Display name \\| Company ID \\| \\| --- \\| --- \\| \\| Description \\| Unique identifier of the company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Company ID \| \| Description \| Unique identifier of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | company_id | | \| Display name \| Company ID \| \| --- \| --- \| \| Description \| Unique identifier of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Company ID | | Description | Unique identifier of the company | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| company_name \| \| --- \| \| \\| Display name \\| Company name \\| \\| --- \\| --- \\| \\| Description \\| Name of the company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Company name \| \| Description \| Name of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | company_name | | \| Display name \| Company name \| \| --- \| --- \| \| Description \| Name of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Company name | | Description | Name of the company | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| dataSourceName \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | dataSourceName | | \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Data source | | Description | The name of the source for this data, as listed on supermetrics.com/docs | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| date \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | date | | \| Display name \| Date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Date | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| expected_close_date \| \| --- \| \| \\| Display name \\| Expected close date \\| \\| --- \\| --- \\| \\| Description \\| Estimated date when the record is expected to close \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Expected close date \| \| Description \| Estimated date when the record is expected to close \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | expected_close_date | | \| Display name \| Expected close date \| \| --- \| --- \| \| Description \| Estimated date when the record is expected to close \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Expected close date | | Description | Estimated date when the record is expected to close | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| last_update_date \| \| --- \| \| \\| Display name \\| Update date \\| \\| --- \\| --- \\| \\| Description \\| Date of the last update to the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Update date \| \| Description \| Date of the last update to the record \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | last_update_date | | \| Display name \| Update date \| \| --- \| --- \| \| Description \| Date of the last update to the record \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Update date | | Description | Date of the last update to the record | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| last_update_datetime \| \| --- \| \| \\| Display name \\| Update datetime \\| \\| --- \\| --- \\| \\| Description \\| Datetime of the last update to the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Update datetime \| \| Description \| Datetime of the last update to the record \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | last_update_datetime | | \| Display name \| Update datetime \| \| --- \| --- \| \| Description \| Datetime of the last update to the record \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Display name | Update datetime | | Description | Datetime of the last update to the record | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| lead_cc_email \| \| --- \| \| \\| Display name \\| Lead CC email \\| \\| --- \\| --- \\| \\| Description \\| Email address for lead-related communication \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead CC email \| \| Description \| Email address for lead-related communication \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| | | lead_cc_email | | \| Display name \| Lead CC email \| \| --- \| --- \| \| Description \| Email address for lead-related communication \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| | | Display name | Lead CC email | | Description | Email address for lead-related communication | | Field type | dimension | | Data type | [string.text.email](/apidocs/field-data-types#text) | | \| lead_channel \| \| --- \| \| \\| Display name \\| Lead channel \\| \\| --- \\| --- \\| \\| Description \\| ID of the channel through which the lead was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead channel \| \| Description \| ID of the channel through which the lead was created \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_channel | | \| Display name \| Lead channel \| \| --- \| --- \| \| Description \| ID of the channel through which the lead was created \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead channel | | Description | ID of the channel through which the lead was created | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_channel_id \| \| --- \| \| \\| Display name \\| Lead channel ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the specific channel, if applicable \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead channel ID \| \| Description \| ID of the specific channel, if applicable \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_channel_id | | \| Display name \| Lead channel ID \| \| --- \| --- \| \| Description \| ID of the specific channel, if applicable \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead channel ID | | Description | ID of the specific channel, if applicable | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_currency \| \| --- \| \| \\| Display name \\| Lead currency \\| \\| --- \\| --- \\| \\| Description \\| Currency of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Display name \| Lead currency \| \| Description \| Currency of the lead \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | lead_currency | | \| Display name \| Lead currency \| \| --- \| --- \| \| Description \| Currency of the lead \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | Display name | Lead currency | | Description | Currency of the lead | | Field type | dimension | | Data type | [string.currency.code](/apidocs/field-data-types#currency) | | \| lead_id \| \| --- \| \| \\| Display name \\| Lead ID \\| \\| --- \\| --- \\| \\| Description \\| Unique identifier for the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead ID \| \| Description \| Unique identifier for the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_id | | \| Display name \| Lead ID \| \| --- \| --- \| \| Description \| Unique identifier for the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead ID | | Description | Unique identifier for the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_is_archived \| \| --- \| \| \\| Display name \\| Lead is archived \\| \\| --- \\| --- \\| \\| Description \\| Flag indicating if the lead is archived \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Lead is archived \| \| Description \| Flag indicating if the lead is archived \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | lead_is_archived | | \| Display name \| Lead is archived \| \| --- \| --- \| \| Description \| Flag indicating if the lead is archived \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Display name | Lead is archived | | Description | Flag indicating if the lead is archived | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| lead_origin \| \| --- \| \| \\| Display name \\| Lead origin \\| \\| --- \\| --- \\| \\| Description \\| Origin type of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead origin \| \| Description \| Origin type of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_origin | | \| Display name \| Lead origin \| \| --- \| --- \| \| Description \| Origin type of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead origin | | Description | Origin type of the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_origin_id \| \| --- \| \| \\| Display name \\| Lead origin ID \\| \\| --- \\| --- \\| \\| Description \\| Origin ID of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead origin ID \| \| Description \| Origin ID of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_origin_id | | \| Display name \| Lead origin ID \| \| --- \| --- \| \| Description \| Origin ID of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead origin ID | | Description | Origin ID of the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_source_name \| \| --- \| \| \\| Display name \\| Lead source name \\| \\| --- \\| --- \\| \\| Description \\| Name of the source where the lead originated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead source name \| \| Description \| Name of the source where the lead originated \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_source_name | | \| Display name \| Lead source name \| \| --- \| --- \| \| Description \| Name of the source where the lead originated \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead source name | | Description | Name of the source where the lead originated | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_title \| \| --- \| \| \\| Display name \\| Lead title \\| \\| --- \\| --- \\| \\| Description \\| Title of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead title \| \| Description \| Title of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_title | | \| Display name \| Lead title \| \| --- \| --- \| \| Description \| Title of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead title | | Description | Title of the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_value \| \| --- \| \| \\| Display name \\| Lead value \\| \\| --- \\| --- \\| \\| Description \\| Monetary value of the lead \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Lead value \| \| Description \| Monetary value of the lead \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | lead_value | | \| Display name \| Lead value \| \| --- \| --- \| \| Description \| Monetary value of the lead \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Lead value | | Description | Monetary value of the lead | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| lead_was_seen \| \| --- \| \| \\| Display name \\| Lead was seen \\| \\| --- \\| --- \\| \\| Description \\| Flag indicating if the lead has been viewed \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Lead was seen \| \| Description \| Flag indicating if the lead has been viewed \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | lead_was_seen | | \| Display name \| Lead was seen \| \| --- \| --- \| \| Description \| Flag indicating if the lead has been viewed \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Display name | Lead was seen | | Description | Flag indicating if the lead has been viewed | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| next_activity_id \| \| --- \| \| \\| Display name \\| Next Activity ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the next scheduled activity for the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Next Activity ID \| \| Description \| ID of the next scheduled activity for the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | next_activity_id | | \| Display name \| Next Activity ID \| \| --- \| --- \| \| Description \| ID of the next scheduled activity for the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Next Activity ID | | Description | ID of the next scheduled activity for the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| organization_id \| \| --- \| \| \\| Display name \\| Organization ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the organization linked to the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Organization ID \| \| Description \| ID of the organization linked to the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | organization_id | | \| Display name \| Organization ID \| \| --- \| --- \| \| Description \| ID of the organization linked to the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Organization ID | | Description | ID of the organization linked to the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| person_id \| \| --- \| \| \\| Display name \\| Person ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the person associated with the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Person ID \| \| Description \| ID of the person associated with the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | person_id | | \| Display name \| Person ID \| \| --- \| --- \| \| Description \| ID of the person associated with the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Person ID | | Description | ID of the person associated with the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### Table: DEAL | \| added_date \| \| --- \| \| \\| Display name \\| Added date \\| \\| --- \\| --- \\| \\| Description \\| Date of when the record was added \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Added date \| \| Description \| Date of when the record was added \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | --- | | added_date | | \| Display name \| Added date \| \| --- \| --- \| \| Description \| Date of when the record was added \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Added date | | Description | Date of when the record was added | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| added_datetime \| \| --- \| \| \\| Display name \\| Added datetime \\| \\| --- \\| --- \\| \\| Description \\| Datetime of when the record was added \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Added datetime \| \| Description \| Datetime of when the record was added \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | added_datetime | | \| Display name \| Added datetime \| \| --- \| --- \| \| Description \| Datetime of when the record was added \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Display name | Added datetime | | Description | Datetime of when the record was added | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| close_date \| \| --- \| \| \\| Display name \\| Close date \\| \\| --- \\| --- \\| \\| Description \\| Date when the record was closed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Close date \| \| Description \| Date when the record was closed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | close_date | | \| Display name \| Close date \| \| --- \| --- \| \| Description \| Date when the record was closed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Close date | | Description | Date when the record was closed | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| close_datetime \| \| --- \| \| \\| Display name \\| Close datetime \\| \\| --- \\| --- \\| \\| Description \\| Datetime when the record was closed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Close datetime \| \| Description \| Datetime when the record was closed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | close_datetime | | \| Display name \| Close datetime \| \| --- \| --- \| \| Description \| Datetime when the record was closed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Display name | Close datetime | | Description | Datetime when the record was closed | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| company_country \| \| --- \| \| \\| Display name \\| Company country \\| \\| --- \\| --- \\| \\| Description \\| Country of the company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Company country \| \| Description \| Country of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | company_country | | \| Display name \| Company country \| \| --- \| --- \| \| Description \| Country of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Company country | | Description | Country of the company | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| company_domain \| \| --- \| \| \\| Display name \\| Company domain \\| \\| --- \\| --- \\| \\| Description \\| Domain of the company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Company domain \| \| Description \| Domain of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | company_domain | | \| Display name \| Company domain \| \| --- \| --- \| \| Description \| Domain of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Company domain | | Description | Domain of the company | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| company_id \| \| --- \| \| \\| Display name \\| Company ID \\| \\| --- \\| --- \\| \\| Description \\| Unique identifier of the company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Company ID \| \| Description \| Unique identifier of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | company_id | | \| Display name \| Company ID \| \| --- \| --- \| \| Description \| Unique identifier of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Company ID | | Description | Unique identifier of the company | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| company_name \| \| --- \| \| \\| Display name \\| Company name \\| \\| --- \\| --- \\| \\| Description \\| Name of the company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Company name \| \| Description \| Name of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | company_name | | \| Display name \| Company name \| \| --- \| --- \| \| Description \| Name of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Company name | | Description | Name of the company | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| creator_id \| \| --- \| \| \\| Display name \\| Creator ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the person who created the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Creator ID \| \| Description \| ID of the person who created the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | creator_id | | \| Display name \| Creator ID \| \| --- \| --- \| \| Description \| ID of the person who created the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Creator ID | | Description | ID of the person who created the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| dataSourceName \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | dataSourceName | | \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Data source | | Description | The name of the source for this data, as listed on supermetrics.com/docs | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| date \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | date | | \| Display name \| Date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Date | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| deal_channel \| \| --- \| \| \\| Display name \\| Deal channel \\| \\| --- \\| --- \\| \\| Description \\| Channel ID associated with the deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Deal channel \| \| Description \| Channel ID associated with the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | deal_channel | | \| Display name \| Deal channel \| \| --- \| --- \| \| Description \| Channel ID associated with the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Deal channel | | Description | Channel ID associated with the deal | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deal_channel_id \| \| --- \| \| \\| Display name \\| Deal channel ID \\| \\| --- \\| --- \\| \\| Description \\| ID associated with the specific channel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Deal channel ID \| \| Description \| ID associated with the specific channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | deal_channel_id | | \| Display name \| Deal channel ID \| \| --- \| --- \| \| Description \| ID associated with the specific channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Deal channel ID | | Description | ID associated with the specific channel | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deal_currency \| \| --- \| \| \\| Display name \\| Deal currency \\| \\| --- \\| --- \\| \\| Description \\| Currency of the deal value \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Display name \| Deal currency \| \| Description \| Currency of the deal value \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | deal_currency | | \| Display name \| Deal currency \| \| --- \| --- \| \| Description \| Currency of the deal value \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | Display name | Deal currency | | Description | Currency of the deal value | | Field type | dimension | | Data type | [string.currency.code](/apidocs/field-data-types#currency) | | \| deal_id \| \| --- \| \| \\| Display name \\| Deal ID \\| \\| --- \\| --- \\| \\| Description \\| Unique identifier for the deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Deal ID \| \| Description \| Unique identifier for the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | deal_id | | \| Display name \| Deal ID \| \| --- \| --- \| \| Description \| Unique identifier for the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Deal ID | | Description | Unique identifier for the deal | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deal_is_deleted \| \| --- \| \| \\| Display name \\| Deal is deleted \\| \\| --- \\| --- \\| \\| Description \\| Indicates if the deal is deleted \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Deal is deleted \| \| Description \| Indicates if the deal is deleted \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | deal_is_deleted | | \| Display name \| Deal is deleted \| \| --- \| --- \| \| Description \| Indicates if the deal is deleted \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Display name | Deal is deleted | | Description | Indicates if the deal is deleted | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| deal_lost_reason \| \| --- \| \| \\| Display name \\| Deal lost reason \\| \\| --- \\| --- \\| \\| Description \\| Reason for losing the deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Deal lost reason \| \| Description \| Reason for losing the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | deal_lost_reason | | \| Display name \| Deal lost reason \| \| --- \| --- \| \| Description \| Reason for losing the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Deal lost reason | | Description | Reason for losing the deal | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deal_origin \| \| --- \| \| \\| Display name \\| Deal origin \\| \\| --- \\| --- \\| \\| Description \\| Origin of the deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Deal origin \| \| Description \| Origin of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | deal_origin | | \| Display name \| Deal origin \| \| --- \| --- \| \| Description \| Origin of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Deal origin | | Description | Origin of the deal | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deal_origin_id \| \| --- \| \| \\| Display name \\| Deal origin ID \\| \\| --- \\| --- \\| \\| Description \\| ID associated with the origin of the deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Deal origin ID \| \| Description \| ID associated with the origin of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | deal_origin_id | | \| Display name \| Deal origin ID \| \| --- \| --- \| \| Description \| ID associated with the origin of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Deal origin ID | | Description | ID associated with the origin of the deal | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deal_probability \| \| --- \| \| \\| Display name \\| Deal probability \\| \\| --- \\| --- \\| \\| Description \\| Chance that a deal will be successfully closed \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.percentage](/apidocs/field-data-types#number) \\| \| \| Display name \| Deal probability \| \| Description \| Chance that a deal will be successfully closed \| \| Field type \| metric \| \| Data type \| [float.number.percentage](/apidocs/field-data-types#number) \| | | deal_probability | | \| Display name \| Deal probability \| \| --- \| --- \| \| Description \| Chance that a deal will be successfully closed \| \| Field type \| metric \| \| Data type \| [float.number.percentage](/apidocs/field-data-types#number) \| | | Display name | Deal probability | | Description | Chance that a deal will be successfully closed | | Field type | metric | | Data type | [float.number.percentage](/apidocs/field-data-types#number) | | \| deal_status \| \| --- \| \| \\| Display name \\| Deal status \\| \\| --- \\| --- \\| \\| Description \\| Current status of the deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Deal status \| \| Description \| Current status of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | deal_status | | \| Display name \| Deal status \| \| --- \| --- \| \| Description \| Current status of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Deal status | | Description | Current status of the deal | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deal_title \| \| --- \| \| \\| Display name \\| Deal title \\| \\| --- \\| --- \\| \\| Description \\| Title of the deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Deal title \| \| Description \| Title of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | deal_title | | \| Display name \| Deal title \| \| --- \| --- \| \| Description \| Title of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Deal title | | Description | Title of the deal | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deal_value \| \| --- \| \| \\| Display name \\| Deal value \\| \\| --- \\| --- \\| \\| Description \\| Monetary value of the deal \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Deal value \| \| Description \| Monetary value of the deal \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | deal_value | | \| Display name \| Deal value \| \| --- \| --- \| \| Description \| Monetary value of the deal \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Deal value | | Description | Monetary value of the deal | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| expected_close_date \| \| --- \| \| \\| Display name \\| Expected close date \\| \\| --- \\| --- \\| \\| Description \\| Estimated date when the record is expected to close \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Expected close date \| \| Description \| Estimated date when the record is expected to close \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | expected_close_date | | \| Display name \| Expected close date \| \| --- \| --- \| \| Description \| Estimated date when the record is expected to close \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Expected close date | | Description | Estimated date when the record is expected to close | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| last_update_date \| \| --- \| \| \\| Display name \\| Update date \\| \\| --- \\| --- \\| \\| Description \\| Date of the last update to the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Update date \| \| Description \| Date of the last update to the record \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | last_update_date | | \| Display name \| Update date \| \| --- \| --- \| \| Description \| Date of the last update to the record \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Update date | | Description | Date of the last update to the record | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| last_update_datetime \| \| --- \| \| \\| Display name \\| Update datetime \\| \\| --- \\| --- \\| \\| Description \\| Datetime of the last update to the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Update datetime \| \| Description \| Datetime of the last update to the record \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | last_update_datetime | | \| Display name \| Update datetime \| \| --- \| --- \| \| Description \| Datetime of the last update to the record \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Display name | Update datetime | | Description | Datetime of the last update to the record | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| local_close_date \| \| --- \| \| \\| Display name \\| Local close date \\| \\| --- \\| --- \\| \\| Description \\| Local date when the record was closed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Local close date \| \| Description \| Local date when the record was closed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | local_close_date | | \| Display name \| Local close date \| \| --- \| --- \| \| Description \| Local date when the record was closed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Local close date | | Description | Local date when the record was closed | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| local_lost_date \| \| --- \| \| \\| Display name \\| Local lost date \\| \\| --- \\| --- \\| \\| Description \\| Local date when the deal was lost \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Local lost date \| \| Description \| Local date when the deal was lost \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | local_lost_date | | \| Display name \| Local lost date \| \| --- \| --- \| \| Description \| Local date when the deal was lost \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Local lost date | | Description | Local date when the deal was lost | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| local_won_date \| \| --- \| \| \\| Display name \\| Local won date \\| \\| --- \\| --- \\| \\| Description \\| Local date when the deal was won \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Local won date \| \| Description \| Local date when the deal was won \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | local_won_date | | \| Display name \| Local won date \| \| --- \| --- \| \| Description \| Local date when the deal was won \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Local won date | | Description | Local date when the deal was won | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| lost_date \| \| --- \| \| \\| Display name \\| Lost date \\| \\| --- \\| --- \\| \\| Description \\| Date when the deal was lost \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Lost date \| \| Description \| Date when the deal was lost \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | lost_date | | \| Display name \| Lost date \| \| --- \| --- \| \| Description \| Date when the deal was lost \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Lost date | | Description | Date when the deal was lost | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| lost_datetime \| \| --- \| \| \\| Display name \\| Lost datetime \\| \\| --- \\| --- \\| \\| Description \\| Datetime when the deal was lost \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Lost datetime \| \| Description \| Datetime when the deal was lost \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | lost_datetime | | \| Display name \| Lost datetime \| \| --- \| --- \| \| Description \| Datetime when the deal was lost \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Display name | Lost datetime | | Description | Datetime when the deal was lost | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| organization_id \| \| --- \| \| \\| Display name \\| Organization ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the organization linked to the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Organization ID \| \| Description \| ID of the organization linked to the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | organization_id | | \| Display name \| Organization ID \| \| --- \| --- \| \| Description \| ID of the organization linked to the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Organization ID | | Description | ID of the organization linked to the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| owner_id \| \| --- \| \| \\| Display name \\| Owner ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the person responsible for the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Owner ID \| \| Description \| ID of the person responsible for the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | owner_id | | \| Display name \| Owner ID \| \| --- \| --- \| \| Description \| ID of the person responsible for the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Owner ID | | Description | ID of the person responsible for the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| person_id \| \| --- \| \| \\| Display name \\| Person ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the person associated with the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Person ID \| \| Description \| ID of the person associated with the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | person_id | | \| Display name \| Person ID \| \| --- \| --- \| \| Description \| ID of the person associated with the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Person ID | | Description | ID of the person associated with the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| pipeline_id \| \| --- \| \| \\| Display name \\| Pipeline ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the pipeline the deal is in \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Pipeline ID \| \| Description \| ID of the pipeline the deal is in \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | pipeline_id | | \| Display name \| Pipeline ID \| \| --- \| --- \| \| Description \| ID of the pipeline the deal is in \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Pipeline ID | | Description | ID of the pipeline the deal is in | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| stage_change_date \| \| --- \| \| \\| Display name \\| Stage change date \\| \\| --- \\| --- \\| \\| Description \\| Date when the record's stage was last changed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Stage change date \| \| Description \| Date when the record's stage was last changed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | stage_change_date | | \| Display name \| Stage change date \| \| --- \| --- \| \| Description \| Date when the record's stage was last changed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Stage change date | | Description | Date when the record's stage was last changed | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| stage_change_datetime \| \| --- \| \| \\| Display name \\| Stage change datetime \\| \\| --- \\| --- \\| \\| Description \\| Datetime when the record's stage was last changed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Stage change datetime \| \| Description \| Datetime when the record's stage was last changed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | stage_change_datetime | | \| Display name \| Stage change datetime \| \| --- \| --- \| \| Description \| Datetime when the record's stage was last changed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Display name | Stage change datetime | | Description | Datetime when the record's stage was last changed | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| won_date \| \| --- \| \| \\| Display name \\| Won date \\| \\| --- \\| --- \\| \\| Description \\| Date when the deal was won \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Won date \| \| Description \| Date when the deal was won \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | won_date | | \| Display name \| Won date \| \| --- \| --- \| \| Description \| Date when the deal was won \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Won date | | Description | Date when the deal was won | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| won_datetime \| \| --- \| \| \\| Display name \\| Won datetime \\| \\| --- \\| --- \\| \\| Description \\| Datetime when the deal was won \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Won datetime \| \| Description \| Datetime when the deal was won \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | won_datetime | | \| Display name \| Won datetime \| \| --- \| --- \| \| Description \| Datetime when the deal was won \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Display name | Won datetime | | Description | Datetime when the deal was won | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) |