Skip to main content
Liaison

Creating Reports via the Report Manager

Getting Started with Data Extraction

If you're just getting started with WebAdMIT's data extraction tools, we recommend you review the following information:

  • Create customized data files through the Export Manager. You can include only the information that you want, in the order you want it. Be sure to review your CAS's data dictionary and master code lists to learn what fields are available to you.
  • Bulk download applicant files through the PDF Manager. Bulk downloads can include the full application PDF, transcripts, letters of recommendation, etc.
  • Pull pre-built reports on your applicants and admissions users through the Report Manager. Reports can also help you compare your applicant pool to the entire CAS applicant pool.
  • Configure and schedule SFTP deliveries to your Student Information System (SIS).
  • If available to you, spot trends and help shape your class through reports in Analytics by Liaison.

Additionally, if you're interested in creating a data feed between WebAdMIT and your data systems, explore these resources:

  • Review the Integration Help Center for best practices and tips in moving records from WebAdMIT into your institution's systems.
  • The WebAdMIT API is the tool that allows you to integrate applicant data into your institution's SIS/ERP system.
  • You can also explore additional APIs, like the Custom Fields API and PDF Manager API.

Video Overview

Overview

WebAdMIT provides you with a suite of predefined reports that you can run against all applicants or an existing list.

Gaining Access to This Feature

The Report Manager feature is available under the Reports & Exports panel and access to this tool is controlled through Work Groups. You must have the Manage Lists, Reports, and Exports permission to create reports and edit any templates that you created.

Additionally, be aware that Institution Managers who are in the WebAdMIT Administrators Work Group can view and delete all reports created within their organization.

Creating Reports

  1. Using the Menu Bar, open the Reports & Exports panel, then click Report Manager.
  2. Click New Report.
  3. Enter a name for your report.
  4. Select the report type and format. Review the Report Types section for report definitions.
    • Applicant reports focus on data about your applicant pool.
    • Comparative reports compare your applicant pool to the entire CAS pool.
    • Decision reports are based on the Decision Codes that you have assigned to your applicants.
    • User reports focus on your program’s Admissions Users.
  5. Select an existing list to run the report against, if applicable.
  6. Indicate if the report should appear in the Menu Bar under the My Exports and Reports subpanel in the Reports & Exports panel. This option provides you with quick access to run the report.
  7. Select who can view the template (e.g., just yourself, specific Work Groups, or all Work Groups). Institution Managers who are in the WebAdMIT Administrators Work Group can view and delete any reports created within their organization.
  8. If you selected a Comparative report type, then you can add additional parameters:
    • Select if the report will run based on your applicants or applications. Running reports based on applications will count each application separately. If an applicant applies to multiple programs at your organization, then they are counted multiple times. Running reports based on applicants counts each applicant only once.
    • Select if your report's results will be limited based on an applicant's Decision Code. Only applicants whom you and other programs have placed in the selected Decision Code will appear in the report. For this reason, we recommend using this Decision Code filter after all final Decision Codes are submitted to your association (typically at the end of the cycle) so that you can have the most comprehensive report.
    • If available, select if your report will compare data across the entire CAS or five or more organizations within the CAS. This allows you to compare your data to similar organizations (e.g., regionally, competitively, etc.).
  9. Click Save and Run Report to run and save the report, Save Report Settings to save the customized report for future use, or Return to Report Manager to discard the report.

Report template built for GPA averages

Downloading a Report from Recent Files

Once you run a report, you'll automatically be sent to the Recent Files page. You can also retrieve exports, reports, and PDF templates run within the past seven days from this page. Be aware that the files you can view on the Recent Files page depend on your Work Group permissions. If you do not have access to specific applicant data, then you will not see reports including that data.

To download a report:

  1. Using the Menu Bar, open the Reports & Exports panel, then click Recent Files.
  2. Click the file link in the Download column. Once you download your report file, you can use your system's software to sort, reorder, and filter the data.

Recent Files page with a GPA report for download

Managing Reports

