You can export the worker monitoring reports available on CommCareHQ to Excel in order to better monitor your users performance and activities. These reports provide information on the users, their case activities, daily form submissions and completions which can be used to monitor workers. The data contained in these reports can be exported to excel with the click of a button, in order to facilitate your analysis.
- Click on Reports on the top menu bar or in the dashboard
- Select the Report you are interested in viewing from the menu bar on the left. For the various types of reports that are available see here
- Simply click on the export to Excel tab on the top of the page. The export to excel is located on the Report Actions menu bar.
After clicking on the Export to Excel tab, CommCareHQ will export the data from HQ to an excel sheet on your computer.
Open it to view the data. It will be the same data as the HQ list, with some minor adjustments.
You can export data to excel in the following reports:
- Case Activity
- Submissions by Form
- Daily Form Submissions
- Daily Form Completions
- Form Completion Time
For example, you can sort your users by different indicators, or you can combine two or matrices, like number of form submissions and time per visit to a client, to create a scorecard for your users. You can use this feature to isolate the higher/lower performing users, manage active and inactive cases, or perform calculations to summarize the performance of your workers by groups or at the aggregate level.
You can also export bulk raw data by creating exports for the specific variables that you want to see. For more information on raw data and custom exports see CommCare Data.