Jeremy performed daily exports of the Event Participant List from VAN and loaded them into a Google Sheet, and maintained a separate Google Sheet with weekly data for each region and its assigned volunteers. Using Civis, regional volunteer assignment data and Event Participant List data were moved into separate tables so Jeremy could aggregate them with SQL and Python scripts for use in the final report.
The Field Director was able to keep better track of overall and individual metrics for each organizer from day-to-day and week-to-week. This resulted in more honed conversations with each organizer about the strategy they used in calls to get people to volunteer, as well as the scripts they used to get people fired up about making calls. After launching his tracker, the number of active volunteers (in a 30-day window) grew from 200 to over 300 in a matter of weeks.