SSIS Components for Google Analytics

Build 25.0.9434

PropertiesAudiences

Lists Audiences on a property.

Select

The component 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: =
The Name or Parent is required to make a request. For example, the following queries are processed server-side:
	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 component.

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434