Guide: Coaching Log Export
The Coaching Log Export includes the raw data about every activity created within your coaching team, which you can then use to build your custom reports externally for deeper and individualized analysis.
Learn more about how to access, filter, and identify your coaching data below:
- Access the Coaching Log
- Filter the data
- Identify events that are missing tags
- Identify events categorized as “other”
- Help, I still have questions!
Access the Coaching Log Export
The Coaching Log Export can be found on your Reports tab, and provides an Excel file that you can use to create your own custom data dashboards.
Simply click the green “Coaching Log Export” button and the file will be sent to you via email.
Note: The export will be sent to your primary email in an .XLSX file. Please double check the primary email associated with your account is correct and change if required.
Filter the Data
Once you’ve opened the attached .XLSX file from your email, open the report in Google Sheets or download it to open in Excel.
To add a filter, click "Data" and then select the Filter/Create a Filter button. This will create a carrot at the top of each column that you can click on and select filters as needed.
Pro-tip: When you use the Filter feature, the options will all be selected by default. Press “Clear” to remove and manually check the necessary filters to easily capture relevant information.
Here’s a quick video that walks through the process: Filtering data from the Coaching Log Export
Identify events that are missing tags
Once filters have been applied to the Coaching Log Export, there are a couple of steps to easily locate any events that are missing tags:
- Fine the Focus Area or District Priority column (column M & N)
- Click the filter icon next to the column header and select "Clear" or "Select All", then check off (Blanks) and click "Ok"
- Locate the Activity column (column S) and click the filter icon next to the column header
- Then click to deselect Other Coaching Responsibilities, then click "Ok"
Using the Event URL (column X), you can navigate to the event in TeachBoost to add tags
Note: Other coaching responsibilities are filtered out because they aren’t available to be tagged and do not contribute to “none selected” in the Coaching Focus Report.
Here’s a quick video that walks through this process: Identify events that are missing tags
Identify events characterized as “other”
To locate events characterized as other, you'll need to follow a couple of steps listed below:
- Head to the "Type" column (column T), and click the filter icon next to the column header
- Select "Clear", check off "Other" and click "Ok"
- Locate the Event URL (column X) to navigate to the event in TeachBoost to recategorize
Here’s a quick video to walk through the process: Identify events characterized as “other”
Help, I still have questions!
If you can't find the answer to your query about the Coaching Log Export in this guide or need additional support, please don't hesitate to reach out to us directly with a support request including as much detail about what you need to do as you can and we'll be happy to help.