Users moving from Universal Analytics to Google Analytics 4 frequently notice the lack of robust table filtering. In Universal Analytics, setting up complex inclusion and exclusion rules directly above your data table was simple. GA4 standard reports restrict you to a basic search bar.
If you want to view rows where views are greater than 10,000 and the page path contains a specific directory, the native GA4 interface forces you to build a completely separate exploration. We built a solution to keep you in your standard reports.
Bringing Back Universal Analytics Style Filters
To solve this common reporting headache, we created the Advanced Table Filter feature. This tool integrates directly into your GA4 standard reports to restore familiar Universal Analytics filtering logic. You can slice your data with precision without leaving your current reporting view.
Step-by-Step Instructions
- Install GA4 Optimizer: Add our free browser extension to Chrome, Edge, or Firefox via the Chrome Web Store.
- Open a Standard Report: Navigate to any standard report within your Google Analytics 4 property.
- Click the Advanced Button: Look for the new "Advanced" button located in the table controls bar right next to the Search and Rows per page options.
- Set Your Conditions: Choose your dimension or metric, select a condition, and enter your target value.
- Apply the Filter: The table will update to show only the rows that match your exact criteria.
Dimension Filtering Options
Our tool allows you to filter dimensions like Page path, Event name, or Source/medium using flexible matching rules. Available dimension conditions include:
- Contains and Does not contain
- Exactly matches and Does not exactly match
- Begins with and Ends with
- Regex (Regular expressions)
Metric Filtering Options
Filtering by metrics is just as robust. You can filter count metrics like Views, Active users, and Key events using greater than, less than, or equals. The feature also includes smart value handling to save you time.
Rate metrics like bounce rate or conversion rate accept percentage values directly. Simply type "20" to filter for 20 percent. Revenue metrics automatically convert to the correct internal format for accurate API querying.
Combining Multiple Filter Conditions
The real power of advanced filtering comes from stacking rules. You can combine multiple conditions using AND logic to narrow down large datasets. For example, you can create a rule where "Views > 5,000 AND Page path contains /shop" to isolate high-traffic product pages.
Active filter chips appear directly above the report table showing your current conditions at a glance. If you need to broaden your data view, simply click the X on any chip to remove that specific condition instantly.
For even more control over large datasets, you can also increase the row limit to 500 rows per page to see more data at once alongside your active filters.
Frequently Asked Questions
Can I use regex to filter GA4 standard reports?
Yes. The advanced table filter feature supports regular expressions. You can select the regex condition when filtering any dimension to match complex patterns in your report data.
Why do some derived metric filters fail in GA4?
Some derived metrics like averages or per-user ratios do not natively support direct API filtering on certain standard reports. If a specific filter fails, the extension will display an error message and suggest alternative metrics you can use.
Does the advanced table filter work on GA4 explorations?
No. This specific feature applies only to GA4 standard reports. Explorations already include native advanced filtering capabilities built into the variables and tab settings panels.
