{"id":11691,"date":"2023-12-01T22:02:27","date_gmt":"2023-12-01T22:02:27","guid":{"rendered":"https:\/\/docs.pcrecruiter.net\/site\/?post_type=docs&#038;p=11691"},"modified":"2024-05-09T19:42:00","modified_gmt":"2024-05-09T19:42:00","password":"","slug":"custom-pipeline-reports","status":"publish","type":"docs","link":"https:\/\/learnsuite.pcrecruiter.net\/site\/docs\/custom-reports\/custom-pipeline-reports\/","title":{"rendered":"Custom Pipeline Reports"},"content":{"rendered":"\n<p>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 <em>current<\/em> pipeline status and <em>grouping<\/em> to display only the candidate&#8217;s latest pipeline record for the specified position, we recommend using the <a href=\"https:\/\/www.pcrecruiter.net\/site\/suite\/docs\/custom-reports\/custom-applicant-tracking\/\" data-type=\"docs\" data-id=\"11661\" target=\"_blank\" rel=\"noopener\">Custom Applicant Tracking Report<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Creating a Custom Pipeline Report<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Click \u201cReports\u201d on the main toolbar.<\/li>\n\n\n\n<li>Click on the \u201cManage Custom Reports\u201d action icon.<\/li>\n\n\n\n<li>Click on the \u201cCustom Pipeline Reports\u201d tab.<\/li>\n\n\n\n<li>Click the \u201cAdd\u201d button to create a new report.<\/li>\n\n\n\n<li>In the \u201cCustom Tracking Report\u201d section, replace the placeholder [[Report Title]] with your desired report name.<\/li>\n\n\n\n<li>Begin populating the cells in the &#8220;Body Rows&#8221; section by clicking on the first cell and choosing the desired field.<\/li>\n\n\n\n<li>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:\n<ul class=\"wp-block-list\">\n<li>Fields starting with &#8220;Name&#8221; pertain to the candidate.<\/li>\n\n\n\n<li>Fields starting with &#8220;Company&#8221; relate to the company associated with the job.<\/li>\n\n\n\n<li>Fields starting with &#8220;Position&#8221; are relevant to the job itself.<\/li>\n\n\n\n<li>Fields beginning with &#8220;Interview&#8221; correspond to specific stages in the pipeline.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Customize Header Rows:\n<ul class=\"wp-block-list\">\n<li>As you select a field, the field name will populate the Header Row cells. For example, you can change the header from &#8220;Company_Name&#8221; to &#8220;Client.&#8221;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Use Field Groups (Optional)\n<ul class=\"wp-block-list\">\n<li>In the &#8220;Field Groups&#8221; section, you can display a list of unique values for the selected field and a count of records 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&#8217;s source.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Include Totals (Optional)\n<ul class=\"wp-block-list\">\n<li>In the &#8220;Totals&#8221; area, you can include a count of how many records contain data in the selected field. <\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Save your Custom Pipeline Report:\n<ul class=\"wp-block-list\">\n<li>Once you\u2019ve made all your selections and configured your report to your satisfaction, click \u201cSave.\u201d Your custom report will be accessible in the \u201cPipeline Reports\u201d section under the Reports menu.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"532\" src=\"https:\/\/learnsuite.pcrecruiter.net\/site\/wp-content\/uploads\/sites\/7\/2023\/12\/Custom-pipeline-Report-1024x532.jpg\" alt=\"\" class=\"wp-image-11702\" srcset=\"https:\/\/learnsuite.pcrecruiter.net\/site\/wp-content\/uploads\/sites\/7\/2023\/12\/Custom-pipeline-Report-1024x532.jpg 1024w, https:\/\/learnsuite.pcrecruiter.net\/site\/wp-content\/uploads\/sites\/7\/2023\/12\/Custom-pipeline-Report-300x156.jpg 300w, https:\/\/learnsuite.pcrecruiter.net\/site\/wp-content\/uploads\/sites\/7\/2023\/12\/Custom-pipeline-Report-768x399.jpg 768w, https:\/\/learnsuite.pcrecruiter.net\/site\/wp-content\/uploads\/sites\/7\/2023\/12\/Custom-pipeline-Report-360x187.jpg 360w, https:\/\/learnsuite.pcrecruiter.net\/site\/wp-content\/uploads\/sites\/7\/2023\/12\/Custom-pipeline-Report.jpg 1412w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Generating a Custom Pipeline Report<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Choose &#8220;Reports&#8221; on the main toolbar.<\/li>\n\n\n\n<li>Select &#8220;Pipeline Reports.&#8221;<\/li>\n\n\n\n<li>Click on the name of the desired report.<\/li>\n\n\n\n<li>In the &#8216;Search Params&#8221; area, you have the option to:\n<ul class=\"wp-block-list\">\n<li>Select a Rollup List of Companies, Names, or Positions.<\/li>\n\n\n\n<li>Limit by Date Range, based on the Appointment Date of the Pipeline record.<\/li>\n\n\n\n<li>Choose your sorting preference using the &#8220;Order By&#8221; dropdown, followed by selecting either ascending or descending order.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Use the options in the &#8220;Filters&#8221; section to further refine your results:\n<ul class=\"wp-block-list\">\n<li>Filter by Contact Name: narrows results based on the Contact Name of the Position record.<\/li>\n\n\n\n<li>Filter by User Name: narrows results based on the User Name of the Position record.<\/li>\n\n\n\n<li>Filter by Company Name: narrows results based on the associated Company Name.<\/li>\n\n\n\n<li>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.<\/li>\n\n\n\n<li>Filter by Position ID: narrows results based on the Position ID field for a specific position record.<\/li>\n\n\n\n<li>Filter by Candidate Status: narrows results based on the Status field of the candidate\u2019s Name record (e.g., C, D, P).<\/li>\n\n\n\n<li>Filter by Position Status: narrows results based on the Status field of the Position record (e.g., A, F, C).<\/li>\n\n\n\n<li>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 &#8220;Filter by Current Interview Type\/Status&#8221; option. If you only want rows returned based on the current status, consider using a Custom Applicant Tracking Report.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>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).<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"500\" src=\"https:\/\/learnsuite.pcrecruiter.net\/site\/wp-content\/uploads\/sites\/7\/2023\/12\/CPR-Filters-1024x500.jpg\" alt=\"\" class=\"wp-image-11716\" srcset=\"https:\/\/learnsuite.pcrecruiter.net\/site\/wp-content\/uploads\/sites\/7\/2023\/12\/CPR-Filters-1024x500.jpg 1024w, https:\/\/learnsuite.pcrecruiter.net\/site\/wp-content\/uploads\/sites\/7\/2023\/12\/CPR-Filters-300x147.jpg 300w, https:\/\/learnsuite.pcrecruiter.net\/site\/wp-content\/uploads\/sites\/7\/2023\/12\/CPR-Filters-768x375.jpg 768w, https:\/\/learnsuite.pcrecruiter.net\/site\/wp-content\/uploads\/sites\/7\/2023\/12\/CPR-Filters-360x176.jpg 360w, https:\/\/learnsuite.pcrecruiter.net\/site\/wp-content\/uploads\/sites\/7\/2023\/12\/CPR-Filters.jpg 1337w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>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&#8217;s latest pipeline record for the specified position, we recommend using the Custom Applicant&hellip; <a class=\"more-link\" href=\"https:\/\/learnsuite.pcrecruiter.net\/site\/docs\/custom-reports\/custom-pipeline-reports\/\">Continue reading <span class=\"screen-reader-text\">Custom Pipeline Reports<\/span><\/a><\/p>\n","protected":false},"author":34,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[86],"glossaries":[],"doc_tag":[],"knowledge_base":[26],"class_list":["post-11691","docs","type-docs","status-publish","hentry","doc_category-custom-reports","knowledge_base-pcrm","entry"],"year_month":"2026-04","word_count":622,"total_views":"448","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"rmontoni","author_nicename":"rmontoni","author_url":"https:\/\/learnsuite.pcrecruiter.net\/site\/author\/rmontoni\/"},"doc_category_info":[{"term_name":"Custom Reports","term_url":"https:\/\/learnsuite.pcrecruiter.net\/site\/docs\/pcrm\/custom-reports\/"}],"doc_tag_info":[],"knowledge_base_info":[{"term_name":"PCRM","term_url":"https:\/\/learnsuite.pcrecruiter.net\/site\/docs\/pcrm\/","term_slug":"pcrm"}],"knowledge_base_slug":["pcrm"],"_links":{"self":[{"href":"https:\/\/learnsuite.pcrecruiter.net\/site\/wp-json\/wp\/v2\/docs\/11691","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learnsuite.pcrecruiter.net\/site\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/learnsuite.pcrecruiter.net\/site\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/learnsuite.pcrecruiter.net\/site\/wp-json\/wp\/v2\/users\/34"}],"replies":[{"embeddable":true,"href":"https:\/\/learnsuite.pcrecruiter.net\/site\/wp-json\/wp\/v2\/comments?post=11691"}],"version-history":[{"count":5,"href":"https:\/\/learnsuite.pcrecruiter.net\/site\/wp-json\/wp\/v2\/docs\/11691\/revisions"}],"predecessor-version":[{"id":12742,"href":"https:\/\/learnsuite.pcrecruiter.net\/site\/wp-json\/wp\/v2\/docs\/11691\/revisions\/12742"}],"wp:attachment":[{"href":"https:\/\/learnsuite.pcrecruiter.net\/site\/wp-json\/wp\/v2\/media?parent=11691"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/learnsuite.pcrecruiter.net\/site\/wp-json\/wp\/v2\/doc_category?post=11691"},{"taxonomy":"glossaries","embeddable":true,"href":"https:\/\/learnsuite.pcrecruiter.net\/site\/wp-json\/wp\/v2\/glossaries?post=11691"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/learnsuite.pcrecruiter.net\/site\/wp-json\/wp\/v2\/doc_tag?post=11691"},{"taxonomy":"knowledge_base","embeddable":true,"href":"https:\/\/learnsuite.pcrecruiter.net\/site\/wp-json\/wp\/v2\/knowledge_base?post=11691"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}