Reporting

Our reporting provides comprehensive analytics and insights, helping you understand trends, identify bottlenecks, and optimize your incident response.

You can see the data directly in UI, or create powerful custom reports with live data exports to be processed elsewhere, e.g. in Google Sheets.

Go to Uptime -> Reporting to see the overview, or navigate to a specific report in the left submenu:

Key features

The reporting interface allows you to analyze various aspects of your system's performance and your team's incident response. You can filter data by numerous criteria and visualize it through different chart types.

Key features include:

• Report Categories: Access a wide array of reports across different domains.

• Filtering: Apply over 10 filter types, including monitors, integrations, escalation policies, users, causes, business hours, and metadata.

• Date Ranges: Select data resolution and absolute or relative date range.

• Reusable URL: Changes to filters and ranges immediately change your URL, allowing you to copy it for later use or quick collaboration.

• Updated in real-time: All your reporting data is always up to date.

• CSV Export: Export data in real-time streaming CSV format.

• Business Hours: Customize what hours and days count as business time for relevant reports.

Individual reports

Our reports are organized into the following categories:

• Incidents Reports: Access incident overview, manual incidents, started-at and resolved-time reports, MTTR, MTTA, heatmaps, and acknowledged-incident insights.

• Organization Reports: View organization-wide metrics, including cross-team incident volume, alert metrics, MTTR, and on-call schedule visibility.

• Teams Reports: Explore team-level reports such as response effort, MTTR, MTTA, incidents, team alerts, on-calls, and detailed on-call metrics.

• Status Page Reports: Monitor status page activity through status updates and subscriber metrics.

• Monitors Reports: Track compound SLA, average SLA, monitor performance, incident volume, and per-monitor MTTA/MTTR.

Custom reports with live CSV export

While our pre-built reports offer extensive functionality, you might need highly customized analyses or visualizations that are updated in real-time. Our live CSV export feature, e.g. combined with Google Sheets, empowers you to create dynamic, automatically refreshing custom reports.

This method is particularly useful for:

• Building bespoke dashboards tailored to unique business metrics.
• Sharing real-time data with stakeholders who prefer spreadsheet formats.
• Performing advanced statistical analysis not available in the UI.

Step 1: Exporting live data as CSV

1. Navigate to a Report: Go to any report that contains the data you wish to analyze. For example, "Incidents Overview".
2. Apply Filters (Optional): Apply any filters or date ranges to narrow down the data before export. The exported CSV will reflect these selections.
3. Get your CSV URL: Look for the Export CSV button located near the top right of the report interface and copy the link address.

You now have a URL that holds your real-time reporting data in an easily usable format 🚀

Step 2: Importing Live Data into Google Sheets

Go to Google Sheets and create a new spreadsheet. Of course, you can use other software in a similar fashion.

Select cell A1 and use the IMPORTDATA function, pasting the copied URL:

=IMPORTDATA("YOUR_EXPORT_CSV_URL_HERE")

After allowing access to data from Better Stack, your data from the live CSV endpoint will be fetched ✨

Step 3: Creating visual reports or aggregations

Now that your live data is in Google Sheets, you can use its powerful features, like pivot tables, to create insightful visualizations.

Create a new sheet for your reporting to keep things organized.

You can insert Pivot tables, create graphs and other visualizations, and aggregate your reporting data in any way you'd like in an environment you're likely already familiar with.

Real-time Updates

The beauty of this setup is that your custom reports and charts in Google Sheets will automatically update as new data becomes available through the IMPORTDATA function. This provides you with live, dynamic dashboards without any manual intervention after the initial setup.

Tips for Custom Reports

• Data Cleaning: You might need to add helper columns in Sheet1 to clean or transform raw data before using it in pivot tables (e.g., extracting dates from timestamps, calculating durations).

• Shareability: Google Sheets allows easy sharing and collaboration, enabling you to share your live reports with your team or management.

• Advanced Formulas: Beyond pivot tables, leverage other Google Sheets functions (e.g., QUERY, FILTER, SUMIF) for more complex analysis.

This approach gives you unmatched flexibility and control over your reporting, ensuring you always have the insights you need, exactly how you need them.