Script Download

Instructions specific to this script:
`Important:` This script has been deprecated by Optmyzr, which means it will continue to work in old experience but will not be supported by Optmyzr once Google completely moves to the new experience. You can edit or delete the existing settings, but can not add new settings anymore.

Change the values in these lines to customize which product groups the script suggests for optimization and to change the date range used for the metrics:

SETTINGS.dateRange = "LAST_MONTH";
SETTINGS.minConversionsBeforeSplitting = 50;
SETTINGS.maxConversionsBeforeCombining = 5;

New to scripts ?
See step by step instructions for running AdWords Scripts in general.
Need Assistance? We are here to help! Contact Us

Script Code

Copy script code into your Clipboard.

// Copyright 2017 - Optmyzr Inc.
// All rights reserved
// For an Enhanced Script version of this script which works at the MCC level and is easier to modify, visit www.optmyzr.com

function main() {
  
  var SETTINGS = new Object();
  
  // --- CHANGE THESE SETTINGS
  SETTINGS.dateRange = "LAST_MONTH";
  // what are the min and max number of conversions you need to be able to make reasonable bid decisions with
  // an acceptable frequency - for reference, Google targets 15 conversions per month per campaign
  SETTINGS.minConversionsBeforeSplitting = 50;
  SETTINGS.maxConversionsBeforeCombining = 5;
  // --- DONT CHANGE ANYTHING AFTER THIS
  
  var currentSetting = new Object();
  currentSetting.reportType = "PRODUCT_PARTITION_REPORT";
  currentSetting.metricsColumns = ['Impressions',
                                   'Clicks', 
                                   'Conversions', 
                                   'Cost', 
                                   'PartitionType',
                                   'ProductGroup'
                                  ];
  currentSetting.whereConditions = ['WHERE',
                                    'Impressions', '>', '0'];
  
  var columnsUsedArray = currentSetting.metricsColumns;
  var whereClause = currentSetting.whereConditions.join(" ");
  
  
  var columnsStr = currentSetting.metricsColumns.join(',');
  
  // Pull the report with the options defined for all non-deleted campaigns
  var query = 'SELECT ' + columnsStr + ' ' +
    'FROM  ' + currentSetting.reportType + ' ' +
      whereClause + ' ' +
        'DURING ' + SETTINGS.dateRange;
  //Logger.log("query: " + query);
  var report = AdWordsApp.report(query);
  var rows = report.rows();
  
  
  SETTINGS.statsForOther = new Object();
  SETTINGS.statsForDefinedGroups = new Object();
  SETTINGS.statsForOther.productGroups = new Array();
  
  SETTINGS.statsForOther.clicks = 0;
  SETTINGS.statsForOther.impressions = 0;
  SETTINGS.statsForOther.cost = 0;
  SETTINGS.statsForOther.conversions = 0;
  SETTINGS.statsForOther.numProductGroups = 0;
  
  SETTINGS.statsForDefinedGroups.clicks = 0;
  SETTINGS.statsForDefinedGroups.impressions = 0;
  SETTINGS.statsForDefinedGroups.cost = 0;
  SETTINGS.statsForDefinedGroups.conversions = 0;
  SETTINGS.statsForDefinedGroups.numProductGroups = 0;
  
  SETTINGS.productGroupsToSplit = new Array();
  SETTINGS.productGroupsToCombine = new Array();
  
  /*
  var productGroupSelector = AdWordsApp
     .productGroups()
     .withCondition("Impressions > 0")
     .forDateRange(SETTINGS.dateRange)
     .orderBy("ConvertedClicks DESC");

Script Download: Vallaeys Shopping Efficiency Score

Script Code

Questions? Feel Free to Contact Us .