This is the legacy documentation for Google Ads scripts. Go to the current docs.

AdsApp.​ExcludedVideoAudienceSelector

Fetches excluded video audiences. Supports filtering and sorting.

Typical usage:

 var excludedVideoAudienceSelector = AdsApp.videoTargeting()
     .excludedVideoAudiences()
     .withCondition("AdGroupStatus = 'ENABLED'")
     .orderBy("AdGroupName DESC");

 var excludedVideoAudienceIterator = excludedVideoAudienceSelector.get();
 while (excludedVideoAudienceIterator.hasNext()) {
   var excludedVideoAudience = excludedVideoAudienceIterator.next();
 }
Related:

Methods:

MemberTypeDescription
get AdsApp.ExcludedVideoAudienceIterator Fetches the requested excluded video audiences and returns an iterator.
orderBy AdsApp.ExcludedVideoAudienceSelector Specifies the ordering of the resulting entities.
withCondition AdsApp.ExcludedVideoAudienceSelector Adds the specified condition to the selector in order to narrow down the results.
withLimit AdsApp.ExcludedVideoAudienceSelector Specifies limit for the selector to use.

get()

Fetches the requested excluded video audiences and returns an iterator.

Return values:

TypeDescription
AdsApp.ExcludedVideoAudienceIterator Iterator of the requested excluded video audiences.

orderBy(orderBy)

Specifies the ordering of the resulting entities. orderBy parameter can have one of the following forms:
  • orderBy("AdGroupName") - orders results by AdGroupName, in ascending order.
  • orderBy("AdGroupName ASC") - orders results by AdGroupName, in ascending order.
  • orderBy("AdGroupName DESC") - orders results by AdGroupName, in descending order.

See ExcludedVideoAudienceSelector.withCondition(String) for enumeration of columns that can be used.

orderBy() may be called multiple times. Consider the following example:

 selector = selector.
     .orderBy("AdGroupName")
     .orderBy("CampaignName");

The results will be ordered by AdGroupName in ascending order. Results with equal AdGroupName value will be ordered by CampaignName in ascending order.

Arguments:

NameTypeDescription
orderBy String Ordering to apply.

Return values:

TypeDescription
AdsApp.ExcludedVideoAudienceSelector The selector with ordering applied.

withCondition(condition)

Adds the specified condition to the selector in order to narrow down the results.

Multiple conditions may be added to the same selector:

 selector = selector
     .withCondition("AdGroupStatus NOT_IN [PAUSED]")
     .withCondition("CampaignName = 'Campaign 1'");
All specified conditions are AND-ed together. The above example will retrieve excluded entities in Campaign 1 that are in ad groups that are not paused.

The parameter to be passed into this method must be of the following form:

 "COLUMN_NAME OPERATOR VALUE"

Operators

The operator that can be used in a condition depends on the type of column.
  • For String columns (e.g. AdGroupName):
    =  !=  STARTS_WITH  STARTS_WITH_IGNORE_CASE  CONTAINS
     CONTAINS_IGNORE_CASE  DOES_NOT_CONTAIN  DOES_NOT_CONTAIN_IGNORE_CASE
  • For Enumeration columns (ones that can only take one value from a pre-defined list, such as AdGroupStatus):
    =  !=  IN []  NOT_IN []
Conditions using IN, NOT_IN, CONTAINS_ALL, CONTAINS_ANY and CONTAINS_NONE operators look as follows:
 withCondition("AdGroupStatus IN [ENABLED, PAUSED]")
Operators are case-sensitive: starts_with won't work.

Columns

All column names are case-sensitive, and so are all values of enumerated columns (such as AdGroupStatus)

Column Type Example
Attributes of excluded video audience
UserListName String withCondition("UserListName STARTS_WITH 'All visitors'")
AdGroupName String withCondition("AdGroupName CONTAINS_IGNORE_CASE 'shoes'")
AdGroupStatus Enumeration: ENABLED, PAUSED, REMOVED withCondition("AdGroupStatus = ENABLED"). Use to fetch excluded topics from only ENABLED ad groups.
CampaignName String withCondition("CampaignName CONTAINS_IGNORE_CASE 'promotion'")
CampaignStatus Enumeration: ENABLED, PAUSED, REMOVED withCondition("CampaignStatus = ENABLED"). Use to fetch excluded topics from only ENABLED campaigns.

Arguments:

NameTypeDescription
condition String Condition to add to the selector.

Return values:

TypeDescription
AdsApp.ExcludedVideoAudienceSelector The selector with the condition applied.

withLimit(limit)

Specifies limit for the selector to use. For instance, withLimit(50) returns only the first 50 entities.

Arguments:

NameTypeDescription
limit int How many entities to return.

Return values:

TypeDescription
AdsApp.ExcludedVideoAudienceSelector The selector with limit applied.