--- title: "Salesforce data warehouse table groups" slug: "salesforce-data-warehouse-table-groups" description: "Explore the complete Supermetrics data warehouse table groups for Salesforce. See all the tables and the fields included in them." updated: 2026-09-23T11:02:37Z published: 2026-09-23T11:02:37Z canonical: "docs.supermetrics.com/salesforce-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. # Salesforce data warehouse table groups Search fields ### Table: LEAD | \| 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_closed \| \| --- \| \| \\| Display name \\| Closed date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Closed date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | date_closed | | \| Display name \| Closed date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Closed date | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| date_created \| \| --- \| \| \\| 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_created | | \| 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) | | \| lead_company \| \| --- \| \| \\| Display name \\| Company \\| \\| --- \\| --- \\| \\| Description \\| The company of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Company \| \| Description \| The company of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_company | | \| Display name \| Company \| \| --- \| --- \| \| Description \| The company of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Company | | Description | The company of the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_count \| \| --- \| \| \\| Display name \\| Leads \\| \\| --- \\| --- \\| \\| Description \\| Total number of leads \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Leads \| \| Description \| Total number of leads \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | lead_count | | \| Display name \| Leads \| \| --- \| --- \| \| Description \| Total number of leads \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Leads | | Description | Total number of leads | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| lead_email \| \| --- \| \| \\| Display name \\| Lead email \\| \\| --- \\| --- \\| \\| Description \\| The email of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead email \| \| Description \| The email of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| | | lead_email | | \| Display name \| Lead email \| \| --- \| --- \| \| Description \| The email of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| | | Display name | Lead email | | Description | The email of the lead | | Field type | dimension | | Data type | [string.text.email](/apidocs/field-data-types#text) | | \| lead_firstname \| \| --- \| \| \\| 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_firstname | | \| 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_last_activity_date \| \| --- \| \| \\| Display name \\| Lead last activity date \\| \\| --- \\| --- \\| \\| Description \\| The last activity date of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead last activity date \| \| Description \| The last activity date of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_last_activity_date | | \| Display name \| Lead last activity date \| \| --- \| --- \| \| Description \| The last activity date of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead last activity date | | Description | The last activity date of the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_lastname \| \| --- \| \| \\| 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_lastname | | \| 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_phone \| \| --- \| \| \\| Display name \\| Lead phone \\| \\| --- \\| --- \\| \\| Description \\| The phone number of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead phone \| \| Description \| The phone number of the lead \| \| 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 \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| | | Display name | Lead phone | | Description | The phone number of the lead | | Field type | dimension | | Data type | [string.text.phone](/apidocs/field-data-types#text) | | \| lead_source \| \| --- \| \| \\| Display name \\| Lead source \\| \\| --- \\| --- \\| \\| Description \\| The source of lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead source \| \| Description \| The source of lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_source | | \| Display name \| Lead source \| \| --- \| --- \| \| Description \| The source of lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead source | | Description | The source of lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_status \| \| --- \| \| \\| Display name \\| Lead status \\| \\| --- \\| --- \\| \\| Description \\| The status of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead status \| \| Description \| The status of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_status | | \| Display name \| Lead status \| \| --- \| --- \| \| Description \| The status of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead status | | Description | The status of the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| lead_title \| \| --- \| \| \\| Display name \\| Lead title \\| \\| --- \\| --- \\| \\| Description \\| The title of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Lead title \| \| Description \| The title of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | lead_title | | \| Display name \| Lead title \| \| --- \| --- \| \| Description \| The title of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Lead title | | Description | The title of the lead | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| organization_name \| \| --- \| \| \\| Display name \\| Organization name \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Organization name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | organization_name | | \| Display name \| Organization name \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Organization name | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### Table: OPPORTUNITY | \| 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_closed \| \| --- \| \| \\| Display name \\| Closed date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Closed date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | date_closed | | \| Display name \| Closed date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Closed date | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| date_created \| \| --- \| \| \\| 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_created | | \| 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) | | \| opportunity_account_description \| \| --- \| \| \\| Display name \\| Opportunity account description \\| \\| --- \\| --- \\| \\| Description \\| The description of the opportunity account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Opportunity account description \| \| Description \| The description of the opportunity account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | opportunity_account_description | | \| Display name \| Opportunity account description \| \| --- \| --- \| \| Description \| The description of the opportunity account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Opportunity account description | | Description | The description of the opportunity account | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| opportunity_account_employee_count \| \| --- \| \| \\| Display name \\| Opportunity account employee count \\| \\| --- \\| --- \\| \\| Description \\| The employee count of the opportunity account \\| \\| Field type \\| dimension \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Opportunity account employee count \| \| Description \| The employee count of the opportunity account \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | opportunity_account_employee_count | | \| Display name \| Opportunity account employee count \| \| --- \| --- \| \| Description \| The employee count of the opportunity account \| \| Field type \| dimension \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Opportunity account employee count | | Description | The employee count of the opportunity account | | Field type | dimension | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| opportunity_account_industry \| \| --- \| \| \\| Display name \\| Opportunity account industry \\| \\| --- \\| --- \\| \\| Description \\| The industry of the opportunity account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Opportunity account industry \| \| Description \| The industry of the opportunity account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | opportunity_account_industry | | \| Display name \| Opportunity account industry \| \| --- \| --- \| \| Description \| The industry of the opportunity account \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Opportunity account industry | | Description | The industry of the opportunity account | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| opportunity_account_name \| \| --- \| \| \\| Display name \\| Opportunity account name \\| \\| --- \\| --- \\| \\| Description \\| Customer of the opportunity \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Opportunity account name \| \| Description \| Customer of the opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | opportunity_account_name | | \| Display name \| Opportunity account name \| \| --- \| --- \| \| Description \| Customer of the opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Opportunity account name | | Description | Customer of the opportunity | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| opportunity_account_phone \| \| --- \| \| \\| Display name \\| Opportunity account phone \\| \\| --- \\| --- \\| \\| Description \\| The phone number of the opportunity account \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Display name \| Opportunity account phone \| \| Description \| The phone number of the opportunity account \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| | | opportunity_account_phone | | \| Display name \| Opportunity account phone \| \| --- \| --- \| \| Description \| The phone number of the opportunity account \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| | | Display name | Opportunity account phone | | Description | The phone number of the opportunity account | | Field type | dimension | | Data type | [string.text.phone](/apidocs/field-data-types#text) | | \| opportunity_amount \| \| --- \| \| \\| Display name \\| Amount \\| \\| --- \\| --- \\| \\| Description \\| The value of the opportunity \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Amount \| \| Description \| The value of the opportunity \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | opportunity_amount | | \| Display name \| Amount \| \| --- \| --- \| \| Description \| The value of the opportunity \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Amount | | Description | The value of the opportunity | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| opportunity_amount_closed_won \| \| --- \| \| \\| Display name \\| Amount won \\| \\| --- \\| --- \\| \\| Description \\| The value of the won opportunities \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Amount won \| \| Description \| The value of the won opportunities \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | opportunity_amount_closed_won | | \| Display name \| Amount won \| \| --- \| --- \| \| Description \| The value of the won opportunities \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Amount won | | Description | The value of the won opportunities | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| opportunity_avg_per_closed \| \| --- \| \| \\| Display name \\| Avg. amount per closed opportunity \\| \\| --- \\| --- \\| \\| Description \\| Average value of an opportunity \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Avg. amount per closed opportunity \| \| Description \| Average value of an opportunity \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | opportunity_avg_per_closed | | \| Display name \| Avg. amount per closed opportunity \| \| --- \| --- \| \| Description \| Average value of an opportunity \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Display name | Avg. amount per closed opportunity | | Description | Average value of an opportunity | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| opportunity_close_date \| \| --- \| \| \\| Display name \\| Opportunity close date \\| \\| --- \\| --- \\| \\| Description \\| The close date of the opportunity \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Opportunity close date \| \| Description \| The close date of the opportunity \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | opportunity_close_date | | \| Display name \| Opportunity close date \| \| --- \| --- \| \| Description \| The close date of the opportunity \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Opportunity close date | | Description | The close date of the opportunity | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| opportunity_count \| \| --- \| \| \\| Display name \\| Opportunity count \\| \\| --- \\| --- \\| \\| Description \\| Total amount of opportunities \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Opportunity count \| \| Description \| Total amount of opportunities \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | opportunity_count | | \| Display name \| Opportunity count \| \| --- \| --- \| \| Description \| Total amount of opportunities \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Opportunity count | | Description | Total amount of opportunities | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| opportunity_created_date \| \| --- \| \| \\| Display name \\| Opportunity created date \\| \\| --- \\| --- \\| \\| Description \\| The date when the opportunity was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Opportunity created date \| \| Description \| The date when the opportunity was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | opportunity_created_date | | \| Display name \| Opportunity created date \| \| --- \| --- \| \| Description \| The date when the opportunity was created \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Opportunity created date | | Description | The date when the opportunity was created | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| opportunity_description \| \| --- \| \| \\| Display name \\| Opportunity description \\| \\| --- \\| --- \\| \\| Description \\| The description for the opportunity \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Opportunity description \| \| Description \| The description for the opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | opportunity_description | | \| Display name \| Opportunity description \| \| --- \| --- \| \| Description \| The description for the opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Opportunity description | | Description | The description for the opportunity | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| opportunity_forecast_category \| \| --- \| \| \\| Display name \\| Forecast category \\| \\| --- \\| --- \\| \\| Description \\| The forecast category for the opportunity \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Forecast category \| \| Description \| The forecast category for the opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | opportunity_forecast_category | | \| Display name \| Forecast category \| \| --- \| --- \| \| Description \| The forecast category for the opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Forecast category | | Description | The forecast category for the opportunity | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| opportunity_forecast_category_name \| \| --- \| \| \\| Display name \\| Forecast category name \\| \\| --- \\| --- \\| \\| Description \\| The forecast category name for the opportunity \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Forecast category name \| \| Description \| The forecast category name for the opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | opportunity_forecast_category_name | | \| Display name \| Forecast category name \| \| --- \| --- \| \| Description \| The forecast category name for the opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Forecast category name | | Description | The forecast category name for the opportunity | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| opportunity_has_line_item \| \| --- \| \| \\| Display name \\| Has line item \\| \\| --- \\| --- \\| \\| Description \\| Whether or not the opportunity has a line item \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Has line item \| \| Description \| Whether or not the opportunity has a line item \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | opportunity_has_line_item | | \| Display name \| Has line item \| \| --- \| --- \| \| Description \| Whether or not the opportunity has a line item \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Display name | Has line item | | Description | Whether or not the opportunity has a line item | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| opportunity_has_open_activity \| \| --- \| \| \\| Display name \\| Has open activity \\| \\| --- \\| --- \\| \\| Description \\| Whether or not the opportunity has open activity \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Has open activity \| \| Description \| Whether or not the opportunity has open activity \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | opportunity_has_open_activity | | \| Display name \| Has open activity \| \| --- \| --- \| \| Description \| Whether or not the opportunity has open activity \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Display name | Has open activity | | Description | Whether or not the opportunity has open activity | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| opportunity_has_overdue_task \| \| --- \| \| \\| Display name \\| Has overdue task \\| \\| --- \\| --- \\| \\| Description \\| Whether or not the opportunity has overdue tasks \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Has overdue task \| \| Description \| Whether or not the opportunity has overdue tasks \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | opportunity_has_overdue_task | | \| Display name \| Has overdue task \| \| --- \| --- \| \| Description \| Whether or not the opportunity has overdue tasks \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Display name | Has overdue task | | Description | Whether or not the opportunity has overdue tasks | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| opportunity_id \| \| --- \| \| \\| Display name \\| Opportunity ID \\| \\| --- \\| --- \\| \\| Description \\| The ID of the opportunity \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Opportunity ID \| \| Description \| The ID of the opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | opportunity_id | | \| Display name \| Opportunity ID \| \| --- \| --- \| \| Description \| The ID of the opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Opportunity ID | | Description | The ID of the opportunity | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| opportunity_is_closed \| \| --- \| \| \\| Display name \\| Is opportunity closed \\| \\| --- \\| --- \\| \\| Description \\| Whether or not the opportunity is closed \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Is opportunity closed \| \| Description \| Whether or not the opportunity is closed \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | opportunity_is_closed | | \| Display name \| Is opportunity closed \| \| --- \| --- \| \| Description \| Whether or not the opportunity is closed \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Display name | Is opportunity closed | | Description | Whether or not the opportunity is closed | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| opportunity_is_won \| \| --- \| \| \\| Display name \\| Is opportunity won \\| \\| --- \\| --- \\| \\| Description \\| Whether or not the opportunity is won \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Is opportunity won \| \| Description \| Whether or not the opportunity is won \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | opportunity_is_won | | \| Display name \| Is opportunity won \| \| --- \| --- \| \| Description \| Whether or not the opportunity is won \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Display name | Is opportunity won | | Description | Whether or not the opportunity is won | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| opportunity_last_activity_date \| \| --- \| \| \\| Display name \\| Opportunity last activity date \\| \\| --- \\| --- \\| \\| Description \\| The date of the last activity for the opportunity \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Opportunity last activity date \| \| Description \| The date of the last activity for the opportunity \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | opportunity_last_activity_date | | \| Display name \| Opportunity last activity date \| \| --- \| --- \| \| Description \| The date of the last activity for the opportunity \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Opportunity last activity date | | Description | The date of the last activity for the opportunity | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| opportunity_last_modified_date \| \| --- \| \| \\| Display name \\| Opportunity last modified date \\| \\| --- \\| --- \\| \\| Description \\| The date when the opportunity was last modified \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Opportunity last modified date \| \| Description \| The date when the opportunity was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | opportunity_last_modified_date | | \| Display name \| Opportunity last modified date \| \| --- \| --- \| \| Description \| The date when the opportunity was last modified \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Opportunity last modified date | | Description | The date when the opportunity was last modified | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| opportunity_last_referenced_date \| \| --- \| \| \\| Display name \\| Opportunity last referenced date \\| \\| --- \\| --- \\| \\| Description \\| The date when the opportunity was last referenced \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Opportunity last referenced date \| \| Description \| The date when the opportunity was last referenced \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | opportunity_last_referenced_date | | \| Display name \| Opportunity last referenced date \| \| --- \| --- \| \| Description \| The date when the opportunity was last referenced \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Opportunity last referenced date | | Description | The date when the opportunity was last referenced | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| opportunity_last_viewed_date \| \| --- \| \| \\| Display name \\| Opportunity last viewed date \\| \\| --- \\| --- \\| \\| Description \\| The date when the opportunity was last viewed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Opportunity last viewed date \| \| Description \| The date when the opportunity was last viewed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | opportunity_last_viewed_date | | \| Display name \| Opportunity last viewed date \| \| --- \| --- \| \| Description \| The date when the opportunity was last viewed \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Opportunity last viewed date | | Description | The date when the opportunity was last viewed | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| opportunity_lead_source \| \| --- \| \| \\| Display name \\| Opportunity lead source \\| \\| --- \\| --- \\| \\| Description \\| The lead source for the opportunity \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Opportunity lead source \| \| Description \| The lead source for the opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | opportunity_lead_source | | \| Display name \| Opportunity lead source \| \| --- \| --- \| \| Description \| The lead source for the opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Opportunity lead source | | Description | The lead source for the opportunity | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| opportunity_name \| \| --- \| \| \\| Display name \\| Opportunity name \\| \\| --- \\| --- \\| \\| Description \\| The name of the opportunity \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Opportunity name \| \| Description \| The name of the opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | opportunity_name | | \| Display name \| Opportunity name \| \| --- \| --- \| \| Description \| The name of the opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Opportunity name | | Description | The name of the opportunity | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| opportunity_next_step \| \| --- \| \| \\| Display name \\| Opportunity next step \\| \\| --- \\| --- \\| \\| Description \\| The next step for the opportunity \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Opportunity next step \| \| Description \| The next step for the opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | opportunity_next_step | | \| Display name \| Opportunity next step \| \| --- \| --- \| \| Description \| The next step for the opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Opportunity next step | | Description | The next step for the opportunity | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| opportunity_owner \| \| --- \| \| \\| Display name \\| Opportunity owner \\| \\| --- \\| --- \\| \\| Description \\| Owner of the opportunity \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Opportunity owner \| \| Description \| Owner of the opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | opportunity_owner | | \| Display name \| Opportunity owner \| \| --- \| --- \| \| Description \| Owner of the opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Opportunity owner | | Description | Owner of the opportunity | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| opportunity_probability \| \| --- \| \| \\| Display name \\| Probability (%) \\| \\| --- \\| --- \\| \\| Description \\| The probability for the opportunity \\| \\| Field type \\| dimension \\| \\| Data type \\| [float.number.percentage](/apidocs/field-data-types#number) \\| \| \| Display name \| Probability (%) \| \| Description \| The probability for the opportunity \| \| Field type \| dimension \| \| Data type \| [float.number.percentage](/apidocs/field-data-types#number) \| | | opportunity_probability | | \| Display name \| Probability (%) \| \| --- \| --- \| \| Description \| The probability for the opportunity \| \| Field type \| dimension \| \| Data type \| [float.number.percentage](/apidocs/field-data-types#number) \| | | Display name | Probability (%) | | Description | The probability for the opportunity | | Field type | dimension | | Data type | [float.number.percentage](/apidocs/field-data-types#number) | | \| opportunity_stage_name \| \| --- \| \| \\| Display name \\| Opportunity stage \\| \\| --- \\| --- \\| \\| Description \\| The stage of the opportunity \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Opportunity stage \| \| Description \| The stage of the opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | opportunity_stage_name | | \| Display name \| Opportunity stage \| \| --- \| --- \| \| Description \| The stage of the opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Opportunity stage | | Description | The stage of the opportunity | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| opportunity_type \| \| --- \| \| \\| Display name \\| Opportunity type \\| \\| --- \\| --- \\| \\| Description \\| The type of the opportunity \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Opportunity type \| \| Description \| The type of the opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | opportunity_type | | \| Display name \| Opportunity type \| \| --- \| --- \| \| Description \| The type of the opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Opportunity type | | Description | The type of the opportunity | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| organization_name \| \| --- \| \| \\| Display name \\| Organization name \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Organization name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | organization_name | | \| Display name \| Organization name \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Organization name | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) |