Document toolboxDocument toolbox

Tempo Timesheets - Time Tracking & Reports

To be able to analyze 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 SQL, and SQL Connector for Jira is the proper solution for such integration.

Exporting Tempo Timesheets data from Jira to SQL can help solve the following issues:

  • You can forecast project complete terms

It’s a common practice for teams to underestimate the amount of time a project or certain tasks will take. With the data provided by time records in Tempo Timesheets, you can not only analyze your previous experience but also make assessments on how long it will take to finish the given task or project. You will have a basis for projections and can set more reasonable deadlines.

  • You can track billable hours

Analyse Tempo Timesheets data for billed hours by customers, projects, teams, assignees etc, as well as easily work with non-billed hours to minimize the risks of underpayment or missed hours.

Tempo fields are located in a separate tab.

Tempo.jpg

The following fields are available for export

Field Name

Field ID

Field Type

Field Name

Field ID

Field Type

Tempo

Tempo Account

<customfield>

String

Tempo Iteration

<customfield>

String

Tempo Team

<customfield>

String

Tempo Team Role

<customfield>

String

Teams

Team Name

TEAM_NAME

String

Team User Key

TEAM_USER_KEY

String

Team User Name

TEAM_USER_NAME

String

Team Role Id

TEAM_ROLE_ID

Int64

Team Role Name

TEAM_ROLE_NAME

String

Tempo Work Attributes

Work Attribute Name

WORK_ATTRIBUTE_NAME

String

Work Attribute Type

WORK_ATTRIBUTE_TYPE

String

Work Attribute Value

WORK_ATTRIBUTE_VALUE

String

Work Attribute Required

WORK_ATTRIBUTE_REQUIRED

Boolean

Worklog Id

WORK_ATTRIBUTE_WORKLOG_ID

Int64

Learn more about Tempo apps data analytics on Tempo blog

https://www.tempo.io/blog/how-to-integrate-tempo-data-with-business-intelligence-tools