To manage existing reports, click Report Manager from the Menu Bar. You can view and perform the following actions for reports that you created or that other users created and shared with you.

Report Manager page with management functionality, including editing and deleting

Running Reports

Click the report name to run it.

Pinning Reports to the Menu Bar

Click the checkbox to pin a report in the Menu Bar under the My Exports and Reports subpanel in the Reports & Exports panel; this option provides you with quick access to run the report.

Scheduling Reports

Use the calendar icon to schedule a file transfer for a report. You can also click the eye icon to review existing file transfer logs.

Editing Reports

Use the pencil icon to edit a report. Note that only report owners can make edits. If you'd like to edit or see the settings of a report that you are not the owner of, you can create a copy of it instead.

Copying Existing Reports

Use the duplicate icon to copy an existing report.

Deleting Reports

Use the trash icon to delete a report. Note that only report owners and Institution Managers who are in the WebAdMIT Administrators Work Group can delete reports.

Report Types

Reports available to you will vary based on the CAS you're working in and the time of the cycle. The list of reports below is not all-inclusive and your CAS may have additional reports available. To view the report description and additional details, click the report name.

Applicant Reports

These reports focus on data about your applicant pool.

A-G Subject Report
Includes applicant CAS ID, name, high school course title, A-G Subject classification, high school name and CEEB code, grade level, home school status, year, term, term type, course credits, applicant-reported grade by quarter and year, discipline code and description, and transcript abbreviation. Download the A-G Subject Report data dictionary for more information about the fields, field types, and associated lookup tables.
 
Applicants by Application Status
Includes applicant CAS ID, name, number of designations they have submitted their CAS application to, the organization and program(s) they have applied to at your institution, their Application Status, and the decision code you have placed them in.
 
CAPTE AAR
Includes data useful for the CAPTE accreditation process, such as the number of applicants who applied and were given an offer of admission, and their average GPAs and ages.
 
Colleges Attended with Degrees
Can be filtered by All Colleges Attended with Degrees or Primary Colleges Attended with Degrees. The Primary indicator is selected by the applicant in their application. This report includes applicant CAS ID, name, college name, attended dates, degree, degree status, and degree earned date.
 
Coursework
Includes applicant CAS ID, name, course prefix, course name, applicant-reported grade and credits, CAS grade, converted numeric grade, verified grade and credits, college code and CEEB code, college name, year, term, term type, status, level, subject, and classification. Download the Coursework data dictionary for more information about the fields, field types, and associated lookup tables.
 
Designations by Application Status
Includes organization name, program name(s), the number of applicants who are in each Application Status, and the total number of applicants for each program and each status.
 
Designations by Decision Code
Similar to Designations by Application Status, this report includes organization name, program name(s), and the number and percentage of applicants who are in each Decision Code (as specified by your program). It also includes the total number of applicants for each program and each Decision Code.
 
Evaluations Report
Can be filtered by evaluation type. This report includes all of the requested and completed evaluations for each applicant, including the applicant's name, ID, evaluation status, received date by the CAS, evaluator's name, contact information, occupation, organization, and title, evaluation details and ratings, waiver status, and permission to contact the evaluator. Download the Evaluations Report data dictionary for more information about the fields, field types, and associated lookup tables.
 
Feeder School Report
Lists the undergraduate universities that feed applicants into your program, including the primary colleges attended, the number of applicants who reported those as their primary college, and a numeric breakdown of those applicants by gender, ethnicity and race, and residency status by gender/sex.
 
Folder Labels – Avery 5160
Includes applicant CAS ID and name, with last name listed before first name.
 
GRE General Official
Includes applicant CAS ID, name, GRE received date, GRE date, quantitative, verbal, and written converted and percentile scores.
 
High School Coursework
Similar to Coursework, this report includes applicant CAS ID, name, course title, applicant-reported grades by quarter and year, high school CEEB code, high school name, home school status, year, term type, course selection, level, and course type. Download the High School Coursework data dictionary for more information about the fields, field types, and associated lookup tables.
 
