Analytics - Exporting your data
Sometimes, your team needs to go even deeper with the data. For those times, you can export a broader range of data from our Data Export tab. We've included the same querying parameters and data as the chart pages with the addition of more summary exports.
Unlike our chart export, these CSV files will be sent directly to your inbox when they've finished processing. From there, the retrieval link will be valid for seven days. As long as you download it within that time frame, you're all set to use these files as you please, whether for custom analysis in a Jupyter notebook or as input data into a more comprehensive BI tool.
Quick Start
Let's get started! In this section, we will review the basic setup and navigation of the Analytics functionality.
-
Select a report. Choose from various summary reports or chart data exports from the drop-down menu.
-
Select a date range and filters. Using the Date Range picker, type in a start and end date using the MM/DD/YYYY format or select the range from the calendar interface by clicking on the calendar icon in the field. The date range currently defaults to UTC timestamps. For example, if you select a date range of 03/20/2022 - 03/23/2022, we will pull data between 03/20/2022 00:00:00 and 03/23/2022 23:59:59.
- Conditional filters can be used to refine the specificity of your query. You can apply none or multiple filters to a single query. We support the following filters:
- Current severity
- Current priority
- Current milestone
- Incident impacted infrastructure
- Incident assigned teams
- Incident attached Runbooks
- Incident tags
- Conditional filters can be used to refine the specificity of your query. You can apply none or multiple filters to a single query. We support the following filters:
-
Generate a Preview. See the first 20 rows of your export to confirm that you're pulling the needed data before sending it to your inbox.
-
Export CSV. Once you've confirmed your data, you can export the CSV. Once the file is ready, you'll be notified via email and provided a direct link to your file, valid for seven days. If there were any errors in running your report, you would be notified with a toast message or email, depending on what went wrong.
Note: By default, all GAMEDAY and MAINTENANCE severity incidents are omitted from the Analytics calculations.
There are numerous reports to select from. We can group them into two main categories: Summary Reports and Chart Data Export.
Summary Reports pivot on incident metadata, aggregating incident KPIs based on impacted service, functionality, severity, and more. The Chart Data Exports (denoted with a "-Export" in the title) are CSV downloads of the same information available in the previous tabs' charts. For more information on those reports, we suggest you look at the Chart Explanations.
If you’re still looking for more, take a look at the Raw Data Export integration here.
Detailed Data Export Explanations
Service Summary
How are all of your services performing? Key indicators, such as incident count and mean time metrics, give your business insight into your organization's service performance and can be a meaningful report for technical and product leads.
Data Dictionary
Column Name | Measurement Unit | Value Type | Description |
---|---|---|---|
Name | n/a | string | Service name as entered into service catalog by the user |
Start Date | YYYY-MM-DD hh:mm:ss UTC | datetime | Start date selected as query parameter |
End Date | YYYY-MM-DD hh:mm:ss UTC | datetime | End date selected as query parameter |
Number of Incidents | Incident count | int | Count of new incidents created for the service during the specified date range |
Total Incident Duration | seconds | int | Total duration of incident measured with incident start timestamp and resolved milestone timestamp; this will be blank if no incidents have been created during the date range |
MTTD | seconds | int | Mean time to Detected metric for incidents created during the specified date range; calculated with incident start timestamp and detected milestone timestamp |
MTTA | seconds | int | Mean time to Acknowledged metric for incidents created during the specified date range; calculated with incident start timestamp and acknowledged milestone timestamp |
MTTM | seconds | int | Mean time to Mitigated metric for incidents created during the specified date range; calculated with incident start timestamp and mitigated milestone timestamp |
MTTR | seconds | int | Mean time to Resolved metric for incidents created during the specified date range; calculated with incident start timestamp and resolved milestone timestamp |
Functionality Summary
How are all of your functionalities performing? Key indicators, such as incident count and mean time metrics, give your business insight into your organization's functionalities performance and can be a meaningful report for technical and product leads.
Data Dictionary
Column Name | Measurement Unit | Value Type | Description |
---|---|---|---|
Name | n/a | string | Functionality name as entered into service catalog by the user |
Start Date | YYYY-MM-DD hh:mm:ss UTC | datetime | Start date selected as query parameter |
End Date | YYYY-MM-DD hh:mm:ss UTC | datetime | End date selected as query parameter |
Number of Incidents | Incident count | int | Count of new incidents created for the functionality during the specified date range |
Total Incident Duration | seconds | int | Total duration of incident measured with incident start timestamp and resolved milestone timestamp; this will be blank if no incidents have been created during the date range |
MTTD | seconds | int | Mean time to Detected metric for incidents created during the specified date range; calculated with incident start timestamp and detected milestone timestamp |
MTTA | seconds | int | Mean time to Acknowledged metric for incidents created during the specified date range; calculated with incident start timestamp and acknowledged milestone timestamp |
MTTM | seconds | int | Mean time to Mitigated metric for incidents created during the specified date range; calculated with incident start timestamp and mitigated milestone timestamp |
MTTR | seconds | int | Mean time to Resolved metric for incidents created during the specified date range; calculated with incident start timestamp and resolved milestone timestamp |
Responder Summary
Who is spending their time in incidents? Key indicators, such as incident count and duration, give your business insight into who is jumping into incidents to help manage individual burnout and identify potential single points of failure in our people.
Data Dictionary
Column Name | Measurement Unit | Value Type | Description |
---|---|---|---|
Responder Name | n/a | string | Name of the Responder (Users) in your organization; not currently limited to a Role |
Start Date | YYYY-MM-DD hh:mm:ss UTC | datetime | Start date selected as query parameter |
End Date | YYYY-MM-DD hh:mm:ss UTC | datetime | End date selected as query parameter |
Number of Incidents | Incident count | int | Count of new incidents created for the service during the specified date range |
Total Incident Duration | seconds | int | Total duration of incident measured with incident start timestamp and resolved milestone timestamp; this will be blank if the Responder had not been assigned to any incidents created during the date range |
Severity Summary
How do your operations vary based on Incident Severity? Key indicators, such as incident count and mean time metrics, give your business insight into your organization's incident response processes.
Data Dictionary
Column Name | Measurement Unit | Value Type | Description |
---|---|---|---|
Name | n/a | string | Severity name as entered into Severities set up by the user |
Start Date | YYYY-MM-DD hh:mm:ss UTC | datetime | start date selected as query parameter |
End Date | YYYY-MM-DD hh:mm:ss UTC | datetime | End date selected as query parameter |
Number of Incidents | Incident count | int | Count of new incidents created with the given Severity during the specified date range |
Total Incident Duration | seconds | int | Total duration of incident measured with incident start timestamp and resolved milestone timestamp; this will be blank if no incidents with specified severity were created during the date range |
MTTD | seconds | int | Mean time to Detected metric for incidents created during the specified date range; calculated with incident start timestamp and detected milestone timestamp |
MTTA | seconds | int | Mean time to Acknowledged metric for incidents created during the specified date range; calculated with incident start timestamp and acknowledged milestone timestamp |
MTTM | seconds | int | Mean time to Mitigated metric for incidents created during the specified date range; calculated with incident start timestamp and mitigated milestone timestamp |
MTTR | seconds | int | Mean time to Resolved metric for incidents created during the specified date range; calculated with incident start timestamp and resolved milestone timestamp |
Incident Summary
What is your overall incident performance? Key indicators, such as incident count and mean time metrics, give your business insight into your organization’s health and can be a meaningful report for technical and product leads.
Data Dictionary
Column Name | Measurement Unit | Value Type | Description |
---|---|---|---|
Start Date | YYYY-MM-DD hh:mm:ss UTC | datetime | start date selected as query parameter |
End Date | YYYY-MM-DD hh:mm:ss UTC | datetime | End date selected as query parameter |
Number of Open Incidents | Incident count | int | Count of incidents that were in milestones detected through mitigated during the selected date range |
Number of Resolved Incidents | Incident count | int | Count of incidents that moved into the resolved milestone status during the selected date range |
MTTD | seconds | int | Mean time to Detected metric for incidents created during the specified date range; calculated with incident start timestamp and detected milestone timestamp |
MTTA | seconds | int | Mean time to Acknowledged metric for incidents created during the specified date range; calculated with incident start timestamp and acknowledged milestone timestamp |
MTTM | seconds | int | Mean time to Mitigated metric for incidents created during the specified date range; calculated with incident start timestamp and mitigated milestone timestamp |
MTTR | seconds | int | Mean time to Resolved metric for incidents created during the specified date range; calculated with incident start timestamp and resolved milestone timestamp |
Incident Resolution
Number of retrospectives started and completed in comparison with the total number of resolved incidents.
Data Dictionary
Column Name | Measurement Unit | Value Type | Description |
---|---|---|---|
Start Date | YYYY-MM-DD hh:mm:ss UTC | datetime | Start date of range to query for data |
End Date | YYYY-MM-DD hh:mm:ss UTC | datetime | End date of range to query for data |
Created Incidents | Incident count | int | Count of incidents started within the time window |
Resolved Incidents | Incident count | int | Count of incidents resolved within the time window |
Retrospective Completion
Incidents created vs. resolved within the time window
Data Dictionary
Column Name | Measurement Unit | Value Type | Description |
---|---|---|---|
Start Date | YYYY-MM-DD hh:mm:ss UTC | datetime | Start date of range to query for data |
End Date | YYYY-MM-DD hh:mm:ss UTC | datetime | End date of range to query for data |
Resolved Incidents | Incident count | int | Count of incidents resolved within the time window |
Retrospectives started | count | int | Count of incidents a retrospective was started for |
Retrospectives completed | count | int | Count of incidents a retrospective was completed for |
Task Completion
Tasks created vs. completed in all incidents within the time window
Data Dictionary
Column Name | Measurement Unit | Value Type | Description |
---|---|---|---|
Start Date | YYYY-MM-DD hh:mm:ss UTC | datetime | Start date of range to query for data |
End Date | YYYY-MM-DD hh:mm:ss UTC | datetime | End date of range to query for data |
Tasks created | count | int | Count of tasks created across all incidents within the time window |
Tasks completed | count | int | Count of tasks completed across all incidents within the time window |
Follow-up Completion
Follow-up created vs. completed in all incidents within the time window
Data Dictionary
Column Name | Measurement Unit | Value Type | Description |
---|---|---|---|
Start Date | YYYY-MM-DD hh:mm:ss UTC | datetime | Start date of range to query for data |
End Date | YYYY-MM-DD hh:mm:ss UTC | datetime | End date of range to query for data |
Follow ups created | count | int | Count of follow-ups created across all incidents within the time window |
Follow ups completed | count | int | Count of follow-ups completed across all incidents within the time window |
Active Incidents by Team
Count of incidents that were active (not resolved) at any point within the time window.
Data Dictionary
Column Name | Measurement Unit | Value Type | Description |
---|---|---|---|
Start Date | YYYY-MM-DD hh:mm:ss UTC | datetime | Start date of range to query for data |
End Date | YYYY-MM-DD hh:mm:ss UTC | datetime | End date of range to query for data |
Team Name | string | int | Name of the team |
Active Incidents | count | int | Count of incidents that were in an unresolved stated at any point within the time window |
Mean Time to Milestone for Active Incidents
The MTT* metrics for all incidents that were active within the specified time window.
Data Dictionary
Column Name | Measurement Unit | Value Type | Description |
---|---|---|---|
Start Date | YYYY-MM-DD hh:mm:ss UTC | datetime | Start date of range to query for data |
End Date | YYYY-MM-DD hh:mm:ss UTC | datetime | End date of range to query for data |
MTTD | seconds | int | Mean time to Detected metric for incidents created during the specified date range; calculated with incident start timestamp and detected milestone timestamp |
MTTA | seconds | int | Mean time to Acknowledged metric for incidents created during the specified date range; calculated with incident start timestamp and acknowledged milestone timestamp |
MTTM | seconds | int | Mean time to Mitigated metric for incidents created during the specified date range; calculated with incident start timestamp and mitigated milestone timestamp |
MTTR | seconds | int | Mean time to Resolved metric for incidents created during the specified date range; calculated with incident start timestamp and resolved milestone timestamp |