Data Collection & Dashboards 101 for ERGs

<p>[[youtube:f3n3IKprcSY]]</p> <p class="lead">ERG data collection should start with one question: what decision will this data change? Build dashboards around three pillars—member engagement depth, leadership pipeline health, and program operational efficiency—and review them weekly with the people who can act on what they see.</p> <h2>Start With the Decision, Not the Data</h2> <p>The most common mistake in ERG data collection is starting with what's easy to measure instead of what's important to know. Google Forms can capture attendance, spreadsheets can track membership, and Slack analytics can show channel activity. But if none of those numbers answer a question that changes behavior, you're building a data graveyard. Before adding any field to any form, confirm: who will review this number, what action they'll take if it's high or low, and by when. If you can't name all three, don't collect it. <a href="/blog/watch-this-before-selecting-your-erg-metrics">Before selecting any metric</a>, confirm it drives a specific decision.</p> <h2>The Three-Pillar Dashboard Framework</h2> <p>Every ERG dashboard should have three sections, reviewed in this order:</p> <p><strong>1. Member Engagement Depth</strong> — Not headcount, not attendance. Measure <a href="/blog/the-member-engagement-scores-mes-of-ergs-explained">Member Engagement Score (MES)</a>: what percentage of your members participate in at least two touchpoints per quarter? And <a href="/blog/calculate-erg-event-engagement-score">Event Engagement Score (EES)</a>: how deeply do attendees engage during events? These numbers tell you whether your community is alive or just subscribed.</p> <p><strong>2. Leadership Pipeline Health</strong> — Track how many ERG members have been promoted, moved into management, or taken on stretch assignments in the past 12 months. Compare to non-ERG peers in the same demographics. This is your business case in a single number.</p> <p><strong>3. Operational Efficiency</strong> — How long does it take to plan an event? What's your leader turnover rate? How many SOPs are documented and current? These operational metrics predict whether your program can sustain itself.</p> <h2>Free Tools That Work</h2> <p>You don't need expensive software to build a useful ERG dashboard. Google Data Studio (Looker Studio) connects to Google Sheets and can produce clean, shareable dashboards. Notion databases with filtered views work for smaller programs. Even a well-structured spreadsheet with conditional formatting can surface problems faster than most enterprise tools. <a href="/blog/how-to-visualize-erg-data-for-free">Here's how to visualize ERG data for free</a> with no specialized software.</p> <h2>The Review Rhythm</h2> <p>A dashboard that no one reviews is worse than no dashboard at all—it creates the illusion of measurement while obscuring real problems. Set a weekly 15-minute review with your ERG leadership team. Each week, pick one metric that moved significantly and discuss why. Monthly, review trends and adjust programming. Quarterly, present the dashboard to your executive sponsor with specific asks tied to what the data shows. If the sponsor doesn't engage with the data, <a href="/blog/exploring-factors-that-contribute-to-low-engagement-of-your-executive-sponsor-with-your-erg">diagnose sponsor engagement</a> and fix the relationship or find a new sponsor.</p> <h2>What to Avoid</h2> <p>Don't build real-time dashboards—weekly aggregation is enough and prevents reactive management. Don't compare ERGs to each other unless they serve comparable populations and have similar resources. Don't let perfect data collection delay action; an 80% accurate metric reviewed weekly beats a 100% accurate metric reviewed quarterly. And never present data without a recommended action. Leadership doesn't need more charts. They need decisions.</p> <p><strong>Related:</strong> <a href="/blog/how-to-measure-erg-program-success">How to Measure ERG Program Success</a> · <a href="/blog/ranking-every-erg-metric-from-best-to-worst">Ranking Every ERG Metric from Best to Worst</a> · <a href="/blog/explained-the-erg-metric-triangle">The ERG Metric Triangle Explained</a> · <a href="/blog/most-important-erg-success-metrics">The Most Important ERG Success Metrics</a> · <a href="/blog/what-not-to-measure-in-ergs">What Not to Measure in ERGs</a></p>