International admissions data is the foundation for every resource-allocation decision: which markets to invest in, which channels are effective, and where the pipeline is leaking.
Without data, every decision is based on gut feeling, and gut feeling is often significantly off from reality.
This guide sets out the twelve minimum fields, how to define them, and how to start without investing in a system.
Principle: fewer fields, but recorded consistently
A common mistake when starting out is designing a system with fifty fields. The result is that no one fills them all in, and the data collected is unusable.
The opposite approach works far better: choose fewer fields, define them clearly, and record them consistently.
The twelve fields listed below are enough for all basic analysis. Once the recording habit is established, more can be added, but this is where to start.
Second principle: record as things happen, not by compiling retrospectively. Data recalled at the end of the season is always incomplete and inaccurate.
The twelve minimum fields
One: application ID. A unique identifier for each learner, used consistently throughout.
Two: source market. Country, and if possible the province or city as well. This is the most important field for resource allocation.
Three: acquisition channel. How the learner found the institution: which partner, which event, whose referral, or found it themselves.
This is the hardest field to collect but the most valuable. The effective way to collect it is to ask right on the first contact form, with preset options rather than a blank field.
Four: program of interest.
Five: date of first contact.
Six: date of the institution’s first response. These two fields yield the response-time metric.
Seven: application submission date.
Eight: admission decision and the date it was issued. Specify whether it is an unconditional or conditional offer.
Nine: date of enrollment confirmation.
Ten: actual enrollment date.
Eleven: reason, if the process is dropped at any stage. This is the field most often left blank, and also the most needed. Use a preset dropdown list rather than a free-text box.
Twelve: entry foreign-language level. By individual skill if available. This field supports reviewing the entry threshold later on.
Clearly define each field
This step determines whether the data is usable, and it is also the step most often skipped.
Examples of points that are easily interpreted differently.
Date of first contact is it the day the learner sent a question, the day they filled in the form, or the day a partner logged them. These three points can be weeks apart.
Substantive response — what counts as one. Does an automated acknowledgment email count?
Actual enrollment — is it the registration date or the date of attending the first class?
Acquisition channel — when a learner heard about the institution through multiple sources, which one gets recorded?
For each field, write one definition sentence and keep it alongside the data table. Without a definition, the figures will not be comparable across seasons or across the people entering them.
Start with a spreadsheet
You don’t need a complex system to start. A spreadsheet with twelve columns is enough for a few hundred applications a year.
Advantages. It costs nothing, anyone can use it, and it is easy to adjust once gaps are found.
Drawbacks to keep in mind. Multiple people editing at once can cause conflicts, and personal data in a spreadsheet needs to be properly protected.
Four principles for using a spreadsheet.
One row per learner, never merged.
Use dropdown lists for columns with fixed values, to avoid the same content being entered in different ways.
Never delete rows; only mark status.
Back up regularly.
Once volume outgrows what a spreadsheet can manage, migrating to a dedicated system will be much easier if the data has been well-structured from the start.
What questions international admissions data answers
The twelve fields above make it possible to answer six important questions.
What is the average response time? From fields five and six.
What is the conversion rate at each stage? From the date milestones.
Which channel is most effective? Not the channel bringing in the most applications, but the one with the highest enrollment rate per application.
Which market deserves further investment? Compare conversion rates and volume across markets.
What is the main barrier? From field eleven.
Is the language threshold appropriate? Cross-check field twelve against later academic results.
The third question deserves emphasis. Many institutions evaluate channels by application volume, and the conclusion often reverses when viewed by conversion rate.
Linking with post-enrollment data
The value of admissions data multiplies many times over when linked with academic outcomes.
Three additional fields are needed downstream.
Whether the learner is still enrolled after the first year.
First-year academic results, at a general level.
Whether the program was completed, recorded much later but still worth keeping.
Linking these three fields with the intake data makes it possible to answer the most important question: which group of learners is genuinely the right fit for the institution.
The results often change the way you see things. A channel that brings in few applications but whose learners complete the program at a high rate is worth far more than a channel bringing in many applications with a high dropout rate.
Linking the data requires the application ID to stay consistent throughout, which is why the first field in the list matters more than it appears to.
Protecting the data
All of this data is personal data, so it must follow protection principles.
Minimal collection. The twelve fields above are what analysis requires. Do not collect anything more that you won’t use.
Limit access. Only those who genuinely need it can view it, and each person has their own account.
Do not store it on personal devices.
Delete once the purpose has been served. Data on people who did not enroll does not need to be kept indefinitely.
Ẩn danh khi phân tích. For trend analysis, identifying data is not needed. The identifying portion can be separated from the portion used for analysis.
This last point is both safer and makes internal data sharing easier.
Who enters the data
This is the question that determines whether the data is complete.
The person directly handling the case should be the one entering the data, right when it happens. Assigning one person to compile it later from multiple sources always leads to gaps.
Data entry must be a step within the process, not extra work tacked on at the end of the day.
Someone needs to review the data periodically. Check each month whether any field is repeatedly left blank. A recurring blank usually means that field is hard to collect or its definition is unclear.
For data coming from partners, definitions and formats need to be agreed on from the start, so they don’t need reworking when entered into the shared system.
When you need to benchmark your own figures against the broader context across education systems, data from the Organisation for Economic Co-operation and Development (OECD) serves as the reference source.
For matters concerning degree recognition that may affect a learner’s decision and should be recorded in the reason field, the framework of The United Nations Educational, Scientific and Cultural Organization (UNESCO) is a source worth citing in advisory materials.
Summary
International admissions data only needs twelve fields to answer the six most important questions, and the principle is fewer fields recorded consistently rather than many fields left blank.
The step that determines data quality is clearly defining each field and keeping the definitions alongside the table, because without it the figures cannot be compared.
And the value multiplies many times over when intake data is linked with academic outcomes, revealing which group of learners is genuinely the right fit for the institution.
Next Steps
Create a spreadsheet with the twelve columns above and start recording from the next application onward, with no need to re-enter old data.
After one admissions season, this table will answer questions that your institution can currently only guess at.
