Excel Report: Openings
Overview
The Openings Excel Report allows you to export comprehensive information about your job openings into an Excel file for reporting, analysis, and offline use.
Generate the Report
To generate an Openings Excel Report:
-
Click the Reports icon in the left navigation menu.
-
At the bottom of the Reports dashboard, select Excel Reports.
- Choose the date range for the report.
- Select one of the predefined date ranges, or
-
Choose Custom to specify your own date range.
- Select Openings Report.
-
Click Generate Report.
The report will be generated and emailed to the email address associated with your Trakstar Hire account.
Note: Reports are typically delivered within 10 minutes. If you don't receive the email, check your Spam or Promotions folder. If it's still missing, contact hire@trakstar.com for assistance.
Data Included in the Openings Report
The Openings Excel Report includes the following fields.
| Field | Description |
|---|---|
| Opening Public ID | A unique, system-generated identifier for the job opening. |
| Opening Name | The name of the job opening. |
| Opening Created By | The user who created the opening. |
| Opening Status | The current status of the opening. See the status definitions below. |
| Is Archived? | Displays Yes if the opening is archived; otherwise displays No. |
| Location | The location assigned to the opening. |
| Opening Team | The team assigned to the opening if your organization uses Teams. |
| Opening Creation Date | The date the opening was created. |
| Opening Info | Displays any Opening Custom Field questions and responses configured for the opening. |
Opening Status Values
The Opening Status field can display one of the following values:
| Status | Description |
|---|---|
| Hiring | The opening is published or available for internal hiring. |
| Not Accepting Candidates | The opening is no longer accepting applications. |
| Archived | The opening has been archived. |
| Draft | The opening has been saved but has not yet been published. |
Frequently Asked Questions
Can I customize which columns are included in the report?
No. The report always includes all available fields. If there are columns you don't need, you can remove them after downloading the Excel file.
Can I generate the report for only specific openings?
The report includes all openings within the selected date range. After downloading the report, you can sort or filter the spreadsheet to remove openings you don't need.
Can I sort or filter the Excel file?
Yes. Once downloaded, you can use Microsoft Excel's built-in sorting and filtering features to organize the data.
Can I download the report in another format?
Reports are generated as Excel files. If needed, you can upload the file into Google Sheets or another spreadsheet application.
Can reports be emailed to non-users?
No. Reports are sent only to the email address of the user who generated the report. You can forward the report after receiving it if it needs to be shared externally.
What should I do if I don't receive my report?
First, check your Spam or Promotions folder. If the report still hasn't arrived after approximately 10 minutes, contact hire@trakstar.com for assistance.