Your question is Build Weekly Sourcing KPI Dashboard. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
Meta's VP of Sourcing oversees recruiting pipeline health across engineering, product, and business hiring. Every Monday morning, they want a dashboard that quickly shows whether sourcing is generating enough high-quality candidates to hit quarterly hiring goals, and where the funnel is breaking.
Last week, Meta had a quarterly target of 1,200 hires, with 430 offers accepted quarter-to-date versus a plan of 480. Recruiters report that top-of-funnel activity looks strong: 52,000 prospects added to Meta's CRM this quarter, 18,200 outreach messages sent last week, and a 41% prospect response rate. However, only 2,900 recruiter screens were completed quarter-to-date, 1,050 onsite loops were completed, 620 offers were extended, and offer acceptance dropped from 74% last quarter to 69% this quarter. Engineering hiring is furthest behind plan: 210 accepted offers versus a target of 280. The VP wants a Monday dashboard that distinguishes signal from noise, highlights leading indicators, and helps prioritize action by team, region, and funnel stage.
meta_sourcing_prospects: prospect_id, role_family, level, region, source_channel, date_added, recruiter_idmeta_outreach_events: prospect_id, outreach_date, outreach_channel, response_flag, positive_response_flagmeta_recruiting_funnel: candidate_id, stage, stage_entered_at, stage_exited_at, req_id, hiring_teammeta_offers: candidate_id, offer_date, offer_status, accepted_flag, compensation_bandmeta_hiring_plan: quarter, hiring_team, region, target_hires, target_offers, target_onsites