zrosenfield/hiring-pipeline-report

Hiring Pipeline Report

Reads the Open Roles list and the Candidates list from the current SharePoint site, analyzes the data, and generates a single self-contained HTML file that serves as an executive hiring dashboard for Zava Industries.

---

Step 1: Read the Data

Read all items from both lists before generating anything.

From Open Roles, collect: role title, department, hiring manager, priority, target start date, and status.

From Candidates, collect: candidate name, role (matches a title in Open Roles), current stage, days in stage, source, recruiter, applied date, and notes.

---

Step 2: Calculate Metrics

Compute these four summary figures:

• Open Roles — count of roles where Status is Open
• Active Candidates — count of candidates whose Current Stage is not Hired, Rejected, or Withdrawn
• Avg Days in Stage — average of Days in Stage across all active candidates
• Pipeline-to-Offer Rate — percentage of all candidates who have reached the Offer or Hired stage

---

Step 3: Generate the HTML Dashboard

Produce a single, completely self-contained HTML file with all CSS and JavaScript embedded inline. Load D3 (version 7) and the D3-Sankey plugin (version 0.12.3) from CDN — these are the only external dependencies allowed.

Branding

Apply Zava Industries brand constants throughout:

| Token | Value | |---|---| | Primary (navy) | #1B2A4A | | Accent (blue) | #3B82F6 | | Success (green) | #10B981 | | Warning (amber) | #F59E0B | | Danger (red) | #EF4444 | | Page background | #F8FAFC | | Card background | #FFFFFF | | Font stack | system-ui, -apple-system, "Segoe UI", sans-serif |

Page Layout

Header — full-width navy bar with "ZAVA INDUSTRIES" in white bold tracked caps, subtitle "Hiring Pipeline Status Report" in lighter weight, and the report generation date right-aligned.

Metrics bar — four cards in a row, one per computed metric. Each card shows the large number, a label below it, and a colored left-border accent. Use green for Open Roles, blue for Active Candidates, amber for Avg Days in Stage, and the accent blue for Pipeline-to-Offer Rate.

Sankey diagram — titled "Candidate Flow by Stage." Build the diagram using D3 and the D3-Sankey plugin. Nodes are the pipeline stages in progression order: Applied, Phone Screen, Interview, Final Round, Offer, Hired — plus exit nodes Rejected and Withdrawn. Count candidates at each stage and calculate flows: a candidate currently in Interview counts as flows through Applied, Phone Screen, and Interview. Color forward-progression flows in a gradient from light blue to accent blue; Rejected exits in red at reduced opacity; Withdrawn exits in gray at reduced opacity. Minimum diagram size is 700px wide by 400px tall, responsive within its card container. If D3 fails to load, show a plain fallback message instead of a broken diagram.

Risk callouts — titled "Risks and Attention Needed." Scan the data and produce callout cards for each of the following patterns found:

• Stale Candidates — any candidate with Days in Stage greater than 10 in Phone Screen, Interview, or Final Round. Show their name, role, stage, and days stuck. Use amber (warning) styling.
• Starved Roles — any Open role that has fewer than two active candidates in the pipeline. Use red (danger) styling.
• Bottleneck Stages — any stage that has more than three times as many candidates as the stage immediately after it. Call out the stage and ratio. Use amber styling.
• Offer Pending — any candidate in the Offer stage for more than three days. Flag as needing follow-up. Use blue (info) styling.

Lay these out as a two-column grid on desktop, single column on mobile.

Breakdown table — titled "Pipeline by Role." One row per Open role with columns: Role Title, Department, Priority (color-coded badge: Critical=red, High=amber, Normal=gray), Active Candidates (count), Furthest Stage (most advanced stage any candidate for that role has reached), and Avg Days (average days in stage for candidates on that role). Sort by Priority descending (Critical first), then by Active Candidates ascending so starved roles surface first.

Footer — "Generated by Zava AI · Confidential" in small gray text.

Design Standards

Use CSS Grid or Flexbox for layout. Cards should have subtle box-shadow and 8px border-radius. Include a print media block that hides decorative elements. Minimum body font size is 14px; minimum table cell font size is 13px. Add a subtle 0.3-second fade-in animation on page load for all cards.

---

Output

Deliver a single HTML file. Do not include any explanatory text outside the file — the entire response is the file content.