Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | timeentries_year | dim | |
| Year of week (Sun-Sat) | timeentries_year_of_week | dim | ||
| Year of week (Mon-Sun) | timeentries_year_of_week_iso | dim | ||
| Year & month | timeentries_year_month | dim | ||
| Month | timeentries_month | dim | ||
| Year & week (Sun-Sat) | timeentries_year_week | dim | ||
| Year & week (Mon-Sun) | timeentries_year_week_iso | dim | ||
| Week (Sun-Sat) | timeentries_week | dim | ||
| Week (Mon-Sun) | timeentries_week_iso | dim | ||
| Day of month | timeentries_day_of_month | dim | ||
| Day of week (Sun-Sat) | timeentries_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | timeentries_day_of_week_name_iso | dim | ||
| Date | timeentries_date | dim | ||
| Datetime | timeentries_atom | dim | ||
| TIME ENTRY | Entry start date | timeentries_entry_start_date | dim | The start date of the time entry |
| Entry end date | timeentries_entry_end_date | dim | The end date of the time entry | |
| Entry start time | timeentries_entry_start | dim | The start time of the time entry | |
| Entry end time | timeentries_entry_end | dim | The end time of the time entry | |
| Description | timeentries_description | dim | Time entry description | |
| Billable | timeentries_billable | dim | Whether the time entry is billable or not | |
| Task ID | timeentries_task_id | dim | The unique ID of the task associated with the time entry | |
| Task name | timeentries_task_name | dim | The name of the task associated with the time entry | |
| Project ID | timeentries_project_id | dim | The unique ID of the project associated with the time entry | |
| Approval request ID | timeentries_approval_request_id | dim | The unique ID of the approval request associated with the time entry | |
| Is locked | timeentries_is_locked | dim | Whether the time entry is locked or not | |
| Invoice ID | timeentries_invoice_id | dim | The unique ID of the time entry invoice | |
| Invoice number | timeentries_invoice_number | dim | The invoice number of the time entry | |
| Manually invoiced | timeentries_manually_invoiced | dim | Whether the time entry is invoiced manually or not | |
| Tags | timeentries_tags | dim | ||
| USER | User ID | timeentries_user__id | dim | The unique ID of the user making the time entry |
| User name | timeentries_user__name | dim | The name of the user making the time entry | |
| User email | timeentries_user__email | dim | The email of the user making the time entry | |
| PROJECT | Project ID | timeentries_project__id | dim | |
| Project name | timeentries_project__project_name | dim | The name of the project associated with the time entry | |
| Project color | timeentries_project__project_color | dim | The color of the project associated with the time entry | |
| Project is billable | timeentries_project__billable | dim | Whether the project is billable or not | |
| Project is archived | timeentries_project__archived | dim | Whether the project is archived or not | |
| Project note | timeentries_project__note | dim | ||
| Project is a template | timeentries_project__template | dim | Whether the project is a template or not | |
| Project is public | timeentries_project__public | dim | Whether the project is a public or not | |
| Project cost rate | timeentries_project__cost_rate | dim | ||
| Project hourly rate | timeentries_project__hourly_rate | dim | ||
| Project hourly rate currency | timeentries_project__hourly_rate_currency | dim | The hourly rate currency of the project | |
| Budget estimate | timeentries_project__budget_estimate | dim | The estimated budget of the project | |
| Time estimate | timeentries_project__time_estimate | dim | The estimated time of the project | |
| Time estimate type | timeentries_project__time_estimate_type | dim | The time estimate type of the project | |
| Time estimate active | timeentries_project__time_estimate_active | dim | Whether the time estimate is active or not | |
| CLIENT | Client ID | timeentries_client__id | dim | The unique ID of the client associated with the time entry |
| Client name | timeentries_client__name | dim | The name of the client associated with the time entry | |
| Workspace ID | timeentries_client__workspace_id | dim | The unique ID of the workspace associated with the client | |
| Client is archived | timeentries_client__archived | dim | Whether the client is archived or not | |
| WORKSPACE | Workspace ID | timeentries_client__workspace__id | dim | The unique ID of the workspace |
| Workspace name | timeentries_client__workspace__name | dim | The name of the workspace | |
| Entries | timeentries_count | met | The number of time entries | |
| Duration (sec) | timeentries_duration_sec | met | The duration of the time entry in seconds | |
| Duration (h) | timeentries_duration_h | met | The duration of the time entry in hours | |
| Amount | timeentries_amount | met | The billable amount of the time entry. This value is rounded. | |
| Billable amount | timeentries_billable_amount | met | The billable amount of the time entry |