About Custom Tables
This feature is only available in Google Analytics 360, part of the Google Analytics 360 Suite.
Learn more about the Google Analytics 360 Suite.
Analytics may sample your data to give you faster access to your standard and custom reports. However, sometimes you may need to access all of the data for a particular set of metrics and dimensions. With Custom Tables, you specify a combination of metrics, dimensions, segments, and filters that you want Analytics to process unsampled on a daily basis. Any report that matches a subset of the configuration1 of your Custom Table will then access that table by default, giving you fast, unsampled data.In this article:
You have a custom report that is based on data from a large number of sessions, so it's always sampled. It has City and Browser as dimensions and Sessions, Pageviews, and Bounce Rate as metrics. You can create a Custom Table that includes those dimensions and metrics. From the table's creation date forward, Analytics will collect unsampled data for your custom report.
Permissions and limits
To create Custom Tables, you must have property-level Edit permission. You can create up to 100 Custom Tables per property. You can view your property's quota usage at any time by going to Custom Tables at the property level in the Admin section. There, you can also view all Custom Tables created by other Editors of your account.
In addition Custom Tables, like standard daily processed tables, has a limit on the number of unique rows of data that can be stored per day. Unlike standard tables, however, Custom Tables has a limit of 500k unique rows per day, 425k higher than the normal limit of 75k rows for 360 customers2. When there are more than 500k unique rows per day for a given table, Analytics stores the top N values3 and creates an (other) row for the remaining value combinations. See (other) entries in reports for more detail on the (other) row.
What data you can include
Not all metrics and dimensions can be included in a Custom Table, and not all reports can benefit from Custom Tables. The Users metric and user based segments cannot be included. Because of the way data is stored or accessed in the following reports, they can't use data from Custom Tables: Flow Visualization, Search Engine Optimization, Multi-Channel Funnels, and Attribution.
Processing and availability
Once you've created a Custom Table, it can take up to two days for unsampled data to appear in the Custom Tables reports on the Customization tab. Analytics provides data for the 30 days prior to the date you create the Custom Table, so you'll have 32 days of data once the table is ready to use (i.e. 30 days of backfilled historical data + the 2 days needed for the unsampled data to appear in the Custom Tables reports). (To access additional unsampled historical data, you may be able to download Unsampled Reports.)
1A report can access a Custom Table's data if it matches a subset of that table's metrics, segments, and filters. A Custom Table can include more metrics, segments, and filters than are specified in the report, but the Custom Table must at least include all of the metrics, segments, and filters in the report.
2If your Custom Table exactly matches an existing aggregate table, then Analytics identifies the Custom Table as an aggregate table, and it is subject to the 75k-row limit. To prevent this, simply include the All Sessions Segment in your Custom Table, which causes Analytics to not identify it as an aggregate table.
3The top value combinations are determined by sorting the table by the relevant metric (e.g., Sessions Pageviews, Transactions, etc.). Lower volume dimension value combinations are then aggregated into the (other) entry.