This query provides a view of one year’s worth of applicants. It includes applicant details, including the current status of their application. Use this query to track progress across the application cycle and monitor overall pipeline health.
Import with Suitcase
Copy this Suitcase ID and paste it in Database → Suitcase Import to import the query:
86040372-071d-4b18-93ec-2badb9d5209c:slate-admissions-showcase💡 Find this query and many others in the Admissions Showcase environment.
Common use cases
You can use this query to surface details about this year’s applicants. You might use it to:
Monitor application status distribution
Identify applicants who need follow-up based on their current status
Support counselor visibility into their assigned applicants and pipeline progress
Provide reporting to leadership on application progress and volume
Track movement through the funnel to identify bottlenecks or delays
Customization
There are many ways to tweak this query to suit your needs:
Adjust filters to focus on a specific entry term or application round within 2025
Narrow results by application status to isolate specific groups
Add counselor assignment or territory fields for more targeted insights
Include additional applicant details such as program, major, or demographics
💡 Make a copy before you start editing.
Assumptions
This example assumes standard Slate application statuses.
Always test before using in production communications.