---
title: "Odoo CRM metrics and dimensions"
slug: "odoo-crm-fields"
description: "Explore the complete list of Odoo CRM metrics and dimensions available through Supermetrics. Find every data field you need to build your reports."
updated: 2026-03-05T14:08:05Z
published: 2026-03-05T14:08:05Z
canonical: "docs.supermetrics.com/odoo-crm-fields"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Odoo CRM metrics and dimensions

> Supermetrics brings all your Odoo CRM data into [Google Sheets](https://workspace.google.com/marketplace/app/supermetrics/523876908005), [Looker Studio](https://supermetrics.com/products/looker-studio), [Power BI](https://supermetrics.com/products/power-bi), [Excel](https://supermetrics.com/products/excel), [BigQuery](https://supermetrics.com/products/bigquery), [Snowflake](https://supermetrics.com/products/snowflake), [Redshift](https://supermetrics.com/products/amazon-redshift), [Azure](https://supermetrics.com/products/azure-synapse)

Early Access3 metrics53 dimensionsSearch fields

### CONTACT INFORMATION

| \| lead_contact \| \| --- \| \| \\| Field label \\| Lead contact \\| \\| --- \\| --- \\| \\| Description \\| The contact of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Lead contact \| \| Description \| The contact of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| lead_contact |
| \| Field label \| Lead contact \| \| --- \| --- \| \| Description \| The contact of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Lead contact |
| Description | The contact of the lead |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| lead_email \| \| --- \| \| \\| Field label \\| Lead email \\| \\| --- \\| --- \\| \\| Description \\| Email of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Field label \| Lead email \| \| Description \| Email of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| lead_email |
| \| Field label \| Lead email \| \| --- \| --- \| \| Description \| Email of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Field label | Lead email |
| Description | Email of the lead |
| Field type | dimension |
| Data type | [string.text.email](/apidocs/field-data-types#text) |
| \| lead_phone \| \| --- \| \| \\| Field label \\| Lead phone \\| \\| --- \\| --- \\| \\| Description \\| Lead phone number \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Field label \| Lead phone \| \| Description \| Lead phone number \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| lead_phone |
| \| Field label \| Lead phone \| \| --- \| --- \| \| Description \| Lead phone number \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Field label | Lead phone |
| Description | Lead phone number |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |
| \| lead_company_name \| \| --- \| \| \\| Field label \\| Lead company name \\| \\| --- \\| --- \\| \\| Description \\| The name of the future partner company that will be created while converting the lead into opportunity \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Lead company name \| \| Description \| The name of the future partner company that will be created while converting the lead into opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| lead_company_name |
| \| Field label \| Lead company name \| \| --- \| --- \| \| Description \| The name of the future partner company that will be created while converting the lead into opportunity \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Lead company name |
| Description | The name of the future partner company that will be created while converting the lead into opportunity |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| lead_street \| \| --- \| \| \\| Field label \\| Lead street \\| \\| --- \\| --- \\| \\| Description \\| The lead street \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.street](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Lead street \| \| Description \| The lead street \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| lead_street |
| \| Field label \| Lead street \| \| --- \| --- \| \| Description \| The lead street \| \| Field type \| dimension \| \| Data type \| [string.geo.street](/apidocs/field-data-types#geographical) \| |
| Field label | Lead street |
| Description | The lead street |
| Field type | dimension |
| Data type | [string.geo.street](/apidocs/field-data-types#geographical) |
| \| lead_city \| \| --- \| \| \\| Field label \\| Lead city \\| \\| --- \\| --- \\| \\| Description \\| City of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.city](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Lead city \| \| Description \| City of the lead \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| lead_city |
| \| Field label \| Lead city \| \| --- \| --- \| \| Description \| City of the lead \| \| Field type \| dimension \| \| Data type \| [string.geo.city](/apidocs/field-data-types#geographical) \| |
| Field label | Lead city |
| Description | City of the lead |
| Field type | dimension |
| Data type | [string.geo.city](/apidocs/field-data-types#geographical) |
| \| lead_postal_code \| \| --- \| \| \\| Field label \\| Lead postal code \\| \\| --- \\| --- \\| \\| Description \\| Postal code of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.zip](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Lead postal code \| \| Description \| Postal code of the lead \| \| Field type \| dimension \| \| Data type \| [string.geo.zip](/apidocs/field-data-types#geographical) \| |
| lead_postal_code |
| \| Field label \| Lead postal code \| \| --- \| --- \| \| Description \| Postal code of the lead \| \| Field type \| dimension \| \| Data type \| [string.geo.zip](/apidocs/field-data-types#geographical) \| |
| Field label | Lead postal code |
| Description | Postal code of the lead |
| Field type | dimension |
| Data type | [string.geo.zip](/apidocs/field-data-types#geographical) |
| \| lead_country \| \| --- \| \| \\| Field label \\| Lead country \\| \\| --- \\| --- \\| \\| Description \\| Country of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country](/apidocs/field-data-types#geographical) \\| \| \| Field label \| Lead country \| \| Description \| Country of the lead \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| lead_country |
| \| Field label \| Lead country \| \| --- \| --- \| \| Description \| Country of the lead \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| Field label | Lead country |
| Description | Country of the lead |
| Field type | dimension |
| Data type | [string.geo.country](/apidocs/field-data-types#geographical) |
| \| lead_website \| \| --- \| \| \\| Field label \\| Lead website \\| \\| --- \\| --- \\| \\| Description \\| Website of the contact \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Lead website \| \| Description \| Website of the contact \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| lead_website |
| \| Field label \| Lead website \| \| --- \| --- \| \| Description \| Website of the contact \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Lead website |
| Description | Website of the contact |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### DATASOURCE

| \| dataSourceName \| \| --- \| \| \\| Field label \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \\| Destinations \\| API, Data warehouse \\| \| \| Field label \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| \| Destinations \| API, Data warehouse \| |
| --- |
| dataSourceName |
| \| Field label \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| \| Destinations \| API, Data warehouse \| |
| Field label | Data source |
| Description | The name of the source for this data, as listed on supermetrics.com/docs |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| Destinations | API, Data warehouse |
| \| system_metadata.data_source_logins \| \| --- \| \| \\| Field label \\| Data source logins \\| \\| --- \\| --- \\| \\| Description \\| The data source login accounts that were used to authenticate against the data source \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Data source logins \| \| Description \| The data source login accounts that were used to authenticate against the data source \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| system_metadata.data_source_logins |
| \| Field label \| Data source logins \| \| --- \| --- \| \| Description \| The data source login accounts that were used to authenticate against the data source \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| Field label | Data source logins |
| Description | The data source login accounts that were used to authenticate against the data source |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |
| \| system_metadata.data_source_login_owners \| \| --- \| \| \\| Field label \\| Data source login owners \\| \\| --- \\| --- \\| \\| Description \\| The Supermetrics users that created the data source login connections \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Data source login owners \| \| Description \| The Supermetrics users that created the data source login connections \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| system_metadata.data_source_login_owners |
| \| Field label \| Data source login owners \| \| --- \| --- \| \| Description \| The Supermetrics users that created the data source login connections \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| Field label | Data source login owners |
| Description | The Supermetrics users that created the data source login connections |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |

### LEAD

| \| lead_id \| \| --- \| \| \\| Field label \\| Lead ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Lead ID \| \| Description \| ID of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| lead_id |
| \| Field label \| Lead ID \| \| --- \| --- \| \| Description \| ID of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Lead ID |
| Description | ID of the lead |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| lead_name \| \| --- \| \| \\| Field label \\| Lead name \\| \\| --- \\| --- \\| \\| Description \\| Name of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Lead name \| \| Description \| Name of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| lead_name |
| \| Field label \| Lead name \| \| --- \| --- \| \| Description \| Name of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Lead name |
| Description | Name of the lead |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| lead_stage \| \| --- \| \| \\| Field label \\| Lead stage \\| \\| --- \\| --- \\| \\| Description \\| The stage of the lead (New, Qualified, Proposition, Won) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Lead stage \| \| Description \| The stage of the lead (New, Qualified, Proposition, Won) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| lead_stage |
| \| Field label \| Lead stage \| \| --- \| --- \| \| Description \| The stage of the lead (New, Qualified, Proposition, Won) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Lead stage |
| Description | The stage of the lead (New, Qualified, Proposition, Won) |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| lead_salesperson \| \| --- \| \| \\| Field label \\| Lead salesperson \\| \\| --- \\| --- \\| \\| Description \\| Salesperson of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Lead salesperson \| \| Description \| Salesperson of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| lead_salesperson |
| \| Field label \| Lead salesperson \| \| --- \| --- \| \| Description \| Salesperson of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Lead salesperson |
| Description | Salesperson of the lead |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| lead_type \| \| --- \| \| \\| Field label \\| Lead type \\| \\| --- \\| --- \\| \\| Description \\| Lead type \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Lead type \| \| Description \| Lead type \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| lead_type |
| \| Field label \| Lead type \| \| --- \| --- \| \| Description \| Lead type \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Lead type |
| Description | Lead type |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| lead_company_currency \| \| --- \| \| \\| Field label \\| Lead company currency \\| \\| --- \\| --- \\| \\| Description \\| The currency of the lead company \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Field label \| Lead company currency \| \| Description \| The currency of the lead company \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| lead_company_currency |
| \| Field label \| Lead company currency \| \| --- \| --- \| \| Description \| The currency of the lead company \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Field label | Lead company currency |
| Description | The currency of the lead company |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |
| \| lead_expected_revenue \| \| --- \| \| \\| Field label \\| Lead expected revenue \\| \\| --- \\| --- \\| \\| Description \\| The expected revenue of lead \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Lead expected revenue \| \| Description \| The expected revenue of lead \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| lead_expected_revenue |
| \| Field label \| Lead expected revenue \| \| --- \| --- \| \| Description \| The expected revenue of lead \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Field label | Lead expected revenue |
| Description | The expected revenue of lead |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| lead_probability \| \| --- \| \| \\| Field label \\| Lead probability \\| \\| --- \\| --- \\| \\| Description \\| The lead probability \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.percentage](/apidocs/field-data-types#number) \\| \| \| Field label \| Lead probability \| \| Description \| The lead probability \| \| Field type \| metric \| \| Data type \| [float.number.percentage](/apidocs/field-data-types#number) \| |
| lead_probability |
| \| Field label \| Lead probability \| \| --- \| --- \| \| Description \| The lead probability \| \| Field type \| metric \| \| Data type \| [float.number.percentage](/apidocs/field-data-types#number) \| |
| Field label | Lead probability |
| Description | The lead probability |
| Field type | metric |
| Data type | [float.number.percentage](/apidocs/field-data-types#number) |
| \| leads \| \| --- \| \| \\| Field label \\| Leads \\| \\| --- \\| --- \\| \\| Description \\| Total amount of lead in the period \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Leads \| \| Description \| Total amount of lead in the period \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| leads |
| \| Field label \| Leads \| \| --- \| --- \| \| Description \| Total amount of lead in the period \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Leads |
| Description | Total amount of lead in the period |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |

### MARKETING

| \| lead_campaign \| \| --- \| \| \\| Field label \\| Lead campaign \\| \\| --- \\| --- \\| \\| Description \\| Campaign of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Lead campaign \| \| Description \| Campaign of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| lead_campaign |
| \| Field label \| Lead campaign \| \| --- \| --- \| \| Description \| Campaign of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Lead campaign |
| Description | Campaign of the lead |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| lead_medium \| \| --- \| \| \\| Field label \\| Lead medium \\| \\| --- \\| --- \\| \\| Description \\| Method of delivery of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Lead medium \| \| Description \| Method of delivery of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| lead_medium |
| \| Field label \| Lead medium \| \| --- \| --- \| \| Description \| Method of delivery of the lead \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Lead medium |
| Description | Method of delivery of the lead |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| lead_source \| \| --- \| \| \\| Field label \\| Lead source \\| \\| --- \\| --- \\| \\| Description \\| Source of the link (E.g Search Engine, another domain or name of email list) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Lead source \| \| Description \| Source of the link (E.g Search Engine, another domain or name of email list) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| lead_source |
| \| Field label \| Lead source \| \| --- \| --- \| \| Description \| Source of the link (E.g Search Engine, another domain or name of email list) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Lead source |
| Description | Source of the link (E.g Search Engine, another domain or name of email list) |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| lead_referred_by \| \| --- \| \| \\| Field label \\| Lead referred by \\| \\| --- \\| --- \\| \\| Description \\| Lead referred by \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Lead referred by \| \| Description \| Lead referred by \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| lead_referred_by |
| \| Field label \| Lead referred by \| \| --- \| --- \| \| Description \| Lead referred by \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Lead referred by |
| Description | Lead referred by |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### QUERY

| \| system_metadata.query_date_range_start \| \| --- \| \| \\| Field label \\| Start date \\| \\| --- \\| --- \\| \\| Description \\| The start date of the requested query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Start date \| \| Description \| The start date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| --- |
| system_metadata.query_date_range_start |
| \| Field label \| Start date \| \| --- \| --- \| \| Description \| The start date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Start date |
| Description | The start date of the requested query |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| system_metadata.query_date_range_end \| \| --- \| \| \\| Field label \\| End date \\| \\| --- \\| --- \\| \\| Description \\| The end date of the requested query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| End date \| \| Description \| The end date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| system_metadata.query_date_range_end |
| \| Field label \| End date \| \| --- \| --- \| \| Description \| The end date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | End date |
| Description | The end date of the requested query |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| system_metadata.query_timezone \| \| --- \| \| \\| Field label \\| Timezone \\| \\| --- \\| --- \\| \\| Description \\| The timezone that is supplied to the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.timezone](/apidocs/field-data-types#time) \\| \| \| Field label \| Timezone \| \| Description \| The timezone that is supplied to the query \| \| Field type \| dimension \| \| Data type \| [string.time.timezone](/apidocs/field-data-types#time) \| |
| system_metadata.query_timezone |
| \| Field label \| Timezone \| \| --- \| --- \| \| Description \| The timezone that is supplied to the query \| \| Field type \| dimension \| \| Data type \| [string.time.timezone](/apidocs/field-data-types#time) \| |
| Field label | Timezone |
| Description | The timezone that is supplied to the query |
| Field type | dimension |
| Data type | [string.time.timezone](/apidocs/field-data-types#time) |
| \| system_metadata.query_filters \| \| --- \| \| \\| Field label \\| Filters \\| \\| --- \\| --- \\| \\| Description \\| All filters used in the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Filters \| \| Description \| All filters used in the query \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| system_metadata.query_filters |
| \| Field label \| Filters \| \| --- \| --- \| \| Description \| All filters used in the query \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| Field label | Filters |
| Description | All filters used in the query |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |
| \| system_metadata.query_date_start \| \| --- \| \| \\| Field label \\| Start \\| \\| --- \\| --- \\| \\| Description \\| When the query was started \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Start \| \| Description \| When the query was started \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| system_metadata.query_date_start |
| \| Field label \| Start \| \| --- \| --- \| \| Description \| When the query was started \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Start |
| Description | When the query was started |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| system_metadata.query_date_end \| \| --- \| \| \\| Field label \\| End \\| \\| --- \\| --- \\| \\| Description \\| When the query completed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| End \| \| Description \| When the query completed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| system_metadata.query_date_end |
| \| Field label \| End \| \| --- \| --- \| \| Description \| When the query completed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | End |
| Description | When the query completed |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| system_metadata.query_duration \| \| --- \| \| \\| Field label \\| Duration \\| \\| --- \\| --- \\| \\| Description \\| The duration in seconds of the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [int.duration.seconds](/apidocs/field-data-types#duration) \\| \| \| Field label \| Duration \| \| Description \| The duration in seconds of the query \| \| Field type \| dimension \| \| Data type \| [int.duration.seconds](/apidocs/field-data-types#duration) \| |
| system_metadata.query_duration |
| \| Field label \| Duration \| \| --- \| --- \| \| Description \| The duration in seconds of the query \| \| Field type \| dimension \| \| Data type \| [int.duration.seconds](/apidocs/field-data-types#duration) \| |
| Field label | Duration |
| Description | The duration in seconds of the query |
| Field type | dimension |
| Data type | [int.duration.seconds](/apidocs/field-data-types#duration) |
| \| system_metadata.query_accounts \| \| --- \| \| \\| Field label \\| Accounts \\| \\| --- \\| --- \\| \\| Description \\| A list of accounts of which the data was pulled from \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Accounts \| \| Description \| A list of accounts of which the data was pulled from \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| system_metadata.query_accounts |
| \| Field label \| Accounts \| \| --- \| --- \| \| Description \| A list of accounts of which the data was pulled from \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| Field label | Accounts |
| Description | A list of accounts of which the data was pulled from |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |
| \| system_metadata.query_excluded_accounts \| \| --- \| \| \\| Field label \\| Excluded invalid accounts \\| \\| --- \\| --- \\| \\| Description \\| A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Excluded invalid accounts \| \| Description \| A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| system_metadata.query_excluded_accounts |
| \| Field label \| Excluded invalid accounts \| \| --- \| --- \| \| Description \| A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| Field label | Excluded invalid accounts |
| Description | A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |

### TIME

| \| today \| \| --- \| \| \\| Field label \\| Today \\| \\| --- \\| --- \\| \\| Description \\| Today's date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \\| Destinations \\| API, Data warehouse \\| \| \| Field label \| Today \| \| Description \| Today's date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| \| Destinations \| API, Data warehouse \| |
| --- |
| today |
| \| Field label \| Today \| \| --- \| --- \| \| Description \| Today's date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| \| Destinations \| API, Data warehouse \| |
| Field label | Today |
| Description | Today's date, e.g. 2017-01-31 |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| Destinations | API, Data warehouse |
| \| year \| \| --- \| \| \\| Field label \\| Year \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| year |
| \| Field label \| Year \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| Field label | Year |
| Field type | dimension |
| Data type | [string.time.year](/apidocs/field-data-types#time) |
| \| year_of_week \| \| --- \| \| \\| Field label \\| Year of week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year of week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| year_of_week |
| \| Field label \| Year of week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| Field label | Year of week (Sun-Sat) |
| Field type | dimension |
| Data type | [string.time.year](/apidocs/field-data-types#time) |
| \| year_of_week_iso \| \| --- \| \| \\| Field label \\| Year of week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year of week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| year_of_week_iso |
| \| Field label \| Year of week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| |
| Field label | Year of week (Mon-Sun) |
| Field type | dimension |
| Data type | [string.time.year](/apidocs/field-data-types#time) |
| \| year_month \| \| --- \| \| \\| Field label \\| Year & month \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearmonth](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & month \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| |
| year_month |
| \| Field label \| Year & month \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| |
| Field label | Year & month |
| Field type | dimension |
| Data type | [string.time.yearmonth](/apidocs/field-data-types#time) |
| \| month \| \| --- \| \| \\| Field label \\| Month \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.month](/apidocs/field-data-types#time) \\| \| \| Field label \| Month \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| |
| month |
| \| Field label \| Month \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| |
| Field label | Month |
| Field type | dimension |
| Data type | [string.time.month](/apidocs/field-data-types#time) |
| \| year_week \| \| --- \| \| \\| Field label \\| Year & week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearweek](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.yearweek](/apidocs/field-data-types#time) \| |
| year_week |
| \| Field label \| Year & week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.yearweek](/apidocs/field-data-types#time) \| |
| Field label | Year & week (Sun-Sat) |
| Field type | dimension |
| Data type | [string.time.yearweek](/apidocs/field-data-types#time) |
| \| year_week_iso \| \| --- \| \| \\| Field label \\| Year & week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearweekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.yearweekiso](/apidocs/field-data-types#time) \| |
| year_week_iso |
| \| Field label \| Year & week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.yearweekiso](/apidocs/field-data-types#time) \| |
| Field label | Year & week (Mon-Sun) |
| Field type | dimension |
| Data type | [string.time.yearweekiso](/apidocs/field-data-types#time) |
| \| week \| \| --- \| \| \\| Field label \\| Week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.week](/apidocs/field-data-types#time) \\| \| \| Field label \| Week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.week](/apidocs/field-data-types#time) \| |
| week |
| \| Field label \| Week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.week](/apidocs/field-data-types#time) \| |
| Field label | Week (Sun-Sat) |
| Field type | dimension |
| Data type | [string.time.week](/apidocs/field-data-types#time) |
| \| week_iso \| \| --- \| \| \\| Field label \\| Week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.weekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.weekiso](/apidocs/field-data-types#time) \| |
| week_iso |
| \| Field label \| Week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.weekiso](/apidocs/field-data-types#time) \| |
| Field label | Week (Mon-Sun) |
| Field type | dimension |
| Data type | [string.time.weekiso](/apidocs/field-data-types#time) |
| \| day_of_month \| \| --- \| \| \\| Field label \\| Day of month \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofmonth](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of month \| \| Field type \| dimension \| \| Data type \| [string.time.dayofmonth](/apidocs/field-data-types#time) \| |
| day_of_month |
| \| Field label \| Day of month \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.dayofmonth](/apidocs/field-data-types#time) \| |
| Field label | Day of month |
| Field type | dimension |
| Data type | [string.time.dayofmonth](/apidocs/field-data-types#time) |
| \| day_of_week_name \| \| --- \| \| \\| Field label \\| Day of week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofweek](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of week (Sun-Sat) \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweek](/apidocs/field-data-types#time) \| |
| day_of_week_name |
| \| Field label \| Day of week (Sun-Sat) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweek](/apidocs/field-data-types#time) \| |
| Field label | Day of week (Sun-Sat) |
| Field type | dimension |
| Data type | [string.time.dayofweek](/apidocs/field-data-types#time) |
| \| day_of_week_name_iso \| \| --- \| \| \\| Field label \\| Day of week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofweekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of week (Mon-Sun) \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweekiso](/apidocs/field-data-types#time) \| |
| day_of_week_name_iso |
| \| Field label \| Day of week (Mon-Sun) \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweekiso](/apidocs/field-data-types#time) \| |
| Field label | Day of week (Mon-Sun) |
| Field type | dimension |
| Data type | [string.time.dayofweekiso](/apidocs/field-data-types#time) |
| \| date \| \| --- \| \| \\| Field label \\| Date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| date |
| \| Field label \| Date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Date |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| atom \| \| --- \| \| \\| Field label \\| Datetime \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Datetime \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| atom |
| \| Field label \| Datetime \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Datetime |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |

### TIMESTAMP

| \| lead_created_date \| \| --- \| \| \\| Field label \\| Lead created date \\| \\| --- \\| --- \\| \\| Description \\| Lead created date \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Lead created date \| \| Description \| Lead created date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| --- |
| lead_created_date |
| \| Field label \| Lead created date \| \| --- \| --- \| \| Description \| Lead created date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Lead created date |
| Description | Lead created date |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| lead_modified_date \| \| --- \| \| \\| Field label \\| Lead modified date \\| \\| --- \\| --- \\| \\| Description \\| Lead modified date \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Lead modified date \| \| Description \| Lead modified date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| lead_modified_date |
| \| Field label \| Lead modified date \| \| --- \| --- \| \| Description \| Lead modified date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Lead modified date |
| Description | Lead modified date |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| lead_modified_datetime \| \| --- \| \| \\| Field label \\| Lead modified datetime \\| \\| --- \\| --- \\| \\| Description \\| Lead modified datetime \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Lead modified datetime \| \| Description \| Lead modified datetime \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| lead_modified_datetime |
| \| Field label \| Lead modified datetime \| \| --- \| --- \| \| Description \| Lead modified datetime \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Lead modified datetime |
| Description | Lead modified datetime |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| lead_update_date \| \| --- \| \| \\| Field label \\| Lead updated date \\| \\| --- \\| --- \\| \\| Description \\| Last stage update date of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Lead updated date \| \| Description \| Last stage update date of the lead \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| lead_update_date |
| \| Field label \| Lead updated date \| \| --- \| --- \| \| Description \| Last stage update date of the lead \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Lead updated date |
| Description | Last stage update date of the lead |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| lead_update_datetime \| \| --- \| \| \\| Field label \\| Lead updated datetime \\| \\| --- \\| --- \\| \\| Description \\| Last stage update datetime of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Lead updated datetime \| \| Description \| Last stage update datetime of the lead \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| lead_update_datetime |
| \| Field label \| Lead updated datetime \| \| --- \| --- \| \| Description \| Last stage update datetime of the lead \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Lead updated datetime |
| Description | Last stage update datetime of the lead |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| lead_expected_closing_date \| \| --- \| \| \\| Field label \\| Lead expected closing date \\| \\| --- \\| --- \\| \\| Description \\| Expected closing date of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Lead expected closing date \| \| Description \| Expected closing date of the lead \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| lead_expected_closing_date |
| \| Field label \| Lead expected closing date \| \| --- \| --- \| \| Description \| Expected closing date of the lead \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Lead expected closing date |
| Description | Expected closing date of the lead |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| lead_expected_closing_datetime \| \| --- \| \| \\| Field label \\| Lead expected closing datetime \\| \\| --- \\| --- \\| \\| Description \\| Expected closing datetime of the lead \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Lead expected closing datetime \| \| Description \| Expected closing datetime of the lead \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| lead_expected_closing_datetime |
| \| Field label \| Lead expected closing datetime \| \| --- \| --- \| \| Description \| Expected closing datetime of the lead \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Lead expected closing datetime |
| Description | Expected closing datetime of the lead |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |