Hi! When running a preview on this script it throws this error "One of the conditions in the query is invalid. (file Code.gs, line 95)".

[Diana Qwerty]

Hi! When running a preview on this script it throws this error "One of the conditions in the query is invalid. (file Code.gs, line 95)"




// Copyright 2015, Google Inc. All Rights Reserved.

//

// Licensed under the Apache License, Version 2.0 (the "License");

// you may not use this file except in compliance with the License.

// You may obtain a copy of the License at

//

//     http://www.apache.org/licenses/LICENSE-2.0

//

// Unless required by applicable law or agreed to in writing, software

// distributed under the License is distributed on an "AS IS" BASIS,

// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

// See the License for the specific language governing permissions and

// limitations under the License.

/**

 * @name Multi Bidder

 *

 * @overview The Multi Bidder script offers functionality similar to that of

 *     Automated Rules based on a spreadsheet. See

 *     https://developers.google.com/google-ads/scripts/docs/solutions/multi-bidder

 *     for more details.

 *

 * @author Google Ads Scripts Team [adwords...@googlegroups.com]

 *

 * @version 1.0.3

 *

 * @changelog

 * - version 1.0.3

 *   - Replaced deprecated keyword.getMaxCpc() and keyword.setMaxCpc().

 * - version 1.0.2

 *   - Added validation of user settings.

 * - version 1.0.1

 *   - Improvements to time zone handling.

 * - version 1.0

 *   - Released initial version.

 */

var SPREADSHEET_URL = 'My_SpreadSheet_Url';

var spreadsheetAccess = new SpreadsheetAccess(SPREADSHEET_URL, 'Rules');

var totalColumns;

function main() {

  // Make sure the spreadsheet is using the account's timezone.

  spreadsheetAccess.spreadsheet.setSpreadsheetTimeZone(

      AdsApp.currentAccount().getTimeZone());

  spreadsheetAccess.spreadsheet.getRangeByName('account_id').setValue(

      AdsApp.currentAccount().getCustomerId());

  var columns = spreadsheetAccess.sheet.getRange(5, 2, 5, 100).getValues()[0];

  for (var i = 0; i < columns.length; i++) {

    if (columns[i].length == 0 || columns[i] == 'Results') {

      totalColumns = i;

      break;

    }

  }

  if (columns[totalColumns] != 'Results') {

    spreadsheetAccess.sheet.getRange(5, totalColumns + 2, 1, 1).

        setValue('Results');

  }

  // clear the results column

  spreadsheetAccess.sheet.getRange(6, totalColumns + 2, 1000, 1).clear();

  var row = spreadsheetAccess.nextRow();

  while (row != null) {

    var argument;

    var stopLimit;

    try {

      argument = parseArgument(row);

      stopLimit = parseStopLimit(row);

    } catch (ex) {

      logError(ex);

      row = spreadsheetAccess.nextRow();

      continue;

    }

    var selector = AdsApp.keywords();

    for (var i = 3; i < totalColumns; i++) {

      var header = columns[i];

      var value = row[i];

      if (!isNaN(parseFloat(value)) || value.length > 0) {

        if (header.indexOf("'") > 0) {

          value = value.replace(/\'/g, "\\'");

        } else if (header.indexOf('\"') > 0) {

          value = value.replace(/"/g, '\\\"');

        }

        var condition = header.replace('?', value);

        selector.withCondition(condition);

      }

    }

    selector.forDateRange(spreadsheetAccess.spreadsheet.

        getRangeByName('date_range').getValue());

    var keywords = selector.get();

    try {

      keywords.hasNext();

    } catch (ex) {

      logError(ex);

      row = spreadsheetAccess.nextRow();

      continue;

    }

    var fetched = 0;

    var changed = 0;

    while (keywords.hasNext()) {

      var keyword = keywords.next();

      var oldBid = keyword.bidding().getCpc();

      var action = row[0];

      var newBid;

      fetched++;

      if (action == 'Add') {

        newBid = addToBid(oldBid, argument, stopLimit);

      } else if (action == 'Multiply by') {

        newBid = multiplyBid(oldBid, argument, stopLimit);

      } else if (action == 'Set to First Page Cpc' ||

          action == 'Set to Top of Page Cpc') {

        var newBid = action == 'Set to First Page Cpc' ?

            keyword.getFirstPageCpc() : keyword.getTopOfPageCpc();

        var isPositive = newBid > oldBid;

        newBid = applyStopLimit(newBid, stopLimit, isPositive);

      }

      if (newBid < 0) {

        newBid = 0.01;

      }

      newBid = newBid.toFixed(2);

      if (newBid != oldBid) {

        changed++;

      }

      keyword.bidding().setCpc(newBid);

    }

    logResult('Fetched ' + fetched + '\nChanged ' + changed);

    row = spreadsheetAccess.nextRow();

  }

  spreadsheetAccess.spreadsheet.getRangeByName('last_execution')

      .setValue(new Date());

}

function addToBid(oldBid, argument, stopLimit) {

  return applyStopLimit(oldBid + argument, stopLimit, argument > 0);

}

function multiplyBid(oldBid, argument, stopLimit) {

  return applyStopLimit(oldBid * argument, stopLimit, argument > 1);

}

function applyStopLimit(newBid, stopLimit, isPositive) {

  if (stopLimit) {

    if (isPositive && newBid > stopLimit) {

      newBid = stopLimit;

    } else if (!isPositive && newBid < stopLimit) {

      newBid = stopLimit;

    }

  }

  return newBid;

}

function parseArgument(row) {

  if (row[1].length == 0 && (row[0] == 'Add' || row[0] == 'Multiply by')) {

    throw ('\"Argument\" must be specified.');

  }

  var argument = parseFloat(row[1]);

  if (isNaN(argument)) {

    throw 'Bad Argument: must be a number.';

  }

  return argument;

}

function parseStopLimit(row) {

  if (row[2].length == 0) {

    return null;

  }

  var limit = parseFloat(row[2]);

  if (isNaN(limit)) {

    throw 'Bad Argument: must be a number.';

  }

  return limit;

}

function logError(error) {

  spreadsheetAccess.sheet.getRange(spreadsheetAccess.currentRow(),

      totalColumns + 2, 1, 1)

  .setValue(error)

  .setFontColor('#c00')

  .setFontSize(8)

  .setFontWeight('bold');

}

function logResult(result) {

  spreadsheetAccess.sheet.getRange(spreadsheetAccess.currentRow(),

      totalColumns + 2, 1, 1)

  .setValue(result)

  .setFontColor('#444')

  .setFontSize(8)

  .setFontWeight('normal');

}

function SpreadsheetAccess(spreadsheetUrl, sheetName) {

  Logger.log('Using spreadsheet - %s.', spreadsheetUrl);

  this.spreadsheet = validateAndGetSpreadsheet(spreadsheetUrl);

  this.sheet = this.spreadsheet.getSheetByName(sheetName);

  this.cells = this.sheet.getRange(6, 2, this.sheet.getMaxRows(),

      this.sheet.getMaxColumns()).getValues();

  this.rowIndex = 0;

  this.nextRow = function() {

    for (; this.rowIndex < this.cells.length; this.rowIndex++) {

      if (this.cells[this.rowIndex][0]) {

        return this.cells[this.rowIndex++];

      }

    }

    return null;

  };

  this.currentRow = function() {

    return this.rowIndex + 5;

  };

}

/**

 * Validates the provided spreadsheet URL

 * to make sure that it's set up properly. Throws a descriptive error message

 * if validation fails.

 *

 * @param {string} spreadsheeturl The URL of the spreadsheet to open.

 * @return {Spreadsheet} The spreadsheet object itself, fetched from the URL.

 * @throws {Error} If the spreadsheet URL hasn't been set

 */

function validateAndGetSpreadsheet(spreadsheeturl) {

  if (spreadsheeturl == 'YOUR_SPREADSHEET_URL') {

    throw new Error('Please specify a valid Spreadsheet URL. You can find' +

        ' a link to a template in the associated guide for this script.');

  }

  return SpreadsheetApp.openByUrl(spreadsheeturl);

}

[Finn Harnett O'Meara]

I have also got the exact same error for the exact same line even though there aren't any queries in my script...

[Google Ads Scripts Forum Advisor]

Hi Finn, Diana,

So that I can take a closer look, would you mind providing the customer ID and the name of the script where you encountered the issue via Reply privately to author option? Also, please provide access to the spreadsheet that the script is using so that I can check it as well.

Regards,
Ejay
Google Ads Scripts Team

ref:_00D1U1174p._5001UKM12M:ref

[Sofia Sorokina]

четвер, 3 жовтня 2019 р. 13:42:52 UTC+3 користувач adsscriptsforumadvisor написав:

Hi, I have the same problem with this script, could you help me? 

[Google Ads Scripts Forum Advisor]

Hi Sofia,

Thanks for raising your concern.

I noticed that you've created this forum post for your concern regarding the Multi Bidder solution script. Let's continue our conversion on that thread so that I can better track it.