How to Create a Recruitment Dashboard in Looker

Tracking your recruitment efforts without a central dashboard can feel like trying to assemble furniture without instructions - pieces are scattered everywhere, nothing seems to fit, and you aren’t sure what the finished product is supposed to look like. A dedicated recruitment dashboard in a tool like Looker (now part of Looker Studio) pulls all those scattered pieces together into a clear, coherent picture of your entire hiring process. This guide will walk you through planning, identifying key metrics, and building a powerful recruitment dashboard in Looker.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Your Hiring Process Needs a Data Dashboard

Modern recruiting is no longer just about intuition and networking, it’s a strategic function driven by data. Relying on spreadsheets and disconnected reports from your Applicant Tracking System (ATS) leaves you reacting to problems instead of proactively solving them. A centralized dashboard flips that dynamic, giving you a real-time command center for your hiring operations.

Here’s what you gain by visualizing your recruitment data:

• A Single Source of Truth: Everyone from the Head of People to individual recruiters sees the same data, leading to more aligned and productive conversations. No more debates over which spreadsheet is the most current.
• Identify Bottlenecks Instantly: Is the 'Hiring Manager Review' stage taking weeks? Are candidates dropping off after the technical assessment? A dashboard makes these blockages obvious so you can fix them.
• Optimize Your Sourcing Strategy: Discover which channels deliver not just the most applicants, but the right applicants. You can then reallocate your budget and effort to the sources that provide the best ROI.
• Improve Candidate Experience: Long recruitment cycles are a major reason top candidates accept other offers. By monitoring metrics like ‘Time to Hire,’ you can actively work on creating a faster, more positive experience.
• Drive Accountability and Performance: Set clear goals for your recruiting team - like time to fill or offer acceptance rate - and track progress in real time.

Planning Your Dashboard: The Prep Work Before You Build

Before jumping into Looker, a little planning goes a long way. Building a dashboard without a clear purpose results in a collection of charts that look nice but don’t provide real insights. Start by asking these fundamental questions.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Who is the dashboard for?

The information an executive needs is different from what an individual recruiter needs. Tailor your dashboard to its primary audience.

• Executives & Leadership: They need a high-level overview. Focus on strategic KPIs like Cost Per Hire, Time to Fill by department, and overall pipeline health.
• HR & Recruiting Managers: They need to manage team performance and process efficiency. They’ll want to see metrics broken down by recruiter, department, and hiring manager.
• Individual Recruiters: They need an operational view of their own open roles. They’ll be most interested in active candidates per stage, time in stage, and upcoming interviews.

What questions does it need to answer?

Framing your needs as questions transforms metrics from abstract numbers into actionable answers. This is the most crucial step in designing a useful dashboard.

Here are some common questions a recruitment dashboard should answer:

• How many open positions do we have right now? By department?
• What is our average time to fill a role? Is it getting better or worse?
• Where are our best candidates coming from (e.g., employee referrals, LinkedIn, job boards)?
• At which stage of the interview process are we losing the most candidates?
• How diverse is our applicant pool?
• What is our offer acceptance rate?

Where is your data coming from?

Your data is likely housed in an Applicant Tracking System (ATS) like Greenhouse, Lever, Workday, or Taleo. To use this data in Looker, it must be loaded into a data warehouse (like BigQuery, Snowflake, or Redshift) that Looker can connect to. This step often requires help from a data engineer to set up the data pipelines. You might also want to pull in data related to recruiting costs from finance software or post-hire performance from your HRIS.

Essential Metrics for a High-Impact Recruitment Dashboard

Now that you have your "why," "who," and "what," it's time to choose the specific metrics and Key Performance Indicators (KPIs) to display. A great dashboard builds a narrative, starting with high-level summaries and allowing users to drill down into the details.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Pipeline Health & Volume KPIs

These metrics give you a bird's-eye view of your recruitment activity and the overall health of your pipeline.

• Open Requisitions: The total number of open roles, often visualized by department or priority level.
• Total Applicants: The raw number of applications received over a specific time period. A line chart is great for tracking this trend.
• Active Candidates: The number of candidates currently engaged in your interview process.
• Candidates by Stage: A funnel chart is perfect for this, showing the number of candidates at each step (e.g., Applied, Screened, First Interview, Final Interview, Offer).

