Mercu supports exporting raw data from the analytics dashboard. All exports are formatted as csv and can be used for further analysis in tools like Google Sheets or Excel.
Exporting the "Dashboard" tab
If your campaign includes one or more questions, you will see the "Dashboard" tab by default when opening the campaign. Otherwise, you will see the "Enrolled" tab (see below).
To export data from the "Dashboard" tab, please click on the "Export" button in the top right corner of the screen.
Each question will generate an individual csv file, and all csv files will be exported as a zipped folder.
CSV file format
Name: Team member's name
Phone: Team member's phone number
Response: Team member's response
IsCorrect: Either blank (no correct response), TRUE (correct response) or FALSE (incorrect response)
RepliedOn: Date and time of team member's response
Name | Phone Number | Response | IsCorrect | RepliedOn |
John Doe | +61406810297 | B | TRUE | 10/05/2023, 04:21:32 |
NOTE: If you are using Excel on a Windows OS, the file may be formatted in a different way. Follow the steps below to fix the formatting of the export.
Formatting the Export
You can use the following template to format the the export data:
โ
To format the data:
Copy the data in your original export.
Open the template above and navigate to the 'Raw_Data' tab.
Paste the data in cell A1.
Click on the 'Formatted_Data' tab and your data should be visible.
Exporting the "Enrolled" tab
To export data from the "Enrolled" tab, please click on the "Export" button in the top right corner of the screen.
The "Enrolled" table is exported as a single file.
CSV file format
ID: Team member's employee ID
Name: Team member's name
Progress: This refers to the enrolment status (see here for more information)
Score: The team member's pass score (only applies, if the campaign includes at least one question with a correct answer option)
EnrolledOn: The date and time the team member was enrolled on
ID | Name | Progress | Score | EnrolledOn | Role | Location |
AB-123 | John Doe | Complete | 0 | 01/06/2023, 12:03:12 | Warehouse Staff | Sydney |
Filtering data
All data exports use whatever search terms and/or filters you apply.