Benchmarks

​

Route

​

Access

• Summary cards — available to all tiers
• Benchmark grid — Premium only (standard users see upgrade prompt)
• Position chart — available to all tiers

​

Filter Sidebar (all functional)

​

Summary Cards (4)

1. Avg NIL / Athlete — total_value / athletes_with_deals for school vs conference
2. Avg Agreement Value — AVG(total_value_usd) across filtered deals
3. % Athletes with Agreement — athletes with deals / total athletes
4. Total NIL Value — SUM(total_value_usd) for school vs conference

​

Benchmark Grid (Premium)

• School: _agg() with university_id == user's
• Conference: _agg() with university_id IN (same conference)
• Peer Group: _agg() with university_id IN (universities in peer group conferences)
• Percentiles: PostgreSQL percentile_cont(0.25/0.50/0.75) on per-athlete totals

​

Position Bar Chart

• Total → school_avg
• Guaranteed → school_avg_guaranteed
• Performance → school_avg_performance

​

Backend Engine

# Example: filtered benchmark aggregation
async def _agg(db, uni_filter, sport_id=None, position_id=None, eligibility_year=None, comp_type=None):
    q = select(
        func.avg(NilDeal.total_value_usd),
        func.count(NilDeal.id),
        func.sum(NilDeal.total_value_usd),
        ...
    ).where(uni_filter, NilDeal.deal_status == "active")
    if eligibility_year:
        q = q.join(Athlete).where(Athlete.eligibility_year == int(eligibility_year))
    if comp_type:
        q = q.where(NilDeal.compensation_type == comp_type)
    ...