Recruiting Efficiency KPIs

These metrics help you understand the speed and cost-effectiveness of your hiring process.

• Time to Fill: The number of days between a job requisition being opened and an offer being accepted by a candidate. This is a key metric for hiring managers.
• Time to Hire: The number of days between a candidate applying and accepting an offer. This metric reflects the efficiency and speed of the candidate journey.
• Cost Per Hire: The total internal and external recruiting costs divided by the number of hires. This includes recruiter salaries, job board fees, agency costs, etc.
• Time in Stage: The average time candidates spend in each interview stage. This helps a lot with identifying and addressing bottlenecks.

Source and Quality of Hire KPIs

These metrics reveal where your best talent is coming from and the effectiveness of your hiring decisions.

• Source of Hire: A breakdown of hires by their origin (e.g., employee referral, career site, LinkedIn, AngelList). A bar or pie chart is effective here.
• Source Efficacy: Don’t just track the source of hires, track the source of qualified candidates. A chart showing the applicant-to-interview ratio by source can be incredibly insightful.
• Offer Acceptance Rate: The percentage of extended job offers that are accepted. A low rate could signal issues with compensation, culture, or the interview process itself.

How to Build Your Recruitment Dashboard in Looker: A Step-by-Step Guide

Once your data is flowing from your ATS into a data warehouse and a developer has created a LookML model for it, you’re ready to start building. Looker’s interface is designed for business users to self-serve, so you don’t need to be a data wizard to create compelling visualizations.

Step 1: Start with an "Explore"

In Looker, you build reports, called "Looks," from an "Explore." An Explore is a curated environment for a specific type of data - in this case, your recruiting data. It gives you a list of "Dimensions" (the things you group by) and "Measures" (the things you count or calculate).

Step 2: Build Your First Visualization (Tile)

Let’s create a simple bar chart showing hires by source.

• Navigate to your recruiting Explore.
• In the left-hand panel, find the Source dimension and click on it.
• Next, find an appropriate measure, like Count of Hires, and click on it.
• Click the "Run" button. You’ll now see a data table with your sources and the count of hires for each.
• Under the "Visualization" tab, select the bar chart icon. Looker will automatically render the chart for you.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Define a Common Set of Filters

Your dashboard needs to be interactive. Filters allow users to slice and dice the data to answer their own questions. Add global filters to your dashboard for things like:

• Date Range (e.g., This Quarter, Last 90 Days)
• Department
• Hiring Manager
• Employment Type (Full-Time, Part-Time, Contract)

Step 4: Create a Mix of Visualization Types

A good dashboard uses different chart types to tell the story best. Don’t just use a dozen bar charts.

• Funnel Chart: Perfect for visualizing your candidate pipeline progression.
• Single Value Tile: Ideal for displaying top-line KPIs like Total Open Requisitions, Average Time to Fill, or Overall Offer Acceptance Rate.
• Line Chart: Use this to show trends over time, such as Applications per Week or Time to Fill per Month.
• Table: Create a detailed view of all open roles with information like the hiring manager, recruiter, and age of the requisition.

Step 5: Assemble Your Tiles into a Dashboard

After you create each visualization in the Explore, you can save it as a "Look" and add it to a dashboard.

• Click the gear icon in the top right of your Explore and select "Save to Dashboard."
• Choose an existing recruitment dashboard or create a new one.
• Repeat this for all your visualizations.
• Once your tiles are on the dashboard, you can drag, drop, and resize them to create a logical and visually appealing layout. A good practice is to put high-level KPIs in single value tiles at the top, followed by trends and more detailed breakdowns below.

Final Thoughts

Building a successful recruitment dashboard transforms your hiring process from a reactive, chaotic function into a strategic, well-oiled machine. By carefully planning your goals, selecting the right metrics, and using Looker's tools to build insightful visualizations, you can make smarter decisions that attract and land top talent more efficiently.

We know that setting up data pipelines and LookML can be a major hurdle for teams that don't have dedicated data engineers. At Graphed, our goal is to eliminate that friction completely. We offer one-click integrations with your data sources, allowing you to connect platforms in seconds and start building dashboards immediately using simple, natural language. Instead of spending weeks on setup, you can simply ask, "show me our time to hire by department this quarter," and get a live, interactive dashboard instantly.