Guest User

Untitled

a guest
Jan 23rd, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.44 KB | None | 0 0
  1. function main() {
  2. var settings = {'linkedView':"ID",
  3. 'linkedAccountId':"ID",
  4. 'accountId':'ID',
  5. 'propertyID':'UA-ID-1'};
  6.  
  7. var spreadsheet = SpreadsheetApp.openByUrl('GOOGLE-DOC-LINK');
  8. var sheet = spreadsheet.getSheetByName('Sheet1');
  9. var range = sheet.getRange(2, 1, sheet.getLastRow(), 6);
  10. var values = range.getValues();
  11.  
  12. for(var i = 0; i < values.length; i++) {
  13. var name = values[i][0];
  14. var suburb = values[i][1];
  15. var state = values[i][2];
  16. var buySale = values[i][3];
  17. var saleExclude = values[i][4];
  18. var duration = Math.floor(values[i][5]);
  19. var excludeSegment;
  20.  
  21. var request = gapi.client.analytics.Management.RemarketingAudience.insert(
  22. {
  23. 'name': name,
  24. 'linkedViews': [settings.linkedView],
  25. 'linkedAdAccounts': [{
  26. 'type': 'ADWORDS_LINKS',
  27. 'linkedAccountId': settings.linkedAccountId,
  28. }],
  29. 'description' : 'TEST',
  30. 'audienceType': 'SIMPLE',
  31. 'audienceDefinition': {
  32. 'includeConditions': {
  33. 'daysToLookBack': 14,
  34. 'segment': "sessions::condition::ga:pagePath=~/"+ suburb +"/"+ state +"/("+ buySale +")/*",
  35. 'membershipDurationDays': duration,
  36. 'isSmartList': false
  37. },
  38. 'excludeConditions': {
  39. 'segment': "sessions::condition::ga:pagePath=@"+ saleExclude
  40. }
  41. }
  42. },
  43. settings.accountId,
  44. settings.propertyID
  45. );
  46.  
  47. }
  48. }
Add Comment
Please, Sign In to add comment