...
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 will provide provides this information as well as a summary of the number of inquirers by admissions stage and academic program.
Go to Faculty/Staff > Base Reports > Admissions > Admissions Inquiry Applicant Listing
...
.
Enter/Select the Starting Inquiry Date and Ending Inquiry Date.
Select the Progress Codes that correspond with inquiries. This is usually Inquired and Lead by may include other codes to match your business practices.
Optionally select additional criteria such as the semester, site or program in which the inquirer is interested.
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.
...
Prospects will appear multiple times, one row for each activity.
Go to Faculty/Staff > Base Reports > Admissions > Admissions Inquiry Applicant Listing with Activities
...
.
Enter/Select the Starting Inquiry Date and Ending Inquiry Date.
Select the Progress Codes that correspond with inquiries. This is usually Inquired and Lead by may include other codes to match your business practices.
Optionally select additional criteria such as the semester, site or program in which the inquirer is interested.
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.
Go to Faculty/Staff > Base Reports > Admissions > Admissions Inquiry Applicant Listing - Extended.
Enter/Select the Starting Inquiry Date and Ending Inquiry Date.
Select the Progress Codes that correspond with inquiries. This is usually Inquired and Lead by may include other codes to match your business practices.
Optionally select additional criteria such as the semester, site or program in which the inquirer is interested.
Click View Report.