Case studySocial impactAirtable + CRM

A huge network. No way to actually use it.

The client

A national organization at the intersection of media, advocacy, and capital.

A small team in the Office of the Founder manages a vast network of partners, advisors, funders, and collaborators — from documentary production to grant-making.

The challenge

Relationship management capped the work.

The network kept growing and the team kept rebuilding the same context by hand for every event and every ask.

  • Fragmented contact management across spreadsheets and tools, with no complete view of the network
  • Labor-intensive event prep — scrambling to compile guest lists and briefing materials
  • No way to track relationship reciprocity: who they’d asked versus who they’d supported
  • Missed opportunities from no visibility into who knew whom
  • Relationship management consuming so much time it capped new initiatives

In their words: “We had a huge network but no way to actually use it strategically — constantly reinventing the wheel for every event.

The solution

A VIP relationship system that compounds.

A custom Airtable system built to grow organically and get more valuable over time without heavy maintenance. Four interconnected tables capture the full context.

Table 01

People

Contacts, relationship history, and the interaction insights that make the next conversation easier.

Table 02

Organizations

The entities those contacts represent, so affiliation is a fact rather than a memory.

Table 03

Initiatives

Projects and events treated as connection points, not one-off logistics.

Table 04

Links

The relationships between people and initiatives, tracking asks made and support given.

The results

What changed.

  • A single, complete view of the network for the first time
  • Event preparation systematized instead of reinvented each time
  • Relationship reciprocity tracked, so the team could see who to call and why
  • Staff time returned to strategic work instead of manual coordination

Start here

Show us how the work moves today.

Thirty minutes. You walk us through how the work moves today; we tell you where it's breaking and what a system would take.

Pick a time and we’ll be there.