How do I exclude and hide rows in a Matomo report?
If you want to hide certain rows in a Matomo report to focus on more relevant data, you can exclude pages containing a particular word. Matomo provides customisable ways to filter reports where you can temporarily hide rows from a report and export the filtered view, or create a permanent filtered Custom Report.
This guide explains both methods for excluding rows containing specific text, such as all pages with homepage
in the URL or title.
Option 1: Exclude rows using a regular expression in search
This option is a quick, temporary filter that hides rows while you view or export a report.
- Open Matomo and go to the report you want to filter, for example Behaviour > Pages.
- In the search box, enter the following regular expression:
^((?!homepage).)*$
- The displayed results will exclude all rows containing the text
homepage
. - Export the filtered report by clicking Export
and choosing your preferred format.
You can replace homepage with other text or patterns, for example:
^((?!contact).)*$
– to exclude any row containing contact.^((?!/blog/).)*$
– to exclude any row containing blog/ in the URL.^((?!thank-you|order-confirmation).)*$
– to exclude rows containing either thank-you or order-confirmation.
Option 2: Use a Custom Report with a filter
Use this option to create a custom report that always excludes specific rows, without needing to reapply filters.
- Navigate to Matomo > Custom Reports > Manage reports.
- Click Create New Report and include the required dimensions and metrics.
- To apply a filter, click Add condition and define the exclusion rule, e.g.,
Page URL
does not containhomepage
.
- When you view the Custom Report, rows containing
homepage in the URL
will be excluded.
By using either method, you can focus on the most relevant data for your analysis. Temporary filters are ideal for one-off checks and exports, while permanent filters ensure those rows stay excluded every time you view the report.