This article is about Google Analytics 4 properties. Refer to the Universal Analytics section if you're still using a Universal Analytics property, which will stop processing data on July 1, 2023 (July 1, 2024 for Analytics 360 properties).

[GA4] About the (other) row

When you view a report that surfaces a large amount of data, you might notice less common values grouped under an (other) row. In this article, you’ll learn about the (other) row and why Analytics uses it. Then, you'll learn about ways to avoid and address the (other) row to see more of your data.

Note: Only standard aggregated reports (including primary and secondary dimensions) and the Data API are subject to the (other) row. Explorations and funnel reports are not subject to the (other) row. Instead, they are subject to data sampling.


Behind the scenes, Analytics loads the data in your reports and the Data API using pre-processed database tables. For example, when you open the Landing page report, an underlying database table includes the dimensions and metrics in the report. The pre-processed database tables enable Analytics to surface your data quickly.

In contrast, explorations and funnel reports load raw event and user-level data without relying on pre-processed database tables. By surfacing raw event and user-level data, Analytics can surface more detailed results, though it may take longer to load.

What causes the (other) row

Analytics sets limits on the amount of data in the underlying database table used in a report. If you collect data with more unique values than the row limit for the table, Analytics groups the less frequent values and labels them as (other).

For example, let's say you have two dimensions in a table. The Device dimension has 3 unique values (i.e., desktop, tablet, mobile) and the Age dimension has 6 unique values (i.e., 18-24, 25-34, 35-44, 45-54, 55-64, 65+). You've also collected data for all possible combinations of the two dimensions (i.e., a user is 18-24 and uses a desktop, a user is 18-24 and uses a tablet, and so on). In this example, the table will have 18 rows (or 3 x 6). If the limit on the table were 15, then the last 3 rows would gather under (other).

You want to see the number of users who arrive on your website by source and medium. In the Traffic acquisition report, you want to look at the Session source and Session medium dimensions, which has the following data:
session_source=S1, session_medium=M1, user_count=200
session_source=S2, session_medium=M2, user_count=100
session_source=S3, session_medium=M3 user_count=10
session_source=S4, session_medium=M4, user_count=5
In this example, if the table cardinality limit is 2, the (other) row would group together the last two buckets for a user_count of 15. The report would return the following results:

session_source=S1, session_medium=M1, user_count=200
session_source=S2, session_medium=M2, user_count=100
session_source=(other), session_medium=(other), user_count=15

What are the limits

The limits for standard reports vary depending on the following:

  • The property type: Analytics 360 properties have higher limits when compared to the limits for standard properties. The exact limits vary depending on the following other factors.
  • The individual report: Some reports (for example, the Pages and screens report) have higher cardinality dimensions, and therefore have higher limits.
  • The complexity of the report: While a standard report with one dimension is rarely affected by an (other) row, reports with secondary dimensions, filters, or comparisons are more likely to include an (other) row. This is because they need database tables with many dimensions. Properties with large and complex data are more likely to exceed the cardinality limits.

Best practices to avoid the (other) row

The following are best practices you can follow to avoid the (other) row:

Use predefined dimensions

  • Use predefined dimensions before you create custom dimensions. For example, use the predefined gaming dimensions (e.g., Character, Virtual currency type) instead of setting up custom dimensions for the same data.
  • Only collect dimensions with 500 or more different values when necessary. These dimensions will affect the table limits used by many other dimensions. When you include a dimension with more than 500 different values in a report, the row limit could apply to most of the data in the property when you use a custom report or add filters, secondary dimensions, or comparisons in a standard report. Sometimes, data that isn't shown in the report contributes to the row limit.
  • Avoid using a custom dimension to create a distinct identifier for each user. Instead, use the User-ID feature.

Use standard reports

  • Use standard reports whenever possible because standard reports have aggregate tables that decrease the likelihood of data rolling up under an (other) row.
  • If you see an (other) row in a report, consider looking at the same data in explorations. If you use Analytics 360, and an exploration begins to sample data, you can request unsampled exploration results.

Address the (other) row

There are a few things you can do when you see the (other) row. The following provides a brief description of when to use each option:

Option What it is When to use it
Create an exploration If you see the (other) row, you can open the data quality icon at the top of the report and click Create an exploration. This option creates an exploration with the same query applied at the lowest sampling rate. Consider this option for one off-questions, or when you want to investigate data with filters or comparisons.
Export your data to BigQuery You can link your property to BigQuery Export and request the same data in BigQuery. Learn more Consider this option to avoid the (other) row and for unsampled results.

Automatic expanded data sets

(Google Analytics 360 only)

If data repeatedly groups into the (other) row in a commonly viewed report, Analytics enables automatic expanded data sets. Learn more

You don't need to take an action to use automatic expanded data sets.

Expanded data sets

(Google Analytics 360 only)

When you request an expanded data set, Analytics creates a special table for the report going forward. Since you can only create up to 100 expanded data sets, you should use them for your most frequently accessed reports. Learn more

Consider this option for reports you plan to use repeatedly.

Was this helpful?
How can we improve it?

Need more help?

Sign in for additional support options to quickly solve your issue

Choose your own learning path

Check out, a new resource to help you get the most out of Google Analytics 4. The new website includes videos, articles, and guided flows, and provides links to the Google Analytics Discord, Blog, YouTube channel, and GitHub repository.

Start learning today!

Clear search
Close search
Google apps
Main menu
Search Help Center