MetaData
Retrieves metadata information for standard and custom dimensions / metrics.
Table Specific Information
Select
Retrieves metadata information for standard and custom dimensions / metrics. If PropertyID connection property not set, dimensions and metrics common to all properties will be retrieved.
The following is an example query:
SELECT * FROM Metadata
Columns
| Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
| ApiName | String | The API name for the dimension / metric. | |||
| CustomDefinition | Boolean | Whether the dimension / metric is custom or not. | |||
| Description | String | Description of how the dimension / metric is used and calculated. | |||
| Type | String | Datatype of the dimension / metric. | |||
| FieldType | String | Whether the field is a dimension or metric. | |||
| UIName | String | The dimension / metric name within the Google Analytics user interface. | |||
| DimensionDeprecatedAPINames | String | Returns the list of depricated names for this dimension but still usable. | |||
| MetricDeprecatedAPINames | String | Returns the list of depricated names for this metric but still usable. | |||
| Expressions | String | The mathematical expression for this derived metric. | |||
| BlockedReasons | String | Return the reasons why access to this metric is blocked for this property. | |||
| Category | String | The display name of the category that this dimension / metric belongs to. |