YMCA of San Francisco - Data Warehouse

Read the full case study.


The YMCA of San Francisco built a centralized data warehouse with BigQuery to better understand the needs of the community, grow membership, and optimize its fundraising efforts.


The YMCA of San Francisco works to expand opportunities for everyone, strengthening the foundations of area communities through youth development, social responsibility, and promoting healthy living through initiatives such as the YMCA Diabetes Prevention Programs and Y Bike. For more than 160 years, the YMCA of San Francisco has addressed the most pressing social issues of the day — whether helping immigrants adjust to life in America, providing safe spaces for kids from all backgrounds to learn and grow, or helping soldiers returning from duty to find civilian jobs back home.

Through 15 branches and hundreds of program sites, the YMCA of San Francisco serves nearly 50,000 members and nearly as many community participants with community-focused activities and programs. It has a strategic plan and 2020 vision that the healthiest children in America will live in the Bay Area, strong in spirit, mind, and body. Increasing membership is important to achieving this goal, and the organization seeks to grow it by 5% annually.