Local and Prerequisite GPAs
Lists the Local GPA and Prerequisite GPA template names, type, applicant count, and average GPA, credits, and quality points for those applicants.
 
Local Status History
Includes applicant CAS ID, name, designation, designation WebAdMIT label, Local Status, Local Status changed date, Local Status changed by, Decision Code, Decision Code changed date, and Decision Code changed by. Review the Decision Code and Local Status update behavior under the Applicant Details page's History panel.
 
Local Status Summary
Includes your program’s Local Statuses along with number and percentage of applicants for your applicant pool.
 
Mailing Labels – Avery 5160
Includes applicant name, street address, city, state, zip code, and country.
 
Payment Data
Includes applicant CAS ID, student ID, name, designation, organization, payment type, method, status, total amount paid, amount by cash, coupon, fee waiver, payment date, request ID, transaction number, confirmation number, and coupon code.
 
Prerequisite Courses
Lists the prerequisite block name, each prerequisite criterion, and whether they have been fulfilled. Includes full details of each course and college. Download the Prerequisite Courses data dictionary for more information about the fields, field types, and associated lookup tables.
 
Scoring Details
Includes applicant CAS ID, name, country, scorable fields, scores for each field, converted values for each field, overall score, and ranking.
 

Comparative Reports

These reports compare your applicant pool to the entire CAS pool or, if available, five or more organizations within the CAS.

Ages
Includes age groups, number and percentage of applicants for the CAS and your program, and median age, age range, and average age for the CAS and your applicant pool.
 
Ages by Gender or Sex
This report splits the applicants by gender/sex, and runs the same data from the Ages report for each grouping.
 
Applicant Reported GREs
Can be filtered by All GREs, Highest Quantitative Percentile, Highest Quantitative and Verbal Combined Percentile, Highest Verbal Percentile, or Most Recent GREs. Lists the applicant-reported GRE score breakdowns, with old and new GRE scoring standard, and the mean scores of applicants for the CAS and your programs.
 
Applicant Reported GREs by Gender or Sex
Can be filtered by All GREs by Gender or Sex, Highest Quantitative Percentile by Gender or Sex, Highest Quantitative and Verbal Combined Percentile by Gender or Sex, Highest Verbal Percentile by Gender or Sex, or Most Recent GREs by Gender or Sex. This report splits the applicants by gender/sex, and runs the same data from the Applicant Reported GREs report for each grouping.
 
Applicant Reported OAT Results
Can be filtered by All OAT Results, Highest Academic Average Result, or Most Recent OAT. Lists the applicant-reported OAT score breakdowns and the mean scores of applicants for the CAS and your programs.
 
Applicants Reporting Economic Disadvantage
Includes the number/percentage of applicants who identify as economically disadvantaged for the CAS and your programs.
 
Applicants Reporting Environmental Disadvantage
Includes the number/percentage of applicants who identify as environmentally disadvantaged for the CAS and your programs.
 
Citizenship Status
Lists number and percentage of applicants based on citizenship status.
 
Colleges Attended
Can be filtered by All Colleges Attended or Primary Colleges Attended. Lists all applicants’ colleges attended school names, school states, applicants for the CAS, and your applicant pool.
 
Countries of Birth
Includes countries of birth abbreviations and number/percentage of applicants for the CAS and your programs.
 
Country of Citizenship
Includes countries of citizenship and number/percentage of applicants for the CAS and your programs.
 
DAT Official Scores
Can be filtered by All DAT Official Scores, Highest Academic Average DAT Official Scores, or Most Recent DAT Official Scores. Lists the official DAT score breakdowns and the mean scores of applicants for the CAS and your programs.
 
Degree Awarded
Lists types of degrees and number/percentage of applicants for the CAS and your programs.
 
Degree Expected
Similar to Degree Awarded report, though for those applicants with a degree expected rather than earned.
 
Ethnicities and Races
Lists major ethnicity and race groups as determined by the CAS, and number/percentage of applicants for the CAS and your programs. Applicants who report multiple ethnicities and races are placed in the Multiple category. This report's percentage breakdowns total 100%.
 
