BingAdsAccountSelector

Contains the methods for filtering and ordering the list of accounts the user has access to. For information about selectors, see Selectors.

Example usage:

    var accounts = AccountsApp.accounts()
        .withCondition("Name CONTAINS_IGNORE_CASE 'PARTIAL ACCOUNT NAME GOES HERE'")
        .get();

    while (accounts.hasNext()) {
        var account = accounts.next();
    }

Methods

executeInParallel(string functionName, string optionalCallbackFunctionName)

Executes the function for each account that the selector returns. After the function is executed for all selected accounts, Scripts calls the optional callback function.

The functionName function may return a value as a string. To return a complex object, use the JSON.stringify method to convert the object to a string. You can then use the JSON.parse method to convert the string back into an object. If your function returns a value, you must specify a callback function to capture the return values. The following shows the callback function's signature. The returned values are passed as an array of ExecutionResult objects.

function myCallback(ExecutionResult[] results)

The following example shows how to process the returned values in the callback function.

function myCallback(results) {
    for (var result of results) {
        var object = JSON.parse(result.getReturnValue());
    }
}

Because this method does not return a BingAdsAccountSelector object, make sure this method is the last selector method in the call chain.

For an example, see Discovering disapproved ads.

Arguments

Returns

executeInParallel(string functionName, string optionalCallbackFunctionName, string optionalInput)

Executes the function for each account that the selector returns. After the function executes for all selected accounts, Scripts calls the optional callback function.

The functionName function may return a value as a string. To return a complex object, use the JSON.stringify method to convert the object to a string. You can then use the JSON.parse method to convert the string back into an object. If your function returns a value, you must specify a callback function to capture the return values. The following shows the callback function's signature. The returned values are passed as an array of ExecutionResult objects.

function myCallback(ExecutionResult[] results)

The following example shows how to process the returned values in the callback function.

function myCallback(results) {
    for (var result of results) {
        var object = JSON.parse(result.getReturnValue());
    }
}

If you pass the optional input parameter, the following shows the signature of the functionName function.

function myFunction(string optionalInput)

Because this method does not return a BingAdsAccountSelector object, make sure this method is the last selector method in the call chain.

For an example, see Discovering disapproved ads.

Arguments

Returns

forDateRange(Object dateFrom, Object dateTo)

Applies the start and end dates for selecting performance metrics.

Specify a date range only if:

• You apply conditions or ordering that reference performance metric fields.
• You want to get performance data for the objects you're selecting. For example, if you plan to call the getStats() method.

You may specify the date parameters using strings or objects. To use strings, specify the date in the form, YYYYMMDD. If you use objects, create an object with the following fields:

• year
• month
• day

For example:

var date = {year: 2018, month: 5, day: 13};

The month is one-based where 1 is January and 12 is December.

The date range is inclusive. If you specify multiple date ranges, only the last date range is used.

Arguments

Returns

forDateRange(String dateRange)

Applies the predefined date range for selecting performance metrics.

Supported date range values:

• TODAY
• YESTERDAY
• LAST_WEEK
• LAST_BUSINESS_WEEK
• LAST_7_DAYS
• THIS_WEEK_SUN_TODAY
• LAST_14_DAYS
• LAST_30_DAYS
• LAST_WEEK_SUN_SAT
• THIS_MONTH
• LAST_MONTH
• ALL_TIME

Specify a date range only if:

• You apply conditions or ordering that reference performance metric fields.
• You want to get performance data for the objects you're selecting. For example, if you plan to call the getStats() method.

If you specify multiple date ranges, only the last date range is used.

Arguments

Returns

get

Gets an iterator used to iterate through the list of accounts.

Returns

orderBy(string orderBy)

Applies the specified ordering to the selected accounts.

Specify the orderBy parameter in the form, "columnName orderDirection" where:

• columnName is one of the supported columns.
• orderDirection is the order to sort the results in. Set to ASC to order the results in ascending order or DESC to order the results in descending order. The default is ASC.

For example, the following call returns results in ascending order by Clicks.

selector = selector.orderBy("Clicks");

Selectors support ordering entities by one field only. You may not order the list of entities by field x, and within x by field y, and so on. If you specify more than one orderBy() call in a chain or in separate selector calls, Scripts orders the list of entities using the field specified in the last orderBy() call. 

Arguments

Returns

withAccountNumbers(string[] accountNumbers)

Gets accounts with the specified account numbers.

Arguments

Returns

withCondition(String condition)

Applies filter criteria to the accounts.

Specify the condition parameter in the form, "columnName operator value" where:

• columnName is one of the supported columns. If columName is set to a performance metric column name, you must specify a date range using forDateRange(String dateRange) or forDateRange(Object dateFrom, Object dateTo).
• operator is one of the supported operators.

Operators

The operator that you use depends on the column's type. Operators are case-sensitive. For example, use STARTS_WITH instead of starts_with.

Operators for columns that contain integers and long values:

<
<=
>
>=
=
!=

Operators for columns that contain double values:

<
>

Operators for columns that contain string values:

=
!=
STARTS_WITH
STARTS_WITH_IGNORE_CASE
CONTAINS
CONTAINS_IGNORE_CASE
DOES_NOT_CONTAIN
DOES_NOT_CONTAIN_IGNORE_CASE

Operators for columns that contain enumeration values:

=
!=
IN []
NOT_IN []

Operators for columns that contain an array of strings:

CONTAINS_ALL
CONTAINS_ANY
CONTAINS_NONE

Supported columns for account filtering. The column names are case sensitive.

The following are the performance metrics columns you may specify.

The following are the account properties you may specify.

Arguments

Returns

withIds(string[] ids)

Gets accounts with the specified IDs.

You may apply one or more conditions to a selector. A chain of conditions is considered an AND operation. For example, the entity is selected only if condition A is true AND condition B is true. For example, the following call selects only account 33333.

AccountsApp.accounts()
    .withIds(['11111', '22222', '33333'])
    .withIds(['33333', '44444', '55555']);
    .get();

Arguments

Returns

withLimit(int limit)

Gets the top n accounts that match the selection criteria.

Arguments

Returns

See also

• AccountsApp.accounts()
• BingAdsAccountIterator
• Multi-account access