Authors with the default Editor or Writer role can export Owl Analytics reports. If you're using a custom role, you'll need to have the Reporting custom role permission to View analytics reports.
You can export any Owl Analytics report to work with your data offline or in tools like Excel, Google Sheets, or Business Intelligence dashboards:
- Go to Reporting > Owl Analytics.
- Select the report you want to view and export from the Choose your report > Type dropdown.
- Select your desired time Period.
- Select your desired Audience.
- Select the document with an arrow icon to Export this dataset in other formats:
Export icon in Owl Analytics - An export modal opens for you to configure your export.
- Choose your Export format:
- CSV: Use this option for Google Sheets and most analysis or business intelligence tools.
- TSV (Excel): Use this option if you plan to use Excel to view the data.
- Json / XML: Use one of these options if you're providing the export to a developer or an analysis tool that prefers the format.
- HTML: Use this option if you'd like a simple web-page version of the data.
- Optional in some reports, recommended: If your export modal gives you the option to Flatten report, we recommend checking this box. This setting puts all data on one level for easier analysis. Flatten report is only available in the Entry pages report, Exit pages report, and Downloads report.
- If you don't check the box to Flatten report, you'll also have an option to Expand subtables. Check this box to make sure any nested subtables are expanded and included in your export.
- Optional: The export will automatically include full raw values, such as 3.151. Check the Format Metrics box to show numbers in an easier-to-read format, like 3.15s.
- Report type: If you chose Json or XML as your Export format, select whether you want the generated file to contain the Standard report, which starts immediately with the results, or the Report with metadata, which will provide a bunch of metadata about the report before listing the results. This includes date ranges, column definitions, and other context.
- Row limit: Choose whether to include All the rows available in the current report or set a Custom limit to get only the number of rows you enter. If you enter a row limit, the exporter pulls the top xx rows from the report.
- Once you've finished setting up your export, select Export to generate the export.
Your file will download or open immediately, depending on the format you chose. (CSV and TSV will download; Json, XML, and HTML will open).
Many Owl Analytics reports let you search the report for specific pages, readers, or other details. These searches act as report filters, showing only the report rows that contain your search word or phrase.
Reports that support search
The Owl Analytics reports that support search are:
- Readers report
- Pageviews report
- Searches report
- Entry pages report
- Exit pages report
- Page titles report
- Downloads report
Run a search to filter a report
To search one of these reports:
- Select the Search (magnifying glass) icon in the report's header:
Select the Search icon - Enter your search word or phrase.
- Hit Enter to run the search and filter the report.
