Clockify fields

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Clockify data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

5 metrics64 dimensions

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
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
timeentries__client__archived
Field label Client is archived
Description Whether the client is archived or not
Field type dimension
Data type bool

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

PROJECT

timeentries__project__id
Field label Project ID
Field type dimension
Data type string.text.value
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
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
timeentries__project__billable
Field label Project is billable
Description Whether the project is billable or not
Field type dimension
Data type bool
timeentries__project__archived
Field label Project is archived
Description Whether the project is archived or not
Field type dimension
Data type bool
timeentries__project__note
Field label Project note
Field type dimension
Data type string.text.value
timeentries__project__template
Field label Project is a template
Description Whether the project is a template or not
Field type dimension
Data type bool
timeentries__project__public
Field label Project is public
Description Whether the project is a public or not
Field type dimension
Data type bool
timeentries__project__cost_rate
Field label Project cost rate
Field type dimension
Data type float.currency.value
timeentries__project__hourly_rate
Field label Project hourly rate
Field type dimension
Data type float.currency.value
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
timeentries__project__budget_estimate
Field label Budget estimate
Description The estimated budget of the project
Field type dimension
Data type float.currency.value
timeentries__project__time_estimate
Field label Time estimate
Description The estimated time of the project
Field type dimension
Data type string.text.value
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
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

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
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
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
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

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
timeentries__year
Field label Year
Field type dimension
Data type string.time.year
timeentries__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
timeentries__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
timeentries__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
timeentries__month
Field label Month
Field type dimension
Data type string.time.month
timeentries__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
timeentries__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
timeentries__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
timeentries__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
timeentries__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
timeentries__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
timeentries__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
timeentries__date
Field label Date
Field type dimension
Data type string.time.date
timeentries__atom
Field label Datetime
Field type dimension
Data type string.time.datetime

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
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
timeentries__entry_start
Field label Entry start time
Description The start time of the time entry
Field type dimension
Data type string.time.datetime
timeentries__entry_end
Field label Entry end time
Description The end time of the time entry
Field type dimension
Data type string.time.datetime
timeentries__description
Field label Description
Description Time entry description
Field type dimension
Data type string.text.value
timeentries__billable
Field label Billable
Description Whether the time entry is billable or not
Field type dimension
Data type bool
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
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
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
timeentries__is_locked
Field label Is locked
Description Whether the time entry is locked or not
Field type dimension
Data type bool
timeentries__invoice_id
Field label Invoice ID
Description The unique ID of the time entry invoice
Field type dimension
Data type string.text.value
timeentries__invoice_number
Field label Invoice number
Description The invoice number of the time entry
Field type dimension
Data type string.text.value
timeentries__manually_invoiced
Field label Manually invoiced
Description Whether the time entry is invoiced manually or not
Field type dimension
Data type bool
timeentries__tags
Field label Tags
Field type dimension
Data type string.text.value
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
timeentries__count
Field label Entries
Description The number of time entries
Field type metric
Data type int.number.value
timeentries__duration_sec
Field label Duration (sec)
Description The duration of the time entry in seconds
Field type metric
Data type int.number.value
timeentries__duration_h
Field label Duration (h)
Description The duration of the time entry in hours
Field type metric
Data type float.number.value
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
timeentries__billable_amount
Field label Billable amount
Description The billable amount of the time entry
Field type metric
Data type float.currency.value

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

WORKSPACE

timeentries__client__workspace__id
Field label Workspace ID
Description The unique ID of the workspace
Field type dimension
Data type string.text.value
timeentries__client__workspace__name
Field label Workspace name
Description The name of the workspace
Field type dimension
Data type string.text.value