PropertiesAudiences
Lists Audiences on a property.
Select
The connector uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:
- Parent supports the following operator: =
- Name supports the following operator: =
SELECT * FROM PropertiesAudiences where parent = 'properties/153123282' SELECT * FROM PropertiesAudiences where name = 'properties/211225502/audiences/2041236988'The rest of the filter is executed client-side in the connector.
Columns
| Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
| Name [KEY] | String | The resource name for this Audience resource. Format: properties/{propertyId}/audiences/{audienceId}. | |||
| Parent | String | Name of the Audiences's logical parent. | |||
| PropertyId | Integer | Property ID value to be used when querying this table. | |||
| DisplayName | String | The display name of the Audience. | |||
| Description | String | The description of the Audience. | |||
| MembershipDurationDays | Integer | The duration a user should stay in an Audience. It cannot be set to more than 540 days. | |||
| AdsPersonalizationEnabled | Boolean | It is automatically set by GA to false if this is an NPA Audience and is excluded from ads personalization. | |||
| EventTrigger | String | Specifies an event to log when a user joins the Audience. If not set, no event is logged when a user joins the Audience. | |||
| ExclusionDurationMode | String | Specifies how long an exclusion lasts for users that meet the exclusion filter. It is applied to all EXCLUDE filter clauses and is ignored when there is no EXCLUDE filter clause in the Audience. | |||
| FilterClauses | String | Filter clauses that define the Audience. All clauses will be AND’ed together. | |||
| CreateTime | Datetime | Time when the Audience was created. |