PH2S Data Team Metrics
Amanda Carroll
Introduction
This report summarizes data tasks completed by PH2S Data Team (consisting of Amanda Carroll and Chelsea Cobranchi) in 2024 and 2025. Data tasks are organized across six categories: (1) REDCap builds; (2) grants supported; (3) publications supported; (4) analysis; (5) process improvement; and (6) training. The purpose of this report is to summarize how tasks are allocated across the categories and identify trends across time.Performance Management Data
| Data Team Summary Tasks from 2025 | Jan N = 231 |
Feb N = 291 |
Mar N = 371 |
Apr N = 411 |
May N = 561 |
Jun N = 451 |
Jul N = 491 |
Aug N = 501 |
Sep N = 711 |
Oct N = 441 |
Nov N = 361 |
Dec N = 191 |
Overall N = 5001 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Metric | |||||||||||||
| Â Â Â Â REDCap Builds | 10 (43%) | 4 (14%) | 8 (22%) | 4 (9.8%) | 15 (27%) | 18 (40%) | 20 (41%) | 10 (20%) | 8 (11%) | 7 (16%) | 11 (31%) | 5 (26%) | 120 (24%) |
| Â Â Â Â Grants Supported | 6 (26%) | 4 (14%) | 9 (24%) | 19 (46%) | 16 (29%) | 8 (18%) | 13 (27%) | 11 (22%) | 12 (17%) | 4 (9.1%) | 4 (11%) | 5 (26%) | 111 (22%) |
| Â Â Â Â Publications Supported | 1 (4.3%) | 2 (6.9%) | 1 (2.7%) | 2 (4.9%) | 0 (0%) | 2 (4.4%) | 1 (2.0%) | 0 (0%) | 2 (2.8%) | 1 (2.3%) | 2 (5.6%) | 2 (11%) | 16 (3.2%) |
| Â Â Â Â Analysis | 1 (4.3%) | 3 (10%) | 4 (11%) | 5 (12%) | 2 (3.6%) | 3 (6.7%) | 0 (0%) | 2 (4.0%) | 0 (0%) | 1 (2.3%) | 2 (5.6%) | 2 (11%) | 25 (5.0%) |
| Â Â Â Â Process Improvement | 5 (22%) | 12 (41%) | 11 (30%) | 8 (20%) | 12 (21%) | 9 (20%) | 3 (6.1%) | 7 (14%) | 10 (14%) | 3 (6.8%) | 6 (17%) | 3 (16%) | 89 (18%) |
| Â Â Â Â Trainings | 0 (0%) | 4 (14%) | 4 (11%) | 3 (7.3%) | 11 (20%) | 5 (11%) | 12 (24%) | 20 (40%) | 39 (55%) | 28 (64%) | 11 (31%) | 2 (11%) | 139 (28%) |
| 1 n (%) | |||||||||||||
| Data Team Task Summary from 2024 | Jan N = 241 |
Feb N = 201 |
Mar N = 301 |
Apr N = 301 |
May N = 331 |
Jun N = 321 |
Jul N = 401 |
Aug N = 351 |
Sep N = 361 |
Oct N = 261 |
Nov N = 231 |
Dec N = 141 |
Overall N = 3431 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Metric | |||||||||||||
| Â Â Â Â REDCap Builds | 10 (42%) | 13 (65%) | 15 (50%) | 5 (17%) | 12 (36%) | 17 (53%) | 19 (48%) | 17 (49%) | 11 (31%) | 10 (38%) | 9 (39%) | 5 (36%) | 143 (42%) |
| Â Â Â Â Grants Supported | 5 (21%) | 0 (0%) | 5 (17%) | 6 (20%) | 7 (21%) | 4 (13%) | 7 (18%) | 6 (17%) | 8 (22%) | 11 (42%) | 5 (22%) | 3 (21%) | 67 (20%) |
| Â Â Â Â Publications Supported | 0 (0%) | 1 (5.0%) | 0 (0%) | 2 (6.7%) | 1 (3.0%) | 2 (6.3%) | 0 (0%) | 0 (0%) | 2 (5.6%) | 0 (0%) | 2 (8.7%) | 0 (0%) | 10 (2.9%) |
| Â Â Â Â Analysis | 3 (13%) | 1 (5.0%) | 2 (6.7%) | 4 (13%) | 6 (18%) | 2 (6.3%) | 1 (2.5%) | 4 (11%) | 6 (17%) | 4 (15%) | 5 (22%) | 6 (43%) | 44 (13%) |
| Â Â Â Â Process Improvement | 2 (8.3%) | 1 (5.0%) | 5 (17%) | 8 (27%) | 1 (3.0%) | 2 (6.3%) | 5 (13%) | 2 (5.7%) | 6 (17%) | 1 (3.8%) | 1 (4.3%) | 0 (0%) | 34 (9.9%) |
| Â Â Â Â Trainings | 4 (17%) | 4 (20%) | 3 (10%) | 5 (17%) | 6 (18%) | 5 (16%) | 8 (20%) | 6 (17%) | 3 (8.3%) | 0 (0%) | 1 (4.3%) | 0 (0%) | 45 (13%) |
| 1 n (%) | |||||||||||||
Data Interpretation
- As seen above from the tables above, the Data Team completed ~500 tasks total in 2025, which was a 45.7% increase from 2024. Chelsea was hired at the end of April in 2024, so this really shows the productivity increase and ceiling of two employees, rather than one.
- As seen in the graph below, from August - November of 2025 the majority of tasks completed were trainings, as the Data Team was preparing for the Clinical Database training in October, as well as the go-live in November. This really monopolized the time of the Data Team, and they are hoping the allocation of quality assurance (QA) tasks and data integration from the Pilot will mostly be given to the future student and S1 in 2026.
- Although the category with the most tasks completed in 2025 was trainings, REDCap builds and grants supported are also categories with many tasks completed. This is an interesting comparison to 2024, where aside from REDCap builds, most other areas were relatively even across tasks completed.
Each of the charts below show each specific task area from above broken down individually. Some key things to note:
- May - July was huge for REDCap builds because of the clinical database, as this was when most of the building and editing was completed. Another big note of this was in November, from go-live, and edits from that.
- April was huge for grants support because of the first attempted submission of ALL FOCUS data that month, which included re-doing the REDCap, cleaning all data, analyzing it, and uploading into their system.
-
The biggest note for publications was that the Data Team was included on
three publications in 2025. Here are the citations for that:
- Langkiet, J., Hutzel-Dunham, E., Brown, J. L., Lyons, M. S., Freiermuth, C., Sprague, J. E., Lambert, J., Braun, R. S., Littlefield, A. K., Frey, J. A., Bachmann, D., Bischof, J. J., Pantalon, M. V., Ancona, R. M., Carroll, A., Petrovitch, D., Himes, K. P., & Punches, B. E. (2026). Mental Health Symptom Screening Among Adult Emergency Department Patients: A Cross-Sectional Study. JACEP Open, 7(2), 100312. https://doi.org/10.1016/j.acepjo.2025.100312
- Bischof, J. J., Reichert, E. M., Maitland, J., Queen, J. M., Cobranchi, C., Conroy, M. J., … & Lyons, M. S. (2025). Evaluation of an influenza vaccine administration program in the emergency department. The American Journal of Emergency Medicine.
- Sherman, J. P., Albright, N., Emerson, B., Cobranchi, C., Brown, J. L., Morgan, E., Gillespie, G. L., Spatholt, D., Richards, R., & Punches, B. E. (2026). No Place to Rest: Housing Instability and Pain Experiences in the Emergency Department. Journal of Emergency Nursing. https://doi.org/10.1016/j.jen.2025.12.003
- For Process Improvement, the Data Team’s biggest months were February (GPRA), March (FOCUS), April (FOCUS), May (FOCUS), June (data SOP’s), and Sept (Clinical DB Training).
- For training, the biggest month is September with the highest bar ‘Created for REDCap Build’, which was the Data Team preparing for the Clinical Database Training. The second highest month was October, with ‘Provided for REDCap Build’ as the highest bar, because that is when all Clinical Database Trainings were conducted.
Key Updates & Strategic Initiatives
2025 was a big year for the Data Team with the go-live of the clinical database. With hundreds of hours of building and creating the training materials, this is hard to track accurately with a count, but was tracked to the best of their abilities. The Data Team also provided six full days of training across HPAs and students, as well as full days of shadowing in the ED for all HPAs and students. Similar to 2024, overall the Data Team completed the most tasks in REDCap, whether completing REDCap builds or edits to existing projects. This is challenging to track, and does not count the consecutive days spent working on these tasks, but rather completed projects. To note, the Data Team takes off 2 weeks every December, and Amanda was off a decent amount Sept - Nov for family emergencies.Looking Ahead
To start 2026 the Data Team has been working through a lot of outlines, data proposals, and REDCap builds for new grants awarded (Punches R, CDC-DIS, ED-SMART, etc.). FOCUS rebuilding and data dissemination will also be a focus of 2026. The Data Team will also be hiring a student and a S1 in 2026, which will offset some of the burden of the ongoing task list, as well as increase trainings and mentoring hours in 2026. This will increase the amount of QA work completed by the data team in 2026 as well.