Client Overview

A leading national organization partners with cities to strengthen municipal governance and improve community outcomes. Operating through two major program centers, the organization runs complex, multi-year initiatives covering everything from early learning systems to workforce development to infrastructure policy. Each initiative involves multiple cities, staff members, funding sources, and measurement frameworks. With program portfolios constantly evolving—adding new cohorts, launching complementary phases, forming cross-program partnerships—leadership needed a way to understand the full scope of their impact without drowning in disconnected spreadsheets.

Organization Type: National Civic Organization

Scale: Multiple program centers operating dozens of initiatives across hundreds of cities

Structure: Two major centers with distinct program areas, each running multiple concurrent initiatives

Focus: Municipal capacity building, policy development, and systems change across diverse program areas

The Challenge

As the organization’s work expanded across more cities and program areas, leadership faced mounting challenges in understanding their portfolio:

Portfolio Visibility Gap

• No single view of which cities were engaged across all initiatives, making it impossible to see cumulative organizational impact in any given location
• Leadership couldn’t answer basic questions like ‘How many initiatives are we running right now?’ or ‘What’s our total footprint in California?’
• Cross-program collaboration opportunities were missed because teams didn’t know what other centers were doing in the same cities

Initiative Complexity and Evolution

• Programs evolved through multiple cohorts and phases, but systems couldn’t track this complexity—new phases were treated as entirely separate projects, losing historical context
• Some initiatives operated across program areas or even across the two major centers, but organizational structure forced artificial boundaries
• Staff worked on multiple initiatives with different roles (lead on one, supporting on another), but there was no unified staffing view

Financial and Grant Fragmentation

• Multiple funders supporting multiple initiatives with multiple grants created a compliance and tracking nightmare
• Grant spending and burn rates tracked separately from initiative progress, making it difficult to align financial and programmatic planning
• No systematic way to see which initiatives were fully funded versus which needed additional resources

Measurement Framework Inconsistency

• Each program area measured success differently, making portfolio-level impact reporting impossible
• Metrics ranged from program inputs (activities delivered) through systems outcomes (long-term change), but no framework unified these measurement levels
• Leadership needed to transition from qualitative descriptions to quantitative measurement but lacked the infrastructure to support this evolution

The organization needed a system that could accommodate complexity without creating complexity—one that would grow with their evolving program structure while maintaining clarity about what was actually happening across their portfolio.

The Solution

Park West Digital designed a comprehensive portfolio management system that serves as the organization’s operational backbone. Built in Airtable with a sophisticated hub-and-spoke architecture, the system provides complete visibility into the ‘who, what, where, when, how, and why’ of every initiative while maintaining the flexibility to accommodate organizational evolution.

Hub-and-Spoke Architecture

At the center sits the Initiatives table—the comprehensive record of every project the organization runs. Surrounding it are nine interconnected tables that provide context and detail:

Table	Purpose
Initiatives	Central hub tracking all projects with status, timelines, descriptions, and relationships
Cities	Geographic tracking showing where each initiative operates
People	Staff assignments, roles, and responsibilities across initiatives
Program Areas	Organizational structure and strategic focus areas
Funders	Master list of funding organizations and their relationships
Grants	Detailed financial tracking including budgets, spending, compliance
Metrics	Performance indicators categorized from inputs through systems outcomes
Cohorts	Phases and participant groups within multi-wave initiatives
Topics	Cross-cutting themes enabling topical analysis beyond program structure
States	Geographic hierarchy enabling state-level rollup reporting

Accommodating Organizational Complexity

The system was designed to handle the real-world messiness of how programs actually evolve:

• Initiative records track whether they’re new initiatives, new phases of existing work, renamed programs, or new cohorts—maintaining historical continuity while acknowledging evolution
• Multi-select relationships allow initiatives to span multiple program areas or centers, reflecting actual collaboration patterns rather than enforcing artificial boundaries
• Cohort table enables tracking distinct phases with different cities, metrics, and focus areas while maintaining connection to the parent initiative
• Flexible staffing model distinguishes between directors, lead staff, additional staff, and program area teams—capturing the nuance of how people actually contribute

Geographic Intelligence

