Industry guide
Higher education marketing dashboard: from inquiry to enrolled student
A higher education marketing dashboard shows a college, university or the agency that markets it which channels and campaigns turn into applications, admits and enrolled students, by program and term. This guide is for enrollment marketing teams and higher ed agencies whose reports stop at clicks and inquiry forms. It covers the funnel KPIs, how to bring CRM data from systems like Slate into Data Studio, what FERPA does and does not cover, a page layout and a worked cost-per-enrolled-student example.

Quick answer
What should a higher education marketing dashboard include?
A higher education marketing dashboard should show inquiries, applications, admits, deposits and enrolled students by channel, program and term, plus conversion rates between each stage, yield, melt and cost per enrolled student. Media and web data come from ad platforms and GA4, while funnel outcomes come from the admissions CRM as aggregated counts.
- Report cost per enrolled student by program, not cost per inquiry or click.
- Funnel outcomes live in the admissions CRM, so the dashboard needs a scheduled CRM feed.
- Aggregate CRM data by week, program, term and source before it reaches Data Studio.
- Show stage-to-stage conversion rates so marketing and admissions see where students drop out.
What is a higher education marketing dashboard?
It is one live report that follows a prospective student from an ad, a search result or an email to an inquiry, an application, an admit, a deposit and a first day of class. Ad platforms and GA4 cover the first two steps. Everything after that sits in the admissions CRM. A higher education marketing dashboard joins the two, so the marketing team can say which campaigns produced enrolled students in the fall term, not just which ones produced form fills.
The articles ranking for this topic agree on the principle. Higher Education Marketing's guide to enrollment metrics lists inquiry-to-application conversion, yield, melt and cost per enrolled student by channel. OHO's older guide separates marketing output dashboards from outcome dashboards. What they leave out is the build: where each number comes from, how CRM data gets into the reporting tool and how to keep student records out of it. That is what this guide covers, using Data Studio (formerly Looker Studio).
Data Studio suits institutions because it is free for creators and viewers, connects natively to GA4, Google Ads, Search Console, Google Sheets and BigQuery, and the reports belong to the institution's own Google accounts. Deans, program directors and admissions staff can view them without a paid licence.
Which KPIs belong on a higher education marketing dashboard?
Organize the KPIs by funnel stage and always split them by program and entry term. A strong campaign for an online MBA and a weak one for undergraduate nursing will average into a meaningless middle if they share one total. Each stage also has its own owner: marketing drives inquiries, admissions converts applications, and yield and melt depend on financial aid and onboarding.
| Stage | KPI | Usual source |
|---|---|---|
| Awareness | Spend, impressions and clicks by campaign and program | Google Ads native connector, Meta and LinkedIn via partner connector |
| Engagement | Program page sessions, request-info and visit-registration key events | GA4 native connector |
| Inquiry | Qualified inquiries by program, term and source | Admissions CRM export, aggregated |
| Application | Started and submitted applications, inquiry-to-application rate | Admissions CRM export, aggregated |
| Admit and deposit | Admits, deposits, admit-to-deposit yield | Admissions CRM export, aggregated |
| Enrollment | Enrolled students, deposit-to-start melt | CRM or student information system, aggregated |
| Value | Cost per application, cost per enrolled student by program | Calculated in Sheets or BigQuery |
How do you get Slate or other CRM data into Data Studio?
Data Studio has no native connector for admissions CRMs such as Slate, Element451 or TargetX, so the CRM data arrives through a scheduled file or an API job. The goal is one weekly table of counts by week, program, term, stage and source, stored in Google Sheets for smaller volumes or BigQuery for larger ones.
For Slate, the Technolutions knowledge base explains that the only way to automate a query run is a scheduled export, delivered to Technolutions' SFTP servers or a remote SFTP server, with web services as another option. In practice that means building a Slate query that returns aggregated counts rather than person records, scheduling it, and having a small job pick up the file and load it into BigQuery. TargetX sits on Salesforce, so its data is usually reached through Salesforce reports or APIs.
The hard part is the source field, not the plumbing. If Slate stores the first source as free text, or as a mix of UTM values and staff-entered labels, the dashboard needs a mapping table and CASE statements in a calculated field to group them into channels. Agree the channel list with admissions before building anything, then keep it stable across terms so year-on-year comparisons hold.
Data Studio blends are limited to 5 sources with equality joins only, which is rarely enough for spend from three ad platforms, GA4 and CRM counts at once. Joining them in BigQuery first, with tables partitioned by date, keeps the report fast and query costs small.
How do you calculate cost per enrolled student? A worked example
Cost per enrolled student is the marketing spend for a program and term divided by the students from those channels who enrolled in that term. It is the number a dean or CFO can compare with tuition revenue, and it exposes channels that generate many cheap inquiries but few students.
Take a hypothetical graduate program recruiting for one fall term. These are illustrative numbers, not benchmarks. It spends $40,000 on paid search and $20,000 on paid social. Paid search produces 400 inquiries, 120 applications, 70 admits and 36 enrolled students. Paid social produces 800 inquiries, 96 applications, 50 admits and 20 enrolled students.
Cost per inquiry favors social: $25 against $100 for search. Cost per enrolled student says the opposite: about $1,111 for search ($40,000 divided by 36) and $1,000 for social ($20,000 divided by 20), so the gap almost closes. The stage rates explain why. Search inquiries convert to applications at 30 percent, social at 12 percent, so admissions spent far more counselor time per social applicant. The decision is no longer 'move budget to social'. It is 'keep both, and fix the social inquiry-to-application rate'.
In Data Studio these are calculated fields like SUM(spend) / SUM(enrolled) and SUM(applications) / SUM(inquiries), built on one table where spend and CRM counts share week, program, term and channel keys. Because enrollment lags spend by months, the table should attribute students to the term they entered, not the week the money was spent.
How should a higher education marketing dashboard be laid out?
Five or six pages suit most institutions. Put a term selector, a program filter and a level filter (undergraduate, graduate, online) on every page, and a funnel chart near the top of the summary so anyone can see where students drop out.
Build separate views for the people who read them. A vice president of enrollment wants the term summary and pace against last year. A program director wants their own funnel. The agency or in-house media team wants campaign detail. One report with page-level filters usually serves all three.
- Term summary: inquiries, applications, admits, deposits and enrolled students against target and last year, with cost per enrolled student.
- Funnel by program: stage counts and conversion rates for each program and level.
- Channels: spend, inquiries, applications and enrolled students by channel and campaign.
- Website: GA4 sessions to program pages, request-info and visit-registration key events by landing page.
- Events and visits: campus visit and open day registrations, attendance and later applications.
- Yield and melt: admits to deposits and deposits to starts, by program and source.
What does FERPA mean for a marketing dashboard?
The safest design keeps student-level records out of the dashboard entirely. A marketing dashboard needs counts by program, term and source, not names, IDs or grades, so aggregate before the data leaves the CRM.
FERPA has a specific boundary worth knowing. As AACRAO's 'Ask the FERPA Professor' column explains, records on applicants are not education records under FERPA until the applicant becomes a student in attendance. Once they enroll and the institution keeps those records, they become education records. State privacy laws and your own institution's policies may still restrict applicant data, and marketing to Canadian prospects brings consent rules such as CASL. This is a summary, not legal advice, so confirm the design with your registrar or privacy office.
Treat GA4 with the same care. Never send names, email addresses, student IDs or application details into GA4 events or parameters. Keep tags off logged-in applicant portals, and pass only the program and form type with each request-info or visit event.
- Aggregate CRM data to weekly counts by program, term, stage and source before export.
- Store exports in institution-owned Google Cloud or Drive accounts, with view-only sharing for readers.
- Use owner's credentials on data sources so viewers never need access to the underlying tables.
- Keep personal data out of GA4, ad platform conversions and Data Studio calculated fields.
How should you handle attribution across a long enrollment cycle?
Use a simple, stated rule and keep it stable. Higher ed cycles run for months, and a student may click a search ad, attend a virtual event and apply after an email. No model captures that perfectly, and switching models mid-cycle breaks every comparison.
GA4 limits the options. In April 2023 Google announced it would remove the first-click, linear, time decay and position-based models from GA4 and Google Ads, as Search Engine Land reported, leaving data-driven and last-click options. Most institutions therefore report the CRM's first source as the primary view, because it is stored with the person record, and use GA4 for on-site behavior.
Show the rule on the dashboard itself. A one-line note on the channel page saying 'Students credited to the first source recorded in the CRM' prevents arguments when a channel lead sees a number they did not expect.
What mistakes make higher education marketing reports misleading?
Most misleading reports in higher ed are accurate but incomplete. These are the problems we look for first when reviewing an existing report.
- Reporting cost per inquiry as the headline, which rewards cheap, low-intent leads.
- Mixing programs and levels in one total, so a strong online program hides a weak on-campus one.
- Comparing this term's applications with last term's final count instead of the same point in the cycle.
- Counting every form fill as an inquiry, including current students and duplicate submissions.
- Ignoring melt, so a campaign that delivers deposits but few starts looks better than it is.
- Letting source values drift between terms, which breaks year-on-year comparisons.
Should you build it in-house or hire a Data Studio agency?
Build it in-house if you have an analyst with CRM query access, a small number of programs and one or two paid channels. A term summary page fed by a weekly Slate export to Google Sheets is a reasonable first version.
Bring in help when you recruit for many programs across several levels, run media through an agency that needs the same funnel view, need CRM exports automated into BigQuery, or nobody trusts the current numbers. Agencies serving several institutions can also use our white-label service to deliver a consistent report under their own brand.
We are not the right fit if you want a packaged enrollment analytics product with predictive scoring. CRM vendors and specialist platforms offer that. We build custom Data Studio dashboards and the data layer behind them, owned by your institution.
How Greenwolf Tech Labs builds higher education marketing dashboards
We start with a free review of your ad accounts, GA4 setup, CRM exports and the source values your admissions team already records. Then we agree stage definitions with marketing and admissions, build the aggregated CRM feed and the data layer in Sheets or BigQuery, design the pages in Data Studio and reconcile every total against the CRM before handover.
Our team has delivered 100+ projects for 200+ clients, and our multi-channel marketing dashboards bring Google Ads, Meta, LinkedIn, GA4 and Search Console into one view. We quote a fixed price after the review, and everything we build sits in accounts your institution owns.
FAQ
Frequently asked questions
What KPIs should a university marketing team track?
Track inquiries, applications, admits, deposits and enrolled students by channel, program and term, with conversion rates between each stage. Add yield, melt and cost per enrolled student. Cost per enrolled student by program is the figure that links marketing spend to tuition revenue.
Can Slate connect directly to Data Studio?
Not with a native connector. Slate automates query runs through scheduled exports to SFTP or through web services, so the usual route is a scheduled query of aggregated counts that a small job loads into BigQuery or Google Sheets. Data Studio then reads that table alongside your ad and GA4 data.
Does FERPA apply to applicant data in a marketing dashboard?
According to AACRAO's FERPA guidance, applicant records are not education records under FERPA until the applicant becomes a student in attendance. State law and institutional policy may still apply, so aggregate data before reporting and confirm the design with your registrar or privacy office.
What is a good cost per enrolled student?
It varies widely by program, level, market and channel, and published figures are rarely comparable. The useful comparison is your own channels and programs against each other and against net tuition per student. A dashboard that tracks both shows where budget earns the most.
How do you track enrollment marketing ROI across a long cycle?
Credit each enrolled student to the term they entered and to a stated source rule, usually the first source in the CRM. Compare spend for the recruiting cycle with enrolled students and their tuition value. Keep the rule fixed across terms so year-on-year comparisons stay valid.
Can one dashboard cover undergraduate, graduate and online programs?
Yes. Add level, program and term fields to every data source and filters to every page, so each audience sees its own funnel while leaders see the total. Keep separate targets per level, because conversion rates and cycle lengths differ.
Do deans and program directors need a licence to view the dashboard?
No. Data Studio is free for creators and viewers. Data Studio Pro costs $9 per user per project per month and is only needed by creators, editors and managers in Pro workspaces, so people who only read the report never need one.
Keep reading
Related pages
Get started
Tell us what your reporting has to do
Describe the dashboards you need, who reads them and where the data sits. We reply within one business day with an approach, the connectors involved and a fixed-price plan.
- Free 30-minute reporting review
- Fixed quote before any work starts
- Everything built and owned in your Google account
Prefer email? info@greenwolftechlabs.com
Get a free proposal
Two lines is enough to start.