--- title: "Clockify metrics and dimensions" slug: "clockify-fields" description: "Explore the Clockify metrics and dimensions available through Supermetrics. Find every data field you need to build your marketing reports." updated: 2026-03-05T14:21:56Z published: 2026-03-05T14:21:56Z canonical: "docs.supermetrics.com/clockify-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. # Clockify metrics and dimensions > Supermetrics brings all your Clockify 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) 5 metrics65 dimensionsSearch fields ### CLIENT | \| timeentries__client__id \| \| --- \| \| \\| Field label \\| Client ID \\| \\| --- \\| --- \\| \\| Description \\| The unique ID of the client associated with the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Client ID \| \| Description \| The unique ID of the client associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | timeentries__client__id | | \| Field label \| Client ID \| \| --- \| --- \| \| Description \| The unique ID of the client associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Client ID | | Description | The unique ID of the client associated with the time entry | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| timeentries__client__name \| \| --- \| \| \\| Field label \\| Client name \\| \\| --- \\| --- \\| \\| Description \\| The name of the client associated with the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Client name \| \| Description \| The name of the client associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | timeentries__client__name | | \| Field label \| Client name \| \| --- \| --- \| \| Description \| The name of the client associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Client name | | Description | The name of the client associated with the time entry | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| timeentries__client__archived \| \| --- \| \| \\| Field label \\| Client is archived \\| \\| --- \\| --- \\| \\| Description \\| Whether the client is archived or not \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Client is archived \| \| Description \| Whether the client is archived or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | timeentries__client__archived | | \| Field label \| Client is archived \| \| --- \| --- \| \| Description \| Whether the client is archived or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Field label | Client is archived | | Description | Whether the client is archived or not | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | ### 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) | ### PROJECT | \| timeentries__project__id \| \| --- \| \| \\| Field label \\| Project ID \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Project ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | timeentries__project__id | | \| Field label \| Project ID \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Project ID | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| timeentries__project__project_name \| \| --- \| \| \\| Field label \\| Project name \\| \\| --- \\| --- \\| \\| Description \\| The name of the project associated with the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Project name \| \| Description \| The name of the project associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | timeentries__project__project_name | | \| Field label \| Project name \| \| --- \| --- \| \| Description \| The name of the project associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Project name | | Description | The name of the project associated with the time entry | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| timeentries__project__project_color \| \| --- \| \| \\| Field label \\| Project color \\| \\| --- \\| --- \\| \\| Description \\| The color of the project associated with the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Project color \| \| Description \| The color of the project associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | timeentries__project__project_color | | \| Field label \| Project color \| \| --- \| --- \| \| Description \| The color of the project associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Project color | | Description | The color of the project associated with the time entry | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| timeentries__project__billable \| \| --- \| \| \\| Field label \\| Project is billable \\| \\| --- \\| --- \\| \\| Description \\| Whether the project is billable or not \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Project is billable \| \| Description \| Whether the project is billable or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | timeentries__project__billable | | \| Field label \| Project is billable \| \| --- \| --- \| \| Description \| Whether the project is billable or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Field label | Project is billable | | Description | Whether the project is billable or not | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| timeentries__project__archived \| \| --- \| \| \\| Field label \\| Project is archived \\| \\| --- \\| --- \\| \\| Description \\| Whether the project is archived or not \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Project is archived \| \| Description \| Whether the project is archived or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | timeentries__project__archived | | \| Field label \| Project is archived \| \| --- \| --- \| \| Description \| Whether the project is archived or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Field label | Project is archived | | Description | Whether the project is archived or not | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| timeentries__project__note \| \| --- \| \| \\| Field label \\| Project note \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Project note \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | timeentries__project__note | | \| Field label \| Project note \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Project note | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| timeentries__project__template \| \| --- \| \| \\| Field label \\| Project is a template \\| \\| --- \\| --- \\| \\| Description \\| Whether the project is a template or not \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Project is a template \| \| Description \| Whether the project is a template or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | timeentries__project__template | | \| Field label \| Project is a template \| \| --- \| --- \| \| Description \| Whether the project is a template or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Field label | Project is a template | | Description | Whether the project is a template or not | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| timeentries__project__public \| \| --- \| \| \\| Field label \\| Project is public \\| \\| --- \\| --- \\| \\| Description \\| Whether the project is a public or not \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Project is public \| \| Description \| Whether the project is a public or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | timeentries__project__public | | \| Field label \| Project is public \| \| --- \| --- \| \| Description \| Whether the project is a public or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Field label | Project is public | | Description | Whether the project is a public or not | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| timeentries__project__cost_rate \| \| --- \| \| \\| Field label \\| Project cost rate \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Project cost rate \| \| Field type \| dimension \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | timeentries__project__cost_rate | | \| Field label \| Project cost rate \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Project cost rate | | Field type | dimension | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| timeentries__project__hourly_rate \| \| --- \| \| \\| Field label \\| Project hourly rate \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Project hourly rate \| \| Field type \| dimension \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | timeentries__project__hourly_rate | | \| Field label \| Project hourly rate \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Project hourly rate | | Field type | dimension | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| timeentries__project__hourly_rate_currency \| \| --- \| \| \\| Field label \\| Project hourly rate currency \\| \\| --- \\| --- \\| \\| Description \\| The hourly rate currency of the project \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Field label \| Project hourly rate currency \| \| Description \| The hourly rate currency of the project \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | timeentries__project__hourly_rate_currency | | \| Field label \| Project hourly rate currency \| \| --- \| --- \| \| Description \| The hourly rate currency of the project \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| | | Field label | Project hourly rate currency | | Description | The hourly rate currency of the project | | Field type | dimension | | Data type | [string.currency.code](/apidocs/field-data-types#currency) | | \| timeentries__project__budget_estimate \| \| --- \| \| \\| Field label \\| Budget estimate \\| \\| --- \\| --- \\| \\| Description \\| The estimated budget of the project \\| \\| Field type \\| dimension \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Budget estimate \| \| Description \| The estimated budget of the project \| \| Field type \| dimension \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | timeentries__project__budget_estimate | | \| Field label \| Budget estimate \| \| --- \| --- \| \| Description \| The estimated budget of the project \| \| Field type \| dimension \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Budget estimate | | Description | The estimated budget of the project | | Field type | dimension | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | | \| timeentries__project__time_estimate \| \| --- \| \| \\| Field label \\| Time estimate \\| \\| --- \\| --- \\| \\| Description \\| The estimated time of the project \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Time estimate \| \| Description \| The estimated time of the project \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | timeentries__project__time_estimate | | \| Field label \| Time estimate \| \| --- \| --- \| \| Description \| The estimated time of the project \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Time estimate | | Description | The estimated time of the project | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| timeentries__project__time_estimate_type \| \| --- \| \| \\| Field label \\| Time estimate type \\| \\| --- \\| --- \\| \\| Description \\| The time estimate type of the project \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Time estimate type \| \| Description \| The time estimate type of the project \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | timeentries__project__time_estimate_type | | \| Field label \| Time estimate type \| \| --- \| --- \| \| Description \| The time estimate type of the project \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Time estimate type | | Description | The time estimate type of the project | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| timeentries__project__time_estimate_active \| \| --- \| \| \\| Field label \\| Time estimate active \\| \\| --- \\| --- \\| \\| Description \\| Whether the time estimate is active or not \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Time estimate active \| \| Description \| Whether the time estimate is active or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | timeentries__project__time_estimate_active | | \| Field label \| Time estimate active \| \| --- \| --- \| \| Description \| Whether the time estimate is active or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Field label | Time estimate active | | Description | Whether the time estimate is active or not | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | ### 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 | | \| timeentries__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) \| | | timeentries__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) | | \| timeentries__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) \| | | timeentries__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) | | \| timeentries__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) \| | | timeentries__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) | | \| timeentries__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) \| | | timeentries__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) | | \| timeentries__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) \| | | timeentries__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) | | \| timeentries__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) \| | | timeentries__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) | | \| timeentries__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) \| | | timeentries__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) | | \| timeentries__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) \| | | timeentries__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) | | \| timeentries__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) \| | | timeentries__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) | | \| timeentries__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) \| | | timeentries__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) | | \| timeentries__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) \| | | timeentries__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) | | \| timeentries__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) \| | | timeentries__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) | | \| timeentries__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) \| | | timeentries__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) | | \| timeentries__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) \| | | timeentries__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) | ### TIME ENTRY | \| timeentries__entry_start_date \| \| --- \| \| \\| Field label \\| Entry start date \\| \\| --- \\| --- \\| \\| Description \\| The start date of the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Entry start date \| \| Description \| The start date of the time entry \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | --- | | timeentries__entry_start_date | | \| Field label \| Entry start date \| \| --- \| --- \| \| Description \| The start date of the time entry \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Entry start date | | Description | The start date of the time entry | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| timeentries__entry_end_date \| \| --- \| \| \\| Field label \\| Entry end date \\| \\| --- \\| --- \\| \\| Description \\| The end date of the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Entry end date \| \| Description \| The end date of the time entry \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | timeentries__entry_end_date | | \| Field label \| Entry end date \| \| --- \| --- \| \| Description \| The end date of the time entry \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Entry end date | | Description | The end date of the time entry | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| timeentries__entry_start \| \| --- \| \| \\| Field label \\| Entry start time \\| \\| --- \\| --- \\| \\| Description \\| The start time of the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Entry start time \| \| Description \| The start time of the time entry \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | timeentries__entry_start | | \| Field label \| Entry start time \| \| --- \| --- \| \| Description \| The start time of the time entry \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Entry start time | | Description | The start time of the time entry | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| timeentries__entry_end \| \| --- \| \| \\| Field label \\| Entry end time \\| \\| --- \\| --- \\| \\| Description \\| The end time of the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Entry end time \| \| Description \| The end time of the time entry \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | timeentries__entry_end | | \| Field label \| Entry end time \| \| --- \| --- \| \| Description \| The end time of the time entry \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Entry end time | | Description | The end time of the time entry | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | | \| timeentries__description \| \| --- \| \| \\| Field label \\| Description \\| \\| --- \\| --- \\| \\| Description \\| Time entry description \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Description \| \| Description \| Time entry description \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | timeentries__description | | \| Field label \| Description \| \| --- \| --- \| \| Description \| Time entry description \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Description | | Description | Time entry description | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| timeentries__billable \| \| --- \| \| \\| Field label \\| Billable \\| \\| --- \\| --- \\| \\| Description \\| Whether the time entry is billable or not \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Billable \| \| Description \| Whether the time entry is billable or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | timeentries__billable | | \| Field label \| Billable \| \| --- \| --- \| \| Description \| Whether the time entry is billable or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Field label | Billable | | Description | Whether the time entry is billable or not | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| timeentries__task_id \| \| --- \| \| \\| Field label \\| Task ID \\| \\| --- \\| --- \\| \\| Description \\| The unique ID of the task associated with the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Task ID \| \| Description \| The unique ID of the task associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | timeentries__task_id | | \| Field label \| Task ID \| \| --- \| --- \| \| Description \| The unique ID of the task associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Task ID | | Description | The unique ID of the task associated with the time entry | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| timeentries__task_name \| \| --- \| \| \\| Field label \\| Task name \\| \\| --- \\| --- \\| \\| Description \\| The name of the task associated with the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Task name \| \| Description \| The name of the task associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | timeentries__task_name | | \| Field label \| Task name \| \| --- \| --- \| \| Description \| The name of the task associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Task name | | Description | The name of the task associated with the time entry | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| timeentries__approval_request_id \| \| --- \| \| \\| Field label \\| Approval request ID \\| \\| --- \\| --- \\| \\| Description \\| The unique ID of the approval request associated with the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Approval request ID \| \| Description \| The unique ID of the approval request associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | timeentries__approval_request_id | | \| Field label \| Approval request ID \| \| --- \| --- \| \| Description \| The unique ID of the approval request associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Approval request ID | | Description | The unique ID of the approval request associated with the time entry | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| timeentries__is_locked \| \| --- \| \| \\| Field label \\| Is locked \\| \\| --- \\| --- \\| \\| Description \\| Whether the time entry is locked or not \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Is locked \| \| Description \| Whether the time entry is locked or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | timeentries__is_locked | | \| Field label \| Is locked \| \| --- \| --- \| \| Description \| Whether the time entry is locked or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Field label | Is locked | | Description | Whether the time entry is locked or not | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| timeentries__invoice_id \| \| --- \| \| \\| Field label \\| Invoice ID \\| \\| --- \\| --- \\| \\| Description \\| The unique ID of the time entry invoice \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Invoice ID \| \| Description \| The unique ID of the time entry invoice \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | timeentries__invoice_id | | \| Field label \| Invoice ID \| \| --- \| --- \| \| Description \| The unique ID of the time entry invoice \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Invoice ID | | Description | The unique ID of the time entry invoice | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| timeentries__invoice_number \| \| --- \| \| \\| Field label \\| Invoice number \\| \\| --- \\| --- \\| \\| Description \\| The invoice number of the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Invoice number \| \| Description \| The invoice number of the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | timeentries__invoice_number | | \| Field label \| Invoice number \| \| --- \| --- \| \| Description \| The invoice number of the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Invoice number | | Description | The invoice number of the time entry | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| timeentries__manually_invoiced \| \| --- \| \| \\| Field label \\| Manually invoiced \\| \\| --- \\| --- \\| \\| Description \\| Whether the time entry is invoiced manually or not \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Field label \| Manually invoiced \| \| Description \| Whether the time entry is invoiced manually or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | timeentries__manually_invoiced | | \| Field label \| Manually invoiced \| \| --- \| --- \| \| Description \| Whether the time entry is invoiced manually or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Field label | Manually invoiced | | Description | Whether the time entry is invoiced manually or not | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| timeentries__tags \| \| --- \| \| \\| Field label \\| Tags \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Tags \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | timeentries__tags | | \| Field label \| Tags \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Tags | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| timeentries__time_entry_id \| \| --- \| \| \\| Field label \\| Time entry ID \\| \\| --- \\| --- \\| \\| Description \\| Represents time entry identifier across the system \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Time entry ID \| \| Description \| Represents time entry identifier across the system \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | timeentries__time_entry_id | | \| Field label \| Time entry ID \| \| --- \| --- \| \| Description \| Represents time entry identifier across the system \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Time entry ID | | Description | Represents time entry identifier across the system | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| timeentries__count \| \| --- \| \| \\| Field label \\| Entries \\| \\| --- \\| --- \\| \\| Description \\| The number of time entries \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Entries \| \| Description \| The number of time entries \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | timeentries__count | | \| Field label \| Entries \| \| --- \| --- \| \| Description \| The number of time entries \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Entries | | Description | The number of time entries | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| timeentries__duration_sec \| \| --- \| \| \\| Field label \\| Duration (sec) \\| \\| --- \\| --- \\| \\| Description \\| The duration of the time entry in seconds \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Duration (sec) \| \| Description \| The duration of the time entry in seconds \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | timeentries__duration_sec | | \| Field label \| Duration (sec) \| \| --- \| --- \| \| Description \| The duration of the time entry in seconds \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Duration (sec) | | Description | The duration of the time entry in seconds | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| timeentries__duration_h \| \| --- \| \| \\| Field label \\| Duration (h) \\| \\| --- \\| --- \\| \\| Description \\| The duration of the time entry in hours \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Duration (h) \| \| Description \| The duration of the time entry in hours \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| | | timeentries__duration_h | | \| Field label \| Duration (h) \| \| --- \| --- \| \| Description \| The duration of the time entry in hours \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| | | Field label | Duration (h) | | Description | The duration of the time entry in hours | | Field type | metric | | Data type | [float.number.value](/apidocs/field-data-types#number) | | \| timeentries__amount \| \| --- \| \| \\| Field label \\| Amount \\| \\| --- \\| --- \\| \\| Description \\| The billable amount of the time entry. This value is rounded \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Amount \| \| Description \| The billable amount of the time entry. This value is rounded \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | timeentries__amount | | \| Field label \| Amount \| \| --- \| --- \| \| Description \| The billable amount of the time entry. This value is rounded \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Amount | | Description | The billable amount of the time entry. This value is rounded | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| timeentries__billable_amount \| \| --- \| \| \\| Field label \\| Billable amount \\| \\| --- \\| --- \\| \\| Description \\| The billable amount of the time entry \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Field label \| Billable amount \| \| Description \| The billable amount of the time entry \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | timeentries__billable_amount | | \| Field label \| Billable amount \| \| --- \| --- \| \| Description \| The billable amount of the time entry \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| | | Field label | Billable amount | | Description | The billable amount of the time entry | | Field type | metric | | Data type | [float.currency.value](/apidocs/field-data-types#currency) | ### USER | \| timeentries__user__id \| \| --- \| \| \\| Field label \\| User ID \\| \\| --- \\| --- \\| \\| Description \\| The unique ID of the user making the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| User ID \| \| Description \| The unique ID of the user making the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | timeentries__user__id | | \| Field label \| User ID \| \| --- \| --- \| \| Description \| The unique ID of the user making the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | User ID | | Description | The unique ID of the user making the time entry | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| timeentries__user__name \| \| --- \| \| \\| Field label \\| User name \\| \\| --- \\| --- \\| \\| Description \\| The name of the user making the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| User name \| \| Description \| The name of the user making the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | timeentries__user__name | | \| Field label \| User name \| \| --- \| --- \| \| Description \| The name of the user making the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | User name | | Description | The name of the user making the time entry | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| timeentries__user__email \| \| --- \| \| \\| Field label \\| User email \\| \\| --- \\| --- \\| \\| Description \\| The email of the user making the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| User email \| \| Description \| The email of the user making the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | timeentries__user__email | | \| Field label \| User email \| \| --- \| --- \| \| Description \| The email of the user making the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | User email | | Description | The email of the user making the time entry | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | ### WORKSPACE | \| timeentries__client__workspace__id \| \| --- \| \| \\| Field label \\| Workspace ID \\| \\| --- \\| --- \\| \\| Description \\| The unique ID of the workspace \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Workspace ID \| \| Description \| The unique ID of the workspace \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | timeentries__client__workspace__id | | \| Field label \| Workspace ID \| \| --- \| --- \| \| Description \| The unique ID of the workspace \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Workspace ID | | Description | The unique ID of the workspace | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| timeentries__client__workspace__name \| \| --- \| \| \\| Field label \\| Workspace name \\| \\| --- \\| --- \\| \\| Description \\| The name of the workspace \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Workspace name \| \| Description \| The name of the workspace \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | timeentries__client__workspace__name | | \| Field label \| Workspace name \| \| --- \| --- \| \| Description \| The name of the workspace \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Workspace name | | Description | The name of the workspace | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) |