The Cities table provides powerful geographic analysis capabilities:

• Automatic calculation of how many initiatives operate in each city, flagging locations with multiple engagements
• State-level rollup enabling leadership to answer questions like ‘Show me everything we’re doing in Texas’
• Cross-initiative visibility surfacing collaboration opportunities when multiple programs work in the same location

Unified Financial View

The Grants table provides comprehensive financial oversight:

• Award amounts, revenue received, expenses incurred, and remaining funds tracked for every grant
• Automatic calculation of percent spent-down enabling proactive grant management
• Status flags (on track, warning, action needed) providing at-a-glance health indicators
• Links to both funders and initiatives connecting financial and programmatic views
• Tracking of compliance requirements including MOUs, no-cost extensions, and indirect cost rates

Measurement Framework Foundation

The Metrics table establishes a unified performance measurement approach:

• Categorization spanning nine metric types from program inputs through long-term systems outcomes
• Flexible linking allowing initiatives to select relevant metrics rather than forcing uniform measurement
• Infrastructure supporting the organization’s journey from qualitative to quantitative measurement without forcing premature precision

Access Control and Permissions

The system implements sophisticated access control:

• Program area owners and team members see only their relevant initiatives
• Leadership views provide complete portfolio visibility across all centers and program areas
• User field linking enables dynamic permission structures that adapt as staff roles change

Results & Impact

Portfolio Intelligence

• Leadership gained immediate answers to previously impossible questions about portfolio composition, geographic reach, and resource allocation
• Cross-program visibility surfaced collaboration opportunities and potential synergies between teams working in the same cities
• Single source of truth eliminated conflicting initiative counts and city engagement numbers in external communications

Operational Clarity

• Staff assignments visible across the entire portfolio, enabling better workload balancing and succession planning
• Initiative lifecycle tracking from planning through completion with clear status indicators
• Historical context preserved as initiatives evolved through multiple phases and cohorts

Financial Oversight

• Grant burn rates and spending patterns visible across the portfolio, enabling proactive financial management
• Clear visibility into which initiatives had secured funding versus which needed additional resources
• Compliance tracking reduced risk of missed deadlines or requirements

Measurement Evolution

• Unified metrics framework positioned organization to transition from qualitative to quantitative measurement
• Portfolio-level impact reporting became possible by aggregating metrics across initiatives
• Infrastructure supports ongoing refinement of measurement approaches without requiring system rebuild

Scalable Foundation

• System accommodates new program structures without architectural changes
• Additional centers can be integrated using the same data model
• Flexible architecture supports integration with external systems like finance platforms and membership databases

Key Success Factors

Reality-Based Design

Park West Digital resisted the temptation to impose clean organizational structures that didn’t reflect how programs actually work. The system was designed around the messy reality of initiatives that span program areas, evolve through phases, and involve staff in multiple roles. This reality-based approach meant the system could be adopted immediately rather than requiring the organization to restructure to fit the database.

Hub-and-Spoke Clarity

Placing Initiatives at the center and connecting all other tables to it created conceptual clarity. Every piece of information in the system has a clear answer to ‘Why are we tracking this?’—because it helps us understand who is doing what, where, when, with what funding, and how we’re measuring success. This architectural coherence makes the system intuitive even as it handles sophisticated complexity.

Integration Readiness

Though initially standalone, the system was architected with future integrations in mind. The data model accommodates connections to finance systems, membership databases, and learning management platforms. This foresight means future enhancements build on the existing foundation rather than requiring painful migrations or parallel systems.

Conclusion

This case demonstrates that portfolio management at scale requires more than better spreadsheets—it requires thoughtful information architecture that reflects organizational reality while providing the structure needed for strategic decision-making. When leadership can see their complete portfolio, understand geographic impact, track financial health, and identify collaboration opportunities, they can make decisions based on comprehensive intelligence rather than fragmented anecdotes.

For nonprofits managing complex, multi-city programs across diverse focus areas, the right system architecture transforms portfolio management from administrative burden into strategic asset—enabling organizations to understand their full impact and allocate resources with confidence.

* * *

Ready to build portfolio intelligence for your multi-city programs?

Contact Park West Digital to discuss your needs.