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 configuration 1 of your Custom Table will then access that table by default, giving you fast, unsampled data.
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.
To read more about custom table : (https://support.google.com/analytics/answer/2774517?hl=en&ref_topic=6016074 )
Create a Custom Table
To create Custom Tables, you must have Edit permission at the account or property level.
- Sign in to Google Analytics..
- Click Admin, and navigate to the relevant property.
- In the PROPERTY column, click Custom Tables.
- Click +New Custom Table.
- Enter a title.
- Select a view from the View drop-down menu.
- Click +add dimension, and add up to six dimensions.
- Click +add metric, and add up to 25 metrics.
- If desired, click +add segment, and add up to four segments.
- 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.
- 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.
To read more about using custom reports: (https://support.google.com/analytics/answer/2774521)
Was this article helpful?
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
We appreciate your effort and will try to fix the article