Ethnicities and Races by Gender or Sex
This report splits the applicants by gender/sex, and runs the same data from the Ethnicities and Races report for each grouping. Applicants who report multiple ethnicities and races are placed in the Multiple category. This report's percentage breakdowns total 100%.
 
Ethnicities and Races by Residency
This report splits the applicants by US Citizens/Non-Citizens, and runs the same data from the Ethnicities and Races report for each grouping. Applicants who report multiple ethnicities and races are placed in the Multiple category. This report's percentage breakdowns total 100%.
 
Ethnicities and Races by Residency and Gender or Sex
This report splits the applicants by US Citizens/Non-Citizens and gender/sex, and runs the same data from the Ethnicities and Races report for each grouping. Applicants who report multiple ethnicities and races are placed in the Multiple category. This report's percentage breakdowns total 100%.
 
Ethnicity and Race (Ignoring Two or More)
Lists major ethnicity and race groups as determined by the CAS, and number/percentage of applicants for the CAS and your programs. For applicants who have chosen more than one ethnicity/race, they will be included within each ethnicity/race category, rather than a Multiple category. This report's percentage breakdowns total more than 100%.
 
Gender or Sex
Lists gender/sex breakdowns and number/percentage of applicants for the CAS and your programs.
 
GPAs by Subject
Lists the subject groupings and mean GPAs of applicants for the CAS and your programs.
 
GPAs by Subject by Gender or Sex
This report splits the applicants by gender/sex, and runs the same data from the GPAs by Subject report for each grouping.
 
GPAs by Year
Lists the year breakdowns, and if applicable, the science, non-science, math, and overall mean GPAs of applicants for the CAS and your programs.
 
GPAs by Year by Gender or Sex
This report splits the applicants by gender/sex, and runs the same data from the GPAs by Year report for each grouping.
 
Majors
Lists majors and number of applicants for the CAS and your programs. The list is arranged from most popular to least popular, based on your applicant numbers.
 
MCAT Official (After Jan 31 2015)
Can be filtered by All MCAT Officials, Highest Overall MCAT Official, or Most Recent MCAT Official. Lists the official MCAT (after January 31, 2015) score breakdowns and the mean scores of applicants for the CAS and your programs.
 
MCAT Official (Before Jan 31 2015)
Can be filtered by All MCAT Officials, Highest Overall MCAT Official, or Most Recent MCAT Official. Lists the official MCAT (before January 31, 2015) score breakdowns and the mean scores of applicants for the CAS and your programs.
 
Military Service
Lists military service types and number/percentage of applicants for the CAS and your programs.
 
Official OAT Report
Can be filtered by Most Recent Official OATs Only, Official OATs Highest Academic Average, or All Official OATs. Lists the official OAT score breakdowns and the mean scores of applicants by gender for the CAS and your programs.
 
PCAT Official Scores
Can be filtered by Highest Composite PCATs, Most Recent PCATs, or PCAT Official Scores. Lists the official PCAT score breakdowns and the mean scores of applicants for the CAS and your programs.
 
States/Provinces of Residence
Lists states/provinces of residence and number/percentage of applicants for the CAS and your programs.
 
States/Provinces of Residence by Gender or Sex
This report splits the applicants by gender/sex, and runs the same data from the States/Provinces of Residence report for each grouping.
 
Zip Code
Lists zip codes and number/percentage of applicants for the CAS and your programs.
 

Decision Reports

These reports are based on the Decision Codes that you have assigned to your applicants, as well as the Decision Codes other programs have assigned to their applicant pools. The accuracy of these reports depends on you and other programs placing applicants in Decision Codes in WebAdMIT. These reports are only available at certain points in the cycle, typically after a cycle closes.

Decisions by Applicant
Lists all applicants, their states of residence, the names and number of programs they applied to, and the Decision Code they were placed in for that program.
 
Offers Received
Lists the number of applications per applicant, the total applicants for each breakdown, and the number of offers an applicant receives based on the number of applications the applicant submitted.
 
