Find all people who have expressed interest in attending your institution but not yet applied.

You need to gauge interest in certain academic programs or sites, or understand where your prospects are coming from.

Considerations

• Do you want to see all inquirers or filter on:

  • Admissions site

  • Academic program

• Do you have full Permissions access to all inquirers?

Start with a pre-built filter

Use this as a starting point. You can add fields to further narrow inquirers returned.

1. Go to Filters > Prospects.

2. In All Users select ZCC Inquirers Last Month.
   
   

   Open

   

3. Click Filters.
   
   

   Open

   

4. By default, the filter shows inquiries submitted within the last month. You may adjust the Inq Date.
   For example, you can show all inquiries with a date greater than > a specific date. Below would return all inquires submitted after 10/3/2024.
   
   

   
   Or you can show all inquires between two dates. Notice the first Inq Date is greater than > and the second Inq Date is less than <. Below would show all inquiries submitted after 10/1/2024 and before 10/31/2024.
   
   

5. By default, the filter shows inquiries with the progress codes of inquired (I) and lead (L). Depending on your business need, you may need to include other codes. Next to Progress Code click the three horizontal lines, select the codes and click Apply.
   
   

6. Next to Adm Ent Sem click the three horizontal lines, select the semester the applicants applied to and click Apply.
   
   

7. Click Submit.

Add criteria

You can further narrow your results by selecting Add Fields, searching for the field name and selecting it.

• Adm Ent Sem to narrow the results to only those inquirers inserted in attending a specific semester.

• Admissions Site o narrow the results to only those inquirers interested in a specific site. Your sites may be physical such as different campuses or program-based such as a day program and a night program.

• Counselor Code to narrow the results to only those inquirers assigned to a specific admissions counselor(s).

Build results

You can show additional information alongside the results by selecting Column Visibility, searching for the field name and selecting it.

• Inq Date shows the date the person inquired.

• Inq Majors shows the academic programs to which the person expressed interest.

• Adm Ent Sem to narrow the results to only those inquirers inserted in attending a specific semester.

• Progress Code shows where they are in the admission process. Inquired, applied, accepted, rejected, deposited, etc.

Save the result format

Once you show the columns you need - and optionally rearrange their order by clicking and dragging them - you can save the column arrangement. Click the disk then give your result layout a name then click Save.

Next time you run the report, you can quickly show the same result columns by selecting your configuration from the drop down menu.

SSRS base reports for additional data

Calculate totals by stage/program

While the filter will display a list of results and associated information like the inquirer’s demographics, this delivered base report provides this information as well as a summary of the number of inquirers by admissions stage and academic program.

1. Go to Faculty/Staff > Base Reports > Admissions > Admissions Inquiry Applicant Listing.

2. Enter/Select the Starting Inquiry Date and Ending Inquiry Date.

3. Select the Progress Codes that correspond with inquiries. This is usually Inquired and Lead by may include other codes to match your business practices.

4. Optionally select additional criteria such as the semester, site or program in which the inquirer is interested.

5. Click View Report.

Get activities for each inquirer

You can use a base report to find inquiries and all their associated activities. For example, you may automatically assign an activity to remind the admissions counselor to call the prospect. This report shows the prospect along with the phone call reminder activity.

Separately, if you use activities to track sources of interest, this report will help you understand what is leading your prospects to your institution.

Prospects will appear multiple times, one row for each activity.

1. Go to Faculty/Staff > Base Reports > Admissions > Admissions Inquiry Applicant Listing with Activities.

2. Enter/Select the Starting Inquiry Date and Ending Inquiry Date.

3. Select the Progress Codes that correspond with inquiries. This is usually Inquired and Lead by may include other codes to match your business practices.

4. Optionally select additional criteria such as the semester, site or program in which the inquirer is interested.

5. Click View Report.

Get lead Url Field (UTM) for each inquirer

If you gather inquires from outside sources and use the Campus Cafe OpenAPI to bring them into Campus Cafe, you can use a base report to see the leadUrl Field (UTM). This will help you understand what websites your inquiries are engaging with.

1. Go to Faculty/Staff > Base Reports > Admissions > Admissions Inquiry Applicant Listing - Extended.

2. Enter/Select the Starting Inquiry Date and Ending Inquiry Date.

3. Select the Progress Codes that correspond with inquiries. This is usually Inquired and Lead by may include other codes to match your business practices.

4. Optionally select additional criteria such as the semester, site or program in which the inquirer is interested.

5. Click View Report.