# hiring metrics sheets
## Metadata

- Canonical URL: https://6ducklearn.com/skills/hiring-metrics-sheets/
- Markdown URL: https://6ducklearn.com/skills/hiring-metrics-sheets/index.md
- Product: skills
- Category: collaboration
- Tags: curated, google-workspace, hr, recruiting, hiring
- Updated: 2026-07-14T03:00:00.357428+00:00
## Summary
Build hiring metrics formulas in Gemini in Sheets and analyse hire data by department and month — a two-step Sheets workflow.
## Content
> **Attribution:** Prepared by 6DuckLearn. Inspired by [Google Workspace with Gemini Prompting Guide 101 (2025)](https://workspace.google.com).

## When to use this

You're an HR manager or recruiter who needs to analyse your hiring data in Google Sheets — whether setting up formulas to count hires by department, identifying which month saw the most hiring activity, or building a metrics dashboard.

## What you'll get

Ready-to-use Sheets formulas and follow-up analysis for your hiring data: COUNTIFS formulas broken down by department, month-over-month hiring trend analysis, and plain-language answers to data questions — all generated within your spreadsheet.

## Prompt template

Use this in **Gemini in Sheets** (with your hiring data sheet open):

```
Step 1 — Formula: Help me create a formula to calculate the total number of hires by department. My data has columns: [list your column headers, e.g. "Name, Department, Start Date, Role, Status"].

Step 2 — Analysis: In what month did we hire the most people? Show me the month-by-month breakdown.
```

**Fill in the variables:**
- `[list your column headers]` — paste your actual column headers so Gemini generates the correct column references (e.g. A, B, C)
- Run Step 1 first to get the formula; then run Step 2 as a follow-up in the same session for the analysis

## Customisation tips

- Add time filters: *"Show totals by department for Q1 2025 only"*
- Request a summary table: *"Create a new sheet with a pivot-style summary: Department | Total Hires | % of Total"*
- Track time-to-hire: *"Add a formula to calculate the average days between [Application Date] and [Start Date] by department"*
- Visualise the data: *"Create a bar chart showing monthly hires over the past 12 months"*

## Iteration suggestions

After Gemini builds your metrics:
1. **Report to leadership** → export key numbers and present them in the context of `survey-results-leadership-summary` format
2. **Identify process gaps** → bring findings back to `recruiting-process-improvement` to address any departments with low hire rates or long time-to-fill

## Related skills in this workflow

| Step | Skill | What it does |
|------|-------|--------------|
| 1 | `recruiting-process-improvement` | Brainstorm process improvements |
| 2 | `job-description-writer` | Write the job description |
| 3 | `interview-screening-questions` | Generate screening questions |
| 4 | `offer-letter-template` | Draft the offer letter |
| 5 | `rejection-letter-empathetic` | Write rejection letters |
| 6 → You are here | `hiring-metrics-sheets` | Build and analyse hiring metrics in Sheets |

## Related Skills

- [interview screening questions](https://6ducklearn.com/skills/interview-screening-questions/index.md): Generate 20 open-ended interview screening questions from an uploaded job description file using the Gemini app.
- [job description writer](https://6ducklearn.com/skills/job-description-writer/index.md): Write a compelling, tailored job description for a specific role and team in Gemini in Docs.
- [offer letter template](https://6ducklearn.com/skills/offer-letter-template/index.md): Draft a professional offer letter template for a selected candidate with a call-to-action to discuss details, in Gemini in Docs.
- [recruiting process improvement](https://6ducklearn.com/skills/recruiting-process-improvement/index.md): Generate a strategic list of improvements to the recruiting process and candidate identification methods in Gemini in Docs.
- [rejection letter empathetic](https://6ducklearn.com/skills/rejection-letter-empathetic/index.md): Write an empathetic, respectful rejection letter for unsuccessful job candidates in Gemini in Docs.
- [gemini hr recruiting hiring](https://6ducklearn.com/skills/gemini-hr-recruiting-hiring/index.md): Write job descriptions, generate interview questions, draft offer and rejection letters, and manage the recruiting pipeline with Gemini