Diagnose where our college admissions funnel is losing students
Analyzes inquiry-to-enrollment conversion, yield, and summer melt to find where prospective students drop off.
The prompt
Help me find where our admissions funnel is losing students.
Institution type: [e.g. "private 4-year", "public regional", "community college"]
Funnel data by stage: [PASTE - inquiries, applicants, completed applications, admits, deposits, enrolled (census), for this year and last 2-3 years]
Segments available: [e.g. in-state vs. out-of-state, first-gen, transfer, program, source, Pell eligibility]
Financial aid data: [discount rate, average net price, aid offer timing]
Changes this year: [e.g. test-optional, new CRM, FAFSA delays, new competitor]
Steps:
1. Calculate conversion at each stage (inquiry-to-app, app-to-complete, admit rate, yield, melt from deposit to census) and compare year over year.
2. Find the biggest leak by stage and by segment, not just overall.
3. Separate likely causes: process (incomplete apps, slow decisions), price (net cost, aid timing), fit (program, location), and competition.
4. Flag summer melt risks and the students most affected.
5. Recommend 3-5 actions by stage, each with the metric it should move.
Return: a funnel table with conversion rates, the top 3 leaks with evidence, recommended actions, and data I should pull next. Do not invent benchmarks; if comparing to peers, mark figures [CONFIRM SOURCE].
Highlighted [brackets] are blanks to replace with your own details.
Fill in the blanks and use this promptMore Data & Analysis prompts
What to fill in
- e.g. "private 4-year", "public regional", "community college"
- discount rate, average net price, aid offer timing
- e.g. test-optional, new CRM, FAFSA delays, new competitor
- CONFIRM SOURCE
How this prompt is built
This prompt follows the Few-Shot structure (Few-shot prompting). A few-shot prompt includes one or more worked examples of the input and the output you want, so the model can copy the pattern instead of guessing it.
Related prompts
- Group students for intervention from screening and assessment dataSorts students into MTSS or RTI tiers and intervention groups from universal screening and diagnostic results.
- Identify the leading and lagging indicators for my business or teamSorts your metrics into leading and lagging indicators, links each lead to the outcome it predicts, and fills gaps in early-warning measures.
- Check whether my data shows causation or just correlationSeparates trend, correlation, and possible causation in your analysis and gives you the strongest claim you can honestly make.
- Analyze my clinic's claim denials and revenue cycle KPIsTurns denial and A/R data into root causes, benchmark gaps, and a prioritized fix list for the front end, coding, and billing teams.