Recruitment Agencies Dashboard in Google Sheets

The Recruitment Agencies Dashboard in Google Sheets reports 16 KPI cards, 18 charts and 15 slicers across six tabs, all driven by native pivot tables. The sample desk it ships with holds 500 requisitions worth $3,980,400 in fee revenue, 222 placements, a 39-day average time-to-fill and 5,240 candidate submissions. Setup takes under 10 minutes: paste your own requisition log over the sample rows and every page redraws itself.

🌍 Join 8,400+ teams in 40+ countries using NextGenTemplates to replace paid SaaS tools with one-time-purchase Excel, Google Sheets, Power BI and HTML templates.

✅ Instant download · One-time payment · No subscription · No per-user fees · Lifetime access

🔑 Key Features of the Recruitment Agencies Dashboard

🎯 Four analysis pages, one requisition log. Overview reports agency-wide performance, Clients covers portfolio and industry mix, Candidates covers sourcing channels and salary benchmarks, and Recruiters ranks desk billings. Every page reads the same Data sheet, so a single paste updates all four.

📌 Built on native pivot tables and slicers, not helper formulas. Each chart reads a pivot table parked to the right of its page. Click a slicer — Month, Client Industry, Job Category, Status, Contract Type, Seniority or Recruiter — and every chart, pivot and Top 5 panel on that page refilters together.

💰 Fee-revenue reporting at four levels. The dashboard splits $3,980,400 of billings by client industry, by contract type (Permanent 61.3%, Executive search 15.8%, Contract 12.7%, Temporary 10.1%), by job category and by recruiter, so you can see which desk and which vertical actually pays the bills.

⏱️ Speed and conversion metrics that recruiters argue about. Average time-to-fill of 39 days, a fastest fill of 7 days and a slowest of 123, submissions-per-placement of 23.6, a 44.4% placement rate and an offer-acceptance gauge reading 82.5 are all calculated from the log, not typed in.

🔎 A record-level Search tab. Pick any Placement ID and the page returns all 16 fields for that requisition — client, recruiter, source, fee, salary, time to fill, submissions, status, contract type, month and quarter.

📈 Auto-expanding to 1,000 rows. Pivots, slicers and every formula already cover 1,000 data rows. Paste new requisitions anywhere up to row 1001 and the dashboard picks them up with no range editing.

📦 What’s Inside the Recruitment Agencies Dashboard in Google Sheets

Page 1: Overview — Agency-Wide Performance

Four KPI cards report Total Fee Revenue, Placements Made, Avg Time to Fill and Avg Fee / Placement, with Month, Client Industry, Job Category and Status slicers above them. Charts include Placements by Job Category, Offer Acceptance Rate %, Fee Revenue by Client Industry, Monthly Placements, and Fee Revenue vs Average Time-to-Fill. The sidebar carries an Agency Snapshot, a Top 5 Clients by Fee Revenue table, a Pipeline Status Mix bar set and an At a Glance list.

Page 2: Clients — Portfolio, Industry Mix and Fee Value

Cards report Active Clients, Permanent Fees, Requisitions and Avg Fee per Client, filtered by Client Industry, Contract Type, Seniority and Month. Charts include Fee Revenue by Industry and Contract Type, Average Salary vs Fee Revenue by Client, Time-to-Fill Distribution by Client, and Requisitions by Client Industry, alongside a Top 5 Industries by Fee Revenue table and a Contract Type Fee Share panel.

Page 3: Candidates — Sourcing Channels and Salary Benchmarks

Cards report Candidates Submitted, Submissions / Place, Avg Salary Offered and Referral Share. Charts include Candidates Submitted by Source, Placements by Contract Type, Average Salary by Job Category, Monthly Candidates Submitted, Requisitions vs Time-to-Fill by Seniority, and Monthly Average Salary Offered. A Candidate Source Mix panel ranks LinkedIn, job boards, referrals and the agency database, and an At a Glance list breaks the pool down by seniority.

Page 4: Recruiters — Desk Billings, Speed and Pipeline Quality

Cards report Total Billings, Active Recruiters, Billings / Desk and Placement Rate, filtered by Recruiter, Contract Type and Month. Charts include Fee Revenue by Recruiter, Average Time-to-Fill by Recruiter and Pipeline Status Mix, next to a Top 5 Recruiters by Billings league table, an Outcome Mix panel and an At a Glance list splitting permanent, contract, executive-search and temporary desks.

Page 5: Search — Placement Record Lookup

Type or pick a Placement ID and the page returns the full record: date, client industry, job category, seniority, client name, recruiter, candidate source, fee revenue, salary offered, time to fill, candidates submitted, status, contract type, month and quarter.

Page 6: Instructions — 10-Step User Guide

A built-in guide explains the pivot-and-slicer architecture, how to clear a slicer, why the KPI cards use SUMIFS and COUNTIFS to stay unfiltered by design, how the 1,000-row auto-expand works and which columns must keep their headers.

Data Sheet

The Data tab holds 500 sample requisitions across 16 columns — Placement ID, Date, Client Industry, Job Category, Seniority, Client Name, Recruiter, Candidate Source, Fee Revenue, Salary Offered, Time to Fill (Days), Candidates Submitted, Status, Contract Type, Month and Quarter. The sample rows are demo data; replace them with your own and keep the headers.

📊 Recruitment Agencies Dashboard in Google Sheets vs. Microsoft Excel Dashboard vs. Bullhorn / JobAdder / Vincere

For agencies that want desk-level billing visibility without paying per-seat ATS fees, the Recruitment Agencies Dashboard in Google Sheets sits in the sweet spot.

