You don't need a counselor for that. It's required by the feds to be published annually on each college's website. Search for the "Common Data Set". It gives you all the data on what is given out for both needs based and non-need based merit aid.
Being OCD about the research, I made a spreadsheet of what I think the relevant data is from the CDS. Below is an example for the School of Mines.
Yield is the percent of students offered enrollment who actually attend. The golden goal is 30%. Look for schools with a low yield, they are more likely to buy students with aid.
Testing is just the high school academic profile of incoming freshmen.
Needs Based Aid is for low income students.
Non-Need Based Aid is merit aid.
The section on where to find this data in the CDS is in the heading of each column.
Colorado School of Mines
C1 - Yield
C9 - Testing
C11 - GPA
H2 - Need Based Financial Aid
H2A - Non-Need Based Financial Aid
Admits
Enrolled
Yield
SAT Composite
SAT Reading
SAT Math
ACT Composite
ACT Math
ACT English
Average GPA
Men
4,231
974
23.0%
25th Percentile
1320
650
660
29
28
27
3.84
E - Number of Students Awarded Any Needs Based Financial Aid
346
N - Number of Freshman Students
442
Women
2,607
474
18.2%
75th Percentile
1460
720
750
33
33
34
K - Average Amount of Needs Based Financial Aid
$5,104
O - Average Amount of Scholarships & Grants
$9,173
Total
6,838
1,448
21.2%
24%
Percent of Freshmen
31%