Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | projects_year | dim | Year |
| Year & month | projects_yearmonth | dim | Year and month | |
| Month | projects_month | dim | Month | |
| Project | Project ID | projects_project_id | dim | The unique ID of the project |
| Project name | projects_project_name | dim | The name of the project | |
| Client ID | projects_client_id | dim | The unique ID of the client | |
| Client name | projects_client_name | dim | The name of the client | |
| Currency | projects_currency | dim | The currency code associated with the client | |
| Total hours | projects_total_hours | met | The totaled hours for the given timeframe. If Time Rounding is turned on within Harvest, the hours will be rounded according to your settings | |
| Billable hours | projects_billable_hours | met | The totaled billable hours for the given timeframe. If Time Rounding is turned on within Harvest, the hours will be rounded according to your settings | |
| None-billable hours | projects_none_billable_hours | met | The totaled non-billable hours for the given timeframe. If Time Rounding is turned on within Harvest, the hours will be rounded according to your settings | |
| Billable rate (%) | projects_billable_rate | met | The percentage of hours that are marked as billable. Formula: Billable hours / Total hours | |
| Billable amount | projects_billable_amount | met | The totaled billable amount for the billable hours | |
| Time | Year | clients_year | dim | Year |
| Year & month | clients_yearmonth | dim | Year and month | |
| Month | clients_month | dim | Month | |
| Client | Client ID | clients_client_id | dim | The unique ID of the client |
| Client name | clients_client_name | dim | The name of the client | |
| Currency | clients_currency | dim | The currency code associated with the project | |
| Total hours | clients_total_hours | met | The totaled hours for the given timeframe. If Time Rounding is turned on within Harvest, the hours will be rounded according to your settings | |
| Billable hours | clients_billable_hours | met | The totaled billable hours for the given timeframe. If Time Rounding is turned on within Harvest, the hours will be rounded according to your settings | |
| None-billable hours | clients_none_billable_hours | met | The totaled non-billable hours for the given timeframe. If Time Rounding is turned on within Harvest, the hours will be rounded according to your settings | |
| Billable rate (%) | clients_billable_rate | met | The percentage of hours that are marked as billable. Formula: Billable hours / Total hours | |
| Billable amount | clients_billable_amount | met | The totaled billable amount for the billable hours | |
| Time | Year | tasks_year | dim | Year |
| Year & month | tasks_yearmonth | dim | Year and month | |
| Month | tasks_month | dim | Month | |
| Task | Task ID | tasks_task_id | dim | The unique ID of the task |
| Task name | tasks_task_name | dim | The name of the task | |
| Currency | tasks_currency | dim | The currency code associated with the task | |
| Total hours | tasks_total_hours | met | The totaled hours for the given timeframe. If Time Rounding is turned on within Harvest, the hours will be rounded according to your settings | |
| Billable hours | tasks_billable_hours | met | The totaled billable hours for the given timeframe. If Time Rounding is turned on within Harvest, the hours will be rounded according to your settings | |
| None-billable hours | tasks_none_billable_hours | met | The totaled non-billable hours for the given timeframe. If Time Rounding is turned on within Harvest, the hours will be rounded according to your settings | |
| Billable rate (%) | tasks_billable_rate | met | The percentage of hours that are marked as billable. Formula: Billable hours / Total hours | |
| Billable amount | tasks_billable_amount | met | The totaled billable amount for the billable hours | |
| Time | Year | team_year | dim | Year |
| Year & month | team_yearmonth | dim | Year and month | |
| Month | team_month | dim | Month | |
| Team | User ID | team_user_id | dim | The unique ID of the user |
| User name | team_user_name | dim | The name of the user | |
| Is contractor | team_is_contractor | dim | The contractor status of the user associated with the reported hours | |
| Currency | team_currency | dim | The currency code associated with the task | |
| Total hours | team_total_hours | met | The totaled hours for the given timeframe. If Time Rounding is turned on within Harvest, the hours will be rounded according to your settings | |
| Billable hours | team_billable_hours | met | The totaled billable hours for the given timeframe. If Time Rounding is turned on within Harvest, the hours will be rounded according to your settings | |
| None-billable hours | team_none_billable_hours | met | The totaled non-billable hours for the given timeframe. If Time Rounding is turned on within Harvest, the hours will be rounded according to your settings | |
| Billable rate (%) | team_billable_rate | met | The percentage of hours that are marked as billable. Formula: Billable hours / Total hours | |
| Billable amount | team_billable_amount | met | The totaled billable amount for the billable hours | |
| Time | Year | time_entries_year | dim | |
| Year of week (Sun-Sat) | time_entries_year_of_week | dim | ||
| Year of week (Mon-Sun) | time_entries_year_of_week_iso | dim | ||
| Year & month | time_entries_year_month | dim | ||
| Month | time_entries_month | dim | ||
| Year & week (Sun-Sat) | time_entries_year_week | dim | ||
| Year & week (Mon-Sun) | time_entries_year_week_iso | dim | ||
| Week (Sun-Sat) | time_entries_week | dim | ||
| Week (Mon-Sun) | time_entries_week_iso | dim | ||
| Day of month | time_entries_day_of_month | dim | ||
| Day of week (Sun-Sat) | time_entries_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | time_entries_day_of_week_name_iso | dim | ||
| Date | time_entries_date | dim | ||
| Datetime | time_entries_atom | dim | ||
| Time entry | Time entry ID | time_entries_time_entry_id | dim | The unique ID of the time entry |
| Spent date | time_entries_spent_date | dim | Date of the time entry | |
| Notes | time_entries_notes | dim | Notes attached to the time entry | |
| Is locked | time_entries_is_locked | dim | Whether or not the time entry has been locked | |
| Locked reason | time_entries_locked_reason | dim | Why the time entry has been locked | |
| Is closed | time_entries_is_closed | dim | Whether or not the time entry has been approved via Timesheet Approval in Harvest | |
| Is billed | time_entries_is_billed | dim | Whether or not the time entry has been marked as invoiced | |
| Timer started at | time_entries_timer_started_at | dim | Date and time the timer was started if tracking by duration | |
| Started time | time_entries_started_time | dim | Time the time entry was started if tracking by start/end times | |
| Ended time | time_entries_ended_time | dim | Time the time entry was ended if tracking by start/end times | |
| Is running | time_entries_is_running | dim | Whether or not the time entry is currently running | |
| Billable | time_entries_billable | dim | Whether or not the time entry is billable | |
| Budgeted | time_entries_budgeted | dim | Whether or not the time entry counts towards the project budget | |
| Billable rate | time_entries_billable_rate | dim | The billable rate for the time entry | |
| Cost rate | time_entries_cost_rate | dim | The cost rate for the time entry | |
| Time entry created at | time_entries_created_at | dim | Date and time the time entry was created | |
| Time entry updated at | time_entries_updated_at | dim | Date and time the time entry was updated | |
| User | User ID | time_entries_user_id | dim | The unique ID of the user associated with the time entry |
| User name | time_entries_user_name | dim | The name of the user associated with the time entry | |
| User assignment ID | time_entries_user_assignment_id | dim | The unique ID of the user assignment | |
| Is project manager | time_entries_is_project_manager | dim | Determines if the user has Project Manager permissions for the project | |
| User assignment is active | time_entries_user_assignment_is_active | dim | Determines whether the user assignment is active or archived | |
| Use default rates | time_entries_use_default_rates | dim | Determines which billable rate(s) will be used on the project for this user when billed by people. When true, the project will use the user's default billable rates. When false, the project will use the custom rate defined on this user assignment | |
| User assignment budget | time_entries_user_assignment_budget | dim | Budget used when the project is budgeted by person | |
| User assignment created at | time_entries_user_assignment_created_at | dim | Date and time the user assignment was created | |
| User assignment updated at | time_entries_user_assignment_updated_at | dim | Date and time the user assignment was updated | |
| User assignment hourly rate | time_entries_user_assignment_hourly_rate | dim | Custom rate used when the project is billed by people and default rate is not being used | |
| Client | Client ID | time_entries_client_id | dim | The unique ID of the client associated with the time entry |
| Client name | time_entries_client_name | dim | The name of the client associated with the time entry | |
| Client currency | time_entries_client_currency | dim | The currency used with the client associated with the time entry | |
| Project | Project ID | time_entries_project_id | dim | The unique ID of the project associated with the time entry |
| Project name | time_entries_project_name | dim | The name of the project associated with the time entry | |
| Project code | time_entries_project_code | dim | The code of the project associated with the time entry | |
| Task | Task ID | time_entries_task_id | dim | The unique ID of the task associated with the time entry |
| Task name | time_entries_task_name | dim | The name of the task associated with the time entry | |
| Task assignment ID | time_entries_task_assignment_id | dim | The unique ID of the task assignment | |
| Task assignment billable | time_entries_task_assignment_billable | dim | Determines whether the task assignment is billable or not. For example: if set to true, all time tracked on this project for the associated task will be marked as billable | |
| Task assignment is active | time_entries_task_assignment_is_active | dim | Determines whether the task assignment is active or archived | |
| Task assignment created at | time_entries_task_assignment_created_at | dim | Date and time the task assignment was created | |
| Task assignment updated at | time_entries_task_assignment_updated_at | dim | Date and time the task assignment was updated | |
| Task assignment hourly rate | time_entries_task_assignment_hourly_rate | dim | Custom rate used when the project is billed by tasks | |
| Task assignment budget | time_entries_task_assignment_budget | dim | Budget used when the project is budgeted by task | |
| Hours | time_entries_hours | met | The amount of hours clocked in the time entry | |
| Hours without timer | time_entries_hours_without_timer | met | The amount of hours clocked in the time entry before the timer was last started. | |
| Rounded hours | time_entries_rounded_hours | met | The amount of hours clocked in the time entry used in summary reports and invoices. This value is rounded according to the Time Rounding setting in your Preferences within Harvest | |
| Time entries | time_entries_entries | met | The number of time entries | |
| Client | Client ID | project_details_client_id | dim | The unique ID of the client |
| Client name | project_details_client_name | dim | The name of the client | |
| Currency | project_details_currency | dim | The currency code associated with the project | |
| Time | Created at | project_details_created_at | dim | Date and time the project was created. |
| Updated at | project_details_updated_at | dim | Date and time the project was last updated. | |
| Starts on | project_details_starts_on | dim | Date the project was started. | |
| Ends on | project_details_ends_on | dim | Date the project will end. | |
| Project | Project ID | project_details_id | dim | The unique ID of the project |
| Project name | project_details_name | dim | The name of the project | |
| Budget by | project_details_budget_by | dim | The method by which the project is budgeted. | |
| Budget is monthly | project_details_budget_is_monthly | dim | Option to have the budget reset every month. | |
| Cost budget include expenses | project_details_cost_budget_include_expenses | dim | Option for budget of Total Project Fees projects to include tracked expenses. | |
| Is active | project_details_is_active | dim | Whether the project is active or archived. | |
| Is billable | project_details_is_billable | dim | Whether the project is billable or not. | |
| Is fixed fee | project_details_is_fixed_fee | dim | Whether the project is a fixed-fee project or not. | |
| Bill by | project_details_bill_by | dim | The method by which the project is invoiced. | |
| Notes | project_details_notes | dim | Project notes. | |
| Budget | project_details_budget | met | The budget in hours for the project when budgeting by time. | |
| Cost budget | project_details_cost_budget | met | The monetary budget for the project when budgeting by money. | |
| Hourly rate | project_details_hourly_rate | met | Rate for projects billed by Project Hourly Rate. | |
| Fee | project_details_fee | met | The amount you plan to invoice for the project. Only used by fixed-fee projects. | |
| Users | User ID | team_details_id | dim | The unique ID of the user. |
| First name | team_details_first_name | dim | The first name of the user. | |
| Last name | team_details_last_name | dim | The last name of the user. | |
| team_details_email | dim | The email address of the user. | ||
| Telephone | team_details_telephone | dim | The user’s telephone number. | |
| Timezone | team_details_timezone | dim | The user’s timezone. | |
| Is contractor | team_details_is_contractor | dim | The contractor status of the user associated with the reported hours | |
| Is active | team_details_is_active | dim | Whether the user is active or archived. | |
| Roles | team_details_roles | dim | The role names assigned to this person. | |
| Avatar URL | team_details_avatar_url | dim | The URL to the user’s avatar image. | |
| Time | Created at | team_details_created_at | dim | Date and time the user was created. |
| Updated at | team_details_updated_at | dim | Date and time the user was last updated. | |
| Weekly capacity | team_details_weekly_capacity | met | The number of hours per week this person is available to work in seconds, in half hour increments. For example, if a person’s capacity is 35 hours, the API will return 126000 seconds. | |
| Default hourly rate | team_details_default_hourly_rate | met | The billable rate to use for this user when they are added to a project. | |
| Cost rate | team_details_cost_rate | met | The cost rate to use for this user when calculating a project’s costs vs billable amount. |