Enhance WPCC page stats to update dynamically from event tracker data

[Piyopiyo-Kitsune]

Summary

Enhance the WordPress Campus Connect page so the Events Completed and Students Reached numbers update dynamically using event tracker data instead of being manually maintained.

Page: https://wordpress.org/education/campus-connect/

Problem

The current stats on the WPCC page require manual updates, which can lead to outdated numbers and additional maintenance overhead.

Proposed Solution

Pull both stats dynamically from the event tracker.

Events Completed

Increment this total for each event where:

• the event is a Campus Connect event, and
• the event status is Closed

Students Reached

Sum the Actual Attendees field across all events where:

• the event is a Campus Connect event, and
• the event status is Closed

Expected Behavior

The WPCC page should automatically display up-to-date totals for:

• Events Completed
• Students Reached

Notes

• Confirm how Campus Connect events are identified in the tracker
• Confirm the tracker/source of truth for this data
• Define handling for events with empty or missing Actual Attendees
• Ensure updates to closed events are reflected in the totals
• Consider caching/performance for public page rendering

[dd32]

Is AirTable the canonical source for this data? I assume this is going to be blocked until I add some importation of that data

[Piyopiyo-Kitsune]

We don't use Airtable for WPCC. The canonical source at the moment are the event trackers.

[dd32]

Gotcha, Thanks for confirming!

My plan then is to setup a nightly task which does the above Proposed Solution type thing, stores that in our internal stats so we have it over time, and then feed that into the template somehow :)