You can export the 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
- 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 from 6 out of the 8 Monitor Workers Reports excluding Submission Times, and Submit Distribution.
Case Activity, Submissions by Form, Daily Form Submissions, Daily Form Completions, and Form Completion Trends of users can all be exported to excel to facilitate analysis and better monitor your workers performance.
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 or create custom exports for the specific variables that you want to see. See here for more information on raw data and custom exports. https://confluence.dimagi.com/display/commcarepublic/Raw+Data