CRM Reporting for Admissions Teams: Which Metrics to Track and How to Use Them

Most admissions teams either track too little — relying on spreadsheet headcounts and anecdotal read of which campaigns are “doing well” — or they track too much, generating reports nobody reads. CRM reporting works when it is built around the questions that actually drive decisions: where are leads coming from, where are they dropping off, and what actions move them toward enrollment.

This guide covers which reports matter, how to set them up, and how to use them to make better admissions decisions.

Why does reporting by source matter so much for admissions?

Not all enquiry sources produce the same quality of lead. A school running Google Ads, Facebook campaigns, education fairs, and organic referrals typically finds that different sources convert at different rates and at different speeds through the funnel. Without source-level reporting, you cannot tell whether to increase budget on the channel that produces your highest-converting leads or cut spend on the one filling your pipeline with enquiries that rarely enrol.

In a CRM, every lead should have a source attached — either captured automatically from UTM parameters when they fill in a web form, or recorded manually when they walk in or call. Report on lead volume, conversion rate, and average days to enrollment by source each month. Over a few intake cycles, the pattern becomes clear enough to guide budget decisions with confidence rather than guesswork.

For more on tracking where your enquiries come from, see the guide on enrollment lead management.

What does the enrollment funnel look like in a CRM?

The enrollment funnel tracks leads as they move through defined stages from first contact to confirmed enrollment. A typical structure looks like this: Enquiry Received, First Contact Made, Application Sent, Application Received, Assessment or Interview, Offer Made, Deposit Paid, Enrolled.

Your CRM should show how many leads are in each stage and what percentage move from one stage to the next. A drop-off between Application Sent and Application Received, for example, tells you that leads are not completing the application — which might mean the process is too complex, the application link is broken, or follow-up at that stage is insufficient.

Stage-by-stage conversion rates give you a precise picture of where the funnel is losing volume, which is far more useful than knowing that your overall conversion rate is “low.” A enrollment CRM built around a defined pipeline makes these stage-level reports easy to run without custom queries or manual spreadsheet work.

How do you track response time, and why does it matter?

Response time — the time between an enquiry arriving and the first meaningful contact — has a direct effect on conversion. Families making school decisions compare several institutions. The one that responds quickly, with relevant information, tends to have an advantage in the consideration process.

Most CRMs can report on average first-response time across all enquiries and by team member. Run this report weekly and compare it to your target. If the average is significantly above your target, look at which days and times enquiries are arriving — if most arrive outside business hours, an automated acknowledgement with an expected response time may close the gap without requiring after-hours staffing.

You can also build an alert in your CRM that flags any lead that has not received a first contact within your target window. This keeps the response time visible without requiring managers to manually review the queue.

What is an open enquiries by age report?

This report shows all unresolved enquiries in your pipeline, sorted by how long they have been open. It is one of the most practical reports for admissions teams to run every morning or at the start of each week.

Leads that have been in the pipeline for 14 days or more without meaningful progress are likely cooling. They may have chosen another school, paused their decision, or simply been missed in the follow-up sequence. An age report makes these visible before the lead is fully lost, giving counsellors the prompt to re-engage with a targeted message.

In HubSpot, this can be built as a contact view filtered to deals in specific pipeline stages and sorted by create date. Set it as a pinned view on the counsellor’s dashboard so it surfaces automatically rather than needing to be generated manually.

How should you report on counsellor activity?

Activity reporting — calls made, emails sent, tasks completed — gives managers visibility into team workload and output without requiring status meetings. In a CRM, every interaction logged against a contact record feeds into activity reports automatically. A counsellor who logs their calls, emails, and notes in the CRM gives management a real picture of follow-up behaviour; one who works outside the CRM creates a gap that only shows up when a lead drops off without explanation.

Activity reports are most useful when paired with conversion data. A counsellor with high activity but low conversion may be contacting leads at the wrong stage or with the wrong message. A counsellor with moderate activity and high conversion has an approach worth understanding and sharing with the team. The data opens the conversation without requiring managers to rely on impressions alone.

How do you use lost reason data to improve the funnel?

When a lead does not enrol, recording the reason — chose a competitor, budget constraints, location, timing, course not available — builds a dataset that informs both admissions strategy and programme decisions. If the same reason appears consistently across a programme or intake period, it points to a structural issue rather than individual case circumstances.

Most CRMs allow you to configure a lost reason dropdown that counsellors select when closing a lead as lost. The quality of this data depends on counsellors using it consistently, which requires the options to be specific enough to be useful and simple enough that it takes less than 30 seconds to record.

Review lost reasons quarterly. If “chose competitor” is the leading reason, understanding which competitor and why is the follow-on question. If “fees too high” appears frequently on a specific programme, that is pricing or value communication feedback worth reviewing with the leadership team. The enrollment reporting guide covers how to structure this analysis across intake cycles.

Frequently asked questions

How often should admissions teams review CRM reports?

Core operational reports — open enquiries, response time, pipeline by stage — are most useful weekly or even daily during active intake periods. Trend reports — source performance, conversion by intake, lost reasons — are best reviewed monthly or per intake cycle. Building a short weekly review of the top three operational reports into the team routine takes under 30 minutes and keeps the funnel visible without over-complicating it.

What if our team does not log calls and emails in the CRM?

Reporting quality is directly tied to data entry consistency. This is usually a behaviour problem, not a tool problem. Embedding CRM logging into the team’s workflow — making it part of how each interaction ends, not an additional task on top of the work — is the practical fix. HubSpot’s email integration and mobile app reduce the friction by allowing one-click logging from an email or call, rather than requiring manual entry after the fact.

Can we build these reports without a developer?

Yes. In HubSpot, most of the reports described here can be built using the native report builder without any technical setup. Pipeline reports, source breakdowns, and activity reports are all available through standard HubSpot reporting. More complex analysis — like multi-touch source attribution or forecasting by intake — may require more configuration or a paid reporting tier.

Should we share CRM reports with programme teams?

Selectively, yes. Lost reason data and conversion by programme are valuable for programme directors to see. They often have context for why a programme is underperforming in admissions that the admissions team does not have access to — a change in curriculum, a competitor launch, or an industry shift. Sharing reports opens that dialogue without requiring either team to operate on assumptions.

If you would like help setting up CRM reporting for your admissions team, talk to us about how we work with schools and universities.