Remarketing Audiences Creations

Remarketing Audiences Creations

function main() {
  var settings = {'linkedView':"XXXXXXXX",
                  'linkedAccountId':"XXX-XXX-XXXX",
                  'accountId':'XXXXXXX',
                  'propertyID':'UA-XXXXXXX-X'};
 //Example spreadsheet https://goo.gl/4ZAb7Z, make copy and paste instead

  var spreadsheet = SpreadsheetApp.openByUrl('https://goo.gl/4ZAb7Z');
  var sheet = spreadsheet.getSheetByName('Sheet1');
  var range = sheet.getRange(2, 1, sheet.getLastRow(), 3);
  var values = range.getValues();
  Logger.log(values.length);

  for(var i = 0; i < values.length; i++) {
    var name = values[i][0];
    var categoryUrl = values[i][1];
    var duration = values[i][2];
    var newAudience = Analytics.Management.RemarketingAudience.insert(
      {
        'name': name,
        'linkedViews': [settings.linkedView],
        'linkedAdAccounts': [{
            'type': 'ADWORDS_LINKS',
            'linkedAccountId': settings.linkedAccountId,
        }],
        'audienceType': 'SIMPLE',
        'audienceDefinition': {
          'includeConditions': {
            'daysToLookBack': 7,
            'segment': 'sessions::condition::ga:pagePath=@' + categoryUrl,
            'membershipDurationDays': duration,
            'isSmartList': false
          }
        }
      },
    settings.accountId,
    settings.propertyID);

   Logger.log(i + ' Audience ' + name + ' was created');
  };
}