Shared Applicants
Lists all the institutions and programs participating in the CAS and the number of applicants you share with that program.
 
Shared Offers
Where applicable, this lists all the institutions and programs participating in the CAS and these breakdowns:
  • Total Number of Applicants Your Program Shares with the Competing Program
  • Applicants Receiving an Offer from Your Program(s) that have Applied to the Competing Program
  • Applicants Accepting an Offer from Your Program(s) that have Applied to the Competing Program
  • Applicants Receiving an Offer from the Competing Program that have Applied to Your Program(s)
  • Applicants Accepting an Offer from the Competing Program that have Applied to Your Program(s)

User Reports

These reports focus on your program’s Admissions Users.

Admissions Users
Lists cycles, CASs, organizations, program names and labels, user names, email addresses, phone numbers, Work Groups, primary user indicator, institution manager indicator, active/deactivated account, date the account was created, last update and login, and login count. This includes only the admissions users for the CAS and cycle you're working in. For example, if you run the report in the PharmCAS 2022-2023 cycle, then only the admissions users that have the PharmCAS 2022-2023 cycle added to their account appear. If you're an institution manager, you can view users across all CASs and cycles you have access to.
 
Interviewer Availability
Lists user names, Interview template name, Interview date and time, and availability.
 
Programs List
Includes institution name, programs, program identifiers, and program labels for the entire institution.
 

Reports Available in the Applicants Panel

Several CASs offer additional Decision Code reports accessible under the Applicants panel in the Menu Bar. If your CAS offers these reports, you must also report final Decision Codes. These reports may be available throughout the cycle or only during a specific time; contact a member of your account team to learn more.

Competing Offers Made
Displays applicants placed in the Offer Made Decision Code by you and other programs. Lists the applicant's name, email, CAS ID, and the number of offers made, including your program (i.e., 2 Offers Made Count includes 1 Offer Made for your program and 1 Offer Made for another program).
 
Competing Offers Accepted
Displays applicants placed in the Offer Accepted Decision Code by you and other programs. Lists the applicant's name, email, CAS ID, and the number of offers accepted, including your program (i.e., 2 Offers Accepted Count includes 1 Offer Accepted for your program and 1 Offer Accepted for another program). If activated by your CAS, you may also view the other program names.
 
Shared Decisions
This may have a different label, such as Matriculated Elsewhere. Displays applicants placed in specified, predefined Decision Codes by you and other programs. Lists the applicant's name, email, Decision Codes at your program and other programs, and the number of competing decisions, including your program (i.e., 2 Total Competing Decisions include 1 qualifying Decision Code for your program and 1 qualifying Decision Code for another program). If activated by your CAS, you may also view the other program names.
 

Applicants panel with Shared Decisions and Competing Offers Accepted reports

Deactivated Reports

The reports below are no longer available in cycles that use the 3.X application because they are built on fields from the 2.0 application. If desired, you can run them in previous cycles of WebAdMIT that used the 2.0 application.

Applicant Reports

  • ADEA CAAPID Cumulative Roster Report
  • ADEA PASS Cumulative Roster Report

Comparative Reports

  • ADEA PASS End of Year Reports
  • Applicant Distribution by Month: charts each month, starting with the previous month you pull the report, to a year before. Includes number/percentage of applicants based on Received, Complete, and Verified application statuses.
  • Evaluation Likert Analysis
  • Evaluator Recommendation
  • Financial Aid
  • First Learned/Heard About Profession
  • Highest Degree Earned: lists the degrees available in the application and the number/percentage of applicants who reported them as their highest degree earned for the CAS and your programs. Applicants can report multiple highest degrees, so the total number of reported degrees may be higher than the number of applicants.
  • Most Influenced to Pursue Profession
  • Summary: lists select reports (total applicants, citizenships by race/ethnicity, average age and GPAs of applicants, Decision Codes, and highest degree earned), split by gender for applicants in your applicant pool.
  • Was this article helpful?