Loading...
hr

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 (required)

    Start date for the source-of-hire reporting period.

  • Reporting Period End (required)

    End date for the source-of-hire reporting period.

  • Tracking Level (required)
  • 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 (required)

    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 (required)

    Number of applicants attributed to this source.

  • Screened Candidates

    Number of candidates screened from this source.

  • Interviews (required)

    Number of interviews completed from this source.

  • Offers

    Number of offers extended to candidates from this source.

  • Hires (required)

    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. 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. 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. 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. 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. 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:

Source names are entered inconsistently, which splits the same channel into multiple rows and hides true performance.
Applicants are counted in more than one source without a documented attribution rule, inflating totals.
Spend is recorded without stating whether it includes agency fees, referral bonuses, or media spend, which distorts cost per hire.
Tracking level changes from one submission to the next, making period-over-period comparisons unreliable.
Rejected or withdrawn candidates are omitted, so conversion rates look better than they are.
The form is used to store candidate-level PII even though the template only needs aggregate source metrics.
Data source and submission details are left blank, which makes the report hard to audit or reconcile.
Paid and organic sources are mixed together, preventing accurate budget decisions.

Common use cases

Talent Acquisition Manager reviewing monthly spend
A TA manager compares job boards, referrals, and agencies across the month to decide where to shift budget. The template keeps counts, spend, and source notes in one record so the review is repeatable.
Recruiter tracking a hiring event campaign
A recruiter logs applicants, interviews, and hires from a career fair or virtual event. Source_detail and campaign_name make it easy to separate event performance from other sourcing activity.
Healthcare staffing team measuring referral quality
A staffing coordinator records referral sources and funnel outcomes for hard-to-fill roles. The form helps show whether referrals produce screened candidates and hires without collecting unnecessary personal data.
Agency versus direct sourcing comparison
An HR analyst compares agency submissions with direct applicant channels for the same requisition group. The audit trail and spend fields support a cleaner comparison of cost per hire.

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.

Go deeper on the topic

Related concepts
  • 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...
Related guides

Ready to use this template?

Get started with MangoApps and use Source-of-Hire Tracking Template with your team — pricing built for small business.

Get Started
Ask AI Product Advisor

Hi! I'm the MangoApps Product Advisor. I can help you with:

  • Understanding our 40+ workplace apps
  • Finding the right solution for your needs
  • Answering questions about pricing and features
  • Pointing you to free tools you can try right now

What would you like to know?