Referral Campaign Input Form
Example Data Table
| Campaign | Reach | Referrals | Applicants | Interviewed | Offers | Hires | Total Cost |
|---|---|---|---|---|---|---|---|
| Quarter 1 | 500 | 120 | 90 | 38 | 18 | 14 | $9,390 |
| Quarter 2 | 620 | 140 | 102 | 44 | 20 | 16 | $10,850 |
| Quarter 3 | 450 | 98 | 72 | 31 | 15 | 11 | $8,260 |
| Quarter 4 | 700 | 165 | 118 | 50 | 24 | 19 | $12,420 |
Formula Used
Referral Rate = (Total Referrals ÷ Campaign Reach) × 100
Referral-to-Application Rate = (Applicants ÷ Total Referrals) × 100
Screen-to-Interview Rate = (Interviewed ÷ Screened) × 100
Offer Acceptance Rate = (Hires ÷ Offers) × 100
Overall Referral-to-Hire Rate = (Hires ÷ Total Referrals) × 100
Retention Rate = (Retained Hires ÷ Hires) × 100
Administrative Cost = Admin Hours × Admin Hourly Rate
Total Campaign Cost = Bonus Cost + Promotion Cost + Tooling Cost + Administrative Cost
Cost per Hire = Total Campaign Cost ÷ Hires
Target Attainment = (Hires ÷ Target Hires) × 100
Efficiency Index is a blended score using hiring yield, retention, cost discipline, and speed. It helps compare campaigns quickly.
How to Use This Calculator
- Enter the campaign reach, meaning the employees exposed to the referral drive.
- Fill in each funnel stage from referrals to retained hires.
- Add all direct and indirect costs, including admin labor.
- Provide average days to hire and your target hire count.
- Click Calculate Performance to display results above the form.
- Download the summary as CSV or use the PDF button for a printable report.
- Compare your output with the example table to benchmark future campaigns.
Frequently Asked Questions
1. What does campaign reach mean?
Campaign reach is the number of employees who saw or received the referral campaign message. It shows the top of your internal promotion funnel.
2. Why track retained hires?
Retained hires show whether referred candidates stay beyond early milestones. This helps measure quality, not only raw hiring volume.
3. What is a strong referral-to-hire rate?
A strong rate depends on role difficulty, brand strength, and bonus design. Compare campaigns over time to identify your realistic internal benchmark.
4. Should admin time be included?
Yes. Administrative time affects true campaign cost. Including coordinator hours makes cost per hire more realistic and useful for budget planning.
5. Why does the calculator validate funnel order?
Each hiring stage should normally shrink or stay equal. Validation helps prevent impossible values, such as hires exceeding offers or applicants exceeding referrals.
6. What does the efficiency index show?
The index summarizes hiring yield, retention, time, and cost into one score. It is useful for comparing referral campaigns side by side.
7. Can I use this for monthly reports?
Yes. You can run the calculator monthly, quarterly, or per hiring drive. Consistent timing makes trend analysis much more meaningful.
8. How do I create a PDF?
Use the PDF button after calculation. It opens the browser print flow, where you can save the result summary as a PDF file.