Importing and managing data
Every KPI and KPV has a data page where you can view, import, and manipulate all athlete data for the metric. You can access it by navigating to your organization's KPIs or KPVs section, clicking on a metric, then clicking the "Data" link in the top right of the slide out.
The data here includes measurements for all athletes at the institution. Athlete names are redacted if they belong to a roster you don't have access to. Data imported for athletes that don't belong to any roster is visible to anyone. If you want imported data anonymized, you should use generic placeholders for first and last name in your CSV file.
Changes made here will trigger the evaluation of group logic and the calculation of assessment formulas. Data can be imported for athletes not on the roster, and it will live here solely as a historical record. Imported data will also affect the results of percentile assessment calculations.
Data can be imported from a CSV file for a given metric. The data does not have to be associated with athletes on any given roster. However, if you want to associate data with existing athletes, you must provide emails that match the ones athletes used to join the platform.
To ensure a successful import, follow the steps below:
1. Download sample spreadsheet
Download a copy of the sample spreadsheet that contains the appropriate column names and data format examples.
2. Populate the sample spreadsheet
The top row should contain the labels first_name, last_name, and email, followed by the measurement dates of the data points you will be importing. Note the following:
- Dates should be in the format of YYYY-MM-DD.
- Data points must be numbers.
- Units are assumed to be the unit specified for KPI's measurement type.
- Email is optional. Emails provided must match an existing athlete on one of your rosters.
- Rows with all zero or blank values will be skipped.
3. Export to CSV format
After you've filled out spreadsheet, export it into CSV format.
4. Import your file
Click the "Import CSV File" button to select and import your file.
You can click on any data point in the table to change its date and value (as long as you have permission to manage the given athlete's data). If a cell doesn't have a value, you can add one by clicking on it and saving a new value.
You can delete a single value by clicking on it to open the slide out form, then clicking "Delete" in the top right of the screen.
You can also delete entire rows or columns at once. Simply hover over a column or row header, then click the delete icon that appears.
You will not be able to delete data for athletes you don't have permission to manage.