Excel Report: Openings

The Excel reports within Hire allow you to pull comprehensive data to view and work with outside the system. This article will cover the details of the Interview Reports within the Excel reports.

Pulling the Report

Click the " Reports" icon on the left bar of your Trakstar Hire screen.

At the bottom of your Reports Dashboard, choose Excel Reports.

You’ll see the Excel reporting options.  Select the date range you'd like to view - either one of the built-in options or a custom date range.

Select Openings Report.

Click Generate Report at the bottom of the screen.  The report will be generated and sent to you via email.  

Note: The report should land in your inbox within ten minutes and go to the email address you use to log in to Hire. Be sure to check your spam/promotions folders! If you still don’t see it, give us a shout at hire@trakstar.com.

Data in the Openings Report

What data is shown in this report? Let's break down each field and column in the Excel report.

  • Opening Public ID: A unique, system-generated ID code that is specific to a job opening
  • Opening Name: The name of your job opening
  • Opening Created By: The name of the user in your account who created the opening.
  • Hiring Status: This status corresponds with the openings' current status in the system:

    1. Hiring: The opening is set as Published or Used Internally for active hiring. 

    2. Not Accepting Candidates: The opening is set as Not Accepting Candidates.

    3. Archived: The opening is set as Archived.

    4. Draft: The opening has been saved as a draft but not yet published. 

  • Is Archived?: If a job opening status is set as Archived, this column will read Yes.  If the job opening status is set as any other status, the column will read No.
  • Location: The location that has been set for the opening.
  • Opening Team: If your company uses Teams to organize your openings on the Hosted Site or Jobs Widget, this field will display the assigned teams.
  • Opening Creation Date: The date that the opening was created.
  • Opening Info: If your company uses Opening Custom Fields to add additional details to an opening, this field will display the questions and answers here.

Frequently Asked Questions

If you aren’t finding your question or answer here, feel free to reach out to us at hire@trakstar.com, and we’d be happy to help!

Can I customize what this report pulls?

The system is hard-coded to pull all the data fields in this report. If there is a column in this report you don’t need, you can delete it from the Excel file once you’ve downloaded it!

Can I only pull the data for specific openings or candidates?

This report was designed to pull the data for all openings within your selected date range. Once you’ve downloaded the Excel file, you can sort the report by openings and remove the ones you do not wish to see. 

How do I sort or filter the data in the Excel file?

Once you download the Excel file, you can filter or sort the data in several ways that fit your needs. Here is how you can learn about filtering in Microsoft Excel.

Can I download this report in any other format?

The system automatically puts the report in Excel format, but you can upload it to Google Sheets if you’d like!

Can the system send reports to non-users?

When generating a report, the system will email the report to the user email address who generated the report. You can always forward the report to a non-user once you receive the report.

What if the report doesn’t come to my email?

Please check your spam folder to ensure the report hasn't landed there. If you still can't locate it, please contact us at hire@trakstar.com.

Still need help? Contact Us Contact Us