How to extract data from the ‘Others’ row?

For performance reasons, Matomo displays up to 1,000 rows at the first level and 500 per subtable. Matomo groups all other rows into a row labelled, Others.

The Others row consolidates entries that fall below a certain threshold when Matomo aggregates the data. By default, Matomo has a row limit of 500. Read more about viewing reports with examples.

In Matomo Cloud, the row limits are fixed and cannot be adjusted. This ensures the system remains optimised for performance and scalability. For Matomo On-Premise, it is possible to adjust the row limits during archiving.

To access data grouped under the Others row, create a Custom Report with rules to isolate specific entries. Alternatively, use Custom Dimensions to capture key attributes at the tracking level.

Extract data from the ‘Others’ row using Custom Reports

To retrieve specific data grouped under the Others row in Matomo, create a custom report with filtering rules. This lets you extract and analyse the information hidden within the Others row, by excluding or including specific URL patterns.

For example, you’ve identified many page URLs follow a pattern like /product-{id} in your Pages report.

1. In a custom report, you can add a filter to exclude these URLs: Page URL does not contain https://mywebsite.com/product-
2. Matomo will isolate and display Page URLs initially grouped under Others that meet the condition in your custom report.
   

With filtering rules, you can access specific data, even for URLs that Matomo consolidates into the Others row.

Extract data from the ‘Others’ row using Custom Dimensions

Another way to bypass the 500 row limit is to create a custom dimension at the Action level. For example, you have 800 product pages and Matomo displays only 500 rows in the report, while merging the rest into the Others row.

1. To define the data you want to extract, navigate to Administration > Custom Dimensions.
2. Create a new Action-level dimension and mark it as Active to start capturing data.

3. Define the values to extract by using the relevant page URL pattern such as /products/(.*)
   

4. Once you have set up tracking, navigate to Behaviour > YourCustomDimension to access the data.

Matomo will display up to 1,000 rows at the first level with 500 rows per subtable, demonstrating how you can access data beyond the default row limits.