Tempo Planner Overview
To be able to analyse Tempo apps data is necessary for the company owners to ensure making informed and timely decisions. That’s why it is important to integrate all Tempo plugins with business intelligence tools such as BigQuery, and BigQuery Connector for Jira is the proper solution for such integration.
Learn more about Tempo apps data analytics on Tempo blog.
Tempo Planner fields can be found in the Tempo tab.
How to Add Tempo Client ID
Tempo Client ID is required to view and export the Tempo Planner data.
Being signed in to your Jira Cloud instance, select Apps, and then select BigQuery Connector for Jira.
On the left-side menu, select Tokens, select Tempo, and then copy the redirect URL.
Select Apps, and then select Tempo.
For your convenience, open Tempo in a new tab. To do it, right-click on Tempo, and then select Open link in new tab.
Select ⚙️.
Scroll down, select OAuth 2.0 Applications, and then select + New Application.
In the Name field, enter any name you’d like.
In our case, it’s BigQuery Connector, you can select any other name.
In the Redirect URLs, field, paste the redirect URL.
The redirect URL for this form was copied in step 2.
In the Client type field, select Public.
In the Authorization grant type, select Authorization code.
Select Create Application.
The Credentials pop-up window will appear.
Copy the client ID and client secret, and then close the window.
Go back to Tokens, the Tempo tab.
Paste your client ID and client secret to the corresponding fields, and then select Validate & Save.
Select Authorize Access.
The Success! message will appear.
Select Onwards!
Starting now, all users with granted permission to work with the data sources can select Tempo and Tempo Cost Tracker tables and fields for export.
Tempo Tables Overview
Table Name | Table Fields References |
|---|---|
Tempo Teams |   |
Tempo Team Members | .gif?version=1&modificationDate=1716459690575&cacheVersion=1&api=v2&width=966&height=563)  |
Tempo Team Projects | .gif?version=1&modificationDate=1716459690593&cacheVersion=1&api=v2&width=980&height=565)  |
Tempo Accounts |   |
Tempo Account Projects |   |
Tempo Work Attributes |   |
Tempo Worklogs Tempo Worklogs are exported together with Jira Issue Worklogs. You can find it under the Jira Work Management tab. Check also how worklogs dates are exported. |   |
Tempo Work Log Work Attributes |   |
Tempo Plans |   |
Tempo Programs |   |
Tempo Holiday Schemes |    |
Tempo Holidays |   |
Tempo Workloads |   |
Tempo Timesheet Reviewers |   |
Tempo Timesheet Approvals |   |