TL;DR for Recruiters
Recruiters sit on some of the most valuable workforce data in any company, and most of it lives in a messy mix of ATS exports and half-built spreadsheets. The two tools that consistently make the biggest difference are Google Sheets for real-time pipeline tracking and Airtable for structured candidate databases your whole team can actually use. Nail those two and your reporting goes from reactive to something hiring managers will actually read.
What Recruiters Actually Need To Track
Before you build a single formula, get clear on what you are actually trying to answer. Most recruiter dashboards fail because they track everything and surface nothing useful.
Here are the seven metrics that actually drive decisions in recruiting.
Time-to-fill is the number of days from the moment a requisition opens to the day an offer is accepted. This is your headline number. If it is creeping past 45 days for mid-level roles, something upstream is broken.
Pipeline conversion rate by stage tells you where candidates are falling off. If you are getting 200 applications but only 10 phone screens, the job description or sourcing channel is wrong. If you are getting 40 final-round interviews but only 3 offers, the problem is in your assessment process.
Source of hire tracks which channel each hired candidate came from: LinkedIn, Indeed, employee referral, direct sourcing, agency, and so on. Without this, you are guessing which job boards deserve your budget.
Offer acceptance rate is the percentage of offers extended that candidates actually accept. Anything below 80% means your compensation benchmarks, offer process, or candidate experience is leaking somewhere.
Cost-per-hire adds up all your recruiting spend divided by the number of hires. Most small recruiting teams do not track this at all, which makes it impossible to justify headcount or tool purchases to leadership.
Requisition aging shows how long each open req has been sitting. A req that has been open 90 days needs a completely different conversation with the hiring manager than one that opened last week.
Hiring manager response time measures how quickly each manager moves candidates through the process after you send them a profile. This one is politically sensitive but it is often the single biggest bottleneck in a pipeline.
Tracking all seven consistently, even in a simple spreadsheet, puts you in a completely different conversation with leadership than most recruiting teams ever get to have. You move from “we’re working on it” to “here is exactly where the process is breaking and what fixing it is worth.”
The Practical Tool Stack
You do not need six tools. You probably need three to four, depending on whether you are an agency recruiter, an in-house team, or a solo operator. Here is what actually works.
Google Sheets
Google Sheets is free and does 80% of what most recruiting teams need. Collaborative editing means multiple recruiters can update the same pipeline tracker simultaneously without version conflicts. The built-in IMPORTRANGE function lets you pull data from one sheet into a summary dashboard automatically. For small and mid-size teams, Sheets covers pipeline tracking, weekly reporting, and source-of-hire analysis without any licensing cost. It starts at $0 for personal use, and Google Workspace business plans begin around $6 per user per month.
Airtable
Airtable is a database that looks like a spreadsheet, which makes it far easier to manage structured candidate records than a flat Google Sheet. You can create linked records between candidates, requisitions, and hiring managers. The gallery view is useful for sharing shortlists with clients or hiring managers without sending a messy spreadsheet attachment. Airtable’s filtering and grouping capabilities make it fast to build per-recruiter dashboards without writing formulas. The free plan covers basic use and paid plans start around $20 per user per month. For agency recruiters managing multiple clients, the client portal feature alone is worth the upgrade cost.
Microsoft Excel with Power Query
Excel is still the right call when you are dealing with large ATS exports or when your hiring team lives in Microsoft 365. Power Query makes it possible to automate the cleaning of messy ATS exports without touching a single formula by hand. If you are pulling monthly reports from Workday, SuccessFactors, or iCIMS, Power Query can refresh that data in seconds instead of you spending two hours reformatting it every time a new export arrives. Excel is included in Microsoft 365 Business Basic, which starts around $6 per user per month.
Looker Studio
Looker Studio is Google’s free dashboard tool that connects directly to Google Sheets, BigQuery, and most major ATS platforms via third-party connectors. It is the fastest way to turn your pipeline tracker into a shareable visual dashboard that auto-refreshes on a schedule you set. Hiring managers can bookmark the URL and check it themselves instead of pinging you every Friday for a status update. Looker Studio itself is free to use and connector fees from third-party providers like Supermetrics or Porter Metrics range from $15 to $50 per month depending on which data sources you need.
Greenhouse Reporting
If your company uses Greenhouse as its ATS, spend time inside its native reporting module before building anything in a spreadsheet. Greenhouse’s structured interview scorecards and built-in pipeline reports cover most of what teams need without any export or formula work. Custom report templates can be saved and shared with hiring managers directly inside the platform. Pricing is not publicly listed but typically starts around $6,000 per year for small teams, which makes it an enterprise-tier consideration rather than a startup one.
Notion Databases
Notion works well as a lightweight alternative to Airtable for teams that already use it for documentation. Its database views, including table, board, calendar, and gallery, can model a candidate pipeline without adding another subscription. The downside is that Notion’s formula engine is less powerful than Airtable’s, so complex calculated fields get awkward fast. The free plan is usable for solo recruiters and paid plans start around $10 per user per month.
A Realistic Weekly Workflow
Here is what a week looks like when your stack is running properly.
Monday morning, you open your Google Sheets pipeline tracker first, before email. You filter by “status changed last week” to see what moved while you were offline. Any candidate stuck at the same stage for more than seven days gets flagged in red using conditional formatting you have already set up. You send quick check-in notes to those hiring managers directly from the flag list. This takes 30 minutes and sets the week’s priorities before your inbox does.
Tuesday you update your source-of-hire log. Every application that converted to a phone screen since last Tuesday gets a row: candidate name, req, source channel, and outcome. This takes about 20 minutes if you have kept it current. If you have not touched it in two weeks, it takes three hours. Consistency is the only thing that makes this data useful over time.
Wednesday is reporting day. Your Looker Studio dashboard auto-refreshes from the Google Sheet, so you do not rebuild anything. You take a screenshot of the pipeline funnel for each active req and paste it into the weekly update email to hiring managers. Writing the commentary takes 15 minutes because the data is already visualized.
Thursday you pull your offer-acceptance tracker and cost-per-hire tab to see where anything is trending wrong. If offer acceptance has dipped below 80% over the past four weeks, you have something concrete to bring to a compensation conversation with HR or leadership.
Friday is your Airtable cleanup day. New candidates added during the week get properly tagged by source, status, and linked to the right requisition. Any candidates who declined or were declined get moved to the archived view rather than deleted, because you will want to search them again in six months when a similar role opens.
This workflow only holds together if you protect Monday’s 30-minute data review and Tuesday’s log update. Skip those two and everything else starts to fall apart by Thursday.
Common Pitfalls In This Industry
-
Tracking activity instead of outcomes. The number of LinkedIn messages you sent is not a metric. Interviews scheduled per sourcing hour is. Build your tracker around what moves hiring forward, not what makes you look busy in a weekly standup.
-
Rebuilding the report every week instead of automating it. If you are manually copy-pasting from your ATS into a spreadsheet every Friday, you are doing a job that a Power Query refresh or a Looker Studio connector should be doing for you automatically.
-
Not agreeing on definitions before building the tracker. “Time-to-fill” means different things to different people. If your hiring manager counts from the day the job was approved and you count from the day it was posted, your numbers will never match. Agree on definitions first, then build.
-
Sharing live edit access to tracking sheets with hiring managers. They will accidentally overwrite formulas. Give them view-only access or a Looker Studio dashboard link instead of the live sheet.
-
Letting the source-of-hire log fall behind. This data has a short shelf life. If you do not log where a hire came from within the week they were hired, you will forget. By the time you try to reconstruct it at quarter-end, the information is gone and the data is useless.
-
Using one giant flat sheet instead of linked tables. A single sheet with 40 columns tracking candidates, reqs, hiring managers, and compensation all in one place becomes unusable after about 50 rows. Split it into related tables from the start and your future self will thank you.
When To Hire An Analyst Or Agency
The DIY stack described above works well for one to three recruiters handling up to 30 active requisitions. Past that point, the data complexity starts to outpace what a part-time spreadsheet habit can handle sustainably.
Specific signs you need outside help: your cost-per-hire numbers are inconsistent because no one has time to maintain the log, you are manually pulling reports instead of reading dashboards, or your leadership team is asking for headcount forecasting and workforce planning data that you cannot produce from your current setup.
A contract data analyst can build the automated pipeline you need in two to four weeks for a few thousand dollars, and the ongoing maintenance is minimal once it is set up correctly. Recruiting analytics agencies exist specifically for this use case and typically charge between $3,000 and $10,000 for a full reporting buildout.
Before you hire outside help, work through the foundational guides at /category/excel-sheets-power-skills/ to make sure you have already gotten the most out of your current setup. Also check out how to build a hiring dashboard in Google Sheets and the Power Query guide for non-technical users for intermediate skill-building steps that might close the gap without added cost.
Frequently Asked Questions
Do I need to know coding to build a recruiting dashboard?
No. Google Sheets, Airtable, and Looker Studio are all usable without writing a single line of code. The most complex thing you will use in Sheets is a VLOOKUP or an IF formula, and there are ready-made templates for both available for free.
What is the best free ATS for a small recruiting team?
Breezy HR and Recruitee both have free tiers that export to CSV cleanly. If you are already running Google Workspace, those CSV exports feed directly into Google Sheets without any formatting issues to clean up.
How do I get hiring managers to actually update candidate status?
Stop asking them to update the ATS directly. Set up a simple weekly email showing which candidates are waiting on their feedback, with a direct link to each candidate profile. Friction is the enemy of compliance and removing it is more effective than any reminder system.
How often should I update my source-of-hire data?
Weekly at minimum. The best practice is to log each hire’s source within 48 hours of the offer acceptance. Doing it in monthly batches produces inaccurate data because you end up guessing.
Can I track diversity metrics in a spreadsheet without storing sensitive data incorrectly?
Yes, but carefully. Store diversity data in an aggregated, anonymized format, meaning percentages by pipeline stage rather than individual candidate attributes. Check your local data privacy laws before storing any self-reported demographic data at the individual record level.
Bottom Line
The single most valuable thing you can do this quarter is set up a clean, consistent source-of-hire log and commit to updating it every week without exception. Everything else, the dashboards, the Looker Studio reports, the Airtable databases, depends on clean underlying data. Bad data in means bad decisions out, no matter how polished the visualization looks. Start with one sheet, track seven metrics, and build the habit before you build the tool. For deeper guides on Excel formulas, Power Query automation, and dashboard design built for non-technical professionals, browse /category/excel-sheets-power-skills/ and pick up where this guide leaves off.