From Drowning in Spreadsheets to Data-Driven Action: What Madison County's Journey Teaches Us About Sustainable Community Health Planning

If you've ever spent six months buried in spreadsheets during CHA season, only to feel completely burnt out by the time you get to your CHIP — you're not alone! 

In fact, that was exactly where Erica Bird, Deputy Director at Madison County Public Health in New York, found herself after two assessment cycles. But by her third cycle in 2025, something had shifted. Instead of drowning in data collection and manual report writing, her team had time and energy for what actually matters: strategic planning, community engagement, and collaborative action. 

NACCHO recently hosted a webinar with Erica and Metopio COO Angie Grover to talk about how Madison County transformed their approach to community health assessment and planning. If you missed it (or want the highlights without watching the replay), here's what was covered. 

The Evolution: From Burnout to Breakthrough 

Erica's first CHA cycle in 2019 looked familiar to many of us: 

• Six months of full-time data analysis and collection 

• Endless spreadsheets 

• Manual report writing 

• Eight focus groups plus qualitative analysis 

• Complete exhaustion by the time the CHIP phase arrived 

By 2022, during the tail end of the pandemic, they got a waiver for an abbreviated version. But even with shortcuts, Erica and an intern still spent six months on secondary data analysis. The momentum was lost before strategic planning even began. 

Then came 2025. 

Three Critical Decisions That Changed Everything 

Before diving into data collection, Erica made three strategic choices that set this cycle apart: 

1. Brought partners to the table early Instead of just the health department and hospitals driving the methodology, Erica convened 10 agencies in November 2024 — before the cycle officially started. Together, they agreed on: 

• The shared purpose of the CHA 

• A realistic timeline 

• How they'd select priorities 

• What data infrastructure they needed 

2. Advocated for a neutral facilitator Erica wanted to be a participant in the process, not just the person running it. Having someone else facilitate the meetings freed her to contribute her expertise where it mattered most. 

3. Invested in sustainable data infrastructure This is where the pitch for Metopio came in. Erica presented it to her partners with a straightforward value proposition: if their three agencies (the health department and two hospital systems) split the cost for five years, they'd have infrastructure that supports not just this cycle, but ongoing reporting, collaboration, and real-time insights. 

What Changes When You're Not Drowning in Spreadsheets 

With curated federal and state data already in the platform, Madison County could skip months of manual data collection and jump straight to analysis. 

Here's what that looked like in practice: 

Data Collection and Analysis 

• Exported a data dictionary to see which indicators were already available 

• Identified gaps and uploaded about 60 local surveillance indicators (with support from their Metopio customer success manager) 

• Loaded in community survey results and focus group transcripts 

• Used AI-generated themes as a starting point for qualitative analysis (with human validation, of course) 

Visualization in Minutes, Not Days

Instead of manually creating charts in Excel and trying to figure out the best way to tell each data story, Erica could: 

• Toggle between visualization types with one click 

• See data at multiple geographic levels 

• Use point layers to overlay community assets (like showing where a partner's "Monday Mile" walking programs were in relation to zip codes with high obesity rates) 

• Generate AI captions for every figure (which she had the power to edit before publishing) 

What used to take six months took a fraction of the time — and the energy they saved went directly into strategic planning. 

The Ripple Effect: When Infrastructure Serves the Whole Community 

One of the most powerful parts of Erica's story isn't just efficiency, but equity and collaboration. 

With the platform in place, Madison County could now: 

Serve as a data resource for partners Erica presented at a nonprofit consortium meeting with a data deep-dive on county demographics and housing — pulled together in 10 minutes. She used the rural benchmark feature (which compares rural counties to other rural counties, not to massive urban centers like NYC) to give partners realistic, actionable context. 

Bring housing partners into the conversation When you can show planning commissions that addressing housing instability doesn't just create homes — it also creates healthier, more resilient communities — you open up new funding streams and collaborative opportunities. 

Support hospital partners during their own cycles The two hospital systems that co-funded the platform will have access to it when they do their own assessments in two years. Instead of asking the health department to provide all the data (on top of their day jobs), hospitals can pull what they need themselves. 

From CHA to CHIP: The Part That Usually Gets Lost 

By the time most teams finish their CHA, they're too worn out to give the CHIP the attention it deserves. 

Not this time! 

Madison County used the platform's CHIP module to: 

• Access a library of evidence-based practices (organized by topic, so no one had to hunt across multiple websites) 

• Adapt national best practices to local context during just two brainstorming sessions 

• Build out logic models that met New York State's "family of measures" requirements 

• Set up data tracking so they could actually see progress over time 

And when it came time for their PHAB accreditation site visit, Erica said she felt confident. The work didn’t just meet standards, she was genuinely proud of it! 

The Data Landscape is Shifting. Your Infrastructure Needs to Shift Too. 

We didn't spend much time on it during the webinar, but it's worth naming: the data landscape is changing fast. 

Federal data sources are becoming less reliable, and some are disappearing altogether. The need for local data (surveys, claims data, community input) has never been greater. 

That's why one of the things that excites us most about Madison County's approach is that they're building their own longitudinal data. The next time they run their community survey, they'll have two years of comparison data. Then three. Then four. 

They're not solely dependent on government entities to tell them what's happening in their community because they're creating their own evidence base. 

What This Could Mean for Your Next CHA Cycle 

If you're staring down your next assessment cycle (or in the middle of one right now), here are some questions worth asking: 

• Where is our burnout coming from? Is it data collection? Manual report writing? Trying to coordinate across multiple partners with different systems? 

• Who needs to be on this journey with us? What would it look like to bring partners to the table at the beginning — not just to rubber-stamp the methodology, but to co-create it? 

• What intelligence is sitting at our fingertips that we can't access? Are we drowning in spreadsheets that could be visualized with a single click? Do we have local data that never makes it into our reports because it's too labor-intensive to analyze? 

• How can we parlay these reports into real-time value? What if our CHA wasn't a static document that gets filed away, but a living dashboard that partners can check at any time? What if our CHIP data updated automatically so we could track progress without rebuilding reports from scratch? 

The Bottom Line 

Erica put it best during the webinar: "I had this confidence that I knew our report met all the standards for accreditation. Metopio really helped us get through this process in a much more efficient way." 

But efficiency alone isn't the goal. The goal is to practice at the top of your license — using your expertise, your knowledge of the community, and your strategic thinking to drive real change. 

The spreadsheets, manual chart-making, and endless copying and pasting are not where your value lies. And it's not where your time should go! 

Want to Learn More? 

We covered a lot in our 60-minute conversation with Erica, and there's even more in the full recording. You can access the replay right here.  

If you're ready to see how Metopio can help you move from drowning in data to driving action, schedule a demo to explore how we automate CHAs, CHIPs, and community health planning — turning months of work into minutes. 

And if you want to stay in the loop on data trends, new partnerships (like our recent collaboration with Yale's PopHIVE), and practical insights for community health leaders, check out our Data Chats podcast.