👥 Who This Template Is For — and Who It’s Not For

✅ This template is built for:

• Owners and directors of recruitment or staffing agencies with 3-30 recruiters who need a monthly billing and pipeline review
• Recruitment team leads who report placements, time-to-fill and fee revenue to a board or client every month
• Independent recruiters and small search firms who already track requisitions in a spreadsheet and want the charts built for them
• In-house talent acquisition teams that want agency-style desk reporting without buying another HR and payroll system

❌ This template is NOT for:

• Agencies that need a live ATS — this reports on your placement log, it does not parse CVs, post jobs or hold candidate records
• Teams needing SSO, audit trails or SOC 2 controls over candidate personal data
• Anyone wanting automated invoicing, payroll or timesheet processing for contractors
• Desks logging more than 1,000 requisitions per period without extending the pivot ranges first

⚙️ How to Use the Recruitment Agencies Dashboard

1. Open the PDF in your download and click the “Make a copy” link to create your own editable copy in Google Drive.
2. Open the Instructions tab and read the 10-step guide — it explains the pivot and slicer layout in two minutes.
3. Go to the Data sheet, delete the 500 sample rows and paste your own requisitions under the same 16 headers.
4. Refresh the pivot tables; every chart, KPI card and Top 5 panel redraws from your numbers.
5. Click any slicer to filter a page by month, industry, job category, seniority, contract type, status or recruiter.
6. Use the Search tab to pull a single Placement ID when a client or recruiter queries one deal.
7. Share the file with your team using Google Sheets link sharing, view-only for clients.

💼 Real-World Use Cases

Priya runs a 10-desk technology recruitment agency in Manchester. Every Monday she opens the Recruiters page, checks the billings league table and the average time-to-fill bar chart, and knows within a minute which desk is slipping — without exporting a report from a per-seat ATS.

Daniel owns a boutique executive search firm with four consultants. He uses the Clients page to see that Technology and Banking & Finance produce most of his fee revenue, then filters by Contract Type to check how much of that is executive search rather than permanent placement, before deciding where to spend his business-development time.

Amara leads talent acquisition at a mid-size services group. She uses the Candidates page to compare LinkedIn, job boards, referrals and the agency database on submissions and salary offered, and takes the source-mix panel straight into her quarterly hiring-cost review.

❓ Frequently Asked Questions

What KPIs does the Recruitment Agencies Dashboard track?

The Recruitment Agencies Dashboard in Google Sheets tracks 16 KPI cards: total fee revenue, placements made, average time to fill, average fee per placement, active clients, permanent fees, requisitions, average fee per client, candidates submitted, submissions per placement, average salary offered, referral share, total billings, active recruiters, billings per desk and placement rate.

How long does setup take?

Under 10 minutes. Open the PDF, click the “Make a copy” link, paste your requisition log over the 500 sample rows on the Data sheet keeping the same headers, and the Recruitment Agencies Dashboard rebuilds every chart, pivot and KPI card automatically.

How does this compare to an ATS like Bullhorn or JobAdder?

An ATS manages candidates, jobs and workflow at roughly $99-$150 per user per month. The Recruitment Agencies Dashboard is a one-time $9.99 reporting layer over your placement log — it will not replace an ATS, but it gives a five-recruiter agency board-level billing reporting for a fraction of one month of seats.

Can I add my own recruiters, industries and job categories?

Yes. Every slicer, pivot and chart in the Recruitment Agencies Dashboard reads the Data sheet, so new recruiter names, client industries, job categories or contract types appear automatically once you refresh the pivots. No formula editing is required.

Does it work on mobile and can I share it with clients?

Yes. Because the Recruitment Agencies Dashboard in Google Sheets runs entirely in Google Sheets, you can open it in the Google Sheets mobile app and share a view-only link with clients or directors without buying them a seat in any system.

How many rows of data can it handle?

The Recruitment Agencies Dashboard ships with 500 sample requisitions and its pivots, slicers and formulas already cover 1,000 rows. Paste new records anywhere up to row 1001 and the dashboard updates on its own; beyond that, extend the pivot ranges once.

Is the data in the screenshots real?

No. Every client name, recruiter name and figure in the Recruitment Agencies Dashboard is demo data generated to show the layout. Delete the sample rows and the dashboard reports only your own agency’s numbers.

👤 About the Author

Built by PK — Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels (@PK-AnExcelExpert, @NextGenTemplates, @NeoTechNavigators). Every template is hand-built and tested before release.

🔗 Explore Related Templates

💎 Save 37% — get this desk covered end to end with the Recruitment & Talent Acquisition Bundle, seven premium Excel and Google Sheets templates in one download.

• Staffing Agency Dashboard in Google Sheets — a separate build focused on agency operations and temp desks rather than the client / candidate / recruiter split used here.
• Temp Staffing Dashboard in Google Sheets — for contract and temp desks where hours and shift fill rates matter more than permanent fees.
• Recruitment Funnel KPI Dashboard in Google Sheets — a month-picker KPI scorecard for the hiring funnel, complementary to this analytical dashboard.
• Recruitment Applicant Tracking System Web App — when you need to store candidates and manage workflow, not just report on them.

Also available as: Recruitment Agencies Dashboard in Excel and Recruitment Agencies Dashboard in Power BI. Browse the full shelf of Google Sheets Dashboards.

📖 Click here to read the Detailed Blog Post

🎥 Visit our YouTube channel for step-by-step video tutorials

👉 YouTube.com/@NextGenTemplates

Watch the step-by-step video Demo:

📅 Last updated: August 2026