--- title: "Pipedrive metrics and dimensions" slug: "pipedrive-fields" description: "Explore the complete list of Pipedrive metrics and dimensions available through Supermetrics. Find every data field you need to build your ideal marketing reports." updated: 2026-03-05T14:11:39Z published: 2026-03-05T14:11:39Z --- > ## 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 metrics and dimensions > Supermetrics brings all your Pipedrive data into [Google Sheets](https://workspace.google.com/marketplace/app/supermetrics/523876908005), [Looker Studio](https://supermetrics.com/products/looker-studio), [Excel](https://supermetrics.com/products/excel), [BigQuery](https://supermetrics.com/products/bigquery), [Snowflake](https://supermetrics.com/products/snowflake), [Redshift](https://supermetrics.com/products/amazon-redshift), [Azure](https://supermetrics.com/products/azure-synapse) 5 metrics78 dimensionsCustom fieldsSearch fields ### COMPANY | \| company_id** \| \| --- \| \| \\| Field label \\| Company ID \\| \\| --- \\| --- \\| \\| Description \\| Unique identifier of the company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Company ID \| \| Description \| Unique identifier of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | company_id** | | \| Field label \| Company ID \| \| --- \| --- \| \| Description \| Unique identifier of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Company ID | | Description | Unique identifier of the company | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| company_name** \| \| --- \| \| \\| Field label \\| Company name \\| \\| --- \\| --- \\| \\| Description \\| Name of the company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Company name \| \| Description \| Name of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | company_name** | | \| Field label \| Company name \| \| --- \| --- \| \| Description \| Name of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Company name | | Description | Name of the company | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| company_domain** \| \| --- \| \| \\| Field label \\| Company domain \\| \\| --- \\| --- \\| \\| Description \\| Domain of the company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Company domain \| \| Description \| Domain of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | company_domain** | | \| Field label \| Company domain \| \| --- \| --- \| \| Description \| Domain of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Company domain | | Description | Domain of the company | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| company_country** \| \| --- \| \| \\| Field label \\| Company country \\| \\| --- \\| --- \\| \\| Description \\| Country of the company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Company country \| \| Description \| Country of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | company_country** | | \| Field label \| Company country \| \| --- \| --- \| \| Description \| Country of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Company country | | Description | Country of the company | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### DATASOURCE | \| dataSourceName** \| \| --- \| \| \\| Field label \\| 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) \\| \\| Destinations \\| API, Data warehouse \\| \| \| Field label \| 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) \| \| Destinations \| API, Data warehouse \| | | --- | | dataSourceName** | | \| Field label \| 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) \| \| Destinations \| API, Data warehouse \| | | Field label | 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) | | Destinations | API, Data warehouse | | \| system_metadata.data_source_logins** \| \| --- \| \| \\| Field label \\| Data source logins \\| \\| --- \\| --- \\| \\| Description \\| The data source login accounts that were used to authenticate against the data source \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Data source logins \| \| Description \| The data source login accounts that were used to authenticate against the data source \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | system_metadata.data_source_logins** | | \| Field label \| Data source logins \| \| --- \| --- \| \| Description \| The data source login accounts that were used to authenticate against the data source \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | Field label | Data source logins | | Description | The data source login accounts that were used to authenticate against the data source | | Field type | dimension | | Data type | [string.text.json](/apidocs/field-data-types#text) | | \| system_metadata.data_source_login_owners** \| \| --- \| \| \\| Field label \\| Data source login owners \\| \\| --- \\| --- \\| \\| Description \\| The Supermetrics users that created the data source login connections \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Data source login owners \| \| Description \| The Supermetrics users that created the data source login connections \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | system_metadata.data_source_login_owners** | | \| Field label \| Data source login owners \| \| --- \| --- \| \| Description \| The Supermetrics users that created the data source login connections \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | Field label | Data source login owners | | Description | The Supermetrics users that created the data source login connections | | Field type | dimension | | Data type | [string.text.json](/apidocs/field-data-types#text) | ### DEAL | \| deal_id** \| \| --- \| \| \\| Field label \\| Deal ID \\| \\| --- \\| --- \\| \\| Description \\| Unique identifier for the deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Deal ID \| \| Description \| Unique identifier for the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | deal_id** | | \| Field label \| Deal ID \| \| --- \| --- \| \| Description \| Unique identifier for the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Deal ID | | Description | Unique identifier for the deal | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deal_title** \| \| --- \| \| \\| Field label \\| Deal title \\| \\| --- \\| --- \\| \\| Description \\| Title of the deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Deal title \| \| Description \| Title of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | deal_title** | | \| Field label \| Deal title \| \| --- \| --- \| \| Description \| Title of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Deal title | | Description | Title of the deal | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deal_status** \| \| --- \| \| \\| Field label \\| Deal status \\| \\| --- \\| --- \\| \\| Description \\| Current status of the deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Deal status \| \| Description \| Current status of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | deal_status** | | \| Field label \| Deal status \| \| --- \| --- \| \| Description \| Current status of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Deal status | | Description | Current status of the deal | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deal_currency** \| \| --- \| \| \\| Field label \\| Deal currency \\| \\| --- \\| --- \\| \\| Description \\| Currency of the deal value \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Field label \| Deal currency \| \| Description \| Currency of the deal value \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | deal_currency** | | \| Field label \| Deal currency \| \| --- \| --- \| \| Description \| Currency of the deal value \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | Field label | Deal currency | | Description | Currency of the deal value | | Field type | dimension | | Data type | [string.currency.code](/apidocs/field-data-types#currency) | | \| deal_origin** \| \| --- \| \| \\| Field label \\| Deal origin \\| \\| --- \\| --- \\| \\| Description \\| Origin of the deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Deal origin \| \| Description \| Origin of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | deal_origin** | | \| Field label \| Deal origin \| \| --- \| --- \| \| Description \| Origin of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Deal origin | | Description | Origin of the deal | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deal_origin_id** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** | | \| Field label \| 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) \| | | Field label | 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_channel** \| \| --- \| \| \\| Field label \\| Deal channel \\| \\| --- \\| --- \\| \\| Description \\| Channel ID associated with the deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Deal channel \| \| Description \| Channel ID associated with the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | deal_channel** | | \| Field label \| Deal channel \| \| --- \| --- \| \| Description \| Channel ID associated with the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | 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** \| \| --- \| \| \\| Field label \\| Deal channel ID \\| \\| --- \\| --- \\| \\| Description \\| ID associated with the specific channel \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| 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** | | \| Field label \| Deal channel ID \| \| --- \| --- \| \| Description \| ID associated with the specific channel \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Deal channel ID | | Description | ID associated with the specific channel | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deal_is_deleted** \| \| --- \| \| \\| Field label \\| Deal is deleted \\| \\| --- \\| --- \\| \\| Description \\| Indicates if the deal is deleted \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Deal is deleted \| \| Description \| Indicates if the deal is deleted \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | deal_is_deleted** | | \| Field label \| Deal is deleted \| \| --- \| --- \| \| Description \| Indicates if the deal is deleted \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Field label | Deal is deleted | | Description | Indicates if the deal is deleted | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| deal_visible_to** \| \| --- \| \| \\| Field label \\| Deal visibility \\| \\| --- \\| --- \\| \\| Description \\| Visibility setting of the deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Deal visibility \| \| Description \| Visibility setting of the deal \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | deal_visible_to** | | \| Field label \| Deal visibility \| \| --- \| --- \| \| Description \| Visibility setting of the deal \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Deal visibility | | Description | Visibility setting of the deal | | Field type | dimension | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| deal_lost_reason** \| \| --- \| \| \\| Field label \\| Deal lost reason \\| \\| --- \\| --- \\| \\| Description \\| Reason for losing the deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| 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** | | \| Field label \| Deal lost reason \| \| --- \| --- \| \| Description \| Reason for losing the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Deal lost reason | | Description | Reason for losing the deal | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deals** \| \| --- \| \| \\| Field label \\| Deals \\| \\| --- \\| --- \\| \\| Description \\| Total number of deals \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Deals \| \| Description \| Total number of deals \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | deals** | | \| Field label \| Deals \| \| --- \| --- \| \| Description \| Total number of deals \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Deals | | Description | Total number of deals | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| deal_value** \| \| --- \| \| \\| Field label \\| Deal value \\| \\| --- \\| --- \\| \\| Description \\| Monetary value of the deal \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Deal value \| \| Description \| Monetary value of the deal \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | deal_value** | | \| Field label \| Deal value \| \| --- \| --- \| \| Description \| Monetary value of the deal \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Deal value | | Description | Monetary value of the deal | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| deal_probability** \| \| --- \| \| \\| Field label \\| Deal probability \\| \\| --- \\| --- \\| \\| Description \\| Chance that a deal will be successfully closed \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.percentage](/apidocs/field-data-types#number) \\| \| \| Field label \| 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** | | \| Field label \| Deal probability \| \| --- \| --- \| \| Description \| Chance that a deal will be successfully closed \| \| Field type \| metric \| \| Data type \| [float.number.percentage](/apidocs/field-data-types#number) \| | | Field label | Deal probability | | Description | Chance that a deal will be successfully closed | | Field type | metric | | Data type | [float.number.percentage](/apidocs/field-data-types#number) | ### LEAD | \| lead_id** \| \| --- \| \| \\| Field label \\| Lead ID \\| \\| --- \\| --- \\| \\| Description \\| Unique identifier for the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Lead ID \| \| Description \| Unique identifier for the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | lead_id** | | \| Field label \| Lead ID \| \| --- \| --- \| \| Description \| Unique identifier for the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Lead ID | | Description | Unique identifier for the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_title** \| \| --- \| \| \\| Field label \\| Lead title \\| \\| --- \\| --- \\| \\| Description \\| Title of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Lead title \| \| Description \| Title of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_title** | | \| Field label \| Lead title \| \| --- \| --- \| \| Description \| Title of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Lead title | | Description | Title of the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_currency** \| \| --- \| \| \\| Field label \\| Lead currency \\| \\| --- \\| --- \\| \\| Description \\| Currency of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Field label \| Lead currency \| \| Description \| Currency of the lead \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | lead_currency** | | \| Field label \| Lead currency \| \| --- \| --- \| \| Description \| Currency of the lead \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | Field label | Lead currency | | Description | Currency of the lead | | Field type | dimension | | Data type | [string.currency.code](/apidocs/field-data-types#currency) | | \| lead_source_name** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** | | \| Field label \| 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) \| | | Field label | 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_origin** \| \| --- \| \| \\| Field label \\| Lead origin \\| \\| --- \\| --- \\| \\| Description \\| Origin type of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Lead origin \| \| Description \| Origin type of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_origin** | | \| Field label \| Lead origin \| \| --- \| --- \| \| Description \| Origin type of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Lead origin | | Description | Origin type of the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_origin_id** \| \| --- \| \| \\| Field label \\| Lead origin ID \\| \\| --- \\| --- \\| \\| Description \\| Origin ID of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| 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** | | \| Field label \| Lead origin ID \| \| --- \| --- \| \| Description \| Origin ID of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Lead origin ID | | Description | Origin ID of the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_channel** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** | | \| Field label \| 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) \| | | Field label | 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** \| \| --- \| \| \\| Field label \\| Lead channel ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the specific channel, if applicable \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| 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** | | \| Field label \| Lead channel ID \| \| --- \| --- \| \| Description \| ID of the specific channel, if applicable \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | 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_is_archived** \| \| --- \| \| \\| Field label \\| Lead is archived \\| \\| --- \\| --- \\| \\| Description \\| Flag indicating if the lead is archived \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| 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** | | \| Field label \| Lead is archived \| \| --- \| --- \| \| Description \| Flag indicating if the lead is archived \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Field label | Lead is archived | | Description | Flag indicating if the lead is archived | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| lead_was_seen** \| \| --- \| \| \\| Field label \\| Lead was seen \\| \\| --- \\| --- \\| \\| Description \\| Flag indicating if the lead has been viewed \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| 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** | | \| Field label \| Lead was seen \| \| --- \| --- \| \| Description \| Flag indicating if the lead has been viewed \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Field label | Lead was seen | | Description | Flag indicating if the lead has been viewed | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| lead_label_ids** \| \| --- \| \| \\| Field label \\| Lead label IDs \\| \\| --- \\| --- \\| \\| Description \\| List of label ID's associated with the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Lead label IDs \| \| Description \| List of label ID's associated with the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_label_ids** | | \| Field label \| Lead label IDs \| \| --- \| --- \| \| Description \| List of label ID's associated with the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Lead label IDs | | Description | List of label ID's associated with the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_visible_to** \| \| --- \| \| \\| Field label \\| Lead visible to \\| \\| --- \\| --- \\| \\| Description \\| Number of people the leads is visible to \\| \\| Field type \\| dimension \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Lead visible to \| \| Description \| Number of people the leads is visible to \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | lead_visible_to** | | \| Field label \| Lead visible to \| \| --- \| --- \| \| Description \| Number of people the leads is visible to \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Lead visible to | | Description | Number of people the leads is visible to | | Field type | dimension | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| lead_cc_email** \| \| --- \| \| \\| Field label \\| Lead CC email \\| \\| --- \\| --- \\| \\| Description \\| Email address for lead-related communication \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Field label \| 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** | | \| Field label \| Lead CC email \| \| --- \| --- \| \| Description \| Email address for lead-related communication \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| | | Field label | Lead CC email | | Description | Email address for lead-related communication | | Field type | dimension | | Data type | [string.text.email](/apidocs/field-data-types#text) | | \| leads** \| \| --- \| \| \\| Field label \\| Leads \\| \\| --- \\| --- \\| \\| Description \\| Total number of leads \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Leads \| \| Description \| Total number of leads \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | leads** | | \| Field label \| Leads \| \| --- \| --- \| \| Description \| Total number of leads \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Leads | | Description | Total number of leads | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| lead_value** \| \| --- \| \| \\| Field label \\| Lead value \\| \\| --- \\| --- \\| \\| Description \\| Monetary value of the lead \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Lead value \| \| Description \| Monetary value of the lead \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | lead_value** | | \| Field label \| Lead value \| \| --- \| --- \| \| Description \| Monetary value of the lead \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Lead value | | Description | Monetary value of the lead | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | ### QUERY | \| system_metadata.query_date_range_start** \| \| --- \| \| \\| Field label \\| Start date \\| \\| --- \\| --- \\| \\| Description \\| The start date of the requested query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Start date \| \| Description \| The start date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | --- | | system_metadata.query_date_range_start** | | \| Field label \| Start date \| \| --- \| --- \| \| Description \| The start date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Start date | | Description | The start date of the requested query | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| system_metadata.query_date_range_end** \| \| --- \| \| \\| Field label \\| End date \\| \\| --- \\| --- \\| \\| Description \\| The end date of the requested query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| End date \| \| Description \| The end date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | system_metadata.query_date_range_end** | | \| Field label \| End date \| \| --- \| --- \| \| Description \| The end date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | End date | | Description | The end date of the requested query | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| system_metadata.query_timezone** \| \| --- \| \| \\| Field label \\| Timezone \\| \\| --- \\| --- \\| \\| Description \\| The timezone that is supplied to the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.timezone](/apidocs/field-data-types#time) \\| \| \| Field label \| Timezone \| \| Description \| The timezone that is supplied to the query \| \| Field type \| dimension \| \| Data type \| [string.time.timezone](/apidocs/field-data-types#time) \| | | system_metadata.query_timezone** | | \| Field label \| Timezone \| \| --- \| --- \| \| Description \| The timezone that is supplied to the query \| \| Field type \| dimension \| \| Data type \| [string.time.timezone](/apidocs/field-data-types#time) \| | | Field label | Timezone | | Description | The timezone that is supplied to the query | | Field type | dimension | | Data type | [string.time.timezone](/apidocs/field-data-types#time) | | \| system_metadata.query_filters** \| \| --- \| \| \\| Field label \\| Filters \\| \\| --- \\| --- \\| \\| Description \\| All filters used in the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Filters \| \| Description \| All filters used in the query \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | system_metadata.query_filters** | | \| Field label \| Filters \| \| --- \| --- \| \| Description \| All filters used in the query \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | Field label | Filters | | Description | All filters used in the query | | Field type | dimension | | Data type | [string.text.json](/apidocs/field-data-types#text) | | \| system_metadata.query_date_start** \| \| --- \| \| \\| Field label \\| Start \\| \\| --- \\| --- \\| \\| Description \\| When the query was started \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Start \| \| Description \| When the query was started \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | system_metadata.query_date_start** | | \| Field label \| Start \| \| --- \| --- \| \| Description \| When the query was started \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Start | | Description | When the query was started | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| system_metadata.query_date_end** \| \| --- \| \| \\| Field label \\| End \\| \\| --- \\| --- \\| \\| Description \\| When the query completed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| End \| \| Description \| When the query completed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | system_metadata.query_date_end** | | \| Field label \| End \| \| --- \| --- \| \| Description \| When the query completed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | End | | Description | When the query completed | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| system_metadata.query_duration** \| \| --- \| \| \\| Field label \\| Duration \\| \\| --- \\| --- \\| \\| Description \\| The duration in seconds of the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [int.duration.seconds](/apidocs/field-data-types#duration) \\| \| \| Field label \| Duration \| \| Description \| The duration in seconds of the query \| \| Field type \| dimension \| \| Data type \| [int.duration.seconds](/apidocs/field-data-types#duration) \| | | system_metadata.query_duration** | | \| Field label \| Duration \| \| --- \| --- \| \| Description \| The duration in seconds of the query \| \| Field type \| dimension \| \| Data type \| [int.duration.seconds](/apidocs/field-data-types#duration) \| | | Field label | Duration | | Description | The duration in seconds of the query | | Field type | dimension | | Data type | [int.duration.seconds](/apidocs/field-data-types#duration) | | \| system_metadata.query_accounts** \| \| --- \| \| \\| Field label \\| Accounts \\| \\| --- \\| --- \\| \\| Description \\| A list of accounts of which the data was pulled from \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Accounts \| \| Description \| A list of accounts of which the data was pulled from \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | system_metadata.query_accounts** | | \| Field label \| Accounts \| \| --- \| --- \| \| Description \| A list of accounts of which the data was pulled from \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | Field label | Accounts | | Description | A list of accounts of which the data was pulled from | | Field type | dimension | | Data type | [string.text.json](/apidocs/field-data-types#text) | | \| system_metadata.query_excluded_accounts** \| \| --- \| \| \\| Field label \\| Excluded invalid accounts \\| \\| --- \\| --- \\| \\| Description \\| A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Excluded invalid accounts \| \| Description \| A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | system_metadata.query_excluded_accounts** | | \| Field label \| Excluded invalid accounts \| \| --- \| --- \| \| Description \| A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| | | Field label | Excluded invalid accounts | | Description | A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting | | Field type | dimension | | Data type | [string.text.json](/apidocs/field-data-types#text) | ### RELATED OBJECT | \| owner_id** \| \| --- \| \| \\| Field label \\| Owner ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the person responsible for the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| 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** | | \| Field label \| Owner ID \| \| --- \| --- \| \| Description \| ID of the person responsible for the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Owner ID | | Description | ID of the person responsible for the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| creator_id** \| \| --- \| \| \\| Field label \\| Creator ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the person who created the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| 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** | | \| Field label \| Creator ID \| \| --- \| --- \| \| Description \| ID of the person who created the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Creator ID | | Description | ID of the person who created the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| person_id** \| \| --- \| \| \\| Field label \\| Person ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the person associated with the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| 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** | | \| Field label \| Person ID \| \| --- \| --- \| \| Description \| ID of the person associated with the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Person ID | | Description | ID of the person associated with the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| organization_id** \| \| --- \| \| \\| Field label \\| Organization ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the organization linked to the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| 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** | | \| Field label \| Organization ID \| \| --- \| --- \| \| Description \| ID of the organization linked to the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Organization ID | | Description | ID of the organization linked to the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| stage_id** \| \| --- \| \| \\| Field label \\| Stage ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the stage the deal is in \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Stage ID \| \| Description \| ID of the stage the deal is in \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | stage_id** | | \| Field label \| Stage ID \| \| --- \| --- \| \| Description \| ID of the stage the deal is in \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Stage ID | | Description | ID of the stage the deal is in | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| pipeline_id** \| \| --- \| \| \\| Field label \\| Pipeline ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the pipeline the deal is in \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| 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** | | \| Field label \| Pipeline ID \| \| --- \| --- \| \| Description \| ID of the pipeline the deal is in \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Pipeline ID | | Description | ID of the pipeline the deal is in | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| next_activity_id** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** | | \| Field label \| 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) \| | | Field label | 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) | ### TIME | \| today** \| \| --- \| \| \\| Field label \\| Today \\| \\| --- \\| --- \\| \\| Description \\| Today's date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \\| Destinations \\| API, Data warehouse \\| \| \| Field label \| Today \| \| Description \| Today's date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| \| Destinations \| API, Data warehouse \| | | --- | | today** | | \| Field label \| Today \| \| --- \| --- \| \| Description \| Today's date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| \| Destinations \| API, Data warehouse \| | | Field label | Today | | Description | Today's date, e.g. 2017-01-31 | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | Destinations | API, Data warehouse | | \| year** \| \| --- \| \| \\| Field label \\| Year \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| | | year** | | \| Field label \| Year \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| | | Field label | Year | | Field type | dimension | | Data type | [string.time.year](/apidocs/field-data-types#time) | | \| year_of_week** \| \| --- \| \| \\| Field label \\| Year of week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year of week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| | | year_of_week** | | \| Field label \| Year of week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| | | Field label | Year of week (Sun-Sat) | | Field type | dimension | | Data type | [string.time.year](/apidocs/field-data-types#time) | | \| year_of_week_iso** \| \| --- \| \| \\| Field label \\| Year of week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year of week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| | | year_of_week_iso** | | \| Field label \| Year of week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| | | Field label | Year of week (Mon-Sun) | | Field type | dimension | | Data type | [string.time.year](/apidocs/field-data-types#time) | | \| year_month** \| \| --- \| \| \\| Field label \\| Year & month \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearmonth](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & month \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| | | year_month** | | \| Field label \| Year & month \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| | | Field label | Year & month | | Field type | dimension | | Data type | [string.time.yearmonth](/apidocs/field-data-types#time) | | \| month** \| \| --- \| \| \\| Field label \\| Month \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.month](/apidocs/field-data-types#time) \\| \| \| Field label \| Month \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| | | month** | | \| Field label \| Month \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| | | Field label | Month | | Field type | dimension | | Data type | [string.time.month](/apidocs/field-data-types#time) | | \| year_week** \| \| --- \| \| \\| Field label \\| Year & week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearweek](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.yearweek](/apidocs/field-data-types#time) \| | | year_week** | | \| Field label \| Year & week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.yearweek](/apidocs/field-data-types#time) \| | | Field label | Year & week (Sun-Sat) | | Field type | dimension | | Data type | [string.time.yearweek](/apidocs/field-data-types#time) | | \| year_week_iso** \| \| --- \| \| \\| Field label \\| Year & week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearweekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.yearweekiso](/apidocs/field-data-types#time) \| | | year_week_iso** | | \| Field label \| Year & week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.yearweekiso](/apidocs/field-data-types#time) \| | | Field label | Year & week (Mon-Sun) | | Field type | dimension | | Data type | [string.time.yearweekiso](/apidocs/field-data-types#time) | | \| week** \| \| --- \| \| \\| Field label \\| Week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.week](/apidocs/field-data-types#time) \\| \| \| Field label \| Week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.week](/apidocs/field-data-types#time) \| | | week** | | \| Field label \| Week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.week](/apidocs/field-data-types#time) \| | | Field label | Week (Sun-Sat) | | Field type | dimension | | Data type | [string.time.week](/apidocs/field-data-types#time) | | \| week_iso** \| \| --- \| \| \\| Field label \\| Week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.weekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.weekiso](/apidocs/field-data-types#time) \| | | week_iso** | | \| Field label \| Week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.weekiso](/apidocs/field-data-types#time) \| | | Field label | Week (Mon-Sun) | | Field type | dimension | | Data type | [string.time.weekiso](/apidocs/field-data-types#time) | | \| day_of_month** \| \| --- \| \| \\| Field label \\| Day of month \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofmonth](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of month \| \| Field type \| dimension \| \| Data type \| [string.time.dayofmonth](/apidocs/field-data-types#time) \| | | day_of_month** | | \| Field label \| Day of month \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.dayofmonth](/apidocs/field-data-types#time) \| | | Field label | Day of month | | Field type | dimension | | Data type | [string.time.dayofmonth](/apidocs/field-data-types#time) | | \| day_of_week_name** \| \| --- \| \| \\| Field label \\| Day of week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofweek](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweek](/apidocs/field-data-types#time) \| | | day_of_week_name** | | \| Field label \| Day of week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweek](/apidocs/field-data-types#time) \| | | Field label | Day of week (Sun-Sat) | | Field type | dimension | | Data type | [string.time.dayofweek](/apidocs/field-data-types#time) | | \| day_of_week_name_iso** \| \| --- \| \| \\| Field label \\| Day of week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofweekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweekiso](/apidocs/field-data-types#time) \| | | day_of_week_name_iso** | | \| Field label \| Day of week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweekiso](/apidocs/field-data-types#time) \| | | Field label | Day of week (Mon-Sun) | | Field type | dimension | | Data type | [string.time.dayofweekiso](/apidocs/field-data-types#time) | | \| date** \| \| --- \| \| \\| Field label \\| Date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | date** | | \| Field label \| Date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Date | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| atom** \| \| --- \| \| \\| Field label \\| Datetime \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Datetime \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | atom** | | \| Field label \| Datetime \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Datetime | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | ### TIMESTAMP | \| added_date** \| \| --- \| \| \\| Field label \\| Added date \\| \\| --- \\| --- \\| \\| Description \\| Date of when the record was added \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| 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** | | \| Field label \| Added date \| \| --- \| --- \| \| Description \| Date of when the record was added \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | 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** \| \| --- \| \| \\| Field label \\| Added datetime \\| \\| --- \\| --- \\| \\| Description \\| Datetime of when the record was added \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| 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** | | \| Field label \| Added datetime \| \| --- \| --- \| \| Description \| Datetime of when the record was added \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Added datetime | | Description | Datetime of when the record was added | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| last_update_date** \| \| --- \| \| \\| Field label \\| Update date \\| \\| --- \\| --- \\| \\| Description \\| Date of the last update to the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| 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** | | \| Field label \| Update date \| \| --- \| --- \| \| Description \| Date of the last update to the record \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | 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** \| \| --- \| \| \\| Field label \\| Update datetime \\| \\| --- \\| --- \\| \\| Description \\| Datetime of the last update to the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| 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** | | \| Field label \| Update datetime \| \| --- \| --- \| \| Description \| Datetime of the last update to the record \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Update datetime | | Description | Datetime of the last update to the record | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| stage_change_date** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** | | \| Field label \| 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) \| | | Field label | 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** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** | | \| Field label \| 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) \| | | Field label | 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) | | \| close_date** \| \| --- \| \| \\| Field label \\| Close date \\| \\| --- \\| --- \\| \\| Description \\| Date when the record was closed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Close date \| \| Description \| Date when the record was closed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | close_date** | | \| Field label \| Close date \| \| --- \| --- \| \| Description \| Date when the record was closed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Close date | | Description | Date when the record was closed | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| close_datetime** \| \| --- \| \| \\| Field label \\| Close datetime \\| \\| --- \\| --- \\| \\| Description \\| Datetime when the record was closed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Close datetime \| \| Description \| Datetime when the record was closed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | close_datetime** | | \| Field label \| Close datetime \| \| --- \| --- \| \| Description \| Datetime when the record was closed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Close datetime | | Description | Datetime when the record was closed | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| won_date** \| \| --- \| \| \\| Field label \\| Won date \\| \\| --- \\| --- \\| \\| Description \\| Date when the deal was won \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Won date \| \| Description \| Date when the deal was won \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | won_date** | | \| Field label \| Won date \| \| --- \| --- \| \| Description \| Date when the deal was won \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Won date | | Description | Date when the deal was won | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| won_datetime** \| \| --- \| \| \\| Field label \\| Won datetime \\| \\| --- \\| --- \\| \\| Description \\| Datetime when the deal was won \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Won datetime \| \| Description \| Datetime when the deal was won \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | won_datetime** | | \| Field label \| Won datetime \| \| --- \| --- \| \| Description \| Datetime when the deal was won \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Won datetime | | Description | Datetime when the deal was won | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| lost_date** \| \| --- \| \| \\| Field label \\| Lost date \\| \\| --- \\| --- \\| \\| Description \\| Date when the deal was lost \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Lost date \| \| Description \| Date when the deal was lost \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | lost_date** | | \| Field label \| Lost date \| \| --- \| --- \| \| Description \| Date when the deal was lost \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Lost date | | Description | Date when the deal was lost | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| lost_datetime** \| \| --- \| \| \\| Field label \\| Lost datetime \\| \\| --- \\| --- \\| \\| Description \\| Datetime when the deal was lost \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Lost datetime \| \| Description \| Datetime when the deal was lost \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | lost_datetime** | | \| Field label \| Lost datetime \| \| --- \| --- \| \| Description \| Datetime when the deal was lost \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Lost datetime | | Description | Datetime when the deal was lost | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| local_won_date** \| \| --- \| \| \\| Field label \\| Local won date \\| \\| --- \\| --- \\| \\| Description \\| Local date when the deal was won \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| 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** | | \| Field label \| Local won date \| \| --- \| --- \| \| Description \| Local date when the deal was won \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | 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_lost_date** \| \| --- \| \| \\| Field label \\| Local lost date \\| \\| --- \\| --- \\| \\| Description \\| Local date when the deal was lost \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| 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** | | \| Field label \| Local lost date \| \| --- \| --- \| \| Description \| Local date when the deal was lost \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | 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_close_date** \| \| --- \| \| \\| Field label \\| Local close date \\| \\| --- \\| --- \\| \\| Description \\| Local date when the record was closed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| 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** | | \| Field label \| Local close date \| \| --- \| --- \| \| Description \| Local date when the record was closed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Local close date | | Description | Local date when the record was closed | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| expected_close_date** \| \| --- \| \| \\| Field label \\| 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) \\| \| \| Field label \| 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** | | \| Field label \| 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) \| | | Field label | 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) |