Data + Settings

One control surface for recruiting KPIs, sponsorship fulfillment, Supabase structure, and operating setup.

Export report Manage filters June 29 review
Static prototype view. Numbers are sample data to show the reporting shape Andrew would see once events, QR sources, candidates, and academy records share one database.

Reporting Filters

Filters should work across sponsorship outcomes and the FLE/FLA funnel so Andrew can compare schools, sources, cohorts, and date ranges without rebuilding spreadsheets.

All schools
December 2026 FLE
All campus events
QR + manual
2026-2028
Sep 1 - Dec 15

KPI Dashboard

Fast answers for the weekly operating meeting: what is scheduled, what is staffed, what is producing candidates, and what is turning into academy-ready talent.

Live from Supabase Rolling 90 days
Sponsorships
42

scheduled or draft campus commitments

31 confirmed74%
Candidates
186

student leads captured by QR, referral, and manual entry

68 from events37%
FLE
38

qualified candidates invited to the two-day experience

29 attended76%
FLA / AFR
9

participants on track for AFR readiness or hire review

2 FR/hire outcomesGoal: 2+

Funnel Metrics

Kanban stages become a measurable recruiting funnel without making the database depend on board columns.

Applicants
186
100%
POP sent
134
72%
Interviewed
89
48%
FLE invited
38
20%
FLE attended
29
76% of invites
FLA accepted
11
38% of FLE

Sponsorship Fulfillment

Track package value by school, including TBD items, owners, approvals, and deliverables tied to real event outcomes.

GVSU Tabling, party deck, Lunch & Learn, basketball signage
82%
CMU Football gameday, ticket banks, LED, social, email, leadership moment
67%
WMU Career Days, SAAC presentations, web banner, email blasts
54%
MSU Tailgate, Fan Fest, Lunch & Learn, LED, Playfly approval items
39%

Source + School Performance

Andrew should see which schools and event types are actually creating candidates, not just which sponsorship assets were purchased.

Applicants By School

GVSU48 applicants, 11 interviews, 4 FLE invites
Top
CMU43 applicants, 9 interviews, 5 FLE invites
Strong
WMU52 applicants, 7 interviews, 3 FLE invites
High volume
MSU43 applicants, 8 interviews, 4 FLE invites
Building

Applicants By Source

Event QR codes68 leads from tabling, games, career days, and mixers
37%
School general QR44 leads from evergreen school links
24%
Participant referrals29 leads tied back to FLA participants
16%
Manual entry45 leads added after conversations or spreadsheet import
24%

Academy Outcomes

Seven-day video completion14 submitted out of 20 invited after FLE
70%
FLA active participants11 accepted, 9 currently on track
82%
AFR readySIE, Life & Health, shadowing, business plan, referrals
6
FR / hiredFuture advisor outcomes tied back to original source
2

Supabase Architecture Summary

Use Supabase as the source of truth from the beginning. The UI can look like calendars and boards, while Postgres preserves the actual operating records underneath.

Build Stance

FrontendNext.js / React admin app, responsive for event-day phone use
UI
DatabaseSupabase Postgres for schools, events, candidates, cohorts, activity, and reporting
Truth
AuthSupabase Auth for internal users; token links for public forms and participant portal
Access
FilesStorage buckets for resumes, FLA videos, participant submissions, sponsorship docs, and event files
Storage

Core Table Groups

Operating setuporganizations, users, schools, school_contactsRoles and contactsV1
Sponsorshipspackages, commitments, events, assignments, attendees, deliverablesCalendar + fulfillmentV1
Candidate funnelqr_sources, candidates, applications, answers, files, assessments, interviewsFLE pipelineV1
FLE / FLAcohorts, fle_attendance, fla_applications, video_responses, reviewsSelection workflowV1.5
Academyparticipants, milestones, submissions, portal_tokens, referralsSix-month progressV2
System historynotifications, activity_logAudit trail + remindersV1

Settings

Setup should feel practical: define the operating year, schools, cohorts, people, QR sources, and notifications before trying to automate imports.

Add school Add cohort Create QR source

Schools

GVSUGrand Rapids / AllendaleActive packageReady
CMUMount PleasantFootball + basketball assetsReady
WMUKalamazooCareer days + SAACDates needed
MSUEast LansingPlayfly approval chainApprovals

Cohorts

December 2026 FLETwo-day experienceApplication window TBDDraft
May 2027 FLETwo-day experienceRolling spring applicantsPlanned
December 2026 FLASix-month academySeven-day video deadline after FLEFuture

Roles

AndrewAdminAll modules, settings, reportingAdmin
AnnieReviewerInterviews, video review, candidate decisionsReviewer
CarrieOperatorPOP workflow, notifications, candidate updatesOperator
Advisors / repsRepAssigned events, check-in, follow-up notesLimited

QR Sources

GVSU Football TableEvent sourceCreates FLE candidate with event attributionActive
WMU Career DayCareer fairHidden school + event fieldsActive
MSU GeneralSchool generalEvergreen recruiting linkDraft
FLA Participant ReferralReferralAttributes referred lead to participantV2

Notification Recipients

New FLE applicationCarrieEmail now, digest optionalV1
Unstaffed eventAndrewIn-app alert plus weekly digestV1
Video submittedAnnie / AndrewReviewer notificationV1.5
Participant overdueParticipant + reviewerMonthly academy remindersV2

Operating Defaults

Sponsorship yearSeptember 1 target for clean calendar, package setup, owners, and TBD commitments.
Phase 1
Application questionsStore question text per application so historical answers remain clear if questions change.
Versioned
Pipeline stagesConfigurable labels, but stage history should live in activity_log and candidate records.
Config
Retention / consentResume, POP status, video, referrals, and future contact acknowledgments before launch.
Confirm

June 29 Questions

Use the call to tighten scope before the July 7 walkthrough. These are the decisions that change what gets built first.

Operating Scope

What must be live by September 1?Confirm whether sponsorship calendar, event details, assignments, and QR source creation are the true MVP.
Critical
Who owns event staffing decisions?Andrew only, school lead, assigned advisor, or a shared operator?
Workflow
Which sponsorship commitments are real dates vs TBD?Separate fixed events from package benefits that still require school coordination.
Data
What should reps be allowed to see on mobile?Assigned events only, candidate leads, tickets, attendee lists, or follow-up history?
Access

FLE / FLA Decisions

What are the final five FLE application questions?Confirm exact wording, required fields, resume consent, and hidden source fields.
Form
Who receives each notification?Carrie for POP, Annie for review/interview, Andrew for owner gaps and high-priority candidates.
People
How strict is the seven-day FLA video deadline?Hard close, late flag, or Andrew override?
Policy
What outcome matters most on the dashboard?FLE attendance, FLA acceptance, AFR readiness, full-time advisor hires, or school ROI?
KPI