--- title: "Zoho CRM data warehouse table groups" slug: "zoho-crm-data-warehouse-table-groups" description: "Explore the complete Supermetrics data warehouse table groups for Zoho CRM. See all the tables and the fields included in them." updated: 2026-03-05T14:15:39Z published: 2026-03-05T14:15:39Z canonical: "docs.supermetrics.com/zoho-crm-data-warehouse-table-groups" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt > Use this file to discover all available pages before exploring further. # Zoho CRM data warehouse table groups Search fields ### Table: LEAD | \| change_log_date \| \| --- \| \| \\| Display name \\| Change log date \\| \\| --- \\| --- \\| \\| Description \\| The date of the last modification made to the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Change log date \| \| Description \| The date of the last modification made to the record \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | --- | | change_log_date | | \| Display name \| Change log date \| \| --- \| --- \| \| Description \| The date of the last modification made to the record \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Change log date | | Description | The date of the last modification made to the record | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| change_log_time \| \| --- \| \| \\| Display name \\| Change log datetime \\| \\| --- \\| --- \\| \\| Description \\| The timestamp of the last modification made to the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Change log datetime \| \| Description \| The timestamp of the last modification made to the record \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | change_log_time | | \| Display name \| Change log datetime \| \| --- \| --- \| \| Description \| The timestamp of the last modification made to the record \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Display name | Change log datetime | | Description | The timestamp of the last modification made to the record | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| converted_account_id \| \| --- \| \| \\| Display name \\| Converted account ID \\| \\| --- \\| --- \\| \\| Description \\| The account ID created when the lead is converted \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Converted account ID \| \| Description \| The account ID created when the lead is converted \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | converted_account_id | | \| Display name \| Converted account ID \| \| --- \| --- \| \| Description \| The account ID created when the lead is converted \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Converted account ID | | Description | The account ID created when the lead is converted | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| converted_contact_id \| \| --- \| \| \\| Display name \\| Converted contact ID \\| \\| --- \\| --- \\| \\| Description \\| The contact ID created when the lead is converted \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Converted contact ID \| \| Description \| The contact ID created when the lead is converted \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | converted_contact_id | | \| Display name \| Converted contact ID \| \| --- \| --- \| \| Description \| The contact ID created when the lead is converted \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Converted contact ID | | Description | The contact ID created when the lead is converted | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| converted_date \| \| --- \| \| \\| Display name \\| Converted date \\| \\| --- \\| --- \\| \\| Description \\| The date when the lead was converted \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Converted date \| \| Description \| The date when the lead was converted \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | converted_date | | \| Display name \| Converted date \| \| --- \| --- \| \| Description \| The date when the lead was converted \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Converted date | | Description | The date when the lead was converted | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| converted_deal_id \| \| --- \| \| \\| Display name \\| Converted deal ID \\| \\| --- \\| --- \\| \\| Description \\| The deal ID created when the lead is converted \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Converted deal ID \| \| Description \| The deal ID created when the lead is converted \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | converted_deal_id | | \| Display name \| Converted deal ID \| \| --- \| --- \| \| Description \| The deal ID created when the lead is converted \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Converted deal ID | | Description | The deal ID created when the lead is converted | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| converted_time \| \| --- \| \| \\| Display name \\| Converted datetime \\| \\| --- \\| --- \\| \\| Description \\| The timestamp when the lead was converted \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Converted datetime \| \| Description \| The timestamp when the lead was converted \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | converted_time | | \| Display name \| Converted datetime \| \| --- \| --- \| \| Description \| The timestamp when the lead was converted \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Display name | Converted datetime | | Description | The timestamp when the lead was converted | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| created_by_id \| \| --- \| \| \\| Display name \\| Created by ID \\| \\| --- \\| --- \\| \\| Description \\| The user ID who created the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Created by ID \| \| Description \| The user ID who created the record \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | created_by_id | | \| Display name \| Created by ID \| \| --- \| --- \| \| Description \| The user ID who created the record \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Created by ID | | Description | The user ID who created the record | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| created_date \| \| --- \| \| \\| Display name \\| Created date \\| \\| --- \\| --- \\| \\| Description \\| The date when the record was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Created date \| \| Description \| The date when the record was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | created_date | | \| Display name \| Created date \| \| --- \| --- \| \| Description \| The date when the record was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Created date | | Description | The date when the record was created | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| created_time \| \| --- \| \| \\| Display name \\| Created datetime \\| \\| --- \\| --- \\| \\| Description \\| The timestamp when the record was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Created datetime \| \| Description \| The timestamp when the record was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | created_time | | \| Display name \| Created datetime \| \| --- \| --- \| \| Description \| The timestamp when the record was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Display name | Created datetime | | Description | The timestamp when the record was created | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| dataSourceName \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | dataSourceName | | \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Data source | | Description | The name of the source for this data, as listed on supermetrics.com/docs | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| date \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | date | | \| Display name \| Date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Date | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| last_activity_date \| \| --- \| \| \\| Display name \\| Last activity date \\| \\| --- \\| --- \\| \\| Description \\| The date of the last activity performed on the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Last activity date \| \| Description \| The date of the last activity performed on the record \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | last_activity_date | | \| Display name \| Last activity date \| \| --- \| --- \| \| Description \| The date of the last activity performed on the record \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Last activity date | | Description | The date of the last activity performed on the record | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| last_activity_time \| \| --- \| \| \\| Display name \\| Last activity datetime \\| \\| --- \\| --- \\| \\| Description \\| The timestamp of the last activity performed on the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Last activity datetime \| \| Description \| The timestamp of the last activity performed on the record \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | last_activity_time | | \| Display name \| Last activity datetime \| \| --- \| --- \| \| Description \| The timestamp of the last activity performed on the record \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Display name | Last activity datetime | | Description | The timestamp of the last activity performed on the record | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| last_enriched_date \| \| --- \| \| \\| Display name \\| Last enriched date \\| \\| --- \\| --- \\| \\| Description \\| The date of the last time the record's information was enriched \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Last enriched date \| \| Description \| The date of the last time the record's information was enriched \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | last_enriched_date | | \| Display name \| Last enriched date \| \| --- \| --- \| \| Description \| The date of the last time the record's information was enriched \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Last enriched date | | Description | The date of the last time the record's information was enriched | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| last_enriched_time \| \| --- \| \| \\| Display name \\| Last enriched datetime \\| \\| --- \\| --- \\| \\| Description \\| The timestamp of the last time the record's information was enriched \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Last enriched datetime \| \| Description \| The timestamp of the last time the record's information was enriched \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | last_enriched_time | | \| Display name \| Last enriched datetime \| \| --- \| --- \| \| Description \| The timestamp of the last time the record's information was enriched \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Display name | Last enriched datetime | | Description | The timestamp of the last time the record's information was enriched | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| lead_annual_revenue \| \| --- \| \| \\| Display name \\| Lead annual revenue \\| \\| --- \\| --- \\| \\| Description \\| The estimated annual revenue of the lead or company \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Lead annual revenue \| \| Description \| The estimated annual revenue of the lead or company \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | lead_annual_revenue | | \| Display name \| Lead annual revenue \| \| --- \| --- \| \| Description \| The estimated annual revenue of the lead or company \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Lead annual revenue | | Description | The estimated annual revenue of the lead or company | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| lead_city \| \| --- \| \| \\| Display name \\| Lead city \\| \\| --- \\| --- \\| \\| Description \\| The city where the lead or company is located \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Lead city \| \| Description \| The city where the lead or company is located \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| | | lead_city | | \| Display name \| Lead city \| \| --- \| --- \| \| Description \| The city where the lead or company is located \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| | | Display name | Lead city | | Description | The city where the lead or company is located | | Field type | dimension | | Data type | [string.geo.city](/apidocs/field-data-types#geographical) | | \| lead_company \| \| --- \| \| \\| Display name \\| Lead company \\| \\| --- \\| --- \\| \\| Description \\| The name of the company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead company \| \| Description \| The name of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_company | | \| Display name \| Lead company \| \| --- \| --- \| \| Description \| The name of the company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead company | | Description | The name of the company | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_converted \| \| --- \| \| \\| Display name \\| Lead is converted \\| \\| --- \\| --- \\| \\| Description \\| Indicates whether the lead has been converted into an account, contact, and deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Lead is converted \| \| Description \| Indicates whether the lead has been converted into an account, contact, and deal \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | lead_converted | | \| Display name \| Lead is converted \| \| --- \| --- \| \| Description \| Indicates whether the lead has been converted into an account, contact, and deal \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Display name | Lead is converted | | Description | Indicates whether the lead has been converted into an account, contact, and deal | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| lead_country \| \| --- \| \| \\| Display name \\| Lead country \\| \\| --- \\| --- \\| \\| Description \\| The country where the lead or company is located \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Lead country \| \| Description \| The country where the lead or company is located \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| | | lead_country | | \| Display name \| Lead country \| \| --- \| --- \| \| Description \| The country where the lead or company is located \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| | | Display name | Lead country | | Description | The country where the lead or company is located | | Field type | dimension | | Data type | [string.geo.country](/apidocs/field-data-types#geographical) | | \| lead_description \| \| --- \| \| \\| Display name \\| Lead description \\| \\| --- \\| --- \\| \\| Description \\| A detailed description of the lead or company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead description \| \| Description \| A detailed description of the lead or company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_description | | \| Display name \| Lead description \| \| --- \| --- \| \| Description \| A detailed description of the lead or company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead description | | Description | A detailed description of the lead or company | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_designation \| \| --- \| \| \\| Display name \\| Lead title \\| \\| --- \\| --- \\| \\| Description \\| The title or job position of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead title \| \| Description \| The title or job position of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_designation | | \| Display name \| Lead title \| \| --- \| --- \| \| Description \| The title or job position of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead title | | Description | The title or job position of the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_email \| \| --- \| \| \\| Display name \\| Lead email \\| \\| --- \\| --- \\| \\| Description \\| The primary email address of the lead or company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead email \| \| Description \| The primary email address of the lead or company \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| | | lead_email | | \| Display name \| Lead email \| \| --- \| --- \| \| Description \| The primary email address of the lead or company \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| | | Display name | Lead email | | Description | The primary email address of the lead or company | | Field type | dimension | | Data type | [string.text.email](/apidocs/field-data-types#text) | | \| lead_email_opt_out \| \| --- \| \| \\| Display name \\| Lead email opt out \\| \\| --- \\| --- \\| \\| Description \\| Indicates whether the lead has opted out of email communications \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Lead email opt out \| \| Description \| Indicates whether the lead has opted out of email communications \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | lead_email_opt_out | | \| Display name \| Lead email opt out \| \| --- \| --- \| \| Description \| Indicates whether the lead has opted out of email communications \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Display name | Lead email opt out | | Description | Indicates whether the lead has opted out of email communications | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| lead_enrich_status \| \| --- \| \| \\| Display name \\| Lead enrich status \\| \\| --- \\| --- \\| \\| Description \\| The status of the enrichment process for the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead enrich status \| \| Description \| The status of the enrichment process for the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_enrich_status | | \| Display name \| Lead enrich status \| \| --- \| --- \| \| Description \| The status of the enrichment process for the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead enrich status | | Description | The status of the enrichment process for the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_fax \| \| --- \| \| \\| Display name \\| Lead fax \\| \\| --- \\| --- \\| \\| Description \\| The fax number of the lead or company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead fax \| \| Description \| The fax number of the lead or company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_fax | | \| Display name \| Lead fax \| \| --- \| --- \| \| Description \| The fax number of the lead or company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead fax | | Description | The fax number of the lead or company | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_first_name \| \| --- \| \| \\| Display name \\| Lead first name \\| \\| --- \\| --- \\| \\| Description \\| The first name of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead first name \| \| Description \| The first name of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_first_name | | \| Display name \| Lead first name \| \| --- \| --- \| \| Description \| The first name of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead first name | | Description | The first name of the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_full_name \| \| --- \| \| \\| Display name \\| Lead name \\| \\| --- \\| --- \\| \\| Description \\| The full name of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead name \| \| Description \| The full name of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_full_name | | \| Display name \| Lead name \| \| --- \| --- \| \| Description \| The full name of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead name | | Description | The full name of the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_id \| \| --- \| \| \\| Display name \\| Lead ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead ID \| \| Description \| The unique identifier of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_id | | \| Display name \| Lead ID \| \| --- \| --- \| \| Description \| The unique identifier of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead ID | | Description | The unique identifier of the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_industry \| \| --- \| \| \\| Display name \\| Lead industry \\| \\| --- \\| --- \\| \\| Description \\| The industry of the lead or company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead industry \| \| Description \| The industry of the lead or company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_industry | | \| Display name \| Lead industry \| \| --- \| --- \| \| Description \| The industry of the lead or company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead industry | | Description | The industry of the lead or company | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_last_name \| \| --- \| \| \\| Display name \\| Lead last name \\| \\| --- \\| --- \\| \\| Description \\| The last name of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead last name \| \| Description \| The last name of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_last_name | | \| Display name \| Lead last name \| \| --- \| --- \| \| Description \| The last name of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead last name | | Description | The last name of the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_locked \| \| --- \| \| \\| Display name \\| Lead locked \\| \\| --- \\| --- \\| \\| Description \\| Indicates whether the lead is locked from editing \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Lead locked \| \| Description \| Indicates whether the lead is locked from editing \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | lead_locked | | \| Display name \| Lead locked \| \| --- \| --- \| \| Description \| Indicates whether the lead is locked from editing \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Display name | Lead locked | | Description | Indicates whether the lead is locked from editing | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| lead_mobile \| \| --- \| \| \\| Display name \\| Lead mobile \\| \\| --- \\| --- \\| \\| Description \\| The mobile phone number of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead mobile \| \| Description \| The mobile phone number of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| | | lead_mobile | | \| Display name \| Lead mobile \| \| --- \| --- \| \| Description \| The mobile phone number of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| | | Display name | Lead mobile | | Description | The mobile phone number of the lead | | Field type | dimension | | Data type | [string.text.phone](/apidocs/field-data-types#text) | | \| lead_no_of_employees \| \| --- \| \| \\| Display name \\| Lead employees \\| \\| --- \\| --- \\| \\| Description \\| The number of employees in the company \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Lead employees \| \| Description \| The number of employees in the company \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | lead_no_of_employees | | \| Display name \| Lead employees \| \| --- \| --- \| \| Description \| The number of employees in the company \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Lead employees | | Description | The number of employees in the company | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| lead_phone \| \| --- \| \| \\| Display name \\| Lead phone \\| \\| --- \\| --- \\| \\| Description \\| The phone number of the lead or company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead phone \| \| Description \| The phone number of the lead or company \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| | | lead_phone | | \| Display name \| Lead phone \| \| --- \| --- \| \| Description \| The phone number of the lead or company \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| | | Display name | Lead phone | | Description | The phone number of the lead or company | | Field type | dimension | | Data type | [string.text.phone](/apidocs/field-data-types#text) | | \| lead_rating \| \| --- \| \| \\| Display name \\| Lead rating \\| \\| --- \\| --- \\| \\| Description \\| A rating assigned to the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead rating \| \| Description \| A rating assigned to the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_rating | | \| Display name \| Lead rating \| \| --- \| --- \| \| Description \| A rating assigned to the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead rating | | Description | A rating assigned to the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_record_status \| \| --- \| \| \\| Display name \\| Lead record status \\| \\| --- \\| --- \\| \\| Description \\| The status of the record (e.g., active, inactive, deleted) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead record status \| \| Description \| The status of the record (e.g., active, inactive, deleted) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_record_status | | \| Display name \| Lead record status \| \| --- \| --- \| \| Description \| The status of the record (e.g., active, inactive, deleted) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead record status | | Description | The status of the record (e.g., active, inactive, deleted) | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_salutation \| \| --- \| \| \\| Display name \\| Lead salutation \\| \\| --- \\| --- \\| \\| Description \\| The salutation to use when addressing the lead (e.g., Mr., Ms., Dr.) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead salutation \| \| Description \| The salutation to use when addressing the lead (e.g., Mr., Ms., Dr.) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_salutation | | \| Display name \| Lead salutation \| \| --- \| --- \| \| Description \| The salutation to use when addressing the lead (e.g., Mr., Ms., Dr.) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead salutation | | Description | The salutation to use when addressing the lead (e.g., Mr., Ms., Dr.) | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_secondary_email \| \| --- \| \| \\| Display name \\| Lead secondary email \\| \\| --- \\| --- \\| \\| Description \\| A secondary email address of the lead or company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead secondary email \| \| Description \| A secondary email address of the lead or company \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| | | lead_secondary_email | | \| Display name \| Lead secondary email \| \| --- \| --- \| \| Description \| A secondary email address of the lead or company \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| | | Display name | Lead secondary email | | Description | A secondary email address of the lead or company | | Field type | dimension | | Data type | [string.text.email](/apidocs/field-data-types#text) | | \| lead_skype_id \| \| --- \| \| \\| Display name \\| Lead Skype ID \\| \\| --- \\| --- \\| \\| Description \\| The Skype ID of the lead or company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead Skype ID \| \| Description \| The Skype ID of the lead or company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_skype_id | | \| Display name \| Lead Skype ID \| \| --- \| --- \| \| Description \| The Skype ID of the lead or company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead Skype ID | | Description | The Skype ID of the lead or company | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_source \| \| --- \| \| \\| Display name \\| Lead source \\| \\| --- \\| --- \\| \\| Description \\| The source from which the lead originated (e.g., website, email, phone) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead source \| \| Description \| The source from which the lead originated (e.g., website, email, phone) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_source | | \| Display name \| Lead source \| \| --- \| --- \| \| Description \| The source from which the lead originated (e.g., website, email, phone) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead source | | Description | The source from which the lead originated (e.g., website, email, phone) | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_state \| \| --- \| \| \\| Display name \\| Lead state \\| \\| --- \\| --- \\| \\| Description \\| The state or province where the lead or company is located \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.region](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Lead state \| \| Description \| The state or province where the lead or company is located \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| | | lead_state | | \| Display name \| Lead state \| \| --- \| --- \| \| Description \| The state or province where the lead or company is located \| \| Field type \| dimension \| \| Data type \| [string.geo.region](/apidocs/field-data-types#geographical) \| | | Display name | Lead state | | Description | The state or province where the lead or company is located | | Field type | dimension | | Data type | [string.geo.region](/apidocs/field-data-types#geographical) | | \| lead_status \| \| --- \| \| \\| Display name \\| Lead status \\| \\| --- \\| --- \\| \\| Description \\| The current status of the lead (e.g., new, contacted, qualified) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead status \| \| Description \| The current status of the lead (e.g., new, contacted, qualified) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_status | | \| Display name \| Lead status \| \| --- \| --- \| \| Description \| The current status of the lead (e.g., new, contacted, qualified) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead status | | Description | The current status of the lead (e.g., new, contacted, qualified) | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_street \| \| --- \| \| \\| Display name \\| Lead street \\| \\| --- \\| --- \\| \\| Description \\| The street address of the lead or company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.street](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Lead street \| \| Description \| The street address of the lead or company \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| | | lead_street | | \| Display name \| Lead street \| \| --- \| --- \| \| Description \| The street address of the lead or company \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| | | Display name | Lead street | | Description | The street address of the lead or company | | Field type | dimension | | Data type | [string.geo.street](/apidocs/field-data-types#geographical) | | \| lead_tag \| \| --- \| \| \\| Display name \\| Lead tag \\| \\| --- \\| --- \\| \\| Description \\| A tag or label associated with the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead tag \| \| Description \| A tag or label associated with the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_tag | | \| Display name \| Lead tag \| \| --- \| --- \| \| Description \| A tag or label associated with the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead tag | | Description | A tag or label associated with the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_twitter \| \| --- \| \| \\| Display name \\| Lead Twitter \\| \\| --- \\| --- \\| \\| Description \\| The Twitter handle of the lead or company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead Twitter \| \| Description \| The Twitter handle of the lead or company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_twitter | | \| Display name \| Lead Twitter \| \| --- \| --- \| \| Description \| The Twitter handle of the lead or company \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead Twitter | | Description | The Twitter handle of the lead or company | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_unsubscribed_mode \| \| --- \| \| \\| Display name \\| Lead unsubscribed mode \\| \\| --- \\| --- \\| \\| Description \\| The mode in which the lead is unsubscribed from email communications \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead unsubscribed mode \| \| Description \| The mode in which the lead is unsubscribed from email communications \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_unsubscribed_mode | | \| Display name \| Lead unsubscribed mode \| \| --- \| --- \| \| Description \| The mode in which the lead is unsubscribed from email communications \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead unsubscribed mode | | Description | The mode in which the lead is unsubscribed from email communications | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_website \| \| --- \| \| \\| Display name \\| Lead website \\| \\| --- \\| --- \\| \\| Description \\| The website of the lead or company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead website \| \| Description \| The website of the lead or company \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| | | lead_website | | \| Display name \| Lead website \| \| --- \| --- \| \| Description \| The website of the lead or company \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| | | Display name | Lead website | | Description | The website of the lead or company | | Field type | dimension | | Data type | [string.text.url](/apidocs/field-data-types#text) | | \| lead_zip_code \| \| --- \| \| \\| Display name \\| Lead zip code \\| \\| --- \\| --- \\| \\| Description \\| The ZIP or postal code of the lead or company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.zip](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Lead zip code \| \| Description \| The ZIP or postal code of the lead or company \| \| Field type \| dimension \| \| Data type \| [string.geo.zip](/apidocs/field-data-types#geographical) \| | | lead_zip_code | | \| Display name \| Lead zip code \| \| --- \| --- \| \| Description \| The ZIP or postal code of the lead or company \| \| Field type \| dimension \| \| Data type \| [string.geo.zip](/apidocs/field-data-types#geographical) \| | | Display name | Lead zip code | | Description | The ZIP or postal code of the lead or company | | Field type | dimension | | Data type | [string.geo.zip](/apidocs/field-data-types#geographical) | | \| modified_by_id \| \| --- \| \| \\| Display name \\| Modified by ID \\| \\| --- \\| --- \\| \\| Description \\| The user ID who last modified the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Modified by ID \| \| Description \| The user ID who last modified the record \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | modified_by_id | | \| Display name \| Modified by ID \| \| --- \| --- \| \| Description \| The user ID who last modified the record \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Modified by ID | | Description | The user ID who last modified the record | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| modified_date \| \| --- \| \| \\| Display name \\| Modified date \\| \\| --- \\| --- \\| \\| Description \\| The date of the last modification made to the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Modified date \| \| Description \| The date of the last modification made to the record \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | modified_date | | \| Display name \| Modified date \| \| --- \| --- \| \| Description \| The date of the last modification made to the record \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Modified date | | Description | The date of the last modification made to the record | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| modified_time \| \| --- \| \| \\| Display name \\| Modified datetime \\| \\| --- \\| --- \\| \\| Description \\| The timestamp of the last modification made to the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Modified datetime \| \| Description \| The timestamp of the last modification made to the record \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | modified_time | | \| Display name \| Modified datetime \| \| --- \| --- \| \| Description \| The timestamp of the last modification made to the record \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Display name | Modified datetime | | Description | The timestamp of the last modification made to the record | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| owner_id \| \| --- \| \| \\| Display name \\| Owner ID \\| \\| --- \\| --- \\| \\| Description \\| The user ID assigned as the owner of the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Owner ID \| \| Description \| The user ID assigned as the owner of the record \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | owner_id | | \| Display name \| Owner ID \| \| --- \| --- \| \| Description \| The user ID assigned as the owner of the record \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Owner ID | | Description | The user ID assigned as the owner of the record | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| unsubscribed_date \| \| --- \| \| \\| Display name \\| Unsubscribed date \\| \\| --- \\| --- \\| \\| Description \\| The date when the record unsubscribed from email communications \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Unsubscribed date \| \| Description \| The date when the record unsubscribed from email communications \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | unsubscribed_date | | \| Display name \| Unsubscribed date \| \| --- \| --- \| \| Description \| The date when the record unsubscribed from email communications \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Unsubscribed date | | Description | The date when the record unsubscribed from email communications | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| unsubscribed_time \| \| --- \| \| \\| Display name \\| Unsubscribed datetime \\| \\| --- \\| --- \\| \\| Description \\| The timestamp when the record unsubscribed from email communications \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Unsubscribed datetime \| \| Description \| The timestamp when the record unsubscribed from email communications \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | unsubscribed_time | | \| Display name \| Unsubscribed datetime \| \| --- \| --- \| \| Description \| The timestamp when the record unsubscribed from email communications \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Display name | Unsubscribed datetime | | Description | The timestamp when the record unsubscribed from email communications | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | ### Table: DEAL | \| account_id \| \| --- \| \| \\| Display name \\| Account ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier of the account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account ID \| \| Description \| The unique identifier of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | account_id | | \| Display name \| Account ID \| \| --- \| --- \| \| Description \| The unique identifier of the account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Account ID | | Description | The unique identifier of the account | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| amount \| \| --- \| \| \\| Display name \\| Deal amount \\| \\| --- \\| --- \\| \\| Description \\| The monetary value of the deal \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Deal amount \| \| Description \| The monetary value of the deal \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | amount | | \| Display name \| Deal amount \| \| --- \| --- \| \| Description \| The monetary value of the deal \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Deal amount | | Description | The monetary value of the deal | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| campaign_source_id \| \| --- \| \| \\| Display name \\| Campaign source ID \\| \\| --- \\| --- \\| \\| Description \\| The campaign ID that led to this deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign source ID \| \| Description \| The campaign ID that led to this deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | campaign_source_id | | \| Display name \| Campaign source ID \| \| --- \| --- \| \| Description \| The campaign ID that led to this deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Campaign source ID | | Description | The campaign ID that led to this deal | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| change_log_date \| \| --- \| \| \\| Display name \\| Change log date \\| \\| --- \\| --- \\| \\| Description \\| The date of the last modification made to the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Change log date \| \| Description \| The date of the last modification made to the record \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | change_log_date | | \| Display name \| Change log date \| \| --- \| --- \| \| Description \| The date of the last modification made to the record \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Change log date | | Description | The date of the last modification made to the record | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| change_log_time \| \| --- \| \| \\| Display name \\| Change log datetime \\| \\| --- \\| --- \\| \\| Description \\| The timestamp of the last modification made to the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Change log datetime \| \| Description \| The timestamp of the last modification made to the record \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | change_log_time | | \| Display name \| Change log datetime \| \| --- \| --- \| \| Description \| The timestamp of the last modification made to the record \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Display name | Change log datetime | | Description | The timestamp of the last modification made to the record | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| closing_date \| \| --- \| \| \\| Display name \\| Closing date \\| \\| --- \\| --- \\| \\| Description \\| The expected date when the deal will be closed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Closing date \| \| Description \| The expected date when the deal will be closed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | closing_date | | \| Display name \| Closing date \| \| --- \| --- \| \| Description \| The expected date when the deal will be closed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Closing date | | Description | The expected date when the deal will be closed | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| closing_time \| \| --- \| \| \\| Display name \\| Closing datetime \\| \\| --- \\| --- \\| \\| Description \\| The expected time when the deal will be closed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Closing datetime \| \| Description \| The expected time when the deal will be closed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | closing_time | | \| Display name \| Closing datetime \| \| --- \| --- \| \| Description \| The expected time when the deal will be closed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Display name | Closing datetime | | Description | The expected time when the deal will be closed | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| contact_id \| \| --- \| \| \\| Display name \\| Contact ID \\| \\| --- \\| --- \\| \\| Description \\| A unique identifier for the contact \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Contact ID \| \| Description \| A unique identifier for the contact \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | contact_id | | \| Display name \| Contact ID \| \| --- \| --- \| \| Description \| A unique identifier for the contact \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Contact ID | | Description | A unique identifier for the contact | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| created_by_id \| \| --- \| \| \\| Display name \\| Created by ID \\| \\| --- \\| --- \\| \\| Description \\| The user ID who created the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Created by ID \| \| Description \| The user ID who created the record \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | created_by_id | | \| Display name \| Created by ID \| \| --- \| --- \| \| Description \| The user ID who created the record \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Created by ID | | Description | The user ID who created the record | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| created_date \| \| --- \| \| \\| Display name \\| Created date \\| \\| --- \\| --- \\| \\| Description \\| The date when the record was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Created date \| \| Description \| The date when the record was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | created_date | | \| Display name \| Created date \| \| --- \| --- \| \| Description \| The date when the record was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Created date | | Description | The date when the record was created | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| created_time \| \| --- \| \| \\| Display name \\| Created datetime \\| \\| --- \\| --- \\| \\| Description \\| The timestamp when the record was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Created datetime \| \| Description \| The timestamp when the record was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | created_time | | \| Display name \| Created datetime \| \| --- \| --- \| \| Description \| The timestamp when the record was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Display name | Created datetime | | Description | The timestamp when the record was created | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| dataSourceName \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | dataSourceName | | \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Data source | | Description | The name of the source for this data, as listed on supermetrics.com/docs | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| date \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | date | | \| Display name \| Date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Date | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| deal_description \| \| --- \| \| \\| Display name \\| Deal description \\| \\| --- \\| --- \\| \\| Description \\| A detailed description of the deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Deal description \| \| Description \| A detailed description of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | deal_description | | \| Display name \| Deal description \| \| --- \| --- \| \| Description \| A detailed description of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Deal description | | Description | A detailed description of the deal | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deal_id \| \| --- \| \| \\| Display name \\| Deal ID \\| \\| --- \\| --- \\| \\| Description \\| Unique identifier for the deal record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Deal ID \| \| Description \| Unique identifier for the deal record \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | deal_id | | \| Display name \| Deal ID \| \| --- \| --- \| \| Description \| Unique identifier for the deal record \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Deal ID | | Description | Unique identifier for the deal record | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deal_lead_source \| \| --- \| \| \\| Display name \\| Deal lead source \\| \\| --- \\| --- \\| \\| Description \\| The source from which the lead originated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Deal lead source \| \| Description \| The source from which the lead originated \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | deal_lead_source | | \| Display name \| Deal lead source \| \| --- \| --- \| \| Description \| The source from which the lead originated \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Deal lead source | | Description | The source from which the lead originated | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deal_locked \| \| --- \| \| \\| Display name \\| Deal locked \\| \\| --- \\| --- \\| \\| Description \\| Indicates whether the deal record is locked \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Deal locked \| \| Description \| Indicates whether the deal record is locked \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | deal_locked | | \| Display name \| Deal locked \| \| --- \| --- \| \| Description \| Indicates whether the deal record is locked \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Display name | Deal locked | | Description | Indicates whether the deal record is locked | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| deal_name \| \| --- \| \| \\| Display name \\| Deal name \\| \\| --- \\| --- \\| \\| Description \\| The name of the deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Deal name \| \| Description \| The name of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | deal_name | | \| Display name \| Deal name \| \| --- \| --- \| \| Description \| The name of the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Deal name | | Description | The name of the deal | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deal_next_step \| \| --- \| \| \\| Display name \\| Deal next step \\| \\| --- \\| --- \\| \\| Description \\| The next action planned for the deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Deal next step \| \| Description \| The next action planned for the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | deal_next_step | | \| Display name \| Deal next step \| \| --- \| --- \| \| Description \| The next action planned for the deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Deal next step | | Description | The next action planned for the deal | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deal_reason_for_loss \| \| --- \| \| \\| Display name \\| Deal reason for loss \\| \\| --- \\| --- \\| \\| Description \\| The reason why the deal was lost if it's not closed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Deal reason for loss \| \| Description \| The reason why the deal was lost if it's not closed \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | deal_reason_for_loss | | \| Display name \| Deal reason for loss \| \| --- \| --- \| \| Description \| The reason why the deal was lost if it's not closed \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Deal reason for loss | | Description | The reason why the deal was lost if it's not closed | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deal_record_status \| \| --- \| \| \\| Display name \\| Deal record status \\| \\| --- \\| --- \\| \\| Description \\| The current status of the deal record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Deal record status \| \| Description \| The current status of the deal record \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | deal_record_status | | \| Display name \| Deal record status \| \| --- \| --- \| \| Description \| The current status of the deal record \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Deal record status | | Description | The current status of the deal record | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deal_stage \| \| --- \| \| \\| Display name \\| Deal stage \\| \\| --- \\| --- \\| \\| Description \\| The current stage of the deal in the sales pipeline \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Deal stage \| \| Description \| The current stage of the deal in the sales pipeline \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | deal_stage | | \| Display name \| Deal stage \| \| --- \| --- \| \| Description \| The current stage of the deal in the sales pipeline \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Deal stage | | Description | The current stage of the deal in the sales pipeline | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deal_tag \| \| --- \| \| \\| Display name \\| Deal tag \\| \\| --- \\| --- \\| \\| Description \\| A tag assigned to the deal for categorization \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Deal tag \| \| Description \| A tag assigned to the deal for categorization \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | deal_tag | | \| Display name \| Deal tag \| \| --- \| --- \| \| Description \| A tag assigned to the deal for categorization \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Deal tag | | Description | A tag assigned to the deal for categorization | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| deal_type \| \| --- \| \| \\| Display name \\| Deal type \\| \\| --- \\| --- \\| \\| Description \\| The type of deal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Deal type \| \| Description \| The type of deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | deal_type | | \| Display name \| Deal type \| \| --- \| --- \| \| Description \| The type of deal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Deal type | | Description | The type of deal | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| expected_revenue \| \| --- \| \| \\| Display name \\| Deal expected revenue \\| \\| --- \\| --- \\| \\| Description \\| The estimated revenue expected from the deal \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Deal expected revenue \| \| Description \| The estimated revenue expected from the deal \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | expected_revenue | | \| Display name \| Deal expected revenue \| \| --- \| --- \| \| Description \| The estimated revenue expected from the deal \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Deal expected revenue | | Description | The estimated revenue expected from the deal | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| last_activity_date \| \| --- \| \| \\| Display name \\| Last activity date \\| \\| --- \\| --- \\| \\| Description \\| The date of the last activity performed on the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Last activity date \| \| Description \| The date of the last activity performed on the record \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | last_activity_date | | \| Display name \| Last activity date \| \| --- \| --- \| \| Description \| The date of the last activity performed on the record \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Last activity date | | Description | The date of the last activity performed on the record | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| last_activity_time \| \| --- \| \| \\| Display name \\| Last activity datetime \\| \\| --- \\| --- \\| \\| Description \\| The timestamp of the last activity performed on the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Last activity datetime \| \| Description \| The timestamp of the last activity performed on the record \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | last_activity_time | | \| Display name \| Last activity datetime \| \| --- \| --- \| \| Description \| The timestamp of the last activity performed on the record \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Display name | Last activity datetime | | Description | The timestamp of the last activity performed on the record | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| lead_conversion_time \| \| --- \| \| \\| Display name \\| Deal lead conversion time \\| \\| --- \\| --- \\| \\| Description \\| Time elapsed between the lead creation date and the date the lead was converted to a contact \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Deal lead conversion time \| \| Description \| Time elapsed between the lead creation date and the date the lead was converted to a contact \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | lead_conversion_time | | \| Display name \| Deal lead conversion time \| \| --- \| --- \| \| Description \| Time elapsed between the lead creation date and the date the lead was converted to a contact \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Deal lead conversion time | | Description | Time elapsed between the lead creation date and the date the lead was converted to a contact | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| modified_by_id \| \| --- \| \| \\| Display name \\| Modified by ID \\| \\| --- \\| --- \\| \\| Description \\| The user ID who last modified the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Modified by ID \| \| Description \| The user ID who last modified the record \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | modified_by_id | | \| Display name \| Modified by ID \| \| --- \| --- \| \| Description \| The user ID who last modified the record \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Modified by ID | | Description | The user ID who last modified the record | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| modified_date \| \| --- \| \| \\| Display name \\| Modified date \\| \\| --- \\| --- \\| \\| Description \\| The date of the last modification made to the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Modified date \| \| Description \| The date of the last modification made to the record \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | modified_date | | \| Display name \| Modified date \| \| --- \| --- \| \| Description \| The date of the last modification made to the record \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Modified date | | Description | The date of the last modification made to the record | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| modified_time \| \| --- \| \| \\| Display name \\| Modified datetime \\| \\| --- \\| --- \\| \\| Description \\| The timestamp of the last modification made to the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Modified datetime \| \| Description \| The timestamp of the last modification made to the record \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | modified_time | | \| Display name \| Modified datetime \| \| --- \| --- \| \| Description \| The timestamp of the last modification made to the record \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Display name | Modified datetime | | Description | The timestamp of the last modification made to the record | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| overall_sales_duration \| \| --- \| \| \\| Display name \\| Deal overall sales duration \\| \\| --- \\| --- \\| \\| Description \\| The total time taken for the deal to reach its current stage \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Deal overall sales duration \| \| Description \| The total time taken for the deal to reach its current stage \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | overall_sales_duration | | \| Display name \| Deal overall sales duration \| \| --- \| --- \| \| Description \| The total time taken for the deal to reach its current stage \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Deal overall sales duration | | Description | The total time taken for the deal to reach its current stage | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| owner_id \| \| --- \| \| \\| Display name \\| Owner ID \\| \\| --- \\| --- \\| \\| Description \\| The user ID assigned as the owner of the record \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Owner ID \| \| Description \| The user ID assigned as the owner of the record \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | owner_id | | \| Display name \| Owner ID \| \| --- \| --- \| \| Description \| The user ID assigned as the owner of the record \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Owner ID | | Description | The user ID assigned as the owner of the record | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| probability \| \| --- \| \| \\| Display name \\| Deal probability (%) \\| \\| --- \\| --- \\| \\| Description \\| The probability of the deal closing successfully \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.percentage](/apidocs/field-data-types#number) \\| \| \| Display name \| Deal probability (%) \| \| Description \| The probability of the deal closing successfully \| \| Field type \| metric \| \| Data type \| [float.number.percentage](/apidocs/field-data-types#number) \| | | probability | | \| Display name \| Deal probability (%) \| \| --- \| --- \| \| Description \| The probability of the deal closing successfully \| \| Field type \| metric \| \| Data type \| [float.number.percentage](/apidocs/field-data-types#number) \| | | Display name | Deal probability (%) | | Description | The probability of the deal closing successfully | | Field type | metric | | Data type | [float.number.percentage](/apidocs/field-data-types#number) | | \| sales_cycle_duration \| \| --- \| \| \\| Display name \\| Deal sales cycle duration \\| \\| --- \\| --- \\| \\| Description \\| The duration of the sales cycle for the deal \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Deal sales cycle duration \| \| Description \| The duration of the sales cycle for the deal \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | sales_cycle_duration | | \| Display name \| Deal sales cycle duration \| \| --- \| --- \| \| Description \| The duration of the sales cycle for the deal \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Deal sales cycle duration | | Description | The duration of the sales cycle for the deal | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) |