Leverage Edu — FY 26-27 Dashboard

Loading dashboard...

Fetching from Firebase

Pipeline Overview

FY 2026-27 · Student Application Funnel

Country

All Countries

Sourcing

All Sourcing

App Status

All Statuses

Intake Month

All Intakes

Service Status

All

Filter by University

All Universities

School Country

All

Pipeline KPIs

Total Apps 📱

—

📌 COUNT all rows in pipeline

STU Open 🔍

—

Submitted · Open only

📌 status='Submitted to University' AND service_status != 2

Open Apps 🔍

—

📌 service_status != 2 (not closed)

Offers 🔍

—

— offer rate

📌 status IN (5 offer statuses)

Rejections 🔍

—

— rej rate

📌 rejected_at IS NOT NULL

Dep. Conditional 🔍

—

📌 appDepositMadeAt_Conditional IS NOT NULL

Info Requested 🔍

—

— of STU open

📌 info_needed_status=1, STU, Open

Deferred Apps 🔍

—

📌 is_deferred=1, Any status

Deferred Offers 🔍

—

📌 is_deferred=1 + offer statuses

Deferred Deposits 🔍

—

📌 is_deferred=1 + Deposit/Registered

Conversion Metrics

App to Closed % 🔍

—

📌 Closed / Total Apps

App to Info % 🔍

—

📌 Info Req / STU Open

Rejection % 🔍

—

📌 Rejected / Total Apps

Offer Rate % 🔍

—

📌 Offers / Total Apps

Decision Rate % 🔍

—

📌 (Rej+Offers) / Apps

Offer→Dep % 🔍

—

📌 (Dep.Cond + Dep.UCOL) / Offers

App→Dep % 🔍

—

📌 (Dep.Cond + Dep.UCOL) / Total Apps

Turnaround Time (TAT)

Avg Offer TAT 🔍

—

📌 Mean of Offer_TAT (>=0)

Avg Awaiting TAT 🔍

—

📌 Mean of Awaiting_Offer_TAT

Fast Offers ≤7d 🔍

—

📌 TAT ≤ 7 days

Slow Offers >30d 🔍

—

📌 TAT > 30 days

Conversion Funnel

Application Funnel

Step-by-step pipeline

Top 10 Countries by Apps

Apps · Offers · Deposits

Apps Offers Deposits

Status Distribution

Pipeline split by application status

Offer Rate by Country

% of apps with offers (min 50 apps)

Rejection Rate by Country

% of apps rejected (min 50 apps)

School × Country Table

All Schools

—

School	Country	Apps	Offers	Rejected	Dep.Cond	Dep.UCOL	Info Req	Avg Offer TAT	Avg Await TAT	Conversion

—

By University

Unique universities —

Country

All Countries

Sourcing

All Sourcing

Sort By

Summary KPIs

Total Apps 🔍

—

📌 Click for apps analysis

Total Offers 🔍

—

📌 Click for offers analysis

Total Rejections 🔍

—

📌 Click for rejections analysis

Total Dep.Cond 🔍

—

📌 Click for deposits analysis

Avg Offer TAT 🔍

—

📌 Click for TAT analysis

Total Info Req 🔍

—

📌 Click for info analysis

Top Performers

Unique Universities 🔍

—

Best Offer Rate 🔍

—

Most Apps 🔍

—

Most Deposits 🔍

—

Fastest Avg TAT 🔍

—

Most Rejections 🔍

—

Top 10 by Apps

Apps & Offers

Top 10 by Deposits

Conditional & Unconditional

University Summary

—

#	University	Country	Apps	STU Open	Offers	Offer%	Rejected	Rej%	Dep.Cond	Dep.UCOL	Info Req	Avg TAT	Avg Await

—

By Sourcing Category

Leverage Direct vs Leverage Partner ·

Country

All Countries

Sourcing Category

All Sourcing

Intake Month

All Intakes

Apps 🔍

—

Offers 🔍

—

Rejections 🔍

—

Dep.Conditional 🔍

—

Dep.Unconditional 🔍

—

Avg TAT 🔍

—

Mean Offer_TAT

Apps 🔍

—

Offers 🔍

—

Rejections 🔍

—

Dep.Conditional 🔍

—

Dep.Unconditional 🔍

—

Avg TAT 🔍

—

Mean Offer_TAT

Volume

Apps · Offers · Deposits

Conversion Rates

Offer% · Dep% · Rej%

Avg Offer TAT

Days to receive offer

Sourcing Breakdown

By Sourcing Category

—

#	Sourcing Category	Apps	Open	Closed	Offers	Offer%	Rejected	Rej%	Dep.Cond	Dep.UCOL	STU Open	Avg TAT

Analysis

—

Country

All Countries

Sourcing

All Sourcing

App Status

All Statuses

Intake Month

All Intakes

Service Status

All

University

All Universities

School Country

All

By Country

By Sourcing

Breakdown

—

—

Apps Overview

Complete applications breakdown

Pipeline Overview

Total Apps 🔍

—

Offers Received 🔍

—

Rejections 🔍

—

Dep. Conditional 🔍

—

Dep. Unconditional 🔍

—

Info Requested 🔍

—

STU Open 🔍

—

Awaiting decision

Service Status

Open (service=0) 🔍

—

📌 Active applications

Hold (service=1) 🔍

—

📌 Temporarily on hold

Closed (service=2) 🔍

—

📌 Completed applications

Conversion Rates

Offer Rate 🔍

—

📌 Offers / Total Apps

Rejection Rate 🔍

—

📌 Rejected / Total Apps

Deposit Rate 🔍

—

📌 Dep.Cond / Total Apps

Offer->Dep Rate 🔍

—

📌 Dep.Cond / Offers

Decision Rate 🔍

—

📌 (Offers+Rej) / Apps

Closed Rate 🔍

—

📌 Closed / Total Apps

Info Rate 🔍

—

📌 Info Req / STU Open

TAT Metrics

Avg Offer TAT 🔍

—

Avg Awaiting TAT 🔍

—

Charts

Pipeline Breakdown

All stages

Conversion Rates

Key rates

By Sourcing

Apps by sourcing category

By Intake Month

Monthly distribution

School Breakdown

All Schools

—

#	School	Country	Apps	Open	Hold	Closed	Offers	Offer%	Dep.Cond	Dep.UCOL	Rejected	Info Req	Avg TAT

—