Source-of-Hire Tracking Template
Track where candidates come from, what each source converts into, and how much each hire costs. This template helps recruiting teams compare channels, document spend, and keep source-of-hire reporting consistent.
Trusted by frontline teams 15 years of frontline software AI customization in seconds
Built for: Technology · Healthcare · Retail · Manufacturing · Professional Services
Overview
The Source-of-Hire Tracking Template is a workplace form for recording where candidates came from, how far they moved through the funnel, and what each source cost. It includes tracking scope fields, source channel details, conversion metrics, spend and efficiency fields, and a reporting notes section with an audit trail.
Use this template when you need a consistent way to compare recruiting channels across a requisition, campaign, or reporting period. It is useful for talent acquisition teams reviewing paid sources, referrals, agencies, job boards, events, and direct sourcing. The form helps answer practical questions such as which channels produce applicants that screen well, which sources convert to offers, and whether spend is justified by hires.
Do not use this template as a candidate intake form or as a place to collect unnecessary personal data. It is designed for aggregate source reporting, not for storing resumes, DOB, SSN, or other PII that is not needed for the metric. If your team cannot define source attribution rules, or if you do not have a reliable data source for counts and spend, the form will produce misleading results. In those cases, set the attribution method first, then use the template to capture only the fields you can verify.
What's inside this template
Tracking Scope
This section defines the reporting boundary so every count and spend figure can be compared within the same requisition, campaign, or period.
-
Reporting Period Start
Start date for the source-of-hire reporting period.
-
Reporting Period End
End date for the source-of-hire reporting period.
- Tracking Level
-
Requisition ID
Enter the requisition or job opening identifier if tracking at requisition level.
-
Campaign Name
Enter the campaign or event name if tracking a sourcing campaign.
Source Channel
This section identifies the exact recruiting source and who owns it, which is essential for consistent attribution and follow-up.
-
Source Channel
Select the source that first introduced the candidate to the opportunity.
-
Source Detail
Optional detail such as the job board name, referral source, agency name, or event name.
-
Source Owner
Optional recruiter, sourcer, or team responsible for the channel.
-
Is this a paid source?
Use this to separate paid and organic channels for spend analysis.
Conversion Metrics
This section captures the funnel counts that show whether a source produces volume, quality, and hires.
-
Applicants
Number of applicants attributed to this source.
-
Screened Candidates
Number of candidates screened from this source.
-
Interviews
Number of interviews completed from this source.
-
Offers
Number of offers extended to candidates from this source.
-
Hires
Number of hires attributed to this source.
-
Rejected or Withdrawn
Number of candidates from this source who were rejected or withdrew.
Spend and Efficiency
This section ties sourcing cost to outcomes so you can calculate whether a channel is worth the spend.
-
Source Spend
Total spend associated with this source for the reporting period.
-
Currency
Currency used for source spend.
-
Cost per Applicant
Calculated as source spend divided by applicants.
-
Cost per Hire
Calculated as source spend divided by hires.
-
Notes on Spend
Add context for unusual spend, discounts, credits, or shared costs.
Reporting Notes and Audit Trail
This section records where the data came from, who submitted it, and any quality issues that affect trust in the report.
-
Data Source
Select all data sources used to compile this record.
-
Data Quality Notes
Document attribution gaps, duplicate records, or assumptions used in reporting.
-
Submitted By
Optional name or team responsible for the submission. Avoid collecting unnecessary PII.
-
Submission Date
Date the record was submitted for audit trail purposes.
How to use this template
- 1. Set the reporting period, tracking level, and requisition or campaign identifier so the record has a clear scope before any counts are entered.
- 2. Choose one source_channel and, if needed, add source_detail, source_owner, and paid_source to show exactly where the candidates came from.
- 3. Enter the funnel counts for applicants, screened candidates, interviews, offers, hires, and rejected or withdrawn candidates using the same attribution rule across all fields.
- 4. Record source_spend, currency, and notes_on_spend so cost per applicant and cost per hire can be reviewed against the same cost basis.
- 5. Add the data_source, data_quality_notes, submitted_by, and submission_date fields to create an audit trail that explains where the numbers came from and who verified them.
Best practices
- Define source attribution rules before the first submission so every recruiter counts candidates the same way.
- Use source_detail for the specific channel name, campaign, event, or vendor instead of stuffing that information into source_channel.
- Mark paid_source clearly so referral, organic, and paid channels do not get blended in reporting.
- Keep the reporting level consistent within a dashboard or time series, because mixing requisition and campaign records makes comparisons unreliable.
- Use numeric inputs for counts and spend fields so validation can catch non-numeric entries before submission.
- Document whether source_spend includes agency fees, ad fees, event costs, or referral bonuses in notes_on_spend.
- Review rejected_or_withdrawn_count alongside interviews and offers to spot channels that create volume but poor fit.
- Keep the form accessible with clear labels, required markers, and simple validation that supports WCAG 2.1 AA.
What this template typically catches
Issues teams running this template most often surface in practice:
Common use cases
Frequently asked questions
What is this template used for?
This template records recruiting source data for a specific reporting period, requisition, or campaign. It captures the channel, conversion counts, spend, and audit trail fields needed to compare sourcing performance. Use it when you want a repeatable way to see which sources generate applicants and hires, not just traffic.
Should I use this by requisition, campaign, or reporting period?
Use the tracking level that matches how your recruiting team makes decisions. Requisition-level tracking is best when hiring needs vary by role, campaign-level tracking works for sourcing pushes, and period-level tracking is useful for monthly or quarterly reporting. The template includes a tracking level field so you can standardize whichever scope you choose.
Who should fill this out?
Usually a recruiter, recruiting coordinator, or talent acquisition analyst owns the form, with source owners or hiring managers adding notes when needed. The submitted_by and data_source fields help show who entered the data and where it came from. If multiple people contribute, assign one owner to review and submit the final record.
How often should source-of-hire data be reported?
Most teams report monthly, with campaign or requisition updates as needed during active hiring. The right cadence depends on how quickly spend and pipeline volume change. Keep the cadence consistent so cost per applicant and cost per hire are comparable across periods.
What are the most common mistakes with source-of-hire tracking?
Common issues include mixing different tracking levels in one report, leaving source_channel too broad, and counting the same candidate in multiple sources without a clear rule. Teams also forget to document whether spend is paid media only or includes agency and referral costs. Clear validation rules and notes_on_spend reduce these problems.
How does this template support data privacy and accessibility?
This form is built around data minimization, so it tracks recruiting performance without collecting unnecessary PII. If you publish or share the form internally, keep labels clear, mark required fields, and use accessible field types and validation that support WCAG 2.1 AA. If candidate-level data is referenced, keep it out of the form unless it is needed for the report.
Can I customize the source channels and metrics?
Yes. You can add source channels such as job boards, employee referrals, agencies, events, social campaigns, or direct sourcing, and you can expand the metrics if your process tracks additional funnel stages. Keep the core fields intact so reports stay comparable over time.
How do I connect this to other recruiting tools?
This template works well with applicant tracking systems, recruiting dashboards, spreadsheets, and BI tools. Use data_source to note whether the numbers came from an ATS export, manual review, or campaign report. That audit trail makes it easier to reconcile differences between systems.
How is this better than ad hoc spreadsheet tracking?
Ad hoc tracking often leaves teams with inconsistent source names, missing spend data, and no clear audit trail. This template standardizes the fields that matter for channel comparison, which makes trend analysis and budget decisions easier. It also helps prevent one-off reporting formats that cannot be compared across hiring cycles.
Related templates
Go deeper on the topic
-
A standard operating procedure (SOP) is a documented, step-by-step procedure for a repeatable task — the written version of "how we do this here." Good SOPs...
-
A daily huddle is a brief (10–15 minute) standing meeting held at the start of a shift or workday to align the team on priorities, surface issues, and...
-
A deskless worker is any employee whose job happens without a desk, a company laptop, or a fixed workstation. They're roughly 80% of the global workforce —...
-
A shift handoff is the structured transition between the outgoing and incoming crew at the change of a shift. It covers what was done, what wasn't done, what...
-
Discover how retail leaders can improve frontline employee well-being, reduce burnout, and drive engagement with proven strategies and mobile-first tools.
-
Healthcare employee engagement ideas to reduce burnout, boost retention, and improve patient outcomes in your health system.
-
Slow decisions cost time and money. Learn how knowledge sharing eliminates analysis paralysis, speeds up decisions, and boosts team productivity.
-
Sync ADP Workforce Now with MangoApps to auto-update employee data, permissions, and HR info in one place—no IT effort required.
Ready to use this template?
Get started with MangoApps and use Source-of-Hire Tracking Template with your team — pricing built for small business.