A national social impact organization operates at the intersection of media, advocacy, and capital deployment. Their small team in the Office of the Founder manages a vast network of partners, advisors, funders, and collaborators across initiatives ranging from documentary production to grant-making programs. With shifting priorities and a need to move quickly on emerging opportunities, the team required a relationship management system that could keep pace with their dynamic work while remaining lean and maintainable.

Industry: Social Impact / Non-Profit

Organization Size: Small team managing a high-profile network

Focus Areas: Media production, capital mobilization, and cross-sector partnerships

The Challenge

Before partnering with Park West Digital, the organization faced several critical obstacles:

• Fragmented contact management across multiple spreadsheets and tools, making it impossible to get a complete view of their network
• Labor-intensive manual processes for event preparation, with team members scrambling to compile guest lists and briefing materials
• No systematic way to track relationship reciprocity—who they’d asked for help versus who they’d supported
• Missed opportunities to leverage their network effectively due to lack of visibility into who knew whom and what projects people were connected to
• Limited team capacity to take on new initiatives because relationship management consumed so much time

As one team member put it: “We had a huge network but no way to actually use it strategically. We were constantly reinventing the wheel for every event and missing connections that were right in front of us.”

The Solution

Park West Digital designed and implemented a custom VIP relationship management system in Airtable, purpose-built for the organization’s unique workflow. The key was creating a system that would grow organically and become more valuable over time, without requiring excessive maintenance.

Core System Architecture

The system centers on four interconnected tables that capture the full context of the organization’s network:

• People – Individual contacts with profile information, relationship history, and interaction insights
• Organizations – Companies and entities that contacts represent
• Initiatives – Projects, events, and programs that serve as connection points
• Links – The relationships between people and initiatives, tracking asks made, support given, and engagement type

User-Friendly Interfaces

Custom interfaces made the system accessible to the entire team:

• Directory view with powerful search and filtering for quick contact lookup
• Event prep interface showing attendee facesheets with photos for easy recognition
• Initiative-centric views showing all connected people and their engagement history

Continuous Evolution

As the organization’s needs evolved, Park West Digital expanded the system to support:

• Event management workflows with RSVP tracking, guest invitation automation, and post-event follow-up
• Meeting and speaking engagement scheduling with automated reminders
• Integration with external data sources for automatic contact enrichment
• Specialized workflows for recurring dinner series and facilitator applications

Results & Impact

Metric	Outcome
Contacts Managed	11,000+ contacts in unified system
Initiatives Tracked	100+ projects, events, and programs
System Evolution	Multi-year partnership with ongoing optimization
Data Quality	Automated duplicate detection and enrichment

Qualitative Benefits

• Transformed event preparation from hours of scrambling to minutes of focused work
• Enabled strategic network leverage by surfacing hidden connections and opportunities
• Created institutional memory that persists beyond individual team members
• Freed up team capacity to focus on high-impact work rather than administrative tasks

“We partnered with Park West Digital to build a custom CRM to help us track and nurture our network. Park West exceeded our expectations every step of the way! First, they were able to understand our needs better than we understood them ourselves, then they were able to build an elegant data management solution that is lean but tremendously powerful. It is clear that Park West Digital is invested in the long term success of our Airtable project, and that the system they built will serve our needs well beyond the scope of this contract.”

— Head of Strategic Partnerships

Key Success Factors

Discovery Before Design

Park West Digital invested significant time understanding not just what the client asked for, but what they actually needed. Through detailed user story mapping and requirements gathering, we identified pain points the team hadn’t fully articulated and designed solutions that addressed root causes rather than symptoms.

Lean by Design

We resisted the temptation to “boil the ocean” with excessive features. Instead, we focused on building a system that would remain maintainable by a small team while still capturing the critical data needed for strategic decisions. Every field and workflow had to justify its existence.

Long-Term Partnership Mindset

Rather than treating this as a one-time project, Park West Digital approached it as the foundation of an evolving system. As the organization’s needs changed and grew, we were there to extend and optimize the platform, creating a relationship that has spanned multiple years and continues to deliver value.

Conclusion

This case demonstrates that social impact organizations don’t need to sacrifice sophistication for simplicity. With the right approach, it’s possible to build relationship management systems that are both powerful and maintainable, that grow smarter over time without becoming burdensome, and that genuinely enable teams to do more of what matters.

For organizations managing complex networks across multiple initiatives, the investment in a well-designed system pays dividends far beyond administrative efficiency—it fundamentally changes what’s possible.