Skip to content
Knowledge Base

Clockify Data Connector User Guide

Last updated

Clockify is a time tracking app that teams use to log hours against projects and clients. With the Power My Analytics Clockify connector, you can bring your Clockify time entries, project details, and daily billable and cost totals into your reports.

Note: Clockify is a Beta connector. It is available in every Hub, where it appears in the source gallery with a BETA label. While it is in Beta, some fields, configuration options, and behavior may still change as we continue to improve it. We will expand this guide as the connector develops, and your feedback helps shape what comes next.

Prerequisites

Before you begin, make sure you have:

  • Access to the Clockify workspaces you want to report on.
  • A Clockify API key. Use the API key of a workspace Admin or Owner. You will copy it from Clockify and paste it into your Hub when you add the source.
  • Your workspace's data region, if your Clockify workspace was set up in a regional data center. Otherwise, you will choose Global.

Adding Clockify as a Data Source

  1. In your Power My Analytics Hub, select Sources from the menu.
  2. Click + Add new source and choose Clockify from the gallery.
  3. In the Connect Clockify window, enter your API Key. To find it in Clockify, click your profile picture, select Profile settings, open the Advanced tab, and go to Manage API keys to generate or copy your key.
  4. Under Data region, choose Global unless your Clockify workspace was set up in a regional data center, then click Connect.

Power My Analytics collects data for each Clockify workspace on the connected account.

Creating a Data Studio Report

  1. In your Hub, go to Reports > Data Studio and click the orange + Create report button.
  2. In the Templates window, select Single sources, find Clockify, and click Open in Data Studio.
  3. In Data Studio, click Authorize if you are prompted, then select your Power My Analytics Hub and the Clockify account you connected.
  4. Click Connect (top right), then click Create report.

Key Reports and Fields

The Clockify connector provides five tables:

  • Time Entries: your individual Clockify time entries.
  • Projects: your Clockify projects and their details.
  • Summary By Client, Summary By Project, and Summary By User: daily totals for each client, project, or user.

For the complete list of available Clockify fields, open the Clockify Schema Explorer in your Hub.

What you'll see in your report

  • Billable time and earnings, such as Billable Hours and Billable Amount.
  • Costs, such as Cost Amount and Cost Rate, with the Currency of your rates and amounts.
  • Client, project, and user details, such as Client Name, so you can see where your team's time goes.

Limitations and Important Considerations

  • Backfilling: Up to 24 months of historical data is available. Power My Analytics backfills 24 months when you first connect your Clockify account as a data source.
  • Beta connector: While Clockify is in Beta, fields, configuration options, and behavior may change. If a field is renamed or removed, you may need to update the reports that use it.

What does this mean for me?

  • Right after you connect, your reports can show up to two years of Clockify history. Older history fills in as the first backfill completes.
  • If a field changes during Beta, a chart that uses it may need to be updated.

Good to know

  • Your Clockify data refreshes once a day with the daily data sync.
  • Each daily data sync refreshes the past 7 days of data, so changes you make to recent time entries in Clockify appear after the next sync.

If there is a Clockify field or report you would like to see, please submit a ticket with a description or screenshot of what you need. Requests during Beta help us decide what to add next.

Troubleshooting

If your Clockify data does not look the way you expect, start with Basic Troubleshooting. A few Clockify patterns are worth checking first:

  • The connection fails when you click Connect: Power My Analytics checks your API key with Clockify before it connects. Copy the key again from Profile settings > Advanced > Manage API keys, and confirm that Data region matches your workspace.
  • A workspace or its data is missing: Connect with the API key of an Admin or Owner of that workspace.

Still have questions? Submit a ticket and our support team will be glad to help. Please include the connector name and a short description of what you are seeing; screenshots are always helpful.

Related Articles