Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function main() {
- var settings = {'linkedView':"ID",
- 'linkedAccountId':"ID",
- 'accountId':'ID',
- 'propertyID':'UA-ID-1'};
- var spreadsheet = SpreadsheetApp.openByUrl('GOOGLE-DOC-LINK');
- var sheet = spreadsheet.getSheetByName('Sheet1');
- var range = sheet.getRange(2, 1, sheet.getLastRow(), 6);
- var values = range.getValues();
- for(var i = 0; i < values.length; i++) {
- var name = values[i][0];
- var suburb = values[i][1];
- var state = values[i][2];
- var buySale = values[i][3];
- var saleExclude = values[i][4];
- var duration = Math.floor(values[i][5]);
- var excludeSegment;
- var request = gapi.client.analytics.Management.RemarketingAudience.insert(
- {
- 'name': name,
- 'linkedViews': [settings.linkedView],
- 'linkedAdAccounts': [{
- 'type': 'ADWORDS_LINKS',
- 'linkedAccountId': settings.linkedAccountId,
- }],
- 'description' : 'TEST',
- 'audienceType': 'SIMPLE',
- 'audienceDefinition': {
- 'includeConditions': {
- 'daysToLookBack': 14,
- 'segment': "sessions::condition::ga:pagePath=~/"+ suburb +"/"+ state +"/("+ buySale +")/*",
- 'membershipDurationDays': duration,
- 'isSmartList': false
- },
- 'excludeConditions': {
- 'segment': "sessions::condition::ga:pagePath=@"+ saleExclude
- }
- }
- },
- settings.accountId,
- settings.propertyID
- );
- }
- }
Add Comment
Please, Sign In to add comment