Googling your hand hygiene data: Using Google Forms, Google Sheets, and R to collect and automate analysis of hand hygiene compliance monitoring

HighlightsWe created an easy‐to‐use, platform‐independent hand hygiene data collection process using Google Forms and Google Spreadsheets.Using R and RStudio Shiny, we built an online analytics engine to provide on‐demand, automated reporting directly from the Google Spreadsheet.By reducing the workload of data collection and analysis, more time may be spent on improving hand hygiene adherence. Background: Hand hygiene is one of the most important interventions in the quest to eliminate healthcare‐associated infections, and rates in healthcare facilities are markedly low. Since hand hygiene observation and feedback are critical to improve adherence, we created an easy‐to‐use, platform‐independent hand hygiene data collection process and an automated, on‐demand reporting engine. Methods: A 3‐step approach was used for this project: 1) creation of a data collection form using Google Forms, 2) transfer of data from the form to a spreadsheet using Google Spreadsheets, and 3) creation of an automated, cloud‐based analytics platform for report generation using R and RStudio Shiny software. Results: A video tutorial of all steps in the creation and use of this free tool can be found on our YouTube channel: https://www.youtube.com/watch?v=uFatMR1rXqU&t. The on‐demand reporting tool can be accessed at: https://crsp.louisville.edu/shiny/handhygiene. Conclusions: This data collection and automated analytics engine provides an easy‐to‐use environment for evaluating hand hygiene data; it also provides rapid feedback to healthcare workers. By reducing some of the data management workload required of the infection preventionist, more focused interventions may be instituted to increase global hand hygiene rates and reduce infection.