---
title: "Pipedrive metrics and dimensions"
slug: "pipedrive-fields"
description: "Explore the Pipedrive metrics and dimensions available through Supermetrics. Find every data field you need to build your marketing reports."
updated: 2026-03-05T14:11:39Z
published: 2026-03-05T14:11:39Z
canonical: "docs.supermetrics.com/pipedrive-fields"
---

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