Custom Pipeline Reports

Table of Contents

For a basic export of candidates based on a specific pipeline stage or date for a particular position, the Custom Pipeline Report is suitable. For more advanced features, such as filtering by current pipeline status and grouping to display only the candidate’s latest pipeline record for the specified position, we recommend using the Custom Applicant Tracking Report.

Creating a Custom Pipeline Report #

  1. Choose “Reports” on the main toolbar.
  2. Click on the action icon labeled “Manage Custom Reports.”
  3. Click on the “Custom Pipeline Reports” tab.
  4. Select “Add” to create a new report.
  5. In the “Custom Company Report Header” section, replace [[Report Title]] with a suitable name for your report.
  6. Begin populating the cells in the “Body Rows” section by clicking on the first cell and choosing the desired field.
  7. Continue selecting fields from left to right and row to row, with the option to choose up to 18 fields. Keep in mind the field prefixes:
    • Fields starting with “Name” pertain to the candidate.
    • Fields starting with “Company” relate to the company associated with the job.
    • Fields starting with “Position” are relevant to the job itself.
    • Fields beginning with “Interview” correspond to specific stages in the pipeline.
  8. As you select a field, the field name will appear in the Header Row cells. In the “Header Rows” section, you can customize the cell content by replacing it with your preferred text to describe the contents.
  9. Utilize the “Field Groups” section to present a list of unique values for the selected field, along with a count of records associated with each unique value. For instance, you can choose the [[Name.Details.EEOC_Source]] field to display a breakdown of the record count based on the candidate’s source.
  10. Once all selections are complete, click “Save.” Your report will be accessible in the “Pipeline Reports” section under the “Reports” menu.

Generating a Custom Pipeline Report #

  1. Choose “Reports” on the main toolbar.
  2. Select “Pipeline Reports.”
  3. Click on the name of the desired report.
  4. In the ‘Search Params” area, you have the option to:
    • Select a Rollup List of Companies, Names, or Positions.
    • Limit by Date Range, based on the Appointment Date of the Pipeline record.
    • Choose your sorting preference using the “Order By” dropdown, followed by selecting either ascending or descending order.
  5. Use the options in the “Filters” section to further refine your results:
    • Filter by Contact Name: narrows results based on the Contact Name of the Position record.
    • Filter by User Name: narrows results based on the User Name of the Position record.
    • Filter by Company Name: narrows results based on the associated Company Name.
    • Filter by Position Title: narrows results based on the Title field of the position record(s). Note: Use the Position ID field for specific job limitations.
    • Filter by Position ID: narrows results based on the Position ID field for a specific position record.
    • Filter by Candidate Status: narrows results based on the Status field of the candidate’s Name record (e.g., C, D, P).
    • Filter by Position Status: narrows results based on the Status field of the Position record (e.g., A, F, C).
    • Filter by Interview Type/Status: narrows results based on the pipeline stage (e.g., Resume/Submitted). Please note that the Custom Applicant Tracking Report also offers a “Filter by Current Interview Type/Status” option. If you only want rows returned based on the current status, consider using a Custom Applicant Tracking Report.
  6. Access the action menu and opt for your desired export format (Note: Export options beyond PDF View Mode depend on your Export Reports security setting).