How do I change the number of rows that are shown in a custom report?

For performance reasons, when you view a report, Matomo will show up to 1 000 rows in the first level of a report, and 500 rows for each subtable. All other rows are grouped into a row having the label, Others.

When flattening the report, both the first level and their corresponding subtable rows are combined into a single level. Read more about switching between hierarchical and flat reports. This effectively expands the data shown where every one of the 1 000 top-level rows could have up to 500 subtable rows. Flattening means adding each of these 500 rows per top-level item to the flat report. The potential to exceed the default 1 000 rows in a flat report is expected from the expanded hierarchy. Refer to the examples below for additional context.

Note: If a specific page is not visible in the report at the first level or within the top 500 entries in a subtable, it might be grouped under the label, Others. Matomo combines data for performance reasons, so pages with lower engagement are included into a single Others row and not displayed individually.

Example 1: Events Report

If you are viewing an Events Report for a single day with 1 200 recorded event categories, actions, or names, Matomo will display up to 1 000 unique event entries. If each of these top-level entries include subtable data like specific actions or names within a category, then the Matomo report will show up to 500 rows per subtable.

When you flatten the report, these subtables are combined with the first level, which could potentially be a large dataset. Custom Reports can include up to three dimensions, so in theory, flattening could result in displaying up to 250,000,000 possible rows (with every 1 000 top-level entry x 500 subtable rows x 500 subtable rows).

Example 2: Page URL Report

If you are viewing the default Pages report for a specific month with 10 000 page views across various URLs on your website, Matomo will display up to 1 000 of the most engaged and unique page URLs at the top level. For websites organised with hierarchical paths (e.g., /products/loans, /products/insurance), each top-level URL may have its own subtable that lists child pages within that path-with up to 500 child URLs displayed in each subtable. Flattening the report merges top-level URLs and their child URLs into a single report.

It is important to note that in Custom Reports, each unique Page URL is represented as its own row, using the full URL as the dimension. Custom Reports do not display URLs in a hierarchical format; hierarchical views are only used when nesting additional dimensions with their parent dimension.

Example 3: Ecommerce Products Report

If you are viewing an Ecommerce Products Report with over 1 000 different product names (e.g., based on product categories, names, or SKUs), Matomo will display the top 1 000 products based on engagement metrics like views or by revenue at the first level.

Each product can also contain subtable data, so flattening this report could significantly increase the row count, potentially exceeding the 1 000 row default.

Archive Data

If you wish to archive all the data, or simply archive more (or less) than the current rows limit, you can override these values in the configuration file config/config.ini.php. For example, to limit all table to 5000 entries, add the following in config/config.ini.php:

[CustomReports]
datatable_archiving_maximum_rows_custom_reports = 5000
datatable_archiving_maximum_rows_subtable_custom_reports = 5000

You can also change the number of rows for Matomo standard reports.

Note: For Matomo Cloud customers, the default row limit is 500 rows. This cannot be modified.