You Can Get Your Event Engagement Score Today.

Let’s stop overcomplicating it.

I know the term Event Engagement Score sounds like something you’d need a data analyst and a 3-week sprint to figure out. But I’m telling you—you can calculate this today.

Step 1: Get your member list.

Open a Google Sheet. Name the tab “Membership”

• Column A = ERG Name

• Column B = Member Names

• Column C = Member Emails

Step 2: Get your event attendee info.

Ask your event host (or yourself) to pull the Zoom attendance report.

Copy the names, emails, and watch times into a second tab (columns D, E, F)

In your event tracker, enter the event date in Column A, the event name in Column B, and the event type (e.g., panel, workshop, social) in Column C.

For Program Managers: Add Column D to list the name(s) of the hosting ERG(s) for each event and shift the other columns to the right.

Step 3: Match it up (Connecting the Member List to the Attendee List)

On the Membership tab, add a new column called “Has Participated”.

Use this formula to check if an email shows up in the Events tab:

=IF(C2=VLOOKUP(C2,Participants!E:E,1,FALSE),"Yes","No")

For Program Managers with the additional column, use this formula instead:

=IF(C2=VLOOKUP(C2,Participants!F:F,1,FALSE),"Yes","No")

(Adjust for your columns/sheet names - also I’m saying Google sheets because it’s my preference, but it can be done in excel just as easy - AI can give you the proper formulas… or send me a screenshot of what you’ve got so far - happy to send one.)

Now drag that formula down your entire list. Done.

What you’ve got now = your Event Engagement Score.

Filter that column by “Yes” to see how many unique members have shown up to at least one event.

Annual Goal: 50% participation within the year

If half your members aren’t engaging even once in a YEAR, it’s not a capacity issue—it’s a programming one.

To take it a step further… You can level this up into a Member Engagement Score by adding in folks who engaged asynchronously (like through surveys or mini tasks). But even if you skip that step, this method gives you a real pulse on whether your events are doing what they’re supposed to do—engage people.

No fancy tools. No new software. No excuses. Just one Google Sheet and a few minutes of clarity.

No template needed, although I do have a pretty comprehensive one with walkthroughs here.

Maceo aka The ERG Homegirl

P.S. There were a lot of questions in response to the union newsletter that I put out a few months ago. I officially have an AMA with a lawyer on the calendar. Feel free to email back with any hyper specific questions that you would want anonymously asked for clarity.

P.P.S. I'm calling the virtual stop of the ERG Recipe Tour “Recipe-O-Rama” and it's gonna be an all day event (7am EST - 5:30pm EST) for sessions that you can hop in and out of throughout the day. Save the date.