Use the Clockify connector to track time spent on different tasks by reporting all time entries added to Clockify. Fetch data by time, user, client, or project, and see the effective billing rate across your employees and projects.
Before you begin
Before you build reports, you need to connect the data source to Supermetrics.
Connection instructions: See our Clockify connection guide.
Available metrics and dimensions: Find the full list of fields in our Clockify field documentation.
Popular queries
These query configurations help you track key performance indicators and analyze trends. You can use these settings in any Supermetrics destination, such as Data Explorer, Dashboards, Google Sheets, Looker Studio, or data warehouse destinations.
Review time entries from last week
Get a daily view of how time was logged last week, so you can review workload distribution and identify any gaps in time tracking.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | Last week |
Metrics | Duration (h) |
Dimensions | Entry start date |
Suggested visualization | Table |
Understanding the data
Duration (h): The duration of the time entry in hours.
Entry start date: The date the time entry started, used to split results by day.
Compare billable hours and amounts month over month
See last month's total logged hours and billable amounts side by side with the previous month, so you can track trends in billing and resource utilization.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | Last month |
Date range comparison | Previous period |
Metrics | Amount, Duration (h) |
Suggested visualization | Table |
Understanding the data
Amount: The rounded value of the billable amount for the time entry.
Duration (h): The duration of the time entry in hours.
Break down billable hours by project and task
See billable amounts and total hours for the current month split by task description and task ID, giving you a detailed view of where time and budget are being spent across projects.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | This month to date |
Metrics | Amount, Duration (h) |
Dimensions | Description, Task ID |
Suggested visualization | Table |
Understanding the data
Amount: The rounded value of the billable amount for the time entry.
Duration (h): The duration of the time entry in hours.
Description: The description of the time entry, typically used to note what work was done.
Task ID: The unique identifier of the task the time entry is logged against, useful for linking entries to specific project tasks.
More resources
You might also be interested in: