Main Objective: Nationally, only eight percent of ninth graders in low-income communities are expected to graduate from college by age 25. These numbers stand in stark contrast to rates for students in America who grow up in the top income quartile: 82 percent of these ninth graders are expected to graduate from college. OneGoal is a rapidly expanding movement dedicated to systemically changing this reality in Chicago, Houston, New York City, and beyond.

Approach: OneGoal targets under-performing students in low-income high schools with an average incoming GPA of 2.7 and an incoming ACT/SAT score of 15/729 to become OneGoal Fellows. OneGoal recruits, selects and trains high-performing teachers working in schools to become Program Directors and implement our 3-year college success model.

These high-performing Program Directors work with a cohort of 25-30 Fellows to enroll in a college that they are most likely to graduate from by: 1) Increasing college options, 2) Breaking down the college application and enrollment process, and 3) establishing academic, financial, and social foundations to succeed in college.

Challenge: OneGoal uses as our primary tool for tracking our student outcomes and we need the ability to quickly roll up custom objects on contact and organization records to ensure that our Fellows are on track. For example, we have a custom object "College Applications" that tracks the colleges our Fellows apply to and we didn't have an easy way of seeing how many Fellows submitted X number of applications or were accepted to Y number of schools.

We reached our Rollup Summary limit with Salesforce and we still didn't have access to the real-time data and analysis to give our Fellows the differentiated support they deserve. We needed a solution that would allow us to summarize and cut our data in many ways AND have the flexibility to add/change our rollups as our program model improves.

Solution: Lots and lots of rollups! We have dozens of rollups that pull key metrics aligned to our goals and benchmarks.

Results: Our bottom line or ROI is student outcomes and this information has allowed us to provide better and more differentiated support to our Fellows. This support helps our Fellows apply and enroll in the right colleges for them and, ultimately, graduate from college.