[UA] Create and use Custom Tables

This feature is only available in Analytics 360, part of Google Marketing Platform. Learn more about Google Marketing Platform.

In this article:

• Create a Custom Table
• Use Custom Table reports
• Manage Custom Tables

Create a Custom Table

To create Custom Tables, you must have the Editor role at the account or property level.

1. Sign in to Google Analytics..
2. Click Admin, and navigate to the relevant property.
3. In the PROPERTY column, click Custom Tables.
4. Click +New Custom Table.
5. Enter a title.
6. Select a view from the View drop-down menu.
7. Click +add dimension, and add up to six dimensions.
8. Click +add metric, and add up to 25 metrics.
9. If desired, click +add segment, and add up to four segments.
10. If desired, click +add filter.
    You can include a total of six dimensions in a Custom Table. However, including a filter on a dimension is the same as including the dimension itself. So, a Custom Table can include a total of six filtered or unfiltered dimensions.
    
    For example, you can apply a filter to each of six dimensions that you added in step 7, for a total of six dimensions with six filters. You cannot add a filter on a new dimension because you've already used all six. Or, for example, if you added only five dimensions, you can add a filter on a sixth dimension.
11. Click Save.

After you create a Custom Table, it can take up to 2 days for unsampled data to appear in the Custom Tables reports on the Customization tab. At that point, you would have the 2 days of data starting from the creation date of the table.

Analytics also adds historical data for the 30 days prior to the creation date of the table. Under normal circumstances, that historical data is available when the new unsampled data is available (in approximately 2 days). However, if your property is undergoing routine maintenance carried out by the Analytics system, it can take up to 40 days for that historical data to appear. If your property is undergoing routine maintenance, you will see a message to that effect in the table.

Use Custom Table reports

To see the reports generated from your Custom Tables, go to the Custom Tables section of the Customization tab. Make sure to select the view in which you created the Custom Table.

Your reports are visible to any user with at least the Viewer role on the view.

To view a custom table:

1. Sign in to Google Analytics..
2. Click Admin, and navigate to the relevant property.
3. Select the Customization tab (at the top of every page in Analytics).
4. In the left navigation, click Custom Tables to expand the list. Then, select the Custom Table you would like to view.

Custom Tables are also used whenever you make a standard report request that can be satisfied by one of your Custom Tables. For example, if you add a secondary dimension to a standard report and the resulting report matches a Custom Table definition (or matches a subset of the definition), the Custom Table will be used.

When you view a report that uses a Custom Table, make sure to adjust your date range so that the start date is after the creation date of your table.

Manage Custom Tables

Once you create a Custom Table, its data can't be reprocessed, so you can't edit or modify a table. To delete an existing Custom Table:

1. Sign in to Google Analytics..
2. Click Admin, and navigate to the relevant property.
3. In the PROPERTY column, click Custom Tables.
4. Click Actions in the row corresponding to the table you want to delete, and select Delete.

You can create up to 100 Custom Tables per property. You can view your property's quota usage at any time next to the +New Custom Table button.