You can query for applications by U.S. state to understand where application volume is coming from. Use this approach to compare state-level demand, identify strong or underrepresented markets, and support recruitment planning.
Try a Slate example 💼
Copy this Suitcase ID and paste it in Database → Suitcase Import to import a pre-made example query:
55d2915b-4204-4449-a8b3-638bdbbb41db:slate-admissions-showcase💡 Tip
Find this query and other importable examples in the Admissions Showcase environment.
Reviewing application volume by state
An applications-by-state query can return one row for each U.S. state or region and show the number of applications associated with that location. This gives your team a quick geographic view of application volume.
The example uses each applicant’s primary address to count applications by state. It sorts the results from highest count to lowest count so the largest application markets appear first.
Building the query
Create the query
Go to Queries / Reports.
Select New Query.
Configure the following settings:
Name: Applications by U.S. state
Folder: Select the folder where the query should be saved.
Type: Configurable Joins
Base: World - Region
Select Save.
Add the Country join
The Country join makes the country for each region available, which lets the query focus on U.S. states.
Select Join.
Select Country.
Select Save.
Add the Country filter
Select Filter.
Under the joined Country path, select Country.
Select Continue.
Set the filter to
IN.From the list, select United States.
Select Save.
Add region exports
These exports identify each state or region returned by the query.
World - Region / ID, labeled State Abbreviation
World - Region / Plain, labeled State
World - Region / Territory Name, labeled Region
Add the count subquery export
The count export is the main output column. It counts applications whose applicant’s primary address matches the current state row.
Select Subquery Export.
Name the export count.
Configure the following settings:
Type: Independent subquery
Category: Records
Base: Application
Output: Aggregate
Aggregate: Count
Same Region
This subquery filter connects each application back to the state row in the parent query. It checks the applicant’s primary address and returns applications where the address region matches the current World - Region row.
In the subquery export, create a join from Application to Person.
Create a join from Person to Address by Rank Overall.
Select Subquery Filter.
Name the filter Same Region.
Configure the filter to compare Address by Rank Overall / Region with the parent query’s World - Region / ID.
Select Save.
Same Country
This subquery filter keeps the application count aligned with the country context of the parent query. In this example, it supports the U.S.-state count by comparing the applicant’s primary address country with the parent query’s joined country.
Select Subquery Filter.
Name the filter Same Country.
Configure the filter to compare Address by Rank Overall / Country with the parent query’s joined Country value.
Select Save.
Select Save again to save the subquery export.
Sort by application count
Select Sort.
Select the count export.
Configure the sort direction as Descending.
Select Save.
Customizing the results
Adjust the query based on the geography or application population you want to review. For example, change the country filter to review a different country, filter the application subquery by round or entry term, or add application-status filters when you only want to count submitted, active, or complete applications.
You can also add exports for territory ownership, counselor assignments, or region groupings if the query will support recruitment travel, territory review, or